So I'm slowly starting to migrate my website to Laravel
and I', finding it very challenging to say the least. I now have to rewrite all my traditional sql
statements and the documentation doesn't give simple snippets of common sql
queries. Below is my login script that I've spent hours trying to figure out how to convert..
$query = "SELECT * FROM users WHERE email='$email' AND password='$password'";
$result = mysqli_query($connection, $query);
$count = mysqli_num_rows($result);
if ($count > 0) {
$row = mysqli_fetch_array($result);
if ($row['verified'] == 1) {
echo "Valid";
} elseif ($row['verified'] == 0) {
echo "not aValid";
}
} elseif ($count == 0) {
echo "not Valid";
}
Any help or guidance will greatly be appreciated. I need to be pointed in the right direction as to how to do simple queries like this one as my site is riddled with a lot of them. I'm starting to think I may have written my logic in a bad way to begin with.
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire