PHP5对Mysql5的任意数据库表的管理代码示例（四）

续：如果点击删除一个条目则会跳转到del.php

// del.php
< html >
< head >< title > Deleting an entry from the database </ title >
< meta http - equiv = " Content-Type "  content = " text/html; charset=gb2312 "   />
</ head >
< body bgcolor = # ffffff>
< h2 > Delete an entry </ h2 >
<?
$database   =   " sunsite " ;
$tablename   =   $_REQUEST [ ' tablename ' ];
echo   " <h2>Data from $tablename</h2> " ;
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 )
{
echo   " Found these entries in the database:<br><p></p> " ;
echo   " <table width=90% align=center border=1><tr> " ;
while  ( $r   =   mysql_fetch_array ( $result ))
{
echo   " <td align=center bgcolor=#00FFFF>$r[0]</td> " ;
$colname [ $column ]  =   $r [ 0 ];
$column   =   $column   +   1 ;
}
echo   " </tr> " ;
mysql_free_result ( $result );

$query   =   " select * from $tablename " ;
$result   =   mysql_db_query ( $database ,   $query );
if  ( $result ) 
while  ( $r   =   mysql_fetch_array ( $result ))
{
echo   " <tr> " ;
echo   " <td><a href="dele.php?$colname[0]=$r[0]&tablename=$tablename">$r[0]</td> " ;
for ( $col = 1 ; $col < $column ; $col ++ )  echo   " <td>$r[$col]</td> " ;
echo   " </tr> " ;
}
echo   " </table> " ;
}
else   echo   " No data. " ;
mysql_free_result ( $result );

?>
< a href = " tables.php?tablename=<? echo  " $tablename " ?> " > Finish </ a >
</ body >
</ html >  

 
然后写入数据库

// dele.php
<? 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 );
}

$para   =   $_GET [ $colname [ 0 ]];

mysql_connect ( " localhost " , " root " , "" ) or  die  ( " Problem connecting to DataBase " );
$query   =   " delete from $tablename where $colname[0]='$para'; " ;
$result   =   mysql_db_query ( $database ,   $query );
Header ( " Location: edit.php?tablename=$tablename " ); 
?>
< meta http - equiv = " Content-Type "  content = " text/html; charset=gb2312 "   />

以上就是所有的代码了。
把它们都放到同一个目录下面即可。
注意：提醒！以上代码在copy的时候一定注意在编辑器里面把每一行代码前面的tab去掉，不然php5编译不过。
而且在每个文件中$database目前为sunsite，$table为software，这个可以根据需要修改。

欢迎发表看法。