ajax请求php数据出现些问题 - php吧

level 11

丶萝卜头楼主

数据已经传输到前端了（从浏览器的调试中network的respond可以看到数据），但是显示不出来（下面放代码）
（囊中羞涩，只能请大佬喝两杯奶茶）

2021年03月20日 11点03分 1

level 11

丶萝卜头楼主

前端：
<!DOCTYPE html>
<html ng-app = 'test'>
<head>
<meta charset="UTF-8">
<meta http-equiv="Content-type=text/html;charset=utf-8"/>

<script type="text/javascript" src="http://code.changer.hk/jquery/1.11.2/jquery.min.js"></script>

<link rel="stylesheet" href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
<style type="text/css">
.table{
width: 1000px;
text-align: center;
}
</style>
<title>学生信息管理</title>
</head>
<body ng-controller = 'main'>
<div class="">
<center>
<table class="table table-bordered table-striped">
<thead>
<tr>
<td>学/号</td>
<td>姓</td>
<td>名</td>
<td>邮件地址</td>
</tr>
</thead>
<tbody id="tbody"></tbody>
</table>
</center>
</div>
</body>
<script type="text/javascript">
//"{"id":"1","firstname":"John","lastname":"Doe","email":"[email protected]"}{"id":"2","firstname":"Mary","lastname":"Moe","email":"[email protected]"}{"id":"3","firstname":"Julie","lastname":"Dooley","email":"[email protected]"}{"id":"4","firstname":"John","lastname":"Doe","email":"[email protected]"}{"id":"5","firstname":"Mary","lastname":"Moe","email":"[email protected]"}{"id":"6","firstname":"Julie","lastname":"Dooley","email":"[email protected]"}{"id":"7","firstname":"John","lastname":"Doe","email":"[email protected]"}{"id":"8","firstname":"Mary","lastname":"Moe","email":"[email protected]"}{"id":"9","firstname":"Julie","lastname":"Dooley","email":"[email protected]"}{"id":"10","firstname":"John","lastname":"Doe","email":"[email protected]"}{"id":"11","firstname":"Mary","lastname":"Moe","email":"[email protected]"}{"id":"12","firstname":"Julie","lastname":"Dooley","email":"[email protected]"}"
$.ajax({
type: 'POST',
url: 'testdb.php',
data: {"id":"1","firstname":"John","lastname":"Doe","email":"[email protected]"},
success: function (data) {
//这里采用了一个非常笨的方法，有哪位大神有好的方法，回复一下呗，谢谢了
//使用正则表达式将其中的 '｝' 更换成 '｝ ' ,增加了一个空格，
var reg = new RegExp('}',"g");
var data = data.replace(reg,'} ');
//根据空格分割成多个对象，
var a = data.split(' ');
var trStr = '';//动态拼接table
for (var i = 0; i < a.length-1; i++) {
//a[i]=a[i].replace('{','');
trStr += '<tr class="example">';
trStr += '<td width="15%">' + JSON.parse(a[i]).id + '</td>';
trStr += '<td width="15%">' + JSON.parse(a[i]).firstname + '</td>';
trStr += '<td width="15%">' + JSON.parse(a[i]).lastname + '</td>';
trStr += '<td>' + JSON.parse(a[i]).email + '</td>';
//trStr += '<td>' + JSON.parse(a[i]).reg_date + '</td>';
trStr += '</tr>';
}
$("#tbody").html(trStr);
}
});
</script>
</html>

2021年03月20日 11点03分 2

level 11

丶萝卜头楼主

