本文介紹了如何使用 PHP 檢查用戶是否已存在于 MySQL 中的處理方法，對大家解決問題具有一定的參考價值，需要的朋友們下面隨著小編來一起學(xué)習(xí)吧！
問題描述
我正在使用以下對我不起作用的代碼.
$con=mysqli_connect("localhost","root","","my_db");$check="SELECT COUNT(*) FROM people WHERE Email = '$_POST[eMailTxt]'";如果 (mysqli_query($con,$check)>=1){echo "用戶已經(jīng)存在<br/>";}別的{$newUser="INSERT INTO people(Email,FirstName,LastName,PassWord) values('$_POST[eMailTxt]','$_POST[NameTxt]','$_POST[LnameTxt]','$_POST[passWordTxt]')"；如果 (mysqli_query($con,$newUser)){echo "您現(xiàn)在已注冊<br/>";}別的{echo "在數(shù)據(jù)庫中添加用戶時出錯<br/>";}}<塊引用>
mysqli_result 類的對象無法轉(zhuǎn)換為 int inC:xampphtdocsExpwelcome.php
解決方案
這段代碼很適合你...
$con=mysqli_connect("localhost","root","","my_db");$check="SELECT * FROM people WHERE Email = '$_POST[eMailTxt]'";$rs = mysqli_query($con,$check);$data = mysqli_fetch_array($rs, MYSQLI_NUM);如果($數(shù)據(jù)[0]> 1){echo "用戶已經(jīng)存在<br/>";}別的{$newUser="INSERT INTO people(Email,FirstName,LastName,PassWord) values('$_POST[eMailTxt]','$_POST[NameTxt]','$_POST[LnameTxt]','$_POST[passWordTxt]')"；如果 (mysqli_query($con,$newUser)){echo "您現(xiàn)在已注冊<br/>";}別的{echo "在數(shù)據(jù)庫中添加用戶時出錯<br/>";}}I am using following code which is not working for me.
$con=mysqli_connect("localhost","root","","my_db");
$check="SELECT COUNT(*) FROM persons WHERE Email = '$_POST[eMailTxt]'";
if (mysqli_query($con,$check)>=1)
{
echo "User Already in Exists<br/>";
}
else
{
$newUser="INSERT INTO persons(Email,FirstName,LastName,PassWord) values('$_POST[eMailTxt]','$_POST[NameTxt]','$_POST[LnameTxt]','$_POST[passWordTxt]')";
if (mysqli_query($con,$newUser))
{
echo "You are now registered<br/>";
}
else
{
echo "Error adding user in database<br/>";
}
}
Object of class mysqli_result could not be converted to int in C:xampphtdocsExpwelcome.php
解決方案
this code works fine for you...
$con=mysqli_connect("localhost","root","","my_db");
$check="SELECT * FROM persons WHERE Email = '$_POST[eMailTxt]'";
$rs = mysqli_query($con,$check);
$data = mysqli_fetch_array($rs, MYSQLI_NUM);
if($data[0] > 1) {
echo "User Already in Exists<br/>";
}
else
{
$newUser="INSERT INTO persons(Email,FirstName,LastName,PassWord) values('$_POST[eMailTxt]','$_POST[NameTxt]','$_POST[LnameTxt]','$_POST[passWordTxt]')";
if (mysqli_query($con,$newUser))
{
echo "You are now registered<br/>";
}
else
{
echo "Error adding user in database<br/>";
}
}
這篇關(guān)于如何使用 PHP 檢查用戶是否已存在于 MySQL 中的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！
【網(wǎng)站聲明】本站部分內(nèi)容來源于互聯(lián)網(wǎng),旨在幫助大家更快的解決問題，如果有圖片或者內(nèi)容侵犯了您的權(quán)益，請聯(lián)系我們刪除處理，感謝您的支持！