PHP接收 JSON 格式資料

<?php

header ('Content-Type: text/html; charset=UTF8');

$name = $_POST["name"];

$order_date= $_POST["order_date"];

$price = $_POST["price"];

//建立資料連線

$link=mysql_connect("sql102.000space.com","space_13936932","nate8586");

if(!$link){

echo("Failure");

}

//開啟資料庫

$db_selected=mysql_select_db("space_13936932_breakfast",$link);

if(!$db_selected){

echo("not open space_13901458_breakfast<br>".mysql_error($link));

}

mysql_query("SET NAME 'UTF8'");

mysql_query('SET NAMES utf8');

mysql_query('SET CHARACTER_SET_CLIENT=utf8');

mysql_query('SET CHARACTER_SET_RESULTS=utf8');

//新增資料

$sql="insert into breakfast(order_date, name, price, status) VALUES ('$order_date', '$name', '$price', '0')";

if (mysql_query($sql,$link)){

echo "Database my_db created";

}else{

echo "Error creating database: " . mysql_error();

}

//釋放查詢結果所佔用的記憶體

mysql_free_result($result);

//關閉資料庫

mysql_close($link);

?>