Nasıl koymak ve PHP ve MySQL veri okuyabilir? Ben şu çalıştı:

$pwdcrypt = SHA1($pwd);
echo "Now we put some data to the database!";
$userregisterquery="INSERT INTO user (email, password) VALUES ('$email', '$pwdcrypt')";
echo $userregisterquery;
mysqli_query($link, $userregisterquery);

$usergetdataquery="SELECT email, password FROM user WHERE email='$email'";
echo $usergetdataquery.'</br>'; 
$result =  mysqli_query($link, $usergetdataquery);
$row = mysqli_fetch_row($result);
print_r($row);

// get the user_id
$useridquery="SELECT user.id FROM user WHERE email = '$email'";
echo $useridquery.'</br>'; 
$result = mysqli_query($link, $useridquery);
$row = mysqli_fetch_array($result);  
echo "the result is:".print_r($row);
mysqli_close($link);

Bu, örneğin çıkarır:

Now we put some data to the database!INSERT INTO user (email, password) VALUES ('fdjisadds@as.com', 'cf860129c95e6afcdb9f9a390354915cde81c40c')We put email: fdjisadds@as.com and password: cf860129c95e6afcdb9f9a390354915cde81c40c to the database.SELECT email, password FROM user WHERE email='fdjisadds@as.com'We get: 1

I = 1 bu kimliği kontrol gibi, bunu ben SQL-terminal ve hiç e-posta yoluyla fdjisadds@as.com oraya koymak başka bir kullanıcı olduğunu buldu.