初学入门 PHP 和 MySQL

ChinaItLab

佚名

2007-5-17

保存本文

推荐给好友

收藏本页

欢迎进入Linux社区论坛，与200万技术人员互动交流 >>进入

　　从数据库中删除一条记录：

　　好，删除很容易。我们仍然需要两个脚本：一个用来选择要删除的记录（基本上同上面选择要编辑的记
录一样），一个用来真正地进行删除和打印新的表格。

--------------------------------------------------------------------------------
del.php3:

<html>
<head><title>Deleting an entry from the database</title>
</head>

<body bgcolor=#ffffff>
<h1>Del an entry</h1>

<?

mysql_connect() or die ("Problem connecting to DataBase");
$query = "select * from tbl";
$result = mysql_db_query("example", $query);

if ($result)
{
echo "Found these entries in the database:<br><p></p>";
echo "<table width=90% align=center border=1><tr>
<td align=center bgcolor=#00ffff>idx</td>
<td align=center bgcolor=#00FFFF>User Name</td>
<td align=center bgcolor=#00FFFF>Last Name</td>
<td align=center bgcolor=#00FFFF>Free Text</td>
</tr>";

while ($r = mysql_fetch_array($result))
{
$idx = $r["idx"];
$user = $r["UserName"];
$last = $r["LastName"];
$text = $r["FreeText"];

echo "<tr>
<td align=center>
<a href="dele.php3?
idx=$idx&UserName=$user&LastName=$last&FreeText=$text">$idx</a></td>
<td>$user</td>
<td>$last</td>
<td>$dtext</td>
</tr>";

}
echo "</table>";
}
else
{
echo "No data.";
}

mysql_free_result($result);
include ('links.x');

?>

</body>
</html>
--------------------------------------------------------------------------------
　　这个脚本与我们用过的编辑脚本很象，所以可以看一下那里的说明。

--------------------------------------------------------------------------------
dele.php3:

<?php

mysql_connect() or die ("Problem connecting to DataBase");
$query = "delete from tbl where idx='$idx' and UserName='$UserName' and
LastName='$LastName' and FreeText='$FreeText'";

$result = mysql_db_query("example", $query);
$query = "SELECT * FROM tbl";
$result = mysql_db_query("example", $query);

if ($result)
{
echo "Found these entries in the database:<br><p></p>";
echo "<table width=90% align=center border=1><tr>
<td align=center bgcolor=#00FFFF>idx</td>
<td align=center bgcolor=#00FFFF>User Name</td>
<td align=center bgcolor=#00FFFF>Last Name</td>
<td align=center bgcolor=#00FFFF>Free Text</td>
</tr>";

while ($r = mysql_fetch_array($result))
{
$idx = $r["idx"];
$user = $r["UserName"];
$last = $r["LastName"];
$text = $r["FreeText"];

echo "<tr>
<td>$idx</td>
<td>$user</td>
<td>$last</td>
<td>$text</td>
</tr>";

}
echo "</table>";
}
else
{
echo "No data.";
}

mysql_free_result($result);

include ('links.x');

?>--------------------------------------------------------------------------------
　　这个脚本看上去很熟悉，唯一不同的就是删除查询的语法：

$query = "delete from tbl where idx='$idx' and UserName='$UserName' and LastName='$LastName' and FreeText='$FreeText'";

　　这个查询将会删除所有与前面的脚本传递来的信息相配匹的记录。容易吧。

　　好了，这就是全部内容了。