Json encode a php mysql query

Question

I am having issues with a $json variable in my code. For some reason, my php query isn't being encoded into my $json variable.

$sql = "SELECT `$column`, `Year`, `Month` FROM unemployed WHERE year BETWEEN ? AND ? and month= ?";

$stmt = $conn->stmt_init();
$stmt->prepare($sql); 
$stmt->bind_param('sss', $gYear, $gYear2, $gMonth);
$stmt->bind_result($Column, $year, $month);
$stmt->execute();
$stmt->store_result();
$numRows = $stmt->num_rows;
$json = array();

if ($numRows) { ?>

<table>
<tr>
<th scope="col"> Hi </th>
<th scope="col"> Year </th>
<th scope="col"> Month </th>
</tr>

<?php while ($row = $stmt->fetch()) { ?>
<tr>
<td> <?php echo $Column; ?> </td>
<td> <?php echo $year; ?> </td>
<td> <?php echo $month; ?> </td>
</tr> 
$json['unemployed'][]= $row;
<?php } ?>
</table>
<?php
echo json_encode($json);
var_dump($json);
?>

After running this script, there still isn't anything in my $json variable. Does anyone know why that is? Shouldn't the variable now be an array with my query values (each row would now be part of an array)?

This is what I get: $json['unemployed'][]= $row; $json['unemployed'][]= $row; echo json_encode($json); var_dump($json); — user2562125
– user2562125, Commented Oct 15, 2013 at 16:39

Rickkwa · Accepted Answer · 2013-10-15 17:12:47Z

1

It doesn't even look like

$json['unemployed'][]= $row;

is within php tags.

Also, it looks like fetch() returns boolean. When you call fetch(), it looks like it fills the variables $Column, $year, and $month with the values from the row. So instead of

$json['unemployed'][]= $row;

Do this:

$json['unemployed'][]= array($Column, $year, $month);

edited Oct 15, 2013 at 17:12

answered Oct 15, 2013 at 16:42

Rickkwa

2,3015 gold badges25 silver badges37 bronze badges

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

9 Comments

user2562125 Over a year ago

Yes that was previous error. Except now I don't believe what I am getting is correct. Here is what var_dump is now: {"unemployed":[true]}array(1) { ["unemployed"]=> array(1) { [0]=> bool(true) } }

Rickkwa Over a year ago

@user2562125 What output did you expect?

user2562125 Over a year ago

Something like {"unemployed":[["183,000","1992","January"],["175,000","1993","January"]]}

Rickkwa Over a year ago

php.net/manual/en/mysqli-stmt.fetch.php It looks like this function returns True/false

user2562125 Over a year ago

So what could I use in place of $stmt->fetch?

|

Ohgodwhy · Accepted Answer · 2013-10-15 16:41:32Z

0

The issue is that you're outside of the scope of the PHP interpreter when attempting to parse the PHP code.

</tr> 
$json['unemployed'][]= $row;

to

</tr> 
<?php $json['unemployed'][]= $row; ?>

answered Oct 15, 2013 at 16:41

Ohgodwhy

50.8k11 gold badges86 silver badges114 bronze badges

1 Comment

user2562125 Over a year ago

Okay now I am getting this: (var_dump is this) {"unemployed":[true]}array(1) { ["unemployed"]=> array(1) { [0]=> bool(true) } }

Collectives™ on Stack Overflow

Json encode a php mysql query

2 Answers 2

9 Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

1 Comment

Related