mysqli:
$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连接查询数据
标签:div exception 数据库 member class title mit 释放 toolbar
本条技术文章来源于互联网,如果无意侵犯您的权益请点击此处反馈版权投诉
本文系统来源:http://www.cnblogs.com/jiangzhaowei/p/6663543.html