[code=PHP]<?php
session_start();
if($_SESSION['admin']=="")echo"<script language=javascript>alert('请先登陆!');window.location.href='login2.php';</script>";
require_once('../config.php');
$link_id = mysql_connect($dbhost,$dbuser,$dbpwd);
mysql_select_db($dbname);
mysql_query("set names 'gbk'");
$kaodian=$_GET[kaodian];
$kaochang=$_GET[kaochang];
$kemu=$_GET[kemu];
$str="select * from rc_zkz where kaodian= '$kaodian' and kaochang ='$kaochang'";
$result=mysql_query($str,$link_id);
$rs=mysql_fetch_array($result);
$shenfenzh=$rs[shenfenzh];
$pic=$rs[pic];
$kaodian=$rs[kaodian];
$kaochang=$rs[kaochang];
$zuowei=$rs[zuowei];
$danwei=$rs[danwei];
$zkz=$danwei.$kaodian.$kaochang.$zuowei;
?>
<!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=gb2312" />
<title></title>
<style type="text/css">
<!--
.STYLE5 {
font-size: 12px;
line-height: 15px;
}
.STYLE1 {font-size: 12px}
.STYLE7 {font-size: 10px}
.STYLE2 {
font-size: 16px;
}
.STYLE8 {
font-size: 10px
}
.STYLE3 {font-size: 28px; font-weight: bold; }
.STYLE4 {font-size: 20px; font-weight: bold; }
#bj{
height: auto;
width: auto;
background-image: url(img/1.png);
}
</style>
<script type="text/javascript" src="../javascript/function.js"></script>
<script language="javascript" >
function CLASS_LIANDONG_YAO(array)
{
//数组,联动的数据源
this.array=array;
this.indexName='';
this.obj='';
//设置子SELECT
// 参数:当前onchange的SELECT ID,要设置的SELECT ID
this.subSelectChange=function(selectName1,selectName2)
{
//try
//{
var obj1=document.all[selectName1];
var obj2=document.all[selectName2];
var objName=this.toString();
var me=this;
obj1.onchange=function()
{
me.optionChange(this.options[this.selectedIndex].value,obj2.id)
} }
//设置第一个SELECT
// 参数:indexName指选中项,selectName指select的ID
this.firstSelectChange=function(indexName,selectName)
{
this.obj=document.all[selectName];
this.indexName=indexName;
this.optionChange(this.indexName,this.obj.id) }
// indexName指选中项,selectName指select的ID
this.optionChange=function (indexName,selectName)
{
var obj1=document.all[selectName];
var me=this;
obj1.length=0;
obj1.options[0]=new Option("请选择",'');
for(var i=0;i<this.array.length;i++)
{
if(this.array[i][1]==indexName)
{
//alert(this.array[i][1]+" "+indexName);
obj1.options[obj1.length]=new Option(this.array[i][2],this.array[i][0]);
}
}
}
}
</script>
</head>
<body>
<table width="643" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td width="643"><table width="634" border="0" cellpadding="0" cellspacing="0">
<tr><td colspan="2"><table width="644" border="0" align="center" cellpadding="0" cellspacing="0"><form action="?" name="form" method="get">
<tr>
<td width="166" height="22" align="center"><label>考点:
<select name="kaodian" id="kaodian">
</select>
</label></td>
<td width="134" align="center"><label>考场:
<select name="kaochang" id="kaochang">
</select>
</label></td>
<td width="146" align="center"><p>
<label>
<input name="kemu" type="radio" id="RadioGroup1_0" value="职业能力测试" checked="checked" />
职业能力测试 </label>
<br />
</p></td>
<td width="136" align="center"><label>
<input type="radio" name="kemu" value="公共基础知识" id="RadioGroup1_1" />
公共基础知识</label></td>
<td width="62" align="center"><input type="submit" name="button2" id="button2" value="查询" /></td>
</tr></form>
</table></td></tr>
<tr>
<td height="20" colspan="2" align="center" class="STYLE4">留验单</td>
</tr>
<tr>
<td height="24" colspan="2"><table width="634" height="18" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td width="23%" height="18" align="center" class="STYLE1">考点:<strong>
<?
if($kaodian=="01"){
echo "第一中学";
}
else
echo "洞山中学";
?></strong></td>
<td width="23%" align="center" class="STYLE1">考试科目:<strong><?=$kemu?></strong></td>
<td width="41%" align="center" class="STYLE1">时间:
<?
if($kemu=="职业能力测试"){
echo"<strong>2010年6月27日上午8:00—9:30</strong>";
}
else
echo"<strong>2010年6月27日上午10:00—12:00</strong>";
?>
</td>
<td width="13%" align="center" class="STYLE1">考场号:<strong><?=$kaochang?></strong></td>
</tr>
</table></td>
</tr>
<tr>
<td width="458" height="55" class="STYLE5"> 注意:<br /> 1.姓名、毕业院校及专业由考生填写,监考人员核对。<br />
2.缺考、违纪、题本(试卷)答题卡回收情况由监考人员在相应的<span class="STYLE2">□</span>内打“√”。</td>
<td width="186" align="right"><table width="159" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="87" height="25" class="STYLE1">监考人员签字:</td>
<td width="72" valign="bottom" class="STYLE4">———</td>
</tr>
<tr>
<td height="30"> </td>
<td valign="bottom" class="STYLE4">———</td>
</tr>
</table></td>
</tr>
<tr>
<td height="218" colspan="2" valign="top"><table width="0" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<?
if(!empty($_GET['page'])) $page = $_GET['page'];
else $page = 1;
$pagesize = 12;
$str="select count(*) as amount from rc_zkz where kaodian= '$kaodian' and kaochang ='$kaochang'";
$rs=mysql_fetch_array(mysql_query($str,$link_id));
$amount=$rs['amount'];
$totlepage=ceil($amount/$pagesize);
$str = "SELECT * FROM rc_zkz where kaodian= '$kaodian' and kaochang ='$kaochang' ORDER BY zuowei asc limit ".($page-1)*$pagesize.",$pagesize";
$result=mysql_query($str,$link_id);
echo "<tr class='row-bg'>";
$i=0;
while($rs = mysql_fetch_array($result))
{
$i++
?>
<td width="825" height="174" align="center"><table width="0" border="0" cellpadding="1" cellspacing="1" bgcolor="#000000">
<tr>
<td width="204" bgcolor="#FFFFFF"><table width="205" height="165" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="79" rowspan="4" align="left" valign="middle"><img src="../<?=$pic?>" width="78" height="100" alt="" /></td>
<td width="126" height="21" align="right" class="STYLE1"><span class="STYLE7">座位号:</span>
<?=$zuowei?></td>
</tr>
<tr>
<td align="right" height="21" class="STYLE1"><span class="STYLE7">缺考:</span><span class="STYLE2">□</span></td>
</tr>
<tr>
<td align="right" height="22" class="STYLE1"><span class="STYLE7">违纪</span><span class="STYLE2">□</span></td>
</tr>
<tr>
<td height="31" align="right" class="STYLE1"><span class="STYLE7">题本(试卷)答题卡回收</span><span class="STYLE2">□</span></td>
</tr>
<tr>
<td height="18" colspan="2" align="left" class="STYLE1"><span class="STYLE7"> 准考证号:</span>
<?=$zkz?></td>
</tr>
<tr>
<td height="18" colspan="2" align="left" class="STYLE1"><span class="STYLE7"> 身份证号:</span>
<?=$shenfenzh?></td>
</tr>
<tr>
<td height="17" colspan="2" class="STYLE1" align="left"><span class="STYLE7"> 姓名(考生留验):</span></td>
</tr>
<tr>
<td height="17" colspan="2" class="STYLE1" align="left" ><span class="STYLE7"> 毕业院校及专业(考生留验):</span></td>
</tr>
</table></td>
</tr>
</table></td>
<?
if($i%3==0) echo "</tr><tr>";
}
?>
<?
mysql_close($link_id);
?>
<tr>
<td height="18" align="left">共<span class="STYLE1">
<?=$amount?>位考生,<?
if($page>1)
echo"<a href=?kaodian=$_GET[kaodian]&kaochang=$_GET[kaochang]&kemu=$_GET[kemu]&page=1>首页</a> <a href=?kaodian=$_GET[kaodian]&kaochang=$_GET[kaochang]&kemu=$_GET[kemu]&page=".($page-1).">上一页</a>";
else echo"首页 上一页";
if($page<$totlepage)
echo"<a href=?kaodian=$_GET[kaodian]&kaochang=$_GET[kaochang]&kemu=$_GET[kemu]&page=".($page+1).">下一页</a> <a href=?kaodian=$_GET[kaodian]&kaochang=$_GET[kaochang]&kemu=$_GET[kemu]&page=$totlepage>末页</a>";
else echo "下一页 末页";
?></span></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
[code]
结果是,重复排一个人的信息,不往下循环~为啥啊?
session_start();
if($_SESSION['admin']=="")echo"<script language=javascript>alert('请先登陆!');window.location.href='login2.php';</script>";
require_once('../config.php');
$link_id = mysql_connect($dbhost,$dbuser,$dbpwd);
mysql_select_db($dbname);
mysql_query("set names 'gbk'");
$kaodian=$_GET[kaodian];
$kaochang=$_GET[kaochang];
$kemu=$_GET[kemu];
$str="select * from rc_zkz where kaodian= '$kaodian' and kaochang ='$kaochang'";
$result=mysql_query($str,$link_id);
$rs=mysql_fetch_array($result);
$shenfenzh=$rs[shenfenzh];
$pic=$rs[pic];
$kaodian=$rs[kaodian];
$kaochang=$rs[kaochang];
$zuowei=$rs[zuowei];
$danwei=$rs[danwei];
$zkz=$danwei.$kaodian.$kaochang.$zuowei;
?>
<!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=gb2312" />
<title></title>
<style type="text/css">
<!--
.STYLE5 {
font-size: 12px;
line-height: 15px;
}
.STYLE1 {font-size: 12px}
.STYLE7 {font-size: 10px}
.STYLE2 {
font-size: 16px;
}
.STYLE8 {
font-size: 10px
}
.STYLE3 {font-size: 28px; font-weight: bold; }
.STYLE4 {font-size: 20px; font-weight: bold; }
#bj{
height: auto;
width: auto;
background-image: url(img/1.png);
}
</style>
<script type="text/javascript" src="../javascript/function.js"></script>
<script language="javascript" >
function CLASS_LIANDONG_YAO(array)
{
//数组,联动的数据源
this.array=array;
this.indexName='';
this.obj='';
//设置子SELECT
// 参数:当前onchange的SELECT ID,要设置的SELECT ID
this.subSelectChange=function(selectName1,selectName2)
{
//try
//{
var obj1=document.all[selectName1];
var obj2=document.all[selectName2];
var objName=this.toString();
var me=this;
obj1.onchange=function()
{
me.optionChange(this.options[this.selectedIndex].value,obj2.id)
} }
//设置第一个SELECT
// 参数:indexName指选中项,selectName指select的ID
this.firstSelectChange=function(indexName,selectName)
{
this.obj=document.all[selectName];
this.indexName=indexName;
this.optionChange(this.indexName,this.obj.id) }
// indexName指选中项,selectName指select的ID
this.optionChange=function (indexName,selectName)
{
var obj1=document.all[selectName];
var me=this;
obj1.length=0;
obj1.options[0]=new Option("请选择",'');
for(var i=0;i<this.array.length;i++)
{
if(this.array[i][1]==indexName)
{
//alert(this.array[i][1]+" "+indexName);
obj1.options[obj1.length]=new Option(this.array[i][2],this.array[i][0]);
}
}
}
}
</script>
</head>
<body>
<table width="643" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td width="643"><table width="634" border="0" cellpadding="0" cellspacing="0">
<tr><td colspan="2"><table width="644" border="0" align="center" cellpadding="0" cellspacing="0"><form action="?" name="form" method="get">
<tr>
<td width="166" height="22" align="center"><label>考点:
<select name="kaodian" id="kaodian">
</select>
</label></td>
<td width="134" align="center"><label>考场:
<select name="kaochang" id="kaochang">
</select>
</label></td>
<td width="146" align="center"><p>
<label>
<input name="kemu" type="radio" id="RadioGroup1_0" value="职业能力测试" checked="checked" />
职业能力测试 </label>
<br />
</p></td>
<td width="136" align="center"><label>
<input type="radio" name="kemu" value="公共基础知识" id="RadioGroup1_1" />
公共基础知识</label></td>
<td width="62" align="center"><input type="submit" name="button2" id="button2" value="查询" /></td>
</tr></form>
</table></td></tr>
<tr>
<td height="20" colspan="2" align="center" class="STYLE4">留验单</td>
</tr>
<tr>
<td height="24" colspan="2"><table width="634" height="18" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td width="23%" height="18" align="center" class="STYLE1">考点:<strong>
<?
if($kaodian=="01"){
echo "第一中学";
}
else
echo "洞山中学";
?></strong></td>
<td width="23%" align="center" class="STYLE1">考试科目:<strong><?=$kemu?></strong></td>
<td width="41%" align="center" class="STYLE1">时间:
<?
if($kemu=="职业能力测试"){
echo"<strong>2010年6月27日上午8:00—9:30</strong>";
}
else
echo"<strong>2010年6月27日上午10:00—12:00</strong>";
?>
</td>
<td width="13%" align="center" class="STYLE1">考场号:<strong><?=$kaochang?></strong></td>
</tr>
</table></td>
</tr>
<tr>
<td width="458" height="55" class="STYLE5"> 注意:<br /> 1.姓名、毕业院校及专业由考生填写,监考人员核对。<br />
2.缺考、违纪、题本(试卷)答题卡回收情况由监考人员在相应的<span class="STYLE2">□</span>内打“√”。</td>
<td width="186" align="right"><table width="159" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="87" height="25" class="STYLE1">监考人员签字:</td>
<td width="72" valign="bottom" class="STYLE4">———</td>
</tr>
<tr>
<td height="30"> </td>
<td valign="bottom" class="STYLE4">———</td>
</tr>
</table></td>
</tr>
<tr>
<td height="218" colspan="2" valign="top"><table width="0" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<?
if(!empty($_GET['page'])) $page = $_GET['page'];
else $page = 1;
$pagesize = 12;
$str="select count(*) as amount from rc_zkz where kaodian= '$kaodian' and kaochang ='$kaochang'";
$rs=mysql_fetch_array(mysql_query($str,$link_id));
$amount=$rs['amount'];
$totlepage=ceil($amount/$pagesize);
$str = "SELECT * FROM rc_zkz where kaodian= '$kaodian' and kaochang ='$kaochang' ORDER BY zuowei asc limit ".($page-1)*$pagesize.",$pagesize";
$result=mysql_query($str,$link_id);
echo "<tr class='row-bg'>";
$i=0;
while($rs = mysql_fetch_array($result))
{
$i++
?>
<td width="825" height="174" align="center"><table width="0" border="0" cellpadding="1" cellspacing="1" bgcolor="#000000">
<tr>
<td width="204" bgcolor="#FFFFFF"><table width="205" height="165" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="79" rowspan="4" align="left" valign="middle"><img src="../<?=$pic?>" width="78" height="100" alt="" /></td>
<td width="126" height="21" align="right" class="STYLE1"><span class="STYLE7">座位号:</span>
<?=$zuowei?></td>
</tr>
<tr>
<td align="right" height="21" class="STYLE1"><span class="STYLE7">缺考:</span><span class="STYLE2">□</span></td>
</tr>
<tr>
<td align="right" height="22" class="STYLE1"><span class="STYLE7">违纪</span><span class="STYLE2">□</span></td>
</tr>
<tr>
<td height="31" align="right" class="STYLE1"><span class="STYLE7">题本(试卷)答题卡回收</span><span class="STYLE2">□</span></td>
</tr>
<tr>
<td height="18" colspan="2" align="left" class="STYLE1"><span class="STYLE7"> 准考证号:</span>
<?=$zkz?></td>
</tr>
<tr>
<td height="18" colspan="2" align="left" class="STYLE1"><span class="STYLE7"> 身份证号:</span>
<?=$shenfenzh?></td>
</tr>
<tr>
<td height="17" colspan="2" class="STYLE1" align="left"><span class="STYLE7"> 姓名(考生留验):</span></td>
</tr>
<tr>
<td height="17" colspan="2" class="STYLE1" align="left" ><span class="STYLE7"> 毕业院校及专业(考生留验):</span></td>
</tr>
</table></td>
</tr>
</table></td>
<?
if($i%3==0) echo "</tr><tr>";
}
?>
<?
mysql_close($link_id);
?>
<tr>
<td height="18" align="left">共<span class="STYLE1">
<?=$amount?>位考生,<?
if($page>1)
echo"<a href=?kaodian=$_GET[kaodian]&kaochang=$_GET[kaochang]&kemu=$_GET[kemu]&page=1>首页</a> <a href=?kaodian=$_GET[kaodian]&kaochang=$_GET[kaochang]&kemu=$_GET[kemu]&page=".($page-1).">上一页</a>";
else echo"首页 上一页";
if($page<$totlepage)
echo"<a href=?kaodian=$_GET[kaodian]&kaochang=$_GET[kaochang]&kemu=$_GET[kemu]&page=".($page+1).">下一页</a> <a href=?kaodian=$_GET[kaodian]&kaochang=$_GET[kaochang]&kemu=$_GET[kemu]&page=$totlepage>末页</a>";
else echo "下一页 末页";
?></span></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
[code]
结果是,重复排一个人的信息,不往下循环~为啥啊?
while($rs = mysql_fetch_array($result))
{
$i++
?>
<td width="825" height="174" align="center"><table width="0" border="0" cellpadding="1" cellspacing="1" bgcolor="#000000">
<tr>
<td width="204" bgcolor="#FFFFFF"><table width="205" height="165" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="79" rowspan="4" align="left" valign="middle"><img src="../<?=$pic?>" width="78" height="100" alt="" /></td>
<td width="126" height="21" align="right" class="STYLE1"><span class="STYLE7">座位号:</span>
<?=$zuowei?></td>
</tr>
<tr>
<td align="right" height="21" class="STYLE1"><span class="STYLE7">缺考:</span><span class="STYLE2">□</span></td>
</tr>
<tr>
<td align="right" height="22" class="STYLE1"><span class="STYLE7">违纪</span><span class="STYLE2">□</span></td>
</tr>
<tr>
<td height="31" align="right" class="STYLE1"><span class="STYLE7">题本(试卷)答题卡回收</span><span class="STYLE2">□</span></td>
</tr>
<tr>
<td height="18" colspan="2" align="left" class="STYLE1"><span class="STYLE7"> 准考证号:</span>
<?=$zkz?></td>
</tr>
<tr>
<td height="18" colspan="2" align="left" class="STYLE1"><span class="STYLE7"> 身份证号:</span>
<?=$shenfenzh?></td>
</tr>
<tr>
<td height="17" colspan="2" class="STYLE1" align="left"><span class="STYLE7"> 姓名(考生留验):</span></td>
</tr>
<tr>
<td height="17" colspan="2" class="STYLE1" align="left" ><span class="STYLE7"> 毕业院校及专业(考生留验):</span></td>
</tr>
</table></td>
</tr>
</table></td>
<?
if($i%3==0) echo "</tr><tr>";
}
?>
<?
mysql_close($link_id);
?>
这一段里面的变量都是开始定义的那个,当然就循环一个人的信息了,改成$rs['xx']。真够烂的一段代码。
一个表中本来就两个字段,有记录:
字段1 字段2
ab cd 我想增加一个新的字段,怎么让新的字段内容是前两个字段的组合?
字段1 字段2 字段3
ab cd abcdsql语句怎么写啊?50分给你啦~
{
mysql_query("update tablename set newcolumn='".$row['a'].$row['b']."' where id=".$row['id']);
}最后的where条件可以是别的表记录的唯一标识字段
update tablename set 字段3=CONCAT(字段1,字段2)
只更新某一条,就lazysmile说的那样