php后台增删改跳转

php登录页面：

<h1>登录界面</h1>

	<form action="dengluchuli.php" method="post">

		用户名：<input type="text"  name="uid"/>

		密码：<input type="text" name="pwd"/>

		<input type="submit" value="登录" />

</form>

其中 dengluchuli.php在规定路径下。

登录跳转页面：

<?php

 	$yonghuming = $_POST["uid"];

 	$mima = $_POST["pwd"];

	$db = new mysqli("localhost","root","","12345");

	$sql = "select password from login where username='{$yonghuming}'";

	$result = $db->query($sql);

	$atter = $result->fetch_row();

    if($atter[0]==$mima && !empty($mima))

    {

		header("location:xinxi.php");

	}

	else

	{

		echo "用户名或密码错误";

	}

?>

此页面用于登录界面登录成功后通过用户名找到相应的数据。

登录主界面：

<?php

$de = new mysqli("localhost","root","","12345");

$e="select * from info";

$result = $de->query($e);

$atter = $result->fetch_all();

echo "<table border=1>";

echo "<tr>

		<td>代号</td>

		<td>姓名</td>

		<td>性别</td>

		<td>民族</td>

		<td>出生日期</td>

		<td>操作</td>

	   </tr> ";

for($i=0;$i<count($atter);$i++)

{

	echo "<tr>";

	for($j=0;$j<count($atter[$i]);$j++)

	{

		if($j==4)

		{

			echo "<td>".$atter[$i][$j]."</td>  <td><a href='shanchu.php?code={$atter[$i][1]}' onclick=\"return confirm('确定删除？')\"> 删除</a></td>";

		}

		else

		{

		echo "<td>".$atter[$i][$j]."</td>";

		}

	}

	echo "</tr>";

}

echo " </table>";

echo "<a href='tianjia.php'>添加数据</a>"

?>

添加数据（tianji.php）：

 <h1>添加数据</h1>

	  <form action="zeng.php" method="post">

		代号：<input type="text" name="daihao" />  <br />

		姓名：<input type="text" name="xinming" /><br />

		性别：<input type="text" name="xinbie" /><br />

		民族：<input type="text" name="minzu" /><br />

		生日：<input type="text" name="shengri" /><br />

		<input type="submit"  value="提交"/>

	</form>

zeng.php　：

<?php

	$code = $_POST["daihao"];

	$name = $_POST["xinming"];

	$sex = $_POST["xinbie"];

	$nation = $_POST["minzu"];

	$birthday = $_POST["shengri"];

	$db = new mysqli("localhost","root","","12345");

	$sql = "insert into info values('{$code}','{$name}','{$sex}','{$nation}','{$birthday}')";

	$r = $db->query($sql);

	if($r)

	{

		header("location:xinxi.php");

	}

	else

	{

		echo "添加失败";

	}

?>

添加成功：

shanchu.php

<?php

    $name = $_GET["code"];

	$db = new mysqli("localhost","root","","12345");

	$sql = "delete from info where name='{$name}'";

	$result = $db->query($sql);

	if($result)

	{

		header("location:xinxi.php");

	}

	else

	{

		echo "删除失败";

	}

?>

修改数据：

在xinxi.php文件中插入代码：

<a href='xiugai.php?code={$atter[$i][1]}'>修改</a>

相同路径下新建xiugai.php

<?php

    $name = $_GET["code"];

	$db = new mysqli("localhost","root","","12345");

	$sql = "select * from info  where name='{$name}'";

	$r = $db->query($sql);

	$atter = $r->fetch_row();

?>

<h1>修改</h1>

	<form action="xiugaichuli.php" method="post">

		<input type="hidden" name="daihao" value="<?php echo $atter[0]; ?>" /> <br />

		姓名：  <input type="text"  name="xinming" value="<?php echo $atter[1]; ?>"/> <br />

		性别：  <input type="text"  name="xinbie" value="<?php echo $atter[2]; ?>"/> <br />

		民族：  <input type="text"  name="minzu" value="<?php echo $atter[3]; ?>"/> <br />

		生日：  <input type="text"  name="shengri" value="<?php echo $atter[4]; ?>"/> <br />

             <input type="submit" value="修改" />

	</form>

相同路径下新建xiugaichuli.php

<?php

    $code = $_POST["daihao"];

	$name = $_POST["xinming"];

	$sex = $_POST["xinbie"];

	$nation = $_POST["minzu"];

	$birthday = $_POST["shengri"];

	$db = new mysqli("localhost","root","","12345");

	$sql = "update info set name='{$name}',sex={$sex},nation='{$nation}',birthday='{$birthday}' where code='{$code}'";

	$r = $db->query($sql);

	if($r)

	{

		header("location:xinxi.php");

	}

	else

	{

		echo "修改失败";

	}

?>

点击修改其中一条数据：

修改成功。

巴特西

php后台增删改跳转

最新文章

热门文章