PHP：
<?php
header("Content-Type:text/html;charset=utf-8");//如果没有这句话，后面的汉字显示是乱码；
//code = $_POST['code'];
$status = "";
$success = "";
$scookies = "";
//连接数据库使用mysqli模式
$username="root";
$userpass="123456";
$servername = "localhost";
$dbname = "design";
$conn = "";//数据库变量
//连接数据库函数，参数分别是数据库地址，用户名，密码，数据库的名称
function connectdb($server,$name,$pwd,$databasename)
{
//创建连接，连接数据库，并判断是否连接成功
$conn = new mysqli($server,$name,$pwd,$databasename);
// 检测连接
if ($conn->connect_error)
{
die("link db failire: " . $conn->connect_error);
echo "connect database [" . $server . " ] failire <br/>";
return $conn;
}
else
{
echo "connect database [" . $server . "] successful <br/>";
return $conn;
}
}
//建立表格
function createnewtable($conn)
{
// 使用 sql 创建数据表
$sql = "CREATE TABLE MyGuests (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
email VARCHAR(50),
reg_date TIMESTAMP
)";
if ($conn->query($sql) == TRUE)
{
echo "Table MyGuests created successfully <br/>";
}
else
{
echo "create database table error: " . $conn->error . " <br/>";
return false;
}
}
//插入数据
function insertrecord($conn,$tablename)
{
//echo -e "\r\n";
//插入一条数据
$sql = "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('John', 'Doe', '[email protected]')";
if ($conn->query($sql) == TRUE)
{
print "insert one record successful <br/>";
} else
{
echo "Error: " . $sql . "<br/>" . $conn->error;
echo "\r\n";
}
$sql="";
//插入多条数据
$sql .= "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('Mary', 'Moe', '[email protected]');";
$sql .= "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('Julie', 'Dooley', '[email protected]')";
if ($conn->multi_query($sql) == TRUE) {
echo "insert records successful. <br/>";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
return true;
}
//删除数据
function del_data($conn,$sql)
{
print $sql . "</br>";
if($conn->query($sql)==true)
{
echo "delete records successful </br>";
}
else
{
echo "delete records failire </br>";
}
}
//将数据库的数据echo
function show_alldata_fromtable($servername,$username,$userpass,$dbname,$tablename)
{
$conn = mysqli_connect($servername,$username,$userpass,$dbname);
if(mysqli_connect_errno($conn))
{
echo "connect mysql failed " . mysqli_connect_error();
return;
}
echo "connect successful<br>";
//第二步设置相应的字符编码
//$mysqli->set_charset("utf8");
//$setting = 'set names utf8';
//mysqli_query($conn,$setting);
//echo "query successful <br>" ;//. $conn . $setting;
//第三步进行查询
$sql = 'SELECT * FROM MyGuests';
//执行查询语句，返回result为数据内容
if($result = mysqli_query($conn,$sql))
{
//得到查询的记录的个数，
$rowcount = mysqli_num_rows($result);
echo "return {$rowcount} records <br>";
echo
"<center>
<table>
<tr>
<th>序号 </th>
<th>姓 </th>
<th>名 </th>
<th>电子邮件 </th>
<th>时间日期 </th>
</tr>
</table>
</center>";
for($i = 0;$i <$rowcount;$i ++)
{
//按顺序一次读取一条记录，保存到sqldata中
$sqldata = mysqli_fetch_assoc($result);
echo
"<center>
<table>
<tr>
<td>".$sqldata['id']."</td>
<td>".$sqldata['firstname']."</td>
<td>".$sqldata['lastname']. "</td>
<td>".$sqldata['email']. "</td>
<td>".$sqldata['reg_date']. "</td>
</tr>
</table>
</center>";
}
mysqli_free_result($result);
}
//第五步把结果写到缓存文件
$file = "sqlcache.txt";
$msg = serialize($sqldata);
//echo $msg;
$fp = fopen($file,"w");
fputs($fp,$msg);
fclose($fp);
}
//执行
$conn = connectdb($servername,$username,$userpass,$dbname);
createnewtable($conn);
$sql = "DELETE FROM myguests ";
insertrecord($conn,'MyGuests');
//$conn->close();
show_alldata_fromtable($servername,$username,$userpass,$dbname,'',$conn);
$conn->close();
?>

2021年03月20日 11点03分 3

level 11

丶萝卜头楼主

目前情况是这样。