<?php
ini_set("error_reporting","E_ALL & ~E_NOTICE");
/*连接数据库*/
$con = mysql_connect("localhost","root","root");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$zz = ('$_POST[location]','$_POST[oxygen]','$_POST[negative]','$_POST[temp]','$_POST[humidity]','$_POST[pm]');
$mz = json_decode($zz);
mysql_select_db("emp", $con);
$sql="INSERT INTO tianqi (location, oxygen, negative, temp, humidity, pm)
/*通过$_post变量从表单中取回值*/
VALUES($zz)"; if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";mysql_close($con)
请问下我这个代码对吗, 服务器需要接收从客户端传来的json数据
客户端传来的数据类型是这样的:{"id":"1","location":"汉字","oxygen":"3.33","negative":"23.2","humidity":"22","temp":"2.33","pm":"6"}
ini_set("error_reporting","E_ALL & ~E_NOTICE");
/*连接数据库*/
$con = mysql_connect("localhost","root","root");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$zz = ('$_POST[location]','$_POST[oxygen]','$_POST[negative]','$_POST[temp]','$_POST[humidity]','$_POST[pm]');
$mz = json_decode($zz);
mysql_select_db("emp", $con);
$sql="INSERT INTO tianqi (location, oxygen, negative, temp, humidity, pm)
/*通过$_post变量从表单中取回值*/
VALUES($zz)"; if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";mysql_close($con)
请问下我这个代码对吗, 服务器需要接收从客户端传来的json数据
客户端传来的数据类型是这样的:{"id":"1","location":"汉字","oxygen":"3.33","negative":"23.2","humidity":"22","temp":"2.33","pm":"6"}
//$_POST['zz']为你接收json的值$sql = "INSERT INTO tianqi (location, oxygen, negative, temp, humidity, pm) values ('".$zz['location']."')";
//后面的值,自己加上
@ayzen1988 可是需要先接收客户端传来的值啊 该怎么接收客户端传来的值然后赋值在$zz上
是这样吗 $zz = json_decode('$_POST[location]','$_POST[oxygen]','$_POST[negative]','$_POST[temp]','$_POST[humidity]','$_POST[pm]', true);