mysql建議連接及查詢資料表PHP程式碼-php教程-PHP中文網

mysql建議連接及查詢資料表PHP程式碼

小云云

發布： 2023-03-20 14:08:01

原創

1438 人瀏覽過

本文主要和大家分享原生mysql查詢,選擇資料庫,建議連線及查詢資料表PHP完整流程，希望能幫助大家。

用mysqli_connect,mysql_connect,mysqli_select_db,mysql_select_db
,mysqli_query,mysql_query直接選擇資料庫.資料表並進行查詢完整程式碼

##database.php檔案為資料庫的使用者或密碼等

<?phpreturn array (    &#39;default&#39; => array (        &#39;hostname&#39; => &#39;127.0.0.1&#39;,        &#39;database&#39; => &#39;phpcms&#39;,        &#39;username&#39; => &#39;root&#39;,        &#39;password&#39; => &#39;root&#39;,        &#39;tablepre&#39; => &#39;v9_&#39;,        &#39;charset&#39; => &#39;utf8&#39;,        &#39;type&#39; => &#39;mysql&#39;,        &#39;debug&#39; => true,        &#39;pconnect&#39; => 0,        &#39;autoconnect&#39; => 0
        ),
);?>

登入後複製

$mysql_user=include(PHPS_PATH.&#39;/caches/configs/database.php&#39;);//得到数据库配置        $username=$mysql_user[&#39;default&#39;][&#39;username&#39;];        $password=$mysql_user[&#39;default&#39;][&#39;password&#39;];        $tablepre=$mysql_user[&#39;default&#39;][&#39;tablepre&#39;];        $database=$mysql_user[&#39;default&#39;][&#39;database&#39;];        $con = mysqli_connect($mysql_user[&#39;default&#39;][&#39;hostname&#39;],$username,$password);//句柄

mysqli_select_db($con,$database);//选择数据库 
$sql = &#39; SELECT * FROM &#39;.$tablepre."pay_account where trade_sn=&#39;".$out_trade_no."&#39;";//file_put_contents(&#39;3.txt&#39;,$sql);$result2=mysqli_query($con,$sql);$orderinfo=mysqli_fetch_array($result2);;$uid=$orderinfo[&#39;userid&#39;];//更新数据库$sql4 = &#39; update  &#39;.$tablepre."pay_account set status= &#39;succ&#39;  where userid=".$uid ." and trade_sn=&#39;".$out_trade_no."&#39;";        $result4=mysqli_query($con,$sql4);
                 mysqli_close($con);

登入後複製

使用mysqli_connect,mysql_connect,mysqli_select_db,mysql_select_db

,mysql#query,mysqli_select_db,mysql_select_db
,mysql#query,mysqli_select_db,mysql_select_db

,mysql#query,mysqli_select_db,mysql_select_db

,mysql#query,mysqli_select.的用戶或密碼等

<?phpreturn array (    &#39;default&#39; => array (        &#39;hostname&#39; => &#39;127.0.0.1&#39;,        &#39;database&#39; => &#39;phpcms&#39;,        &#39;username&#39; => &#39;root&#39;,        &#39;password&#39; => &#39;root&#39;,        &#39;tablepre&#39; => &#39;v9_&#39;,        &#39;charset&#39; => &#39;utf8&#39;,        &#39;type&#39; => &#39;mysql&#39;,        &#39;debug&#39; => true,        &#39;pconnect&#39; => 0,        &#39;autoconnect&#39; => 0
        ),
);?>

登入後複製

$mysql_user=include(PHPS_PATH.&#39;/caches/configs/database.php&#39;);//得到数据库配置        $username=$mysql_user[&#39;default&#39;][&#39;username&#39;];        $password=$mysql_user[&#39;default&#39;][&#39;password&#39;];        $tablepre=$mysql_user[&#39;default&#39;][&#39;tablepre&#39;];        $database=$mysql_user[&#39;default&#39;][&#39;database&#39;];        $con = mysqli_connect($mysql_user[&#39;default&#39;][&#39;hostname&#39;],$username,$password);//句柄

mysqli_select_db($con,$database);//选择数据库 
$sql = &#39; SELECT * FROM &#39;.$tablepre."pay_account where trade_sn=&#39;".$out_trade_no."&#39;";//file_put_contents(&#39;3.txt&#39;,$sql);$result2=mysqli_query($con,$sql);$orderinfo=mysqli_fetch_array($result2);;$uid=$orderinfo[&#39;userid&#39;];//更新数据库$sql4 = &#39; update  &#39;.$tablepre."pay_account set status= &#39;succ&#39;  where userid=".$uid ." and trade_sn=&#39;".$out_trade_no."&#39;";        $result4=mysqli_query($con,$sql4);
                 mysqli_close($con);
相关推荐：

登入後複製

mysql查询表里的重复数据方法

登入後複製

<a href="http://www.php.cn/mysql-tutorials-358763.html" target="_self">详细介绍MySQL查询优化</a><br/>

登入後複製

以上是mysql建議連接及查詢資料表PHP程式碼的詳細內容。更多資訊請關注PHP中文網其他相關文章！