景初

  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理
PHP从零单排（十五）牛刀小试--就业信息周报系统 分类： PHP 2014-05-02 20:28 155人阅读 评论(0) 收藏

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>


版权声明：本文为博主原创文章，未经博主允许不得转载。

posted on 2014-05-02 20:28  景初  阅读(143)  评论(0)  编辑  收藏  举报