DaniWeb Forum Index > Web Development > PHP

How do I use PHP to create a JSON object?

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Mar 2008

Posts: 8

Reputation: agrarian is an unknown quantity at this point

Solved Threads: 0

agrarian

Offline

Newbie Poster

How do I use PHP to create a JSON object?

Sep 2nd, 2009

I am trying to use a Dojo (ajax) table on my page that has detail rows in which I want to draw detail tables. The tables have a format event which calls formatDetail. In this event I would like to build a simple table using JSON data.

My problem is how do I use PHP to create the JSON data object so that my formatDetail javascript can use it?

My test code so far is, in the header:

 Help with Code Tags 
 javascript Syntax (Toggle Plain Text) 
function formatDetail(inWatchId, inRowIndex) {
	alert("Length is: " + myJSON.length);
}
function formatDetail(inWatchId, inRowIndex) {
	alert("Length is: " + myJSON.length);
}

And in the body of the page:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$stmt = sqlsrv_query($connection,$query);
while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC))
{
	$arr[] = $row;
}
$objJSON = '{"sample":'.json_encode($arr).'}';
echo "<script>var myJSON = $objJSON;</script>";
$stmt = sqlsrv_query($connection,$query);
while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC))
{
	$arr[] = $row;
}
$objJSON = '{"sample":'.json_encode($arr).'}';
echo "<script>var myJSON = $objJSON;</script>";

When I try this, the js alert displays "Length is undefined"

What am I doing wrong?

•

Join Date: Apr 2005

Posts: 1,435

Reputation: ShawnCplus is a glorious beacon of light

Solved Threads: 233

ShawnCplus ShawnCplus is offline

Offline

Code Monkey

Re: How do I use PHP to create a JSON object?

Sep 2nd, 2009

Don't try to mix creating your own json strings

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$objJSON = array('sample' => null);
// whatever
$objJSON['sample'] = $arr;
$objJSON = json_encode($objJSON);
echo '<script type="text/javascript">var myJSON = ' . $objJSON . ';</script>
 
$objJSON = array('sample' => null);
// whatever
$objJSON['sample'] = $arr;
$objJSON = json_encode($objJSON);
echo '<script type="text/javascript">var myJSON = ' . $objJSON . ';</script>

Last edited by ShawnCplus; Sep 2nd, 2009 at 4:13 pm.

GCS d- s+ a-->? C++(++++) UL+++ P+>+++ L+++ E--- W+++
N+ o K w++(---) O? !M- V PS+>++ PE+ Y+ PGP !t- 5? X- R tv+
b+>++ DI+ D G++>+++ e+ h+>++ r y+
PMs asking for help will not be answered, post on the forums. That's what they're there for.