执行$ stmt-> num_rows时返回0 [重复]

Question

This question already has an answer here:

• Mysqli Prepared Stmt returns 0 num_rows 1 answer

I am new to mysqli. I am connecting to a mysql db, and fetching some data.

$user_id = "CCD_00005";

    /* create a prepared statement */
    if ($stmt = mysqli_prepare($GLOBALS['conn'], "SELECT user_name FROM user_master WHERE user_id=?")) {

        /* bind parameters for markers */
        mysqli_stmt_bind_param($stmt, "s", $user_id);

        /* execute query */
        mysqli_stmt_execute($stmt);

        /* bind result variables */
        mysqli_stmt_bind_result($stmt, $user_name);

        /* fetch value */
        mysqli_stmt_fetch($stmt);

        echo("Total Results:".$stmt->num_rows."<br />");

        printf("%s is having name %s
", $user_id, $user_name);

        /* close statement */
        mysqli_stmt_close($stmt);
 }

I am getting the result Total Results:0 CCD_00005 is having name sdafasdf

Why am I not getting the row count as 1.

Please help.

</div>

Answer 1

change your execution order as below:

$user_id = "CCD_00005";

    /* create a prepared statement */
    if ($stmt = mysqli_prepare($GLOBALS['conn'], "SELECT user_name FROM user_master WHERE user_id=?")) {

        /* bind parameters for markers */
        mysqli_stmt_bind_param($stmt, "s", $user_id);

        /* execute query */
        mysqli_stmt_execute($stmt);

        mysqli_stmt_store_result($stmt);        
        echo("Total Results:".mysqli_stmt_num_rows($stmt)."<br />");

        /* bind result variables */
        mysqli_stmt_bind_result($stmt, $user_name);

        /* fetch value */
        mysqli_stmt_fetch($stmt);


        printf("%s is having name %s
", $user_id, $user_name);

        /* close statement */
        mysqli_stmt_close($stmt);