第二阶段冲刺第六天
一、说在前面
为什么PHP有大作业还要有实验还得考试！！上午写了一上午的php实验，然后下午和php小组开交流会议看看各自完成的程度，晚上又是弄了一晚上的php，被php占据的一天。我还没弄钢镚儿呢！
二、完成情况
所以还是贴出php完成的内容吧...
<?php /** * Created by PhpStorm. * User: 26218 * Date: 2020/5/27 * Time: 8:26 */ ?> <!doctype html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0"> <meta http-equiv="X-UA-Compatible" content="ie=edge"> <title>添加个人资料</title> </head> <body> <center> <h1>添加个人资料</h1> <form action="check_insert.php" method="post" onsubmit="return check()"> <table border="1px"> <tr> <td>真实姓名：</td> <td><input type="text" name="name" id="name" ></td> </tr> <tr> <td>性别：</td> <td><input type="radio" name="sex" id="sex" value="男"> 男 <input type="radio" name="sex" id="sex" value="女"> 女</td> </tr> <tr> <td>兴趣爱好：</td> <td><input type="text" name="like" id="like" ></td> </tr> <tr> <td> 家庭住址：</td> <td><select name="locate" id="locate"> <option value="邯郸">邯郸</option> <option value="承德">承德</option> <option value="邢台">邢台</option> </select> </td> </tr> <tr> <td>备注：</td> <td><textarea rows="8" cols="15" name="remark" id="remark"></textarea></td> </tr> <tr> <td colspan="2" style="text-align: center"> <input type="submit" value="提交"> <input type="reset" value="重置"> </td> </tr> </table> </form> </center> </body> <script> function check() { var name=document.getElementById("name"); var sex=document.getElementById("sex"); var like=document.getElementById("like"); var locate=document.getElementById("locate"); var remark=document.getElementById("remark"); if(name.value==""){ alert("姓名不能为空"); name.focus(); return false; } else if(sex.value==""){ alert("性别不能为空"); sex.focus(); return false; } else if(like.value==""){ alert("爱好不能为空"); like.focus(); return false; } else if(locate.value==""){ alert("住址不能为空"); locate.focus(); return false; } else if(remark.value==""){ alert("备注不能为空"); remark.focus(); return false; } } </script> </html>
<?php /** * Created by PhpStorm. * User: 26218 * Date: 2020/4/30 * Time: 17:35 */ ?> <!doctype html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0"> <meta http-equiv="X-UA-Compatible" content="ie=edge"> <title>Document</title> </head> <body> <?php include_once("conn/conn.php"); ?> <center> <h1 style="text-align: center">学生个人信息表</h1> <table width="90%" border="1px" cellpadding="0" cellspacing="0" style="text-align: center"> <tr > <td width="20%" class="top">姓名</td> <td width="10%" class="top">性别</td> <td width="20%" class="top">爱好</td> <td width="10%" class="top">住址</td> <td width="10%" class="top">备注</td> <td width="20%" class="top">管理</td> </tr> <?php $sqlstr = "select * from ex01 order by 'id'"; $result = mysqli_query($conn,$sqlstr); while ($rows = mysqli_fetch_row($result)){ echo "<tr>"; for($i = 1; $i < count($rows); $i++){ echo "<td height='25' align='center' class='m_td'>".$rows[$i]."</td>"; } echo "<td class='m_td'><a href='ex01_c.php?id={$rows[0]}'>修改</a>/<a href='javascript:del({$rows[0]})'>删除</a></td>"; echo "</tr>"; } ?> </table> </center> </body> <script type="text/javascript"> function del (id) { if (confirm("确定删除这条信息吗？")){ window.location = "ex01_d.php?id="+id; } } </script> </html>
<?php /** * Created by PhpStorm. * User: 26218 * Date: 2020/5/27 * Time: 8:26 */ include_once ("conn/conn.php"); $sid=$_GET['id']; $sqlstr = "select * from ex01 where id=$sid "; $result = mysqli_query($conn,$sqlstr); if(!empty($result)){ $rows = mysqli_fetch_array($result); if($rows['sex']=="女") echo 1; if($rows['sex']=="女") echo 0; } if(!empty($_POST)) { $name = $_POST['name']; $sex = $_POST['sex']; $love = $_POST['love']; $locate = $_POST['locate']; $remark = $_POST['remark']; $sql1 = "UPDATE ex01 SET name='$name',sex='$sex',love='$love',locate='$locate',remark='$remark' where id= '$sid' "; echo $sql1; $result1 = mysqli_query($conn, $sql1); if ($result1) { echo "<script>alert(\"修改成功 \");window.location.href='ex01_b.php';</script>"; } } ?> <!doctype html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0"> <meta http-equiv="X-UA-Compatible" content="ie=edge"> <title>添加个人资料</title> </head> <body> <center> <h1>修改个人资料</h1> <form action="" method="post" onsubmit="return check()"> <table border="1px"> <tr> <td>真实姓名：</td> <td><input type="text" name="name" id="name" value="<?php if(!empty($rows))echo $rows['name'] ?>"></td> </tr> <tr> <td>性别：</td> <td><input type="radio" name="sex" id="sex" checked="false" value="男"> 男 <input type="radio" name="sex" id="sex" value="女"> 女</td> </tr> <tr> <td>兴趣爱好：</td> <td><input type="text" name="love" id="love" value="<?php echo $rows['love']?>"></td> </tr> <tr> <td> 家庭住址：</td> <td><select name="locate" id="locate" value="<?php echo $rows['locate']?>"> <option value="邯郸">邯郸</option> <option value="承德">承德</option> <option value="邢台">邢台</option> </select> </td> </tr> <tr> <td>备注：</td> <td><textarea rows="8" cols="15" name="remark" id="remark" ><?php echo $rows['remark']?></textarea></td> </tr> <tr> <td colspan="2" style="text-align: center"> <input type="submit" value="提交"> <input type="reset" value="重置"> </td> </tr> </table> </form> </center> </body> <script> function check() { var name=document.getElementById("name"); var sex=document.getElementById("sex"); var like=document.getElementById("like"); var locate=document.getElementById("locate"); var remark=document.getElementById("remark"); if(name.value==""){ alert("姓名不能为空"); name.focus(); return false; } else if(sex.value==""){ alert("性别不能为空"); sex.focus(); return false; } else if(like.value==""){ alert("爱好不能为空"); like.focus(); return false; } else if(locate.value==""){ alert("住址不能为空"); locate.focus(); return false; } else if(remark.value==""){ alert("备注不能为空"); remark.focus(); return false; } } </script> </html>
<?php /** * Created by PhpStorm. * User: 26218 * Date: 2020/5/27 * Time: 10:56 */ include_once("conn/conn.php"); $id = $_GET['id']; //删除指定数据 $sql = "DELETE FROM ex01 WHERE id='$id'"; echo $sql; $result = mysqli_query($conn,$sql); if(!empty($result)){ echo "<script>alert(\"删除成功\");window.location.href='ex01_b.php';</script>"; exit; }else { echo "<script>alert(\"删除失败\");window.location.href='ex01_b.php';</script>"; exit; } ?>
<?php /** * Created by PhpStorm. * User: 26218 * Date: 2020/5/27 * Time: 8:46 */ include_once ("conn/conn.php"); if($_POST!=null){ $sqlstr = "insert into ex01 (name,sex,love,locate,remark) values ('".$_POST["name"]."','".$_POST["sex"]."','".$_POST["like"]."','".$_POST["locate"]."','".$_POST["remark"]."')"; echo $sqlstr.'<br>'; $result = mysqli_query($conn,$sqlstr); if(!empty($result)){ echo "<script type='text/javascript'>"; echo "alert('添加成功');window.location.href='ex01_b.php';"; // echo "window.location.href('ex01_b.php');"; echo "</script>"; // echo "点击<a href='ex01_b.php'>这里</a>查看"; } }else { echo "登陆失败，点击此处<a href='ex01_a.php'>返回</a>重试"; }
<?php /** * Created by PhpStorm. * User: 26218 * Date: 2020/5/27 * Time: 8:46 */ include_once ("conn/conn.php"); if($_POST!=null){ $sqlstr = "insert into ex02 (name,sex,old,locate,love) values ('".$_POST["name"]."','".$_POST["sex"]."','".$_POST["old"]."','".$_POST["locate"]."','".$_POST["love"].")"; echo $sqlstr.'<br>'; $result = mysqli_query($conn,$sqlstr); if(!empty($result)){ echo "<script type='text/javascript'>"; echo "alert('添加成功');window.location.href='ex02_c.php';"; echo "</script>"; // echo "点击<a href='ex01_b.php'>这里</a>查看"; } }else { echo "保存失败，点击此处<a href='ex02_a.php'>返回</a>重试"; }
<?php /** * Created by PhpStorm. * User: 26218 * Date: 2020/5/27 * Time: 12:29 */ include_once("conn/conn.php"); $id = $_GET['id']; //删除指定数据 $sql = "DELETE FROM ex02 WHERE name='$id'"; echo $sql; $result = mysqli_query($conn,$sql); if(!empty($result)){ echo "<script>alert(\"删除成功\");window.location.href='ex02_b.php';</script>"; exit; }else { echo "<script>alert(\"删除失败\");window.location.href='ex02_b.php';</script>"; exit; }
<?php /** * Created by PhpStorm. * User: 26218 * Date: 2020/5/27 * Time: 11:10 */ $name=""; $sex=""; if(!empty($_POST)){ $name=$_POST['name']; $sex=$_POST['sex']; include_once("conn/conn.php"); $sql1="select * from ex02 where name='$name'"; $request=mysqli_query($conn,$sql1); // echo $sql1.'<br>'; if(!empty($request)){ $rows=mysqli_fetch_row($request); } if(!empty($rows)){ echo "不空"; echo "<script type='text/javascript'>"; echo "window.location.href='ex02_c.php?name={$name}&sex={$sex}';"; echo "</script>"; } else{ echo "空"; echo "<script type='text/javascript'>"; echo "window.location.href='ex02_b.php?name={$name}&sex={$sex}';"; echo "</script>"; } } ?> <!doctype html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0"> <meta http-equiv="X-UA-Compatible" content="ie=edge"> <title>用户登录</title> </head> <body> <center> <h1>用户登录</h1> <form method="post"> <table border="1px"> <tr> <td>姓名：</td> <td><input type="text" id="name" name="name"></td> </tr> <tr> <td>性别：</td> <td> <input type="radio" id="sex" name="sex" value="男">男 <input type="radio" id="sex" name="sex" value="女">女 </td> </tr> <tr> <td colspan="2" align="center"> <input type="submit" value="提交"> <input type="reset" value="重置"> </td> </tr> </table> </form> </center> </body> </html>
<?php /** * Created by PhpStorm. * User: 26218 * Date: 2020/5/27 * Time: 11:23 */ $name=""; $sex=""; $chenghu=""; if(!empty($_GET)){ $name=$_GET['name']; $sex=$_GET['sex']; } if($sex=="男")$chenghu="先生"; else if($sex=="女")$chenghu="小姐"; ?> <!doctype html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0"> <meta http-equiv="X-UA-Compatible" content="ie=edge"> <title>添加个人信息</title> </head> <body> <h2 style="color: #00bf00" align="center"><?php echo "$name $chenghu 您好，对不起，没有找到您的个人资料，请填写您的详细信息！" ?></h2> <hr color="red"> <center> <h1>添加个人资料</h1> <form action="check_insert.php" method="post" onsubmit="return check()"> <table border="1px"> <tr> <td>真实姓名：</td> <td><input type="text" name="name" id="name" ></td> </tr> <tr> <td>性别：</td> <td><input type="radio" name="sex" id="sex" value="男"> 男 <input type="radio" name="sex" id="sex" value="女"> 女</td> </tr> <tr> <td>年龄：</td> <td><input type="text" name="old" id="old" ></td> </tr> <tr> <td> 家庭住址：</td> <td><select name="locate" id="locate"> <option value="邯郸">邯郸</option> <option value="承德">承德</option> <option value="邢台">邢台</option> </select> </td> </tr> <tr> <td>特长爱好：</td> <td><textarea rows="8" cols="15" name="love" id="love"></textarea></td> </tr> <tr> <td colspan="2" style="text-align: center"> <input type="submit" value="提交"> <input type="reset" value="重置"> </td> </tr> </table> </form> </center> </body> </html>
<?php /** * Created by PhpStorm. * User: 26218 * Date: 2020/5/27 * Time: 11:23 */ include_once("conn/conn.php"); $name=""; if(!empty($_GET)){ $name=$_GET['name']; $sex=$_GET['sex']; // echo $name; } $sql1="select * from ex02 where name='$name'"; $request=mysqli_query($conn,$sql1); if(!empty($request)){ $row=mysqli_fetch_row($request); } else{ echo "没接到值"; } ?> <!doctype html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0"> <meta http-equiv="X-UA-Compatible" content="ie=edge"> <title>添加个人信息</title> </head> <body> <h2 style="color: #00bf00" align="center">学生个人信息表</h2> <hr color="red"> <center> <h1>添加个人资料</h1> <form action="check_insert.php" method="post" onsubmit="return check()"> <table border="1px"> <tr> <td>真实姓名：</td> <td><?php echo $row[0]?></td> </tr> <tr> <td>性别：</td> <td><?php echo $row[1]?></td> </tr> <tr> <td>年龄：</td> <td><?php echo $row[2]?></td> </tr> <tr> <td> 家庭住址：</td> <td><?php echo $row[3]?></td> </tr> <tr> <td>特长爱好：</td> <td><?php echo $row[4]?></td> </tr> <tr> <td colspan="2" style="text-align: center"> <a href='<?php echo "ex02_d.php?name=$name"?>'>修改</a> <a href="javascript:del('<?php echo $name?>')">删除</a> </td> </tr> </table> </form> </center> </body> <script type="text/javascript"> function del (id) { if (confirm("确定删除这条信息吗？")){ window.location = "delete.php?id="+id; } } </script> </html>
<?php /** * Created by PhpStorm. * User: 26218 * Date: 2020/5/27 * Time: 11:23 */ include_once ("conn/conn.php"); $name1=$_GET['name']; $sqlstr = "select * from ex02 where name ='$name1' "; //echo $sqlstr; $result = mysqli_query($conn,$sqlstr); if(!empty($result)){ $rows = mysqli_fetch_array($result); } if(!empty($_POST)) { $name = $_POST['name']; $sex = $_POST['sex']; $love = $_POST['love']; $locate = $_POST['locate']; $old = $_POST['old']; $sql1 = "UPDATE ex02 SET name= '$name',sex='$sex',love='$love',locate='$locate',old='$old' where name= '$name1' "; echo $sql1; $result1 = mysqli_query($conn, $sql1); if ($result1) { echo "<script>alert(\"修改成功 \");window.location.href='ex02_c.php?name=$name&sex=$sex';</script>"; } } ?> <!doctype html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0"> <meta http-equiv="X-UA-Compatible" content="ie=edge"> <title>修改个人信息</title> </head> <body> <h2 style="color: #00bf00" align="center">修改学生个人信息</h2> <hr color="red"> <center> <h1>修改个人资料</h1> <form action="" method="post" onsubmit="return check()"> <table border="1px"> <tr> <td>真实姓名：</td> <td><input type="text" name="name" id="name" value="<?php echo $rows[0]?>"></td> </tr> <tr> <td>性别：</td> <td><input type="radio" name="sex" id="sex" value="男" checked="checked"> 男 <input type="radio" name="sex" id="sex" value="女"> 女</td> </tr> <tr> <td>年龄：</td> <td><input type="text" name="old" id="old" value="<?php echo $rows[2]?>" ></td> </tr> <tr> <td> 家庭住址：</td> <td><select name="locate" id="locate" value="<?php echo $rows[3]?>"> <option value="邯郸">邯郸</option> <option value="承德">承德</option> <option value="邢台">邢台</option> </select> </td> </tr> <tr> <td>特长爱好：</td> <td><textarea rows="8" cols="15" name="love" id="love"><?php echo $rows[4]?>"</textarea></td> </tr> <tr> <td colspan="2" style="text-align: center"> <input type="submit" value="提交"> <input type="reset" value="重置"> </td> </tr> </table> </form> </center> </body> </html>
