通讯录的增删改查
今天内容不多,继续完善通讯录的最最基本功能,增删该查。
效果图如下
主要修改了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