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);
?>