1.创建信息页面
<!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> </head> <body> <b>提交用户信息</b> <form name="form" method="post" action="PageInsert.php"> <table width="25%" border="0" cellpadding="0" cellspacing="2" > <tr> <td width="40%" height="29">学号:</td> <td width="60%"><input name="number" type="text" id="number" size="20" /></td> </tr> <tr> <td width="40%" height="29">姓名:</td> <td width="60%"><input name="name" type="text" id="name" size="20" /></td> </tr> <tr> <td width="40%" height="29">生源地:<br/></td> <td width="60%"><input name="homeland" type="text" id="homeland" size="20" /></td> </tr> <tr> <td width="40%" height="29">已签约单位:</td> <td width="60%"><input name="offer" type="text" id="offer" size="20" /></td> </tr> <tr> <td width="40%" height="29">实习单位:</td> <td width="60%"><input name="company" type="text" id="company" size="20" /></td> </tr> <tr> <td height="25">有无签约意向:</td> <td> <select name="offerstate"> <option value="有">有</option> <option value="无">无</option> <option value="已签">已签</option> </select> </td> </tr> <tr> <td height="25">户口状态:</td> <td> <select name="homestate"> <option value="原籍">原籍</option> <option value="学校">学校</option> </select> </td> </tr> <tr> <td height="25">毕业后户口意向:</td> <td> <select name="homefuture"> <option value="原籍">原籍</option> <option value="公司">公司</option> <option value="人才">人才</option> </select> </td> </tr> <tr> <td height="25">毕业后档案意向:</td> <td> <select name="filefuture"> <option value="原籍">原籍</option> <option value="公司">公司</option> <option value="人才">人才</option> </select> </td> </tr> <tr> <td height="1"> <input type="submit" name="Submit" value="提交" /></td> <td> </td> </tr> </table> </form> </body> </html>
2.输入信息页面
<?php $host='localhost'; $user_name='root'; $password='helloworld'; $number=$_POST['number']; $name=$_POST['name']; $offer=$_POST['offer']; $company=$_POST['company']; $offerstate=$_POST['offerstate']; $homeland=$_POST['homeland']; $homestate=$_POST['homestate']; $homefuture=$_POST['homefuture']; $filefuture=$_POST['filefuture']; //判断!!! $conn=mysql_connect($host,$user_name,$password); if(!$conn) { die('数据库连接失败:'.mysql_error()); } mysql_select_db('101024'); $sql="insert into class set 学号='".$number."', 姓名='".$name."',已签约单位='".$offer."',实习单位='".$company."',意向='".$offerstate."',生源地='".$homeland."',户口状态='".$homestate."',户口意向='".$homefuture."',档案意向='".$filefuture."',修改时间=NOW()"; mysql_query($sql) OR die("<br/>ERROR:<b>".mysql_error()."</b><br/>SQL:".$sql); mysql_close($conn); echo '数据插入成功! <a href="PageCreate.html">返回</a>'; ?>3.登录页面
<?php session_start(); $_SESSION['bool']=0; ?> <!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>PageLogin</title> </head> <body> <form name="form" method="post" action="PageInfo.php"> <table width="25%" border="0" cellpadding="0" cellspacing="2"> <tr> <td width="40%" height="29">请输入你的学号:</td> <td width="60%"><input name="number" type="text" id="number" size="20" /></td> </tr> <tr> <td height="1"> <input type="submit" name="Submit" value="登录" /> </td> <td> </td> </tr> </table> </form> </body> </html>4.个人信息页面
<?php $host='localhost'; $user_name='root'; $password='helloworld'; session_start(); $conn=mysql_connect($host,$user_name,$password); if(!$conn) { die('数据库连接失败:'.mysql_error()); } mysql_select_db('101024'); if($_SESSION['bool']==1) { $number=$_POST['number']; $name=$_POST['name']; $offer=$_POST['offer']; $company=$_POST['company']; $offerstate=$_POST['offerstate']; $homeland=$_POST['homeland']; $homestate=$_POST['homestate']; $homefuture=$_POST['homefuture']; $filefuture=$_POST['filefuture']; $sql="update class set 学号='".$number."', 姓名='".$name."',已签约单位='".$offer."',实习单位='".$company."',意向='".$offerstate."',生源地='".$homeland."',户口状态='".$homestate."',户口意向='".$homefuture."',档案意向='".$filefuture."',修改时间=NOW()"; $result=mysql_query($sql) OR die("<br/>ERROR:<b>".mysql_error()."</b><br/>SQL:".$sql); } $number=$_POST['number']; $sql="select * from class where 学号='$number'"; $result=mysql_query($sql) OR die("<br/>ERROR:<b>".mysql_error()."</b><br/>SQL:".$sql); $_SESSION['num']=$number; //upate!!!!! $sql="update class set 修改时间=NOW()"; mysql_query($sql) OR die("<br/>ERROR:<b>".mysql_error()."</b><br/>SQL:".$sql); mysql_close($conn); $row=mysql_fetch_array($result,MYSQL_ASSOC); ?> <!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><?php echo $number ;?></title> <script language="javascript"> function confirm() { alert("确认信息成功!") } </script> </head> <body> <b>您的信息</b> <form name="form" method="post" action="PageUpdate.php"> <table width="25%" border="0" cellpadding="0" cellspacing="2" > <tr> <td width="40%" height="29">学号:</td> <td width="60%" ><?php echo $row['学号']; ?></td> </tr> <tr> <td width="40%" height="29">姓名:</td> <td width="60%"><?php echo $row['姓名']; ?></td> </tr> <tr> <td width="40%" height="29">生源地:<br/></td> <td width="60%"><?php echo $row['生源地']; ?></td> </tr> <tr> <td width="40%" height="29">已签约单位:</td> <td width="60%"><?php echo $row['已签约单位']; ?></td> </tr> <tr> <td width="40%" height="29">实习单位:</td> <td width="60%"><?php echo $row['实习单位']; ?></td> </tr> <tr> <td height="25">有无签约意向:</td> <td> <?php echo $row['意向']; ?> </td> </tr> <tr> <td height="25">户口状态:</td> <td> <?php echo $row['户口状态']; ?> </td> </tr> <tr> <td height="25">毕业后户口意向:</td> <td> <?php echo $row['户口意向']; ?> </td> </tr> <tr> <td height="25">毕业后档案意向:</td> <td> <?php echo $row['档案意向']; ?> </td> </tr> <tr> <td height="25">上次登录时间:</td> <td> <?php echo $row['修改时间']; ?> </td> </tr> <tr> <td height="1"> <input type="button" name="Submit" value="确认信息" onclick="confirm()"/></td> <td height="1"> <input type="submit" name="Submit" value="修改信息" /></td> <td> </td> </tr> </table> <a href="PageAll.php">显示全部信息</a> </form> </body> </html>
5.修改信息页面
<?php $host='localhost'; $user_name='root'; $password='helloworld'; session_start(); $number=$_SESSION['num']; $_SESSION['bool']=1; $arr_offerstate=array('有'=>'有','无'=>'无','已签'=>'已签'); $arr_homestate=array('学校'=>'学校','原籍'=>'原籍'); $arr_homefuture=array('原籍'=>'原籍','人才'=>'人才','公司'=>'公司'); $arr_filefuture=array('原籍'=>'原籍','人才'=>'人才','公司'=>'公司'); $conn=mysql_connect($host,$user_name,$password); if(!$conn) { die('数据库连接失败:'.mysql_error()); } mysql_select_db('101024'); $sql="select * from class where 学号='$number'"; $result=mysql_query($sql) OR die("<br/>ERROR:<b>".mysql_error()."</b><br/>SQL:".$sql); $row=mysql_fetch_array($result,MYSQL_ASSOC); mysql_close(); ?> <!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> </head> <body> <b>提交用户信息</b> <form name="form" method="post" action="PageInfo.php"> <table width="25%" border="0" cellpadding="0" cellspacing="2" > <tr> <td width="40%" height="29">学号:</td> <td width="60%"><input name="number" type="text" id="homeland" size="20" value="<?php echo $row['学号']?>"/></td> </tr> <tr> <td width="40%" height="29">姓名:</td> <td width="60%"><input name="name" type="text" id="homeland" size="20" value="<?php echo $row['姓名']?>"/></td> </tr> <tr> <td width="40%" height="29">生源地:<br/></td> <td width="60%"><input name="homeland" type="text" id="homeland" size="20" value="<?php echo $row['生源地']?>"/></td> </tr> <tr> <td width="40%" height="29">已签约单位:</td> <td width="60%"><input name="offer" type="text" id="offer" size="20" value="<?php echo $row['已签约单位']?>"/></td> </tr> <tr> <td width="40%" height="29">实习单位:</td> <td width="60%"><input name="company" type="text" id="company" size="20" value="<?php echo $row['实习单位']?>"/></td> </tr> <tr> <td height="25">有无签约意向:</td> <td> <select name="offerstate"> <?php foreach($arr_offerstate as $k=>$v) { $option=($row['意向']==$k)?'<option value="'.$k.'" selected>'.$v.'</option>':'<option value="'.$k.'">'.$v.'</option>'; echo $option.'\n'; } ?> </select> </td> </tr> <tr> <td height="25">户口状态:</td> <td> <select name="homestate"> <?php foreach($arr_homestate as $k=>$v) { $option=($row['户口状态']==$k)?'<option value="'.$k.'" selected>'.$v.'</option>':'<option value="'.$k.'">'.$v.'</option>'; echo $option.'\n'; } ?> </select> </td> </tr> <tr> <td height="25">毕业后户口意向:</td> <td> <select name="homefuture"> <?php foreach($arr_homefuture as $k=>$v) { $option=($row['户口意向']==$k)?'<option value="'.$k.'" selected>'.$v.'</option>':'<option value="'.$k.'">'.$v.'</option>'; echo $option.'\n'; } ?> </select> </td> </tr> <tr> <td height="25">毕业后档案意向:</td> <td> <select name="filefuture"> <?php foreach($arr_filefuture as $k=>$v) { $option=($row['档案意向']==$k)?'<option value="'.$k.'" selected>'.$v.'</option>':'<option value="'.$k.'">'.$v.'</option>'; echo $option.'\n'; } ?> </select> </td> </tr> <tr> <td height="1"> <input type="submit" name="Submit" value="修改信息" /></td> <td> </td> </tr> </table> </form> </body> </html>
7.分页显示全部信息
<?php $host='localhost'; $user_name='root'; $password='helloworld'; $conn=mysql_connect($host,$user_name,$password); if(!$conn) { die('FAIL!'.mysql_error()); } mysql_select_db('101024'); if(isset($_GET['page'])) { $page=$_GET['page']; } else { $page=1; } $page_size=12; $sql='select * from class'; $result=mysql_query($sql); $total=mysql_num_rows($result); if($total) { if($total<$page_size) $page_count=1; if($total%$page_size) { $page_count=(int)($total/$page_size)+1; } else { $page_count=$total/$page_size; } } else { $page_count=0; } $turn_page=''; if($page==1) { $turn_page.='首页 | 上一页 |'; } else { $turn_page.='<a href=13-8.php?page=1>首页</a> | <a href=13-8.php?page='.($page-1).'>上一页</a> |'; } if($page==$page_count || $page_count==0) { $turn_page.='下一页 | 尾页'; } else { $turn_page.='<a href=13-8.php?page='.($page+1).'> 下一页 </a> | <a href=13-8.php?page='.$page_count.'> 尾页 </a>'; } $sql='select * from class limit '.($page-1)*$page_size.','.$page_size; $result=mysql_query($sql) OR die ("<br/>ERROR:<b>".mysql_error()."</b><br/>SQL:".$sql); ?> <html> <head> <title>13-8.php</title> </head> <body> <table width="75%" border="0" cellpadding="0" cellspacing="1" bgcolor="#7b7b84"> <tr bgcolor="#8bbcc7"> <td height="33"><div align="center"><strong>学号</strong></div></td> <td><div align="center"><strong>姓名</strong></div></td> <td><div align="center"><strong>生源地</strong></div></td> <td><div align="center"><strong>已签约单位</strong></div></td> <td><div align="center"><strong>实习单位</strong></div></td> <td><div align="center"><strong>有无签约意向</strong></div></td> <td><div align="center"><strong>户口状态</strong></div></td> <td><div align="center"><strong>户口意向</strong></div></td> <td><div align="center"><strong>档案意向</strong></div></td> </tr> <?php if($num=mysql_num_rows($result)) { while($row=mysql_fetch_array($result,MYSQL_ASSOC)) { ?> <tr bgcolor="#FFFFFF"> <td height="22" align="right"><?php echo $row['学号']; ?> </td> <td height="22"> <?php echo $row['姓名']; ?> </td> <td height="22"> <?php echo $row['生源地']; ?> </td> <td height="22"> <?php echo $row['已签约单位']; ?> </td> <td height="22"> <?php echo $row['实习单位']; ?> </td> <td height="22"> <?php echo $row['意向']; ?> </td> <td height="22"> <?php echo $row['户口状态']; ?> </td> <td height="22"> <?php echo $row['户口意向']; ?> </td> <td height="22"> <?php echo $row['档案意向']; ?> </td> </tr> <?php } } echo $turn_page; mysql_close($conn); ?> </body> </html>
版权声明:本文为博主原创文章,未经博主允许不得转载。