鍍金池/ 問答/數(shù)據(jù)庫(kù)  網(wǎng)絡(luò)安全/ 如何將下面這段代碼中的mysql修改為mysqli或PDO寫法

如何將下面這段代碼中的mysql修改為mysqli或PDO寫法

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /www/wwwroot/xcx.xxxxxx.com/phpwxpay/connect.php on line 11
ID 訂單號(hào) 流水號(hào) 支付時(shí)間

程序后臺(tái)提示這段

對(duì)應(yīng)的文件代碼為

<?php
header("Content-type: text/html; charset=utf-8");
session_start();

$host="localhost";
$db_user="sucaishui";//數(shù)據(jù)庫(kù)帳號(hào)
$db_pass="123456";//數(shù)據(jù)庫(kù)密碼
$db_name="xiaochengxu";//數(shù)據(jù)庫(kù)名

$timezone="Asia/Shanghai";
$link=mysql_connect($host,$db_user,$db_pass);
mysql_select_db($db_name,$link);
mysql_query("SET names UTF8");
header("Content-Type: text/html; charset=utf-8");
date_default_timezone_set($timezone); //北京時(shí)間
?>

回答
編輯回答
幼梔

mysqli:

<?php

$timezone="Asia/Shanghai";
date_default_timezone_set($timezone);

$host="localhost";
$db_user="sucaishui";//數(shù)據(jù)庫(kù)帳號(hào)
$db_pass="123456";//數(shù)據(jù)庫(kù)密碼
$db_name="xiaochengxu";//數(shù)據(jù)庫(kù)名

$db = new mysqli($host, $db_user, $db_pass, $db_name);
if ($db -> connect_errno) {
    error_log('[連接失敗][ ' . $db -> connect_error . ' ]');
}
$db -> query('SET NAMES utf8');

PDO:

<?php

$timezone="Asia/Shanghai";
date_default_timezone_set($timezone);

$host="localhost";
$db_user="sucaishui";//數(shù)據(jù)庫(kù)帳號(hào)
$db_pass="123456";//數(shù)據(jù)庫(kù)密碼
$db_name="xiaochengxu";//數(shù)據(jù)庫(kù)名

$dsn = "mysql:dbname={$db_name};host={$host}";

try {
    $db = new PDO($dsn, $db_user, $db_pass);
} catch (PDOException $e) {
    error_log('[連接失敗][ ' . $e -> getMessage() . ' ]');
}
$db -> exec('SET NAMES utf8');

大概是這樣？

2018年7月5日 13:41