<li><a href="add.php3">Add a new entry to the DataBase</a>
<li><a href="edit.php3">Edit an entry</a>
<li><a href="del.php3">Delete an entry from the DataBase</a>
</ul>
include的语法是:
Include ('included_text_file');
现在我们可以用?>来关闭PHP部分,并且用</body></html>来结束html页面。
使用表单增加数据让我们看一下下面的代码:
--------------------------------------------------------------------------------
<html>
<head><title>Add an entry to the database</title>
</head>
<body bgcolor=#ffffff>
<h1>Add an entry</h1>
<form method="post" action="add2tbl.php3">
<table width=90% align=center>
<tr><td>Index:</td><td><input type=text name="idx" size=3 maxlength=3></td></tr> <tr><td>UserName:</td><td><input type=text name="UserName" size=40
maxlength=100></td></tr>
<tr><td>LastName:</td><td><input type=text name="LastName" size=40
maxlength=100></td></tr> <tr><td>FreeText:</td><td><input type=text name="FreeText" s=40 maxlength=100></td></tr> <tr><td></td><td><input type=submit value=add></td></tr>
</form>
</table>
<?php include ('links.x');?>
</body>
</html>
--------------------------------------------------------------------------------
假设你对表单很熟悉,这是一个相当简单的脚本。我们根据html页面设计了一个表单,它在提交后调用 add2tbl.php3脚本。现在,表单与MySQL表相对应由4个字段组成:index number,FirstName,LastName和 FreeText。注意在这个表单中字段名字与MySQL表中字段名一样,但这只是为了方便起见而不是必须。
我们再一次使用了include命令<? include ('links.x');?>(象在前面所解释的)来增加链接。
让我们看一下add2tbl.php3脚本:
--------------------------------------------------------------------------------
<html>
<body>
<?
if ($UserName)
{
mysql_connect() or die ("Problem connecting to DataBase");
$query = "insert into tbl values ('$idx','$UserName','$LastName','$FreeText')";
$result = mysql_db_query("example", $query);
echo "Data inserted. new table:<br><p></p>";
$query = "SELECT * FROM tbl";
$result = mysql_db_query("example", $query);
if ($result)
{
echo "<table width=90% align=center border=1><tr>







