Home / Questions / 260508
Accepted
LauraZ
Asked: 2020-05-04 06:36:39 +0800 CST 2020-05-04 06:36:39 +0800 CST

Check connection to MySQL database with PHP - PDO

  • 772

I have a database on my site with the users and their passwords to be able to enter the page. The database is fine, the same with the login page, they worked fine without any problem. Until a few days ago, for no apparent reason, it stopped working. This is the code I used to connect:

<?php

class conexion {

  public static function conectar ()
  {
    try {

      $cn = new PDO("mysql:host=localhost:3306;dbname=misitio_bdatos","miusuario","qaz123");

      return $cn;

    } catch (PDOException $ex) {
      die($ex->getMessage() );
    }

  }

}    //sin etiqueta de cierre por ser parte de un require

So I decided to check if these data were really correct, with the following code that I found on the internet and named as check.php

<?php
    function Conectarse()
    {
    $host='localhost:3306';
    $usuariodb='miusuario';
    $passwdb='qaz123';
    $nombredb='misitio_bdatos';

    if (!($link=mysql_connect($host,$usuariodb,$passwdb)))
    {
    echo "Error conectando a la base de datos.";
    exit();
    }
    if (!mysql_select_db($nombredb,$link))
    {
    echo "Error seleccionando la base de datos, verifique que el nombre de usuario utilizado este asociado a la base de datos.";
    exit();
    }
    return $link;
    }

    $link=Conectarse();
    echo "Conexión con la base de datos conseguida.
    ";
    mysql_close($link); //cierra la conexion
    ?>

But when I go to that file in mysite.com/check.php it shows me the message

The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.

How can I verify that this connection is actually being made correctly?

I am working with PDO to validate logins.

Thank you very much :)

php

1 Answers

  1. Best Answer

    If you are working with PDO you can try this connection

    <?php
   class conexion {
      private $host = "nombre HOST";
      private $user = "usuario";
      private $pass = "password";
      private $database = "nombre de la base de datos";

      //database handler
      private $dbh;
      //statement
      private $stmt;
      //errores
      private $error;

      public static function conectar() {
         //configurar la conexión
         $dsn = "mysql:host=".$this->host.";dbname=".$this->database;
         //opciones que se agregaran a la conexion mysql
         //PDO::ATTR_PERSISTENT - la conexion con pdo será persistente, optimizara los recursos del servidor

         $options = array(
            PDO::ATTR_PERSISTENT => true,
            PDO::ATTR_ERRMODE =>PDO::ERRMODE_EXCEPTION
         );

         //creamos una instancia de PDO
         //lo insertamos en una excepcion
         try{

            $this->dbh = new PDO($dsn,$this->user,$this->pass,$options);
            //con la siguiente instrucción controlamos el return de caracteres extraños que no puede interpretar la db
            $this->dbh->exec('set names '.UTF8);
            echo "Conexion realizada con exito";
         }catch(PDOException $e){
             $this->error = $e->getMessage();
             echo "Excepcion: ".$this->error;
         }
      } 
   }

?>
    • 2