今天內容不多，繼續完善通訊錄的最最基本功能，增刪該查。

效果圖如下

主要修改了c-main.php文件

  1: <?php
  2: include 'c-config.php';
  3: if (empty($_SESSION['uid']) || empty($_SESSION['ushell']) ||!user_shell($_SESSION['uid'], $_SESSION['ushell'])){
  4: 	echo "<script>alert('您無權訪問該頁面，請先登錄！');location.href='c-login.php'</script>";
  5: 	exit();
  6: }
  7: 
  8: $sql = "select * from c_users where u_id = '".$_SESSION['uid']."'";
  9: $query = mysql_query($sql);
 10: $row = mysql_fetch_array($query);
 11: echo $row['u_email']."--".$row['u_name']."--".$row['u_telephone']."<br>";
 12: echo "<a href='c-login.php?exit=true'>退出登錄</a><br>";
 13: 
 14: if (!empty($_GET['edit'])) {
 15: 	$id = $_GET['edit'];
 16: 	$sql = "select * from c_contacts where c_id = '$id'";
 17: 	$querty = mysql_query($sql);
 18: 	$rs = mysql_fetch_array($querty);
 19: 	echo "<form action='c-main.php' method='post'>
 20: 			<input type='hidden' name='id' value=".$rs['c_id']."> 
 21: 			郵箱<input type='text' name='email' value=".$rs['c_email']."><br>
 22: 			姓名<input type='text' name='name' value=".$rs['c_name']."><br>
 23: 			電話<input type='text' name='telephone' value=".$rs['c_telephone']."><br>
 24: 			備注<textarea rows='5' cols='50' name='description'>".$rs['c_description']."</textarea><br>
 25: 			<input type='submit' name='update' value='修改'>
 26: 		  </form>";
 27: }
 28: 
 29: if (!empty($_POST['update'])){
 30: 	$sql="update c_contacts set c_email = '".$_POST['email']."',
 31: 			c_name = '".$_POST['name']."',
 32: 			c_telephone = '".$_POST['telephone']."',
 33: 			c_description = '".$_POST['description']."' where c_id = '".$_POST['id']."'";
 34: 	mysql_query($sql);
 35: }
 36: 
 37: if (!empty($_GET['add'])) {
 38: 	echo "<form action='c-main.php' method='post'>
 39: 			郵箱<input type='text' name='email'><br>
 40: 			姓名<input type='text' name='name'><br>
 41: 			電話<input type='text' name='telephone'><br>
 42: 			備注<textarea rows='5' cols='50' name='description'></textarea><br>
 43: 			<input type='submit' name='add' value='增加'>
 44: 		  </form>";
 45: }
 46: 
 47: if (!empty($_POST['add'])){	
 48: 	$sql="insert into c_contacts (c_id, u_id, c_email, c_name, c_telephone, c_description) 
 49: 		values (null, '".$_SESSION['uid']."', '".$_POST['email']."', '".$_POST['name']."', '".$_POST['telephone']."', '".$_POST['description']."')";
 50: 	mysql_query($sql);
 51: }
 52: 
 53: if (!empty($_GET['del'])) {
 54: 	$d = $_GET['del'];
 55: 	$sql = "delete from c_contacts where c_id = '$d'";
 56: 	mysql_query($sql);
 57: 	echo "刪除成功";
 58: }
 59: 
 60: $pagesize = 5;
 61: $url = $_SERVER["REQUEST_URI"];
 62: $url = parse_url($url);
 63: $url=$url['path'];
 64: $numq = mysql_query("select * from c_contacts where u_id ='".$_SESSION['uid']."'");
 65: $num = mysql_num_rows($numq);
 66: $totalpage = ceil($num/$pagesize);
 67: $pageval = 1;
 68: $page='0 ,';
 69: if (!empty($_GET['page'])) {
 70: 	$pageval = $_GET['page'];
 71: 	$page = ($pageval - 1) * $pagesize;
 72: 	$page.=" ,";
 73: }
 74: 
 75: if($pageval <= 0){
 76: 	$pageval = 1;
 77: }
 78: 
 79: $sql = "select * from c_contacts where u_id ='".$_SESSION['uid']."' limit $page $pagesize";
 80: $query=mysql_query($sql);
 81: echo "<center><table border='1' width='600'>";
 82: echo "<tr><td>郵箱</td><td>姓名</td><td>電話</td><td>備注</td><td>-</td><td>-</td></tr>";
 83: while($row=mysql_fetch_array($query)){
 84: 	echo "<tr><td>".$row['c_email']."</td><td>".$row['c_name']."</td><td>".$row['c_telephone']."</td><td>".$row['c_description']."</td>
 85: 			<td><a href=c-main.php?edit=".$row['c_id'].">修改</a></td>
 86: 			<td><a href=c-main.php?del=".$row['c_id'].">刪除</a></td></tr>";
 87: }
 88: echo "</table></center>";
 89: 
 90: echo "<center>共".$num."條<a href='c-main.php?add=1'>增加條目</a><br>";
 91: if ($pageval <= 1){
 92: 	echo "<a>上一頁</a>";
 93: }else {
 94: 	echo "<a href=$url?page=".($pageval - 1).">上一頁</a>";
 95: }
 96: echo "$pageval/$totalpage";
 97: if ($pageval >= $totalpage){
 98: 	echo "<a>下一頁</a>";
 99: }else {
100: 	echo "<a href=$url?page=".($pageval + 1).">下一頁</a><center>";
101: }
102: 
103: ?>

隨著代碼量的增加，不可能每次都貼全部代碼到blog上來，先把它備份到網盤上，之后可能的話弄個CVS或者SVN。如需要代碼請點擊這里，您也可以訪問http://www.jifanchuan.com/contacts/去試用這個代碼。不過在用谷歌游覽器的時候，退出有點問題，不知道為什么，回頭查下。

堅持的去做一些事情，養成一些好的習慣，每天寫blog也是一種美德O(∩_∩)O~

——失足挨踢的偽coder