SELECT mysql with php json encode

Question

Here My code now :

$sql = "SELECT * FROM schedule_feednow WHERE IDMac = '".$_GET["IDMac"]."'";
$result = mysql_query($sql) or die(mysql_error());
$json_data = array();

while($rec = mysql_fetch_assoc($result)){
	$Subjson = array();
	$Subjson['IDMac'] = $rec['IDMac'];
	$Subjson['DATETIME'] = $rec['DATETIME'];
	$Subjson['Weight'] = $rec['Weight'];
	
	array_push($json_data,$Subjson);
	

}

echo json_encode ($json_data);

and Result :

[{"IDMac":"C-01","DATETIME":"12:05:19 AM on June 23, 2017","Weight":"50"},{"IDMac":"C-01","DATETIME":"12:05:55 AM on June 23, 2017","Weight":"50"},{"IDMac":"C-01","DATETIME":"02:02:20 PM on June 23, 2017","Weight":"50"}]

But I don't want this Result

I want this Result->

["Schedule":{"IDMac":"C-01","DATETIME":"12:05:19 AM on June 23, 2017","Weight":"50"},{"IDMac":"C-01","DATETIME":"12:05:55 AM on June 23, 2017","Weight":"50"},{"IDMac":"C-01","DATETIME":"02:02:20 PM on June 23, 2017","Weight":"50"}]

Please help me to generate code or train me. Thank you very much.

modsfabio · Accepted Answer · 2017-06-23 13:02:08Z

2

Simply put your current result into an array with key "Schedule":

echo json_encode(array('Schedule' => $json_data));

answered Jun 23, 2017 at 13:02

modsfabio

1,1371 gold badge13 silver badges31 bronze badges

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

Comments

aynber · Accepted Answer · 2017-06-23 13:01:49Z

1

Just create another array and put your json data in that:

$newJsonData = ['Schedule' => $json_data];
echo json_encode ($newJsonData);

answered Jun 23, 2017 at 13:01

aynber

23.2k9 gold badges57 silver badges69 bronze badges

Comments

Paladin · Accepted Answer · 2017-06-23 13:02:18Z

1

Replace

echo json_encode ($json_data);

with

$myResult = ['Schedule' => $json_data];
echo json_encode ($myResult);

answered Jun 23, 2017 at 13:02

Paladin

1,63715 silver badges29 bronze badges

Comments

JNCM · Accepted Answer · 2017-06-23 13:39:33Z

0

$sql = "SELECT * FROM schedule_feednow WHERE IDMac = '".$_GET["IDMac"]."'";
$result = mysql_query($sql) or die(mysql_error());
$json_data = array();

while($rec = mysql_fetch_array($result)){
	$json_data[] = $rec;
}

echo json_encode ('Schedule' => $json_data);

answered Jun 23, 2017 at 13:39

JNCM

1

1 Comment

mhatch Over a year ago

Can you provide some explanation for your example?

Collectives™ on Stack Overflow

SELECT mysql with php json encode

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related