mysqli returning null values

Question

im trying to get data from my DB but all i get is null values.

I know that the query isnt empty because i get values from inside my if($stmt->num_rows > 0)

code.

When i run my query on my phpmyadmin i also get good results.

This is my code thanks for helping:

$sql = "SELECT register_date FROM personal WHERE user_id = ?"; 

    $stmt = $mysqli->prepare($sql) or trigger_error($mysqli->error."[$sql]");

    $stmt->bind_param('s', $user_id);

    $user_id = $_GET['user_id'];

    $stmt->execute();

    $stmt->store_result();

    $stmt->bind_result($register_date);

    if($stmt->num_rows > 0)
    {

         $response["date"] = $register_date;
         $response["success"] = 1;
           // echoing JSON response
           echo json_encode($response);

    }

    else
    {
          $response["success"] = 0;
          echo json_encode($response);
    }

Not familiar with MySQLi but don't you need to set $user_id before the bind_param? — user849001
– user849001, Commented Aug 1, 2013 at 9:04

ujjwalwahi · Accepted Answer · 2013-08-01 08:54:14Z

2

Try

$stmt->bind_result($register_date);
$stmt->execute();
$stmt->store_result();
$stmt->fetch();
echo $register_date;

Please read bind_result doc

answered Aug 1, 2013 at 8:54

ujjwalwahi

3421 gold badge4 silver badges13 bronze badges

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

1 Comment

dasdasd Over a year ago

I forgot about $stmt->fetch();. Thank you for helping

Story Teller · Accepted Answer · 2013-08-01 08:50:24Z

-1

Your code is a bit mixed up, you'll need to define your variables (in this case $user_id) before using them.

I suggest moving to PDO rather than using MySQLi.

answered Aug 1, 2013 at 8:50

Story Teller

4371 gold badge4 silver badges14 bronze badges

Collectives™ on Stack Overflow

mysqli returning null values

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related