一:投票,连个页面都引用了DBDA封装类
<!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> <style type="text/css"> *{ margin:0px auto; padding:0px; } .title { height:50px; margin:20px 0px 0px 20px; } .list { width:300px; height:200px; margin-left:20px; } .xx { width:300px; height:30px; } .jieguo { width:300px; height:200px; margin-left:20px; } .xxnr { width:300px; height:30px; } </style> </head> <body> <form action="ChuLi.php" method="post"> <?php include("DBDA.php"); $db = new DBDA(); $sql = "select * from DiaoYanTiMu"; $result = $db->Query($sql); //题目标题 echo "<div class='title'>{$result[0][1]}</div>"; $code = $result[0][0]; $sqlx = "select * from DiaoYanXuanXiang where TiMuDaiHao = {$code}"; $resultx = $db->Query($sqlx); $xian = ""; if(@$_GET["bs"]==1) { $xian = "display:none"; } else { $xian="display:block"; } //题目选项的DIV echo "<div class='list' style='{$xian}'>"; for($i=0;$i<count($resultx);$i++) { echo "<div class='xx'>"; echo "<input type='checkbox' value='{$resultx[$i][0]}' name='opt[]' />"; echo "<span>{$resultx[$i][1]}</span>"; echo "</div>"; } echo "</div>"; //下面是投票结果的DIV $xianshi = ""; if(@$_GET["bs"]==1) { $xianshi = "display:block"; } else { $xianshi="display:none"; } echo "<div class='jieguo' style='{$xianshi}'>"; //求总人数 $sqlcount = "select sum(Numbers) from DiaoYanXuanXiang"; $attrcount = $db->Query($sqlcount); for($j=0;$j<count($resultx);$j++) { $rs = $resultx[$j][2]; if($attrcount[0][0]==0) { $bfb = 0; } else { $bfb = ($rs/$attrcount[0][0])*100; } echo "<div class='xxnr'>"; echo "<span style='float:left'>{$resultx[$j][1]}</span>"; echo "<div style='float:left;margin:10px 0px 0px 10px;100px; height:4px; border:1px solid #000'> <div style='{$bfb}%; height:4px;margin-left:0px; background-color:#666'></div> </div>"; echo "<span style='float:left; margin-left:10px'>{$resultx[$j][2]}</span>"; echo "</div>"; } echo "</div>"; ?> <div style="margin-left:20px; 200px"> <input id="tj" type="submit" style="float:left;<?php echo $xian; ?>;margin:0px 0px 0px 10px" value="提交" /> <input id="fh" type="button" style="float:left;<?php echo $xianshi;?>;margin:0px 0px 0px 10px" onclick="ShowTP()" value="返回" /> <input type="button" style="float:left;display:block;margin:0px 0px 0px 10px" onclick="ShowJieGuo()" value="显示结果" /> </div> </form> </body> <script type="text/javascript"> function ShowJieGuo() { var list = document.getElementsByClassName("list"); var jieguo = document.getElementsByClassName("jieguo"); var tj = document.getElementById("tj"); var fh = document.getElementById("fh"); fh.style.display="block"; tj.style.display="none"; list[0].style.display="none"; jieguo[0].style.display ="block"; } function ShowTP() { var list = document.getElementsByClassName("list"); var jieguo = document.getElementsByClassName("jieguo"); var tj = document.getElementById("tj"); var fh = document.getElementById("fh"); fh.style.display="none"; tj.style.display="block"; list[0].style.display="block"; jieguo[0].style.display ="none"; } </script> </html>
投票过来的处理页面
<?php include("DBDA.php"); $db = new DBDA(); $attr = $_POST["opt"]; for($i=0;$i<count($attr);$i++) { $sql = "update DiaoYanXuanXiang set Numbers = Numbers+1 where Ids = {$attr[$i]}"; $db->Query($sql,0); } header("location:Test.php?bs=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> <style> a{ text-decoration:none; } a:link,a:visited{ color:#00F; } table{ text-align:center; } span{ color:#00F; cursor:pointer; } </style> </head> <body> <table width="100%" cellpadding="0" cellspacing="0" border="1"> <tr><td>操作</td><td>关键字</td><td>区域</td><td>使用面积</td><td>租金</td><td>租赁类型</td><td>房屋类型</td></tr> <?php //连接数据库,取出数据,并在表格中显示 include("DBDA.php"); $db=new DBDA(); $sql="select * from house order by keyword"; $result=$db->Query($sql,1,"housedb"); //var_dump($result); $strconfirm=""确认删除?""; for($i=0;$i<count($result);$i++){ echo "<tr> <td> <a href='AddInfo.php?bj=2&id={$result[$i][0]}'>编辑</a> <a href='AddInfo.php?bj=3&id={$result[$i][0]}' onclick='javascript:if(confirm({$strconfirm})){return ture}else{return false}' >删除</a> </td> <td>{$result[$i][1]}</td> <td>{$result[$i][2]}</td> <td>{$result[$i][3]}</td> <td>{$result[$i][4]}</td> <td>{$result[$i][5]}</td> <td>{$result[$i][6]}</td> </tr>"; } ?> </table> <a href="AddInfo.php?bj=1"><input type="button" value="添加数据"/></a> <a href="search.php"><input type="button" value="查询"/></a> <script> /*function Confirm(){ var f=document.getElementsByClassName("tz"); for(var i=0;i<f.length;i++){ } var bool=confirm("你确定删除?"); alert(bool); if(bool){ window.location.href=""; }; }*/ </script> </body> </html>
处理页面
<!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> <?php include("DBDA.php"); $bj=$_GET["bj"]; $db=new DBDA(); //$bj=1; if($bj==1){ $arradd=$_POST["sja"]; //var_dump($arradd); $str="'{$arradd[0]}','{$arradd[1]}',{$arradd[2]},{$arradd[3]},'{$arradd[4]}','{$arradd[5]}'"; //echo $str."<br/>"; $sql="INSERT INTO house(keyWord,area,squaremeter,rent,renttype,housetype) VALUES ({$str})"; //echo $sql; $bool=$db->Query($sql,0,"housedb"); if($bool){ header("location:HouseInfo.php"); }else{ header("location:AddInfo.php?bj=1;"); } }else if($bj==2){ $arrupdate=$_POST["sja"]; $id=$_GET["id"]; $sql="delete from house where id={$id}"; $bool=$db->Query($sql,0,"housedb"); $stru="'{$arrupdate[0]}','{$arrupdate[1]}',{$arrupdate[2]},{$arrupdate[3]},'{$arrupdate[4]}','{$arrupdate[5]}'"; $sqlu="INSERT INTO house(keyWord,area,squaremeter,rent,renttype,housetype) VALUES ({$stru})"; $db->Query($sqlu,0,"housedb"); header("location:HouseInfo.php"); } ?> </body> </html>
添加,删除,修改
<!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> <style> a{ text-decoration:none; } .text{ display:inline-block; width:100px; text-align:center; } </style> </head> <body> <?php $bj=$_GET["bj"]; //$bj=1; include("DBDA.php"); $db=new DBDA(); //echo $bj; if($bj==1){ //添加数据 echo " <form action='chuli.php?bj=1' method='post'> <div class='text'>关键字:</div><input type='text' name='sja[]'/><br/> <div class='text'>区域:</div><input type='text' name='sja[]'/><br/> <div class='text'>使用面积:</div><input type='text' name='sja[]'/><br/> <div class='text'>租金:</div><input type='text' name='sja[]'/><br/> <div class='text'>租赁类型:</div><input type='text' name='sja[]'/><br/> <div class='text'>房屋类型:</div><input type='text' name='sja[]'/><br/> <input type='submit' value='插入'/> <a href='HouseInfo.php'><input type='button' value='取消'/></a> <form> "; }else if($bj==2){ //修改数据 $idu=$_GET["id"]; $sqlu="select * from house where id={$idu}"; $arrUpdate=$db->Query($sqlu,1,"housedb"); echo " <form action='chuli.php?bj=2&id={$arrUpdate[0][0]}' method='post'> <div class='text'>关键字</div><input type='text' name='sja[]' value='{$arrUpdate[0][1]}'/><br/> <div class='text'>区域</div><input type='text' name='sja[]' value='{$arrUpdate[0][2]}'/><br/> <div class='text'>使用面积</div><input type='text' name='sja[]' value='{$arrUpdate[0][3]}'/><br/> <div class='text'>租金</div><input type='text' name='sja[]' value='{$arrUpdate[0][4]}'/><br/> <div class='text'>租赁类型</div><input type='text' name='sja[]' value='{$arrUpdate[0][5]}'/><br/> <div class='text'>房屋类型</div><input type='text' name='sja[]' value='{$arrUpdate[0][6]}'/><br/> <input type='submit' value='更新'/> <a href='HouseInfo.php'><input type='button' value='取消'/></a> <form> "; }else if($bj==3){ //删除数据 $id=$_GET["id"]; $sql="delete from house where id={$id}"; $bool=$db->Query($sql,0,"housedb"); header("location:HouseInfo.php"); } ?> </body> </html>