PHP MySQLi query returning null

Question

I am trying to connect to mysql database via php, check if a given entry is there in the database and act accordingly. Even when I try the php with entries that exist in the database, the query is returning null.

   <?php
        $host='host';
        $uname='username';
        $pwd='password';
        $db="db";

        $con = new mysqli($host,$uname,$pwd,$db) or die("connection failed");

        if(mysqli_connect_error($con)){
                echo "Failed To connect to database";
            }

        $name=$_REQUEST['name'];
        $number=$_REQUEST["number"];
        $email=$_REQUEST['email'];


        $sqlc = $con -> prepare('select * from customer where contact = ? ');
        $sqlc -> bind_param('s', $number);
        $sqlc -> execute();
        $slqc -> store_result();
        $row_cnt = mysqli_num_rows($sqlc);
        if ($row_cnt>=1){
                echo "number already registered";
            }
        else {
                //do something else
             }
        mysqli_close($con);
        ?>

I tried without using store_result() first but to the same effect. Edit: After checking out one of the solutions provided, I have to add that I don't have access to the php.ini settings file. So I cannot use report_error

Are you sure that your `$number` is string here: `$sqlc -> bind_param('s', $number);`? — S.I., Oct 13 '16 at 05:14
I have tried using 'i' & 'd'. As well as using $number=(int)$_REQUEST["number"]; Didn't make a difference — Sharan, Oct 13 '16 at 05:17
Thank you. I went through the link and I am doing something similar to the example shown there. Even otherwise, I have tried withoug `store_result()` The `execute()` itself returns null — Sharan, Oct 13 '16 at 05:23
@RaxWeber why should they know it? Is anything wrong with this function? — Your Common Sense, Oct 13 '16 at 05:24
@YourCommonSense I don't have access to php settings. How do I see the error report then? — Sharan, Oct 13 '16 at 05:33
it is written in the post linked above. I can't see any reference to php.ini there, only few lines of PHP code which you can manage to write, I am sure — Your Common Sense, Oct 13 '16 at 05:57

PHP MySQLi query returning null

0 Answers0