PHP returning null values when the data exists

Question

I am running a making a mobile app that uses PHP to retrieve data from a web server.

When I run the SQL statement in the sql query it returns the correct data.

when I run the PHP it returns null values for the item at location 0 in the gameArray, all other items in the array show the right values

the code is as follows

$userResponse = array(
            'login' => $userName,
            'nickname' => $userNickName); 

$stmt = $conn->gamedb->prepare("SELECT player1, player2, currentturn, question1, question2, question3, question4, question5, question6, question7, question8, question9 FROM Game WHERE Player1 = ? OR Player2 = ?");
$stmt->bind_param('ss', $userName, $userName);
$stmt->execute();
$result = $stmt->store_result();

//create games array to be filled when stepping through the games
$gameResponse = array();

if($conn->gamedb->affected_rows > 0)
{
    while ($stmt->fetch())
    {
        $stmt->bind_result($player1, $player2, $currentTurn,
                           $question1, $question2, $question3,
                           $question4, $question5, $question6,
                           $question7, $question8, $question9);

        $gameArray = array($player1, $player2, $currentTurn,
                           $question1, $question2, $question3,
                           $question4, $question5, $question6,
                           $question7, $question8, $question9);


        //stores the game data into an array
        $gameResponse[] = $gameArray;
    }

    //close stmt
    $stmt->close();
}

$response = array(
            $userResponse,
            $gameResponse
            );

echo json_encode($response);

any help would be awesome!

I wouldn't bother with checking affected_rows

Phil
– Phil

2013-10-14 03:26:01 +00:00
Commented Oct 14, 2013 at 3:26 — Phil
– Phil, Commented Oct 14, 2013 at 3:26

Machavity · Accepted Answer · 2013-10-14 03:27:19Z

1

Could I suggest you try something a bit simpler?

while($row = $result->fetch_assoc()) {
    $gameResponse[] = $row;
}

This way you don't have to go through all the gyrations of assigning variables and such. PHP will do that for you.

answered Oct 14, 2013 at 3:27

Machavity♦

31.8k27 gold badges97 silver badges108 bronze badges

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

Comments

Phil · Accepted Answer · 2013-10-14 03:33:18Z

0

Reading the manual page for mysqli_stmt::fetch, it clearly states

Note that all columns must be bound by the application before calling mysqli_stmt_fetch().

Try this instead...

$gameResponse = array();

$stmt->bind_result($player1, $player2, $currentTurn,
                   $question1, $question2, $question3,
                   $question4, $question5, $question6,
                   $question7, $question8, $question9);

while ($stmt->fetch()) {
    $gameResponse[] = array($player1, $player2, $currentTurn,
                            $question1, $question2, $question3,
                            $question4, $question5, $question6,
                            $question7, $question8, $question9);
}

edited Oct 14, 2013 at 3:33

answered Oct 14, 2013 at 3:27

Phil

166k25 gold badges265 silver badges269 bronze badges

Collectives™ on Stack Overflow

PHP returning null values when the data exists

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related