这个用mysqli面向对象怎么写?
答案:1 悬赏:50
解决时间 2021-03-08 01:41
- 提问者网友:wodetian
- 2021-03-07 07:17
这个用mysqli面向对象怎么写?
最佳答案
- 二级知识专家网友:笑迎怀羞
- 2021-03-07 08:48
//连接并选择数据库
$mysqli = new mysqli("localhost", "my_user", "my_password", "my_db_name");
//如果连接失败
if ($mysqli->connect_errno) {
printf("Connect failed: %s
", $mysqli->connect_error);
exit();
}
$sql = "SELECt * FROM admin where `username` = '$username'";
//query 后面都差不多
$result = $mysqli -> query($sql);
$uname = is_array($row = $result -> fetch_assoc());
$pwd = $uname ? $password == $row["password"] : FALSE;
if($pwd){
$_SESSION["id"] = $row["id"];
$_SESSION["permit"] = $row["password"];
echo "OK!";
}else{
echo "Fail!";
session_destroy();
}
$mysqli->close();
$mysqli = new mysqli("localhost", "my_user", "my_password", "my_db_name");
//如果连接失败
if ($mysqli->connect_errno) {
printf("Connect failed: %s
", $mysqli->connect_error);
exit();
}
$sql = "SELECt * FROM admin where `username` = '$username'";
//query 后面都差不多
$result = $mysqli -> query($sql);
$uname = is_array($row = $result -> fetch_assoc());
$pwd = $uname ? $password == $row["password"] : FALSE;
if($pwd){
$_SESSION["id"] = $row["id"];
$_SESSION["permit"] = $row["password"];
echo "OK!";
}else{
echo "Fail!";
session_destroy();
}
$mysqli->close();
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