本文实例讲述了PHP提示 Deprecated: mysql_connect(): The mysql extension is deprecated的解决方法,在PHP程序开发中常会遇到这类问题。分享给大家供大家参考,具体的解决方法如下:
将下面代码改为mysqli或PDO即可。
1
2
3
4
5
|
function connectit () {
global $CFG ;
mysql_connect( $CFG [ 'db_host' ], $CFG [ 'db_user' ], $CFG [ 'db_pass' ]) or die (mysql_error());
mysql_select_db( $CFG [ 'db_name' ]);
}
|
PDO:
1
|
$dbh = new PDO( 'mysql:host=localhost;dbname=test' , $user , $pass );
|
MYSQLI:
1
2
3
4
5
6
7
8
9
10
|
$link = mysqli_connect(
'localhost' , /* The host to connect to 连接MySQL地址 */ 'user' , /* The user to connect as 连接MySQL用户名 */ 'password' , /* The password to use 连接MySQL密码 */ 'world' ); /* The default database to query 连接数据库名称*/ if (! $link ) {
printf( "Can't connect to MySQL Server. Errorcode: %s " , mysqli_connect_error());
exit ;
}
|
希望本文所述对大家的PHP程序设计有所帮助。