Mysqli query return empty results

Question

im trying to get some data from my DB using this 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 = ? ";

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

    $id_for_wall = '43';

    $stmt2->bind_param('s', $id_for_wall);

    $stmt2->execute();

    $stmt2->bind_result($message);

    $stmt2->store_result();

    $stmt2->fetch();

        echo $message;

?>

My problem is that i get empty string in my echo.

But if i run the same query in my phpmyadmin i get good results.

Thanks for helping

Although this question is a sure too localized one, +1 for having error reporting almost proper. — Your Common Sense
– Your Common Sense, Commented Sep 9, 2013 at 13:20
To make it straight: your code looks all right. As much as a human can tell. To investigate a problem you have to run your code and debug it. The sooner you understand it the sooner you have your code working. — Your Common Sense
– Your Common Sense, Commented Sep 9, 2013 at 14:01

Your Common Sense · Accepted Answer · 2013-09-09 13:19:26Z

1

Most likely there are no row to match condition in your WHERE clause, namely with id = 43

answered Sep 9, 2013 at 13:19

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

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

7 Comments

Your Common Sense Over a year ago

Try to run it right here with a hardcoded (not bound) value and see. Using query()/fetch_array()

dasdasd Over a year ago

I tried hardcoded and i get empty result. But when i use it in my phpadmin, same query, i get good result...

Your Common Sense Over a year ago

WEll, you are querying another database with your phpmyadmin then

dasdasd Over a year ago

Its not, im sure about it.

Your Common Sense Over a year ago

You'd better trust your eyes, not speculations. This is a most important skill a developer have to develop. Try to select all the records from the table and see.

|

Nunser · Accepted Answer · 2013-09-09 13:46:56Z

-1

Check your incoming results like this.

 while ($stmt->fetch()) {
   echo $message;    
 }

edited Sep 9, 2013 at 13:46

Nunser

4,5228 gold badges27 silver badges37 bronze badges

answered Sep 9, 2013 at 13:30

rohitcopyright

3421 gold badge2 silver badges9 bronze badges

1 Comment

Your Common Sense Over a year ago

this code is useless itself and won't help to solve the particular problem in question.

Collectives™ on Stack Overflow

Mysqli query return empty results

2 Answers 2

7 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related