php使用mysql和mysqli串連查詢資料

標籤：

mysql：

<?php $code = $_POST[‘code‘];$status = "";$success = "";$scookies = "";try {    $dbname="root";    $dbpass="root";    $dbhost="127.0.0.1";    $dbdatabase="mysql";     //產生一個串連    $db_connect=mysql_connect($dbhost,$dbname,$dbpass);    //選擇一個需要操作的資料庫    mysql_select_db($dbdatabase,$db_connect);    // 擷取查詢結果    $strsql="select * from `go_member_addmoney_record` where `code` = ‘$code‘ limit 1";    $result=mysql_query($strsql);    // 迴圈取出記錄    while ($row=mysql_fetch_array($result))    {        $status = $row[‘status‘];        $scookies = $row[‘scookies‘];    }    // 釋放資源    mysql_free_result($result);    // 關閉串連    mysql_close($db_connect);      if($status=="已付款"){        $success = "success";    }    else{        $success = "faild";    }     echo $success.";".$scookies;}catch (Exception $e){}?>

mysqli：

<?php $code = $_POST[‘code‘];$status = "";$success = "";$scookies = "";try {    $dbname="root";    $dbpass="root";    $dbhost="127.0.0.1";    $dbdatabase="mysql";     //產生一個串連    $db_connect= new mysqli($dbhost,$dbname,$dbpass,$dbdatabase);    // 擷取查詢結果    $strsql="select * from `go_member_addmoney_record` where `code` = ‘$code‘ limit 1";    $result=$db_connect->query($strsql);    // 迴圈取出記錄    while ($row=mysqli_fetch_assoc($result))    {     $status = $row[‘status‘];     $scookies = $row[‘scookies‘];    }    // 釋放資源    $result->close();    // 關閉串連    $db_connect->close();    if($status=="已付款"){        $success = "success";    }    else{        $success = "faild";    }     echo $success.";".$scookies;}catch (Exception $e){}?>

 

php使用mysql和mysqli串連查詢資料