<?php
$mysql_server_name = "localhost";
$mysql_username="root";
$mysql_password="123";
$mysql_database="eqms";
//判断是否为空。_POST是post请求方式,_GET是get请求方式。客户端请求
if(isset($_POST['name'])){
$name = $_POST['name'];
}
//连接数据库
$conn = mysqli_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database);
// 检测连接
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
//echo "连接成功";
//echo "<br/>";
//查询表
$sql = "SELECT * FROM student where name='$name'";
//遍历表
$result = $conn->query($sql);
$json ="";
$data =array(); //定义好一个数组.PHP中array相当于一个数据字典
//定义一个类,用到存放从数据库中取出的数据
class User
{
public $name ;
public $sex;
public $birth;
}
//输出每一行数据
while($row = $result->fetch_assoc())
{
/*echo "<br />";
echo $row['name'] . " " . $row['birth'];
echo "<br />";*/
$user =new User();
$user->name = $row["name"];
$user->sex = $row["sex"];
$user->birth = $row["birth"];
$data[]=$user;
}
$json = json_encode($data);//把数据转换为JSON数据.
//php中用.连接,类似+
echo "{".'"user"'.":".$json."}";
mysqli_close($conn);
?>
$mysql_server_name = "localhost";
$mysql_username="root";
$mysql_password="123";
$mysql_database="eqms";
//判断是否为空。_POST是post请求方式,_GET是get请求方式。客户端请求
if(isset($_POST['name'])){
$name = $_POST['name'];
}
//连接数据库
$conn = mysqli_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database);
// 检测连接
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
//echo "连接成功";
//echo "<br/>";
//查询表
$sql = "SELECT * FROM student where name='$name'";
//遍历表
$result = $conn->query($sql);
$json ="";
$data =array(); //定义好一个数组.PHP中array相当于一个数据字典
//定义一个类,用到存放从数据库中取出的数据
class User
{
public $name ;
public $sex;
public $birth;
}
//输出每一行数据
while($row = $result->fetch_assoc())
{
/*echo "<br />";
echo $row['name'] . " " . $row['birth'];
echo "<br />";*/
$user =new User();
$user->name = $row["name"];
$user->sex = $row["sex"];
$user->birth = $row["birth"];
$data[]=$user;
}
$json = json_encode($data);//把数据转换为JSON数据.
//php中用.连接,类似+
echo "{".'"user"'.":".$json."}";
mysqli_close($conn);
?>