檢查mysql是否存在行我需要幫助檢查是否存在行。我收到“電子郵件不再存在publisher@example.com”。有沒(méi)有更好的方法來(lái)檢查mysqli是否存在行？if (count($_POST)) {
$email = $dbl->real_escape_string(trim(strip_tags($_POST['email'])));
$passwd = $dbl->real_escape_string(trim(strip_tags($_POST['passwd'])));
$query = "SELECT `email` FROM `tblUser` WHERE `email` = '$email'";
$result = mysqli_query($dbl,$query);
if(is_resource($result) && mysqli_num_rows($result) == 1 ){
$row = mysqli_fetch_assoc($result);
echo $email . " email exists " . $row["email"] . "\n";
}
else{
echo "email no longer exists" . $email . "\n";
} }
3 回答
人到中年有點(diǎn)甜
TA貢獻(xiàn)1895條經(jīng)驗(yàn) 獲得超7個(gè)贊
驗(yàn)證之后和INSERT之前檢查用戶名是否已經(jīng)存在，使用mysqli（程序）。這有效：
//check if username already exists
include 'phpscript/connect.php'; //connect to your database
$sql = "SELECT username FROM users WHERE username = '$username'";
$result = $conn->query($sql);
if($result->num_rows > 0) {
$usernameErr = "username already taken"; //takes'em back to form
} else { // go on to INSERT new record添加回答
舉報(bào)
0/150
提交
取消