例子一:
$i=0;
while($row = mysql_fetch_array($result))
{
$res[$i]['gname']=$row['gname'];
$res[$i]['gcatg']=$row['gcatg'];
$res[$i]['gmaker']=$row['gmaker'];
$res[$i]['gprice']=$row['gprice'];
$res[$i]['gnum']=$row['gnum'];
$res[$i]['gid']=$row['gid'];
$i++;
}
foreach($res as $eachres)
{
$eachres['gname'];
$eachres['gcatg'];
}
例子二:
$sponsors = array(
array('facebook','The biggest social network in the world.','http://www.facebook.com/'),
array('adobe','The leading software developer targeted at web designers and developers.','http://www.adobe.com/'),
array('microsoft','One of the top software companies of the world.','http://www.microsoft.com/'),
);
foreach($sponsors as $company)
{
echo $company[0];
echo $company[1];
}
从json中取数据(php)
$i=0;
while($row = mysql_fetch_array($result))
{
$res[$i]['gname']=$row['gname'];
$res[$i]['gcatg']=$row['gcatg'];
$res[$i]['gmaker']=$row['gmaker'];
$i++;
}
echo json_encode($res);
对应的js取数据
res1 = $.parseJSON(res);
for(var i=1;i<res1.length;i++){
for(var key in res1[i]){
console.log("key:"+key+",value:"+res1[i][key]);
}
}