主要技术:一、运用php获取数据库的数据,并将数据转化为二维数据的形式’,运用json_encode() 对数组变量进行JSON编码。二、在js中将php数组转化为js数组并使用eval()解析数组数据,通过for循环动态创建表格并添加相应的css样式使表格更加美观。
代码:php部分:
<?php
require_once "..\MyPhp\MySqlConnect.php";
mysqli_query($conn , "set names utf8");
//学生信息二维数组
$memberinfo=null;
$memberinfos=null;
$i=0;
$sql = "Select examanswer.tno,testpaper.tname,examanswer.mno,members.mname
,examinfo.startime,examinfo.endtime,examinfo.location
from examanswer,testpaper,examinfo,members
WHERE testpaper.tno=examanswer.tno and examinfo.tno=examanswer.tno
and examinfo.mno=examanswer.mno
and members.mno=examanswer.mno
group by examanswer.tno,examanswer.mno
";
$result = mysqli_query($conn,$sql);
while ($row = mysqli_fetch_assoc($result)) {
$memberinfo[0] = $row['tno'];
$memberinfo[1] = $row['tname'];