员工信息查询php实验.docVIP

员工信息查询php实验 一、sc.php font color =#000000 ?php $link=mysql_connect(localhost,root,)or die(数据库服务器连接失败！br); mysql_select_db(employee,$link)or die(数据库选择失败！br); mysql_query(set names gb2312); ? head meta http-equiv=content-type content=text/html;charset=gb2312 title员工信息/title /head body ?php $name=$_POST[name]; $id=$_POST[id]; $sql=select * from employee where name like %.$name.%and id like %.$id.%; $result=mysql_query($sql,$link); $nums=mysql_num_rows($result); for($n=0;$n$nums;$n++) { $id[$n]=mysql_result($result,$n,id); $name[$n]=mysql_result($result,$n,name); $sex[$n]=mysql_result($result,$n,sex); $tel[$n]=mysql_result($result,$n,tel); $add[$n]=mysql_result($result,$n,add); $salary[$n]=mysql_result($result,$n,salary); } ? /font table width =63% border=1 tr bgcolor=#99FF33 td工号:/td td姓名:/td td性别:/td td电话:/td td家庭住址信息:/td td基本工资: ?php for ($m=0;$m$nums;$m++) { echotr. td.mysql_result($result,$m,id)./td. td.mysql_result($result,$m,name)./td. td.mysql_result($result,$m,sex)./td. td.mysql_result($result,$m,tel)./td. td.mysql_result($result,$m,add)./td. td.mysql_result($result,$m,salary)./td. /tr; } ? /td /tr /table pa href =sr.php返回/a/p /body /html sr.php html head meta http-equiv=content-type content=text/html;charset=gb2312 title员工信息查询主页/title /head body form id=form1 name=form1 method=post action=sc.php p请输入查询内容：/p p label姓名： input type=text name=name / /label /p p labelID： input type=text name=id / /label /p p label input type=submit name=Submit value=提交 / /label label input type=reset name=Submit2 value=重置 / /label /p /form /body /html