Deprecated mysql connect

Question

I am getting this warning  but the program still runs correctly   The MySQL code is showing me a message in PHP      Deprecated  mysql connect    The mysql extension is deprecated and   will be removed in the future  use mysqli or PDO instead in   C  xampp htdocs task media new connect inc php on line 2   My connect inc php page is   lt  php    connect   mysql connect  localhost   root         mysql select db  dbname      gt    What does this mean and how can I eliminate the message

User · Answer

That is because you are using PHP 5 5 or your webserver would have been upgraded to 5 5 0   The mysql   functions has been deprecated as of 5 5 0    Source

User · Answer

Warning  deprecated   in general means that you are trying to use function that is outdated  It doeasnt mean thaqt your code wont work  but you should consider refactoring    In your case functons mysql  are deprecated  If you want to know more about that here is good explanation already   Why shouldn  39 t I use mysql   functions in PHP

User · Answer

Well  i just faced such message today when i moved to new hosting  anyway i have tried to change the  mySQL  to  mySQLi  but not working  so i have done this    lt  php   FileName  Connection php mysql htm    Type  MYSQL    HTTP  true    Turn off all error reporting error reporting 0    connect myconn    Database Connection    hostname myconn    localhost    database myconn    db name    username myconn    user name    password myconn    pass    myconn   mysql connect  hostname myconn   username myconn   password myconn  or die   lt h1 style margin 0  gt A MySQL error has occurred  lt  h1 gt  lt p gt  lt b gt Your Query  lt  b gt       connect myconn     lt br   gt   lt b gt Error Number  lt  b gt       mysql errno        lt  p gt     mysql error     mysql select db  database myconn   myconn     gt    The trick is to set error reporting off       Turn off all error reporting error reporting 0     For PHP 7  you can use this code instead   ini set  display errors   0   ini set  log errors   1     Thanks

User · Answer

You can remove the warning by adding a     before the mysql connect    mysql connect  localhost   root         but as the warning is telling you  use mysqli or PDO since the mysql extension will be removed in the future

User · Answer

Its just a warning that is telling you to start using newer methods of connecting to your db such as  pdo objects   http   code tutsplus com tutorials php-database-access-are-you-doing-it-correctly--net-25338  The manual is here  http   www php net manual en book pdo php

User · Answer

Adding a   works for me    I tested with error reporting E ALL   E DEPRECATED

User · Answer

put this in your php page   ini set  error reporting   E ALL  amp   E DEPRECATED

User · Answer

PDO class replaces these methods  Example for Mysql or MariaDB      BDD SQL   new PDO  mysql host   BDD SQL SERVER   dbname   BDD SQL BASE   charset utf8            BDD SQL LOGIN  BDD SQL PWD           array            PDO  ATTR EMULATE PREPARES   gt  false            PDO  ATTR ERRMODE   gt  PDO  ERRMODE EXCEPTION    launch exception if error           PDO  ATTR DEFAULT FETCH MODE  gt  PDO  FETCH ASSOC                       Source   PDO Class

User · Answer

There are a few solutions to your problem   The way with MySQLi would be like this    lt  php  connection   mysqli connect  localhost    username    password    database      To run database queries is also simple and nearly identical with the old way    lt  php    Old way mysql query  CREATE TEMPORARY TABLE  table     connection      New way mysqli query  connection   CREATE TEMPORARY TABLE  table       Turn off all deprecated warnings including them from mysql      lt  php error reporting E ALL   E DEPRECATED     The Exact file and line location which needs to be replaced is   System Startup php   line  2   error reporting E All   replace with error reporting E ALL   E DEPRECATED

User · Answer

If you have done your coding then   ini set  error reporting   E ALL  amp   E DEPRECATED      is good option but if you are in beginning then definitely you should use mysqli

User · Answer

mysql    is officially deprecated as of PHP v5 5 0 and will be removed in the future   Use mysqli   function or pdo  Read Oracle Converting to MySQLi

User · Answer

lt  php   link   mysqli connect  localhost   root        if    link         die  Could not connect to MySQL      mysqli error         echo  Connection OK   mysqli close  link      gt    This will solve your problem

User · Answer

This warning is displayed because a new extension has appeared  It suppouse that you still can use the old one but in some cases it  s impossible   I show you how I do the connection with database  You need just change the values of the variables   My connection file  connection php   lt  php       host  IP or Server Name  usually  localhost        user  Database user     password  Database password     db  Database name       PHP 5 4 o earlier  DEPRECATED    con   mysql connect  host  user  password  or exit  Connection Error      connection   mysql select db  db   con       PHP 5 5  New method    connection    mysqli connect  host  user  password  db     gt    The extension changes too when performing a query   Query File   example php    lt  php    First I call for the connection  require  connection php             Here code if you need do something        query    Here the query you are going to perform       QUERY PHP 5 4 o earlier  DEPRECATED    result   mysql query   query  or exit  The query could not be performed        QUERY PHP 5 5  NEW EXTENSION    result   mysqli query   query  or exit  The query could not be performed          gt    This way is using MySQL Improved Extension  but you can use PDO  PHP Data Objects    First method can be used only with MySQL databases  but PDO can manage different types of databases   I m going to put an example but it  s necessary to say that I only use the first one  so please correct me if there is any error   My PDO connection file   PDOconnection php    lt  php   hostDb  mysql host   Here IP or Server Name  dbname  Database name       user  Database user     password  Database password      connection   new PDO  hostDb   user   password     gt    Query File  PDO    example php    lt  php   query    Here the query you are going to perform     result  connection- gt  query    gt    To finish just say that of course you can hide the warning but  it  s not a good idea because can help you in future save time if an error happens  all of us knows the theory but if you work a lot of hours sometimes    brain is not there

User · Answer

Deprecated features in PHP 5 5 x  The original MySQL extension is now deprecated  and will generate E DEPRECATED errors when connecting to a database  Instead  use the   MYSQLi or PDO MySQL extensions      Syntax    lt  php    connect   mysqli connect  localhost    user    password    dbname      Also  replace all mysql   functions into mysqli   functions  instead of    lt  php   connect   mysql connect  localhost   root         mysql select db  dbname      gt

User · Answer

To suppress the deprecation message for this alone  and stay informed of other deprecations in your code  you can prefix the connect with      lt  php  connect    mysql connect  localhost   root       mysql select db  dbname      gt

[php] Deprecated: mysql_connect()

That is because you are using PHP 5.5 or your webserver would have been upgraded to 5.5.0.

Examples related to php

Examples related to mysql

Examples related to function

Examples related to deprecated