出现问题

PHP代码<?php

header("Content-Type:text/html;charset=utf-8");//如果没有这句话，后面的汉字显示是乱码；

//连接数据库 使用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
";

return $conn;

}

else

{

//echo "connect database [" . $server . "] successful
";

return $conn;

}

}

//检测表是否存在

function check_table_is_exist($sql,$find_table)

{

$row=mysql_query($sql);

$database=array();

$finddatabase=$find_table;

while ($result=mysql_fetch_array($row,MYSQL_ASSOC))

{

$database[]=$result['Database'];

}

unset($result,$row);

mysql_close();

/*开始判断表是否存在*/

if(in_array($find_table,$database))

{

return true;

}

else

{

return false;

}

}

//create new table

function createnewtable($conn)

{

// 使用 sql 创建数据表

$sql = "CREATE TABLE MyGuests (

{1}

id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,

{1}

firstname VARCHAR(30) NOT NULL,

{1}

lastname VARCHAR(30) NOT NULL,

{1}

email VARCHAR(50),

{1}

reg_date TIMESTAMP

{1}

)";

if ($conn->query($sql) == TRUE)

{

echo "Table MyGuests created successfully
";

}

else

{

echo "create database table error: " . $conn->error . "
";

return false;

}

}

function insertrecord($conn,$tablename)

{

//echo -e "rn";

//插入一条数据

$sql = "INSERT INTO MyGuests (firstname, lastname, email)

{1}

VALUES ('John', 'Doe', 'john@example.com')";

if ($conn->query($sql) == TRUE)

{

print "insert one record successful
";

} else

{

echo "Error: " . $sql . "
" . $conn->error;

echo "rn";

}

$sql="";

//插入多条数据

$sql .= "INSERT INTO MyGuests (firstname, lastname, email)

{1}

VALUES ('Mary', 'Moe', 'mary@example.com');";

$sql .= "INSERT INTO MyGuests (firstname, lastname, email)

{1}

VALUES ('Julie', 'Dooley', 'julie@example.com')";

if ($conn->multi_query($sql) == TRUE) {

echo "insert records successful.
";

} else {

echo "Error: " . $sql . "
" . $conn->error;

}

return true;

}

/*

function showtabledata($conn,$sql)

{1}

{

{1}

$conn->query($sql);

{1}

}

{1}

*/

//删除某行数据

function del_data($conn,$sql)

{

print $sql . "";

if($conn->query($sql)==true)

{

echo "delete records successful ";

}

else

{

echo "delete records failire ";

}

}

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
";

//第二步设置相应的字符编码

//$mysqli->set_charset("utf8");

//$setting = 'set names utf8';

//mysqli_query($conn,$setting);

//echo "query successful
" ;//. $conn . $setting;

//第三步进行查询

//从 表中选取所有的列。

$sql = 'SELECT * FROM MyGuests';

//执行查询语句，返回result为数据内容

if($result = mysqli_query($conn,$sql))

{

//得到查询的记录的个数，

$rowcount = mysqli_num_rows($result);

//111echo "return {$rowcount} records
";

for($i = 0;$i

{

//按顺序一次读取一条记录，保存到sqldata中

$sqldata = mysqli_fetch_assoc($result);

echo

"

{1}

{1}

{1}

".$sqldata['id']."

{1}

".$sqldata['firstname']."

{1}

".$sqldata['lastname']. "

{1}

".$sqldata['email']. "

{1}

".$sqldata['reg_date']. "

{1}

{1}

{1}

";

}

//从结果集中取得行，然后释放结果内存：

mysqli_free_result($result);

}

//第五步把结果写到缓存文件

$file = "sqlcache.txt";

//通过序列化表单值，创建 URL 编码文本字符串。

$msg = serialize($sqldata);

//echo $msg;

//打开文件或者 URL

//"w" 写入方式打开，将文件指针指向文件头并将文件大小截为零。如果文件不存在则尝试创建之。

$fp = fopen($file,"w");

//写入文件

fputs($fp,$msg);

//关闭一个打开文件

fclose($fp);

}

//执行代码

$conn = connectdb("localhost","root","123456","design");

//createnewtable($conn);

//$sql = "DELETE FROM myguests ";

//del_data($conn,$sql);

//insertrecord($conn,'MyGuests');

//$conn->close();

show_alldata_fromtable("localhost","root","123456","design",'',$conn);

$conn->close();

?>

前端代码

更新

$.ajax({

type: 'POST',

url: 'testdb.php',

data: {"id":"1","firstname":"John","lastname":"Doe","email":"john@example.com"},

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 < data.length-1; i++) {

//a[i]=a[i].replace('{','');

trStr += '

';

trStr += '

' + data[i].id + '';

trStr += '

' + data[i].firstname + '';

trStr += '

' + data[i].lastname + '';

trStr += '

' + data[i].email + '';

//trStr += '

' + JSON.parse(a[i]).reg_date + '';

trStr += '

';

}

$("#tbody").html(trStr);

//设置id为tbody的tbody内容为trStr

}

});