"mysqli_num_rows($query) > 0" is not becoming true

Asked Oct 14 '17 at 16:30

Active Oct 14 '17 at 16:30

Viewed 27 times

I have this php code sample and I have several rows in the database tables... but the condition (mysqli_num_rows($query) > 0) is not satisfying...

<?php
    include './Dashboard/database_connect.php';

    if (!empty($_POST['firstName']) && !empty($_POST['lastName'])) {
        $fname = $_POST['firstName'];
        $lname = $_POST['lastName'];

        $query = mysqli_query($conn, "SELECT * FROM patient WHERE firstname='$fname' AND lastname='$lname'");
        $row=  mysqli_num_rows($query);

        echo "<script>alert('1')</script>"; 

        if($row>0){ #this if condition is not becoming true, even if I have multiple rows in my database's patient table

            echo "<script>alert('Rows Found')</script>";

        }else{
           echo "<script>alert('No Rows found')</script>"; 
        }
    } else {

        echo "<script>alert('wrong')</script>";
    }
    ?>

Can anyone please Help???

asked Oct 14 '17 at 16:30

the_dempa

Check if `mysqli_query` returns without error. – Hatted Rooster Oct 14 '17 at 16:33
How can I check that Sir? @RickAstley – the_dempa Oct 14 '17 at 16:34
1

Learn to use parameters! Don't munge query strings with parameter values. It leads to syntax errors and SQL injection vulnerabilities. – Gordon Linoff Oct 14 '17 at 16:34
First, your code is exposed to SQL Injection! Second, check your query without `WHERE` clause. – Ismail RBOUH Oct 14 '17 at 16:35
https://php.net/manual/en/mysqli.error.php will tell you if you have an error – chris85 Oct 14 '17 at 16:36
Query is fine sir @IsmailRBOUH – the_dempa Oct 14 '17 at 16:40
@chris85: Sir I didn't get that. Can you simplify that for me? – the_dempa Oct 14 '17 at 16:45
`if (!$query = mysqli_query($conn, "SELECT * FROM patient WHERE firstname='$fname' AND lastname='$lname'")) { printf("Errormessage: %s\n", mysqli_error($conn));` – chris85 Oct 14 '17 at 16:49
Sir, I think the problem is with my include (`'database_connection.php'`). When I use it without including it's working.Is there any particular reason? – the_dempa Oct 14 '17 at 17:07

"mysqli_num_rows($query) > 0" is not becoming true

0 Answers0