Hello.
Could anyone familiar with mysqli advise me with regards reading and searching a database please?
After connecting to the database, and opening it.
So far, I've written the following:-
$sql = "SELECT Member_id, Fullname, Username, Email, Password, Location, Country, DOB, Gender, Photo, Tzone, WebsiteURL, MembershipType, AccountStatus, ShortURL, BusinessAddress, SignupDate, LastVisitDate, AccountClosedDate, AccountDeleteDate FROM registration"; $result = $conn->query($sql);
if ($result->num_rows > 0) { // output data of each row while ($row = $result->fetch_row()) { if ( $row[3] == $user_email & $row[4] == $user_password) {
echo "Found Entry";
}
}
}
mysqli_close($conn);
I'm finding that the above, will only read the first record/entry in the database, and will not read/search the rest of the database.
I'd like to ask/request how do I go about searching the rest of the database? As I don't know how to proceed with it.
Thank You.