PHP提示Deprecated: mysql_connect(): The mysql extension is deprecated的解决方法

港控/mmm° 2023-10-16 22:43 2阅读 0赞

来源:http://www.jb51.net/article/54465.htm

这篇文章主要介绍了PHP提示Deprecated: mysql\_connect(): The mysql extension is deprecated的解决方法,是在进行PHP数据库程序开发中常会遇到的错误,需要的朋友可以参考下

本文实例讲述了PHP提示 Deprecated: mysql\_connect(): The mysql extension is deprecated的解决方法，在PHP程序开发中常会遇到这类问题。分享给大家供大家参考，具体的解决方法如下：

将下面代码改为mysqli或PDO即可。

[?][Link 1]

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> 
    <div>
      2 
    </div> 
    <div>
      3 
    </div> 
    <div>
      4 
    </div> 
    <div>
      5 
    </div> </td> 
   <td> 
    <div> 
     <div> 
      <code>function</code> 
      <code> connectit () { </code> 
     </div> 
     <div> 
      <code>global</code> 
      <code> $CFG</code> 
      <code>; </code> 
     </div> 
     <div> 
      <code>mysql_connect(</code> 
      <code>$CFG</code> 
      <code>[</code> 
      <code>'db_host'</code> 
      <code>], </code> 
      <code>$CFG</code> 
      <code>[</code> 
      <code>'db_user'</code> 
      <code>], </code> 
      <code>$CFG</code> 
      <code>[</code> 
      <code>'db_pass'</code> 
      <code>]) </code> 
      <code>or</code> 
      <code>die</code> 
      <code>(mysql_error()); </code> 
     </div> 
     <div> 
      <code>mysql_select_db(</code> 
      <code>$CFG</code> 
      <code>[</code> 
      <code>'db_name'</code> 
      <code>]); </code> 
     </div> 
     <div> 
      <code>} </code> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

PDO:

[?][Link 1]

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> </td> 
   <td> 
    <div> 
     <div> 
      <code>$dbh</code> 
      <code> = </code> 
      <code>new</code> 
      <code>PDO(</code> 
      <code>'mysql:host=localhost;dbname=test'</code> 
      <code>, </code> 
      <code>$user</code> 
      <code>, </code> 
      <code>$pass</code> 
      <code>); </code> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

MYSQLI:

[?][Link 1]

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> 
    <div>
      2 
    </div> 
    <div>
      3 
    </div> 
    <div>
      4 
    </div> 
    <div>
      5 
    </div> 
    <div>
      6 
    </div> 
    <div>
      7 
    </div> 
    <div>
      8 
    </div> 
    <div>
      9 
    </div> 
    <div>
      10 
    </div> </td> 
   <td> 
    <div> 
     <div> 
      <code>$link</code> 
      <code> = mysqli_connect( </code> 
     </div> 
     <div> 
      <code>&nbsp;</code> 
      <code>'localhost'</code> 
      <code>, </code> 
      <code>/* The host to connect to 连接MySQL地址 */</code>&nbsp;&nbsp; 
     </div> 
     <div> 
      <code>&nbsp;</code> 
      <code>'user'</code> 
      <code>,&nbsp;&nbsp; </code> 
      <code>/* The user to connect as 连接MySQL用户名 */</code>&nbsp;&nbsp; 
     </div> 
     <div> 
      <code>&nbsp;</code> 
      <code>'password'</code> 
      <code>, </code> 
      <code>/* The password to use 连接MySQL密码 */</code>&nbsp;&nbsp; 
     </div> 
     <div> 
      <code>&nbsp;</code> 
      <code>'world'</code> 
      <code>);&nbsp; </code> 
      <code>/* The default database to query 连接数据库名称*/</code>&nbsp;&nbsp; 
     </div> 
     <div>
       &nbsp; 
     </div> 
     <div> 
      <code>if</code> 
      <code> (!</code> 
      <code>$link</code> 
      <code>) { </code> 
     </div> 
     <div> 
      <code>&nbsp;&nbsp;</code> 
      <code>printf(</code> 
      <code>"Can't connect to MySQL Server. Errorcode: %s "</code> 
      <code>, mysqli_connect_error()); </code> 
     </div> 
     <div> 
      <code>&nbsp;&nbsp;</code> 
      <code>exit</code> 
      <code>; </code> 
     </div> 
     <div> 
      <code>}</code> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

[Link 1]: http://www.jb51.net/article/54465.htm#