Jump to content

Search the Community

Showing results for tags 'database mysqli'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • W3Schools
    • General
    • Suggestions
    • Critiques
  • HTML Forums
    • HTML/XHTML
    • CSS
  • Browser Scripting
    • JavaScript
    • VBScript
  • Server Scripting
    • Web Servers
    • Version Control
    • SQL
    • ASP
    • PHP
    • .NET
    • ColdFusion
    • Java/JSP/J2EE
    • CGI
  • XML Forums
    • XML
    • XSLT/XSL-FO
    • Schema
    • Web Services
  • Multimedia
    • Multimedia
    • FLASH

Calendars

  • Community Calendar

Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests


Languages

Found 1 result

  1. How do I search a database?

    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.
×