php MySQLi Object-Oriented prepared statements

Asked Nov 17 '17 at 14:24

Active Nov 17 '17 at 14:47

Viewed 388 times

I am new in php, the below is what I did. The output is 012345, that means $result= $pre->get_result(); has problem.

P.S. I tried to use int instead of String here $pre->bind_param('i',$id);, but it has the same output.

<?php                       
require 'Connections/pplcon.php';
header("Content-Type:text/html; charset=utf-8");
mysqli_set_charset( $conn, 'utf8');
?> 


<?php

/* activate reporting */
$driver = new mysqli_driver();
$driver->report_mode = MYSQLI_REPORT_ALL;


$id="1";

    //Created a template
    echo 0; 
    $sql = "SELECT * FROM Coupon WHERE ActivityID = ?";
    //Create a prepared statement
    echo 1; 
    if($pre = $conn->prepare($sql)) {
        echo 2; 
        $pre->bind_param('s',$id);
        echo 3; 

        echo 4; 
        $pre->execute();
        echo 5; 
        $result= $pre->get_result();
        echo 6; 
        if ($result->num_rows > 0) {
                while ($row = mysqli_fetch_assoc($result)) {
                    echo $row['ActivityID'] . "<br>";
                }

        }
    }
    else {
        echo 0; 
    }

?>

edited Nov 17 '17 at 14:38

asked Nov 17 '17 at 14:24

Eric Chong

Everything fine with the db connection? – B001ᛦ Nov 17 '17 at 14:26
I expect output is 01234561 – Eric Chong Nov 17 '17 at 14:27
yes, db connection is fine for sure, because i use the same connection for another file, it works fine and shows correct record. – Eric Chong Nov 17 '17 at 14:31
Have you considered declaring `$id` before you bind? Have you checked your error logs? – Jay Blanchard Nov 17 '17 at 14:31
You should enable exception-based error reporting. Maybe there is some error you missed: http://php.net/manual/en/mysqli-driver.report-mode.php – tereško Nov 17 '17 at 14:31
Where did you define the variable `$id`? – Rotimi Nov 17 '17 at 14:32
Right before `echo 4;` @Akintunde – Jay Blanchard Nov 17 '17 at 14:32
1

No it should be before `bind_param()` .. At the moment it should be undefined – Rotimi Nov 17 '17 at 14:33
I update the code, please see the updated. but the output is same 012345 and please kindly adv how to find the error report – Eric Chong Nov 17 '17 at 14:40
what is your PHP version? – Your Common Sense Nov 17 '17 at 14:46
php version 5.8 – Eric Chong Nov 17 '17 at 15:24
there is no such version. Can you check it again? – Your Common Sense Nov 17 '17 at 15:58
php version 5.6.30 – Eric Chong Nov 17 '17 at 16:01

php MySQLi Object-Oriented prepared statements

0 Answers0