本文操作环境:windows7系统、php7.1版,dell g3电脑
php mysqli怎么查询数据库?
phpmysqli连接查询数据
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视频教程》
以上就是php mysqli怎么查询数据库的详细内容。