mysql connect The mysql extension is deprecated and will be removed in the future use mysqli or PDO instead

Question

An error occurred in script  C  xampp htdocs framework connect php  on line 13   mysql connect    The mysql extension is deprecated and will be removed in the future  use       mysqli or PDO instead  Date Time  12-17-2013 15 10 43    how can i solved this problems  i have look around this maybe the php version problem but still can not delete this error message     lt  php     Database config      db host           localhost    db user                db pass                db database       banners        End config       link    mysql connect  db host  db user  db pass  or die  Unable to establish a DB     connection     mysql set charset  utf8    mysql select db  db database  link      gt

User · Answer

php     Database config      db host           localhost    db user                db pass                db database       banners        End config       mysqli   new mysqli  db host   db user   db pass   db database      check connection    if  mysqli connect errno          printf  Connect failed   s n   mysqli connect error         exit         gt

User · Answer

Simply put  you need to rewrite all of your database connections and queries   You are using mysql   functions which are now deprecated and will be removed from PHP in the future  So you need to start using MySQLi or PDO instead  just as the error notice warned you   A basic example of using PDO  without error handling     lt  php  db   new PDO  mysql host localhost dbname testdb charset utf8    username    password     result    db- gt exec  INSERT INTO table firstname  lastname  VAULES  John    Doe       insertId    db- gt lastInsertId      gt    A basic example of using MySQLi  without error handling     db   new mysqli  DBServer   DBUser   DBPass   DBName    result    db- gt query  INSERT INTO table firstname  lastname  VAULES  John    Doe        Here s a handy little PDO tutorial to get you started  There are plenty of others  and ones about the PDO alternative  MySQLi

[php] mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead

Examples related to php

Examples related to mysql