MySQL data to JSON format using PHP script

Question

I have a table ('attributes') of data with three columns (created, temp and hum).

I need to write a php script to remove this data in JSON format in order for it to be charted with the ChartJS framework.

I have the following code so far but the script returns "Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\wamp\www\charttest\query.php on line 16"

  <?php 
$DBServer = 'localhost';
$DBUser = 'root';
$DBPass = '';
$DBName = 'digiplant_system';

$conn = new mysqli($DBServer, $DBUser, $DBPass, $DBName);

if ($conn->connect_error) {
    trigger_error('Could not connect to database!' . $conn->connect_error, E_USER_ERROR);
} 

$sql="Select * from attributes";
$l= array();
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {
  $l[] = $row;
}
$j = json_encode($l);
echo $j;
?>

best not to use mysql_ functions in new code.. they are deprecated. Can you use the mysqli equivalents, or PDO ? — msturdy, Feb 05 '14 at 20:35

score 3 · Answer 1 · answered Feb 05 '14 at 20:35

3

The error means the $result is false, mysql_query didn't work. You're mixing mysql and mysqli functions, they are very different

answered Feb 05 '14 at 20:35

helion3

30,779
15
51
95

if you could show me what to use instead that would be appreciated – Feb 05 '14 at 20:37
Stick with the functions included in the `mysqli` extension: http://us3.php.net/mysqli_query – helion3 Feb 05 '14 at 20:38

MySQL data to JSON format using PHP script

1 Answers1