<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>添加数据</title>
<link rel="stylesheet" type="text/css" href="mystyle.css">
</head>
<body>
<center>
<table width="799" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="106" background="images/banner.jpg"> </td>
</tr>
<tr>
<td>
<table width="100%" height="27" border="0" cellpadding="0" cellspacing="0" background="images/link.jpg">
<tr>
<td width="243" align="center" valign="middle"><b>
<?php
echo date("Y-m-d")." ";
echo date(l);
?>
</b></td>
<td width="90" align="center" valign="middle"><a href="index.php?action=show" class="a">浏览目录</a></td>
<td width="94" align="center" valign="middle"><a href="index.php?action=insert" class="a">添加图书</a></td>
<td width="94" align="center" valign="middle"><a href="#" class="a">简单查询</a></td>
<td width="91" align="center" valign="middle"><a href="#" class="a">高级查询</a></td>
<td width="94" align="center" valign="middle"><a href="#" class="a">分组统计</a></td>
<td width="93" align="center" valign="middle"><a href="#" class="a">退出系统</a></td>
</tr>
</table>
</td>
</tr>
</table>
<table width="799" height="300" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="middle">
<?php
$conn = mysql_connect("localhost","root","root");
mysql_query("set names gb2312");
mysql_select_db("db_mingrisoft");
//浏览图书
if (($action == null) or ($_GET[action] == "show")){
?>
<form name="form1" id="form1" method="post">
<table width="90%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="5%" height="25" class="top">id</td>
<td width="30%" 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>
</tr>
<?php
$sqlstr = "select * from tb_mrbook order by id";
$result = mysql_query($sqlstr,$conn);
while ($rows = mysql_fetch_row($result)){
echo "<tr>";
for($i = 0; $i < count($rows); $i++){
echo "<td height='25' align='center' class='m_td'>".$rows[$i]."</td>";
}
echo "<td class='m_td'><a href='#'>修改</a>/<a href='#'>删除</a></td>";
echo "</tr>";
}
?>
</table>
</form>
<?php
}
//添加操作
if ($_POST[action] == "insert"){
if (!($_POST[bookname] and $_POST[price] and $_POST[f_time] and $_POST[type]))
echo "输入不允许为空。点击<a href='javascript:onclick=history.go(-1)'>这里</a> 返回";
else{
$sqlstr1 = "insert into tb_mrbook values('','".$_POST[bookname]."','".$_POST[price]."','".$_POST[f_time]."','".$_POST[type]."')";
$result = mysql_query($sqlstr1,$conn);
if ($result){
echo "添加成功,点击<a href='index.php'>这里</a>查看";
}
else
echo "<script>alert('添加失败');history.go(-1);</script>";
}
}
//插入界面
if($_GET[action] == "insert"){
?>
<form name="intFrom" method="post" action="index.php">
<table width="100%" height="200" border="0" cellpadding="0" cellspacing="0">
<tr align="center" valign="middle">
<td width="30%" class="c_td"> </td>
<td width="10%" align="right" class="c_td"> </td>
<td width="30%" class="c_td"> </td>
<td width="30%" class="c_td"> </td>
</tr>
<tr>
<td class="c_td"> </td>
<td align="right" valign="middle" class="c_td">书名:</td>
<td align="center" valign="middle" class="c_td"><input type="text" name="bookname"></td>
<td class="c_td"> </td>
</tr>
<tr>
<td class="c_td"> </td>
<td align="right" valign="middle" class="c_td">价格:</td>
<td align="center" valign="middle" class="c_td"><input type="text" name="price"></td>
<td class="c_td"> </td>
</tr>
<tr>
<td class="c_td"> </td>
<td align="right" valign="middle" class="c_td">出版时间:</td>
<td align="center" valign="middle" class="c_td"><input type="text" name="f_time"></td>
<td class="c_td"> </td>
</tr>
<tr>
<td class="c_td"> </td>
<td align="right" valign="middle" class="c_td">所属类别:</td>
<td align="center" valign="middle" class="c_td"><input type="text" name="type"></td>
<td class="c_td"> </td>
</tr>
<tr align="center" valign="middle">
<td class="c_td"> </td>
<td colspan="2" class="c_td">
<input type="hidden" name="action" value="insert">
<input type="submit" name="Submit" value="添加">
<input type="reset" name="reset" value="重置"></td>
<td class="c_td"> </td>
</tr>
</table>
</form>
<?php
}
?>
</td>
</tr>
</table>
<table width="799" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="67" background="images/bottom.jpg"> </td>
</tr>
</table>
</center>
</body>
</html>
这两行中的
<td width="90" align="center" valign="middle"><a href="index.php?action=show" class="a">浏览目录</a></td>
<td width="94" align="center" valign="middle"><a href="index.php?action=insert" class="a">添加图书</a></td>这两行中的action=show"
action=insert"是什么意思action
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>添加数据</title>
<link rel="stylesheet" type="text/css" href="mystyle.css">
</head>
<body>
<center>
<table width="799" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="106" background="images/banner.jpg"> </td>
</tr>
<tr>
<td>
<table width="100%" height="27" border="0" cellpadding="0" cellspacing="0" background="images/link.jpg">
<tr>
<td width="243" align="center" valign="middle"><b>
<?php
echo date("Y-m-d")." ";
echo date(l);
?>
</b></td>
<td width="90" align="center" valign="middle"><a href="index.php?action=show" class="a">浏览目录</a></td>
<td width="94" align="center" valign="middle"><a href="index.php?action=insert" class="a">添加图书</a></td>
<td width="94" align="center" valign="middle"><a href="#" class="a">简单查询</a></td>
<td width="91" align="center" valign="middle"><a href="#" class="a">高级查询</a></td>
<td width="94" align="center" valign="middle"><a href="#" class="a">分组统计</a></td>
<td width="93" align="center" valign="middle"><a href="#" class="a">退出系统</a></td>
</tr>
</table>
</td>
</tr>
</table>
<table width="799" height="300" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="middle">
<?php
$conn = mysql_connect("localhost","root","root");
mysql_query("set names gb2312");
mysql_select_db("db_mingrisoft");
//浏览图书
if (($action == null) or ($_GET[action] == "show")){
?>
<form name="form1" id="form1" method="post">
<table width="90%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="5%" height="25" class="top">id</td>
<td width="30%" 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>
</tr>
<?php
$sqlstr = "select * from tb_mrbook order by id";
$result = mysql_query($sqlstr,$conn);
while ($rows = mysql_fetch_row($result)){
echo "<tr>";
for($i = 0; $i < count($rows); $i++){
echo "<td height='25' align='center' class='m_td'>".$rows[$i]."</td>";
}
echo "<td class='m_td'><a href='#'>修改</a>/<a href='#'>删除</a></td>";
echo "</tr>";
}
?>
</table>
</form>
<?php
}
//添加操作
if ($_POST[action] == "insert"){
if (!($_POST[bookname] and $_POST[price] and $_POST[f_time] and $_POST[type]))
echo "输入不允许为空。点击<a href='javascript:onclick=history.go(-1)'>这里</a> 返回";
else{
$sqlstr1 = "insert into tb_mrbook values('','".$_POST[bookname]."','".$_POST[price]."','".$_POST[f_time]."','".$_POST[type]."')";
$result = mysql_query($sqlstr1,$conn);
if ($result){
echo "添加成功,点击<a href='index.php'>这里</a>查看";
}
else
echo "<script>alert('添加失败');history.go(-1);</script>";
}
}
//插入界面
if($_GET[action] == "insert"){
?>
<form name="intFrom" method="post" action="index.php">
<table width="100%" height="200" border="0" cellpadding="0" cellspacing="0">
<tr align="center" valign="middle">
<td width="30%" class="c_td"> </td>
<td width="10%" align="right" class="c_td"> </td>
<td width="30%" class="c_td"> </td>
<td width="30%" class="c_td"> </td>
</tr>
<tr>
<td class="c_td"> </td>
<td align="right" valign="middle" class="c_td">书名:</td>
<td align="center" valign="middle" class="c_td"><input type="text" name="bookname"></td>
<td class="c_td"> </td>
</tr>
<tr>
<td class="c_td"> </td>
<td align="right" valign="middle" class="c_td">价格:</td>
<td align="center" valign="middle" class="c_td"><input type="text" name="price"></td>
<td class="c_td"> </td>
</tr>
<tr>
<td class="c_td"> </td>
<td align="right" valign="middle" class="c_td">出版时间:</td>
<td align="center" valign="middle" class="c_td"><input type="text" name="f_time"></td>
<td class="c_td"> </td>
</tr>
<tr>
<td class="c_td"> </td>
<td align="right" valign="middle" class="c_td">所属类别:</td>
<td align="center" valign="middle" class="c_td"><input type="text" name="type"></td>
<td class="c_td"> </td>
</tr>
<tr align="center" valign="middle">
<td class="c_td"> </td>
<td colspan="2" class="c_td">
<input type="hidden" name="action" value="insert">
<input type="submit" name="Submit" value="添加">
<input type="reset" name="reset" value="重置"></td>
<td class="c_td"> </td>
</tr>
</table>
</form>
<?php
}
?>
</td>
</tr>
</table>
<table width="799" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="67" background="images/bottom.jpg"> </td>
</tr>
</table>
</center>
</body>
</html>
这两行中的
<td width="90" align="center" valign="middle"><a href="index.php?action=show" class="a">浏览目录</a></td>
<td width="94" align="center" valign="middle"><a href="index.php?action=insert" class="a">添加图书</a></td>这两行中的action=show"
action=insert"是什么意思action
意思就是你点击了这个链接之后,会传给index.php一个变量$_GET['action'],这个变量的值是show。
if (($action == null) or ($_GET[action] == "show"))
show就显示 目录的内容
insert就显示 要新增的表单实现单一入口index.php