Retrieve data from MySQLi under prepared statement

Asked Mar 23 '20 at 05:03

Active Mar 23 '20 at 05:14

Viewed 40 times

I have this MYSQLi query below. The connection to the database is no problem. I tried to use bind_result too, it could retrieve the data without any problem. However when I use select * statement, it returned the result only True or False. It didn't return any data. Is there anything wrong?

Error: returned from PHP

Fatal error: Call to a member function fetch_array() on boolean in line 20

Code:

$conn       = new CDatabase();
$mysqli     = $conn->dbConnect();

$sqlstmt = "SELECT * FROM general_staff WHERE generalstaff_userid =? AND generalstaff_password =? LIMIT 1";

if ($mysqli->connect_error) { echo "Connection failure."; }

    if($stmt = $mysqli->prepare($sqlstmt)){
        $stmt->bind_param("ss", $username, $password);
        $stmt->execute();
        $stmt->store_result();
        $stmt_result = $stmt->get_result();
        $stmt_rows = $stmt->num_rows();

        if ($stmt_rows >0) {    

            while ($row = $stmt_result->fetch_array()){
                echo $row[1];
        }
    }
?>

By adding this code below to get error code, it returned 1193

if (!$mysqli->query("SET a=1")) {
printf("Errorcode: %d\n", $mysqli->errno);

edited Mar 23 '20 at 05:14

asked Mar 23 '20 at 05:03

Ken

1

Check the result of `$stmt->execute()`. – Barmar Mar 23 '20 at 05:16
may i ask how... – Ken Mar 23 '20 at 05:24
See https://stackoverflow.com/a/22662582/283366 – Phil Mar 23 '20 at 05:40
Hard to tell which one is the problem here, but two links provided should be enough – Your Common Sense Mar 23 '20 at 06:47

Retrieve data from MySQLi under prepared statement

0 Answers0