Mysqli query returns empty string

Question

In progress of this issue:

This is my php code:

<?php 

error_reporting(E_ALL);
ini_set('display_errors', 1);


$mysqli2 = new mysqli('');

    if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
   }

    $sql2 = "SELECT message FROM wall_workouts_names WHERE id = '43' ";

    $stmt2 = $mysqli2->prepare($sql2) or trigger_error($mysqli2->error."[$sql2]");

    $stmt2->execute();

    $stmt2->bind_result($message);

    $stmt2->store_result();

     $stmt2->fetch();

    if($stmt2->num_rows > 0)
       echo $message;    
   else
        echo 'empty';    

?>

From this code i get empty string as a result.

This is my table in phpmyadmin

enter image description here

When i run the same code but with this query:

 $sql2 = "SELECT workout_name FROM wall_workouts_names WHERE id = '43' ";

My echo is "t", as is should be.

But when i run this query:

 $sql2 = "SELECT message FROM wall_workouts_names WHERE id = '43' ";

I get empty string, something like this: "".

I dont understand what im doing wrong.

What is the return value of $stmt2->bind_result($message); ? Is it === true? — Thomas Farvour
– Thomas Farvour, Commented Sep 10, 2013 at 16:25

Mike Firesheets · Accepted Answer · 2013-09-10 16:38:44Z

1

According to this commenter, the

"proper procedure order is: prepare -> execute -> store_result -> bind -> fetch."

I notice that you are calling store_result() AFTER you call bind_result(). Does changing the order of those calls make any difference?

answered Sep 10, 2013 at 16:38

Mike Firesheets

1396 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mike Firesheets Over a year ago

Have you tried other sanity checks, like selecting message and workout_name together, and selecting the message from a different record besides id 43?

dasdasd Over a year ago

I tried selecting different record, and still got empty string. BUT i tried selecting more than one column and its working, thank you.

Collectives™ on Stack Overflow

Mysqli query returns empty string

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related