续点击添加一个条目就会跳转到add.php
//add.php
%26lt;html%26gt;
%26lt;head%26gt;%26lt;title%26gt;Add an entry to the database%26lt;/title%26gt;
%26lt;meta http-equiv="Content-Type" content="text/html; charset=gb2312" /%26gt;
%26lt;/head%26gt;
%26lt;body bgcolor=#ffffff%26gt;
%26lt;h2%26gt;Add an entry%26lt;/h2%26gt;
%26lt;?php
$database = "sunsite";
$tablename = $_GET['tablename'];
mysql_connect("localhost","root","") or die ("Problem connecting to DataBase");
$query = "show columns from $tablename";
$result = mysql_db_query($database,$query);
$column = 0;
if ($result)
{
while ($r = mysql_fetch_array($result))
{
$colname[$column] = $r[0];
$column = $column + 1;
}
mysql_free_result($result);
}
$id = 0;
do
{
$id++;
$query = "select * from $tablename where $colname[0]='$id'";
$result = mysql_db_query($database,$query);
}
while(mysql_fetch_array($result))
?%26gt;
%26lt;form method="post" action="addsoftware.php"%26gt;
%26lt;table width=90% align=center%26gt;
%26lt;tr%26gt;%26lt;td%26gt;%26lt;?php echo "$colname[0]";?%26gt;:%26lt;/td%26gt;%26lt;td%26gt;%26lt;?php echo "$id"; ?%26gt;%26lt;/td%26gt;%26lt;/tr%26gt;
%26lt;?
for ($col=1;$col%26lt;$column;$col++)
echo "%26lt;tr%26gt;%26lt;td%26gt;$colname[$col]:%26lt;/td%26gt;%26lt;td%26gt;%26lt;input type=text name=$colname[$col] size="100%"%26gt;%26lt;/td%26gt;%26lt;/tr%26gt;";
?%26gt;
%26lt;input type=hidden name="%26lt;?php echo "$colname[0]"; ?%26gt;" value="%26lt;?php echo "$id"; ?%26gt;"%26gt;
%26lt;input type=hidden name=tablename value="%26lt;?php echo "$tablename"; ?%26gt;"%26gt;
%26lt;tr%26gt;%26lt;td%26gt;%26lt;/td%26gt;%26lt;td%26gt;%26lt;input type=submit value=" Add "%26gt;%26lt;/td%26gt;%26lt;/tr%26gt;
%26lt;/table%26gt;
%26lt;/form%26gt;
%26lt;a href="tables.php?tablename=%26lt;? echo "$tablename"?%26gt;"%26gt;Finish%26lt;/a%26gt;
%26lt;/body%26gt;
%26lt;/html%26gt; 其中id是自动寻找并生成的，而且保证在数据库中id是唯一的。点击add之后会将内容写入数据库，然后会继续让你添加内容，直至添加完毕点击finish回到上一层，显示出添加条目後的数据库内容。
下面是添加过程中对数据库进行操作的addsoftware.php
//addsoftware.php
%26lt;?php
$database = "sunsite";
$tablename = $_POST['tablename'];
mysql_connect("localhost","root","") or die ("Problem connecting to DataBase");
$query = "show columns from $tablename";
$result = mysql_db_query($database,$query);
$column = 0;
if ($result)
{
while ($r = mysql_fetch_array($result))
{
$colname[$column] = $r[0];
$column = $column + 1;
}
mysql_free_result($result);
}
for($col=0;$col%26lt;$column;$col++)
$para[$col] = $_POST[$colname[$col]];
if ($_POST['name'])
{
mysql_connect("localhost","root","") or die ("Problem connecting to DataBase");
$query = "insert into $tablename values ('$para[0]' ";
for($col=1;$col%26lt;$column;$col++)
$query = $query . ",'" . $para[$col] . "'";
$query = $query . ");";
$result = mysql_db_query($database, $query);
Header("Location: add.php?tablename=$tablename");
}
else
{
echo "No name Entered. Please go back and reenter name";
}
?%26gt;
%26lt;meta http-equiv="Content-Type" content="text/html; charset=gb2312" /%26gt;
待续。