PHP MySQL中间件 返回JSON
作者:
好好他爸爸 | 来源:发表于
2020-06-13 23:57 被阅读0次<?php
$MySql_ServerIP = "127.0.0.1";
$MySql_UserName = "root";
$MySql_Password = "root";
$MySql_DBName ="";
$MySQL_Conn = new Mysqli($MySql_ServerIP,$MySql_UserName,$MySql_Password,$MySql_DBName);
if ($MySQL_Conn->connect_error){
die("连接失败,失败原因: ".$MySQL_Conn->connect_error);
}
if($_SERVER['REQUEST_METHOD'] == 'POST')
{
if(empty($_POST["sql"]))
{
echo "sql错误";
exit();
}
else
{
$sql = $_POST["sql"];
$result = $MySQL_Conn->query($sql);
$JsonArr = array();
while($row = $result->fetch_assoc())
{
$JsonArr[] = $row;
}
echo json_encode($JsonArr);
$MySQL_Conn->close();
}
}
else
{
echo "禁止访问!";
}
?>
本文标题:PHP MySQL中间件 返回JSON
本文链接:https://www.haomeiwen.com/subject/dppqxktx.html
网友评论