Posted By

ecavazos on 01/21/08

Tagged

php
json

Versions (?)

Last Edited at 01/21/08 11:59pm

Statistics

Viewed 1087 times

Favorited by 4 user(s)

Related snippets

Output JSON String from PHP

/ Published in: PHP

This snippet references the data access class I linked to.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

// query parameters
$p[0] = 'id';
$p[1] = 'name';
 
// query database
$result = $dal->selectFieldsOrder('inventory_categories', $p, 'name asc');
 
$numRows = $result->num_rows;
$loopCount = 1;
 
$json = '{ '
	  . '"categories" : [';
 
// build json string
while ($row = $result->fetch_assoc()) {
	$json .= '{ '
		  . '"id" : "' . $row['id'] . '", '
		  . '"name" : "' . addcslashes($row['name'], '"') . '" '
		  . '}';
 
	// add comma if 	  
	if ($loopCount < $numRows) {
		$json .= ', ';
		$loopCount++;
    }
}
 
$json .= '] '
	  . '}';
 
echo $json;