- 论坛徽章:
- 0
|
本帖最后由 mmx384 于 2013-04-13 16:32 编辑
请各位看看这是什么情况,快要搞晕了。
出现问题如图:
http://hc5621722.130188.dprktimes.com/search.php
页面代码如下:- <?php
- session_start();
- header("Content-type: text/html; charset=utf-8");
- $dbhost = 'admin.130188.dprktimes.com';
- $dbbase = 'mmx384';
- $dbuser = 'mmx384';
- $dbpwd = '××××××××';
- $dblink = mysql_connect($dbhost,$dbuser,$dbpwd) or die('连接数据库失败:'.mysql_error());
- //mysql_close($dblink);
- mysql_select_db($dbbase,$dblink) or die( "不能选定数据库 ${dbbase}:".mysql_error());
- mysql_query("set names utf8",$dblink) or die('set names error.');
- $HTML = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
- <title>title</title>
- </head>
- <body>';
- $putstr = $HTML."<form id='myform' name='myform' method='post' >";
- $xq = 14;
- $sid = 1;
- $gid = 1;
- $sqlstr = "select `stu`.`sit`,`stu`.`cid`,`stu`.`num`,`arch_stu`.`name` from `stu` left join `arch_stu` on `stu`.`num` = `arch_stu`.`num` where `stu`.`xq` = ${xq} and `stu`.`sid` = ${sid} and `stu`.`gid` = ${gid} order by `stu`.`cid` asc,`stu`.`sit` asc";
- //echo $sqlstr;
- unset($num_arr);
- $result = mysql_query($sqlstr,$dblink) or die('查询失败,未知错误请联系管理员');
- if(mysql_num_rows($result) > 0){
- while($rs=mysql_fetch_array($result)){
- $sit_arr[] = $rs['sit'];
- $class_arr[] = $rs['cid'];
- $num_arr[] = $rs['num'];
- $name_arr[] = $rs['name'];
- }
- }
- $putstr .= '<table border="1">';
- $putstr .= '<tr ><td>座位</td><td>班级</td><td>学籍号</td><td>姓名</td></tr>';
- if(isset($num_arr)){
- foreach($num_arr as $i=>$val){
- $putstr .= '<tr>';
- $putstr .= "<td>".$sit_arr[$i]."</td>"; //座位号
- $putstr .= "<td>一(1)</td>"; //班级
- $putstr .= "<td>".$num_arr[$i]."</td>"; //学籍号
- $putstr .= "<td>".$name_arr[$i]."</td>"; //姓名
- $putstr .= '</tr>';
- }
- }
- $putstr .= '</table>';
- $putstr .= '</form></body></html>';
- echo $putstr;
- ?>
复制代码 如果[班级]列是不是中文则表格正常。
|
|