Home / Questions / 100239
Accepted
joan
Asked: 2020-09-06 21:07:19 +0800 CST 2020-09-06 21:07:19 +0800 CST

Why do I get the error "Call to undefined function mysql_connect()"?

  • 772

When I want to generate a PDF with php and MySQL I get this error, which I don't know how to solve:

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\codigoresponsive\codigonuevoappfish\opnpdf\reporte3_pdf.php:4 Stack trace: #0 {main} thrown in

mysql

2 Answers

  1. Best Answer

    Mysql_connectis deprecated, you have to use mysqliinstead:

    //Creas una variable de tipo objeto mysqli con los datos de la bd y el charset que quieras
$mysqli = new mysqli('127.0.0.1', 'root', 'root', 'basededatos1');
$mysqli->set_charset("utf8");

    And do the queries like this:

    $res = $mysqli->query("SELECT * FROM personas");

while($f = $res->fetch_object()){
    echo $f->nombre.' <br/>';
}

    Using the Query method that the object has, mysqliyou put the SQL string and fetch_objectyou put the data of each row in a new object $fto be able to access its columns in the way that I show in the example.

    All the best.

    • 23

  2. What happens is that you are using the extension mysql_connect(), it was deprecated in PHP 5.5.0and removed in PHP 7.0.0. And the extensions MySQLior should be used instead PDO_MySQL.

    Example:

     <?php
    $cons_usuario="root";
    $cons_contra="";
    $cons_base_datos="test";
    $cons_equipo="localhost";
    
    $obj_conexion = 
    mysqli_connect($cons_equipo,$cons_usuario,$cons_contra,$cons_base_datos);
    if(!$obj_conexion)
    {
        echo "<h3>No se ha podido conectar PHP - MySQL, verifique sus datos.</h3><hr><br>";
    }
    else
    {
        echo "<h3>Conexion Exitosa PHP - MySQL</h3><hr><br>";
    }
    
    /* ejemplo de una consulta */

    $var_consulta= "select * from tabla_prueba";
    $var_resultado = $obj_conexion->query($var_consulta);

    if($var_resultado->num_rows>0)
      {
        echo"<table border='1' align='center'>
         <tr bgcolor='#E6E6E6'>
            <th>Campo1</th>
            <th>Campo2</th>
            <th>Campo3</th>
            <th>Campo5</th>
            <th>Campo5</th>
        </tr>";
    
    while ($var_fila=$var_resultado->fetch_array())
    {
        echo "<tr>
        <td>".$var_fila["campo_uno"]."</td>";
        echo "<td>".$var_fila["campo_dos"]."</td>";
        echo "<td>".$var_fila["campo_tres"]."</td>";
        echo "<td>".$var_fila["campo_cuatro"]."</td>";
        echo "<td>".$var_fila["campo_cinco"]."</td></tr>";
     }
    }
    else
      {
        echo "No hay Registros";
      }

    ?>
    • 0