$num_results = 3;
$row = array('company_name'=>'microsoft','person_name'=>'bill gates','address_name'=>'USA','insert_id'=>110);
for ($i=0; $i <$num_results; $i++)
{
//$row = $result->fetch_assoc();
echo '<p><strong>'.($i+1).'. 公司名称: ';
echo htmlspecialchars(stripslashes($row['company_name']));
echo '</strong><br />联系人: ';
echo stripslashes($row['person_name']);
echo '<br />联系地址: ';
echo stripslashes($row['address_name']);
echo'<br />';
$delete=$row['insert_id'];
echo "<td><input type='button' name='del' value='delete from insert_file where $delete=''</td>";
echo '</p>';
}
$row = array('company_name'=>'microsoft','person_name'=>'bill gates','address_name'=>'USA','insert_id'=>110);
for ($i=0; $i <$num_results; $i++)
{
//$row = $result->fetch_assoc();
echo '<p><strong>'.($i+1).'. 公司名称: ';
echo htmlspecialchars(stripslashes($row['company_name']));
echo '</strong><br />联系人: ';
echo stripslashes($row['person_name']);
echo '<br />联系地址: ';
echo stripslashes($row['address_name']);
echo'<br />';
$delete=$row['insert_id'];
echo "<td><input type='button' name='del' value='delete from insert_file where $delete=''</td>";
echo '</p>';
}
echo "<td><a href="deleteRecord.php?id=".$delete.">delete</a></td>";deleteRecord.php:$sql = "delete from insert_file where id=".$_GET['id'];
<?php
$add_company=$_POST['add_company'];
$add_person=$_POST['add_person'];
$add_address=$_POST['add_address'];if (!$add_company || !$add_person || !$add_address)
{
echo '你还没有输齐所有必需的信息!<br/>'
.'请返回并再次输入!';
exit;
}
if (!get_magic_quotes_gpc())
{
$add_company = addslashes($add_company);
$add_person = addslashes($add_person);
$add_address = addslashes($add_address);
} @ $db = new mysqli('localhost', 'user', 'password', 'database'); if (mysqli_connect_errno())
{
echo '错误!未能正确连接数据库.请稍后继续操作或联系数据库管理员.';
exit;
}
$query = "insert into insert_file(company_name,person_name,address_name) values
('".$add_company."','".$add_person."','".$add_address."')";
$result = $db->query($query);
if ($result)
echo $db->affected_rows.' 条新信息已经存入数据库.'; $query = "select * from insert_file ";
$result = $db->query($query);$num_results = $result->num_rows; echo '<p>目前总共存有信息数: '.$num_results.'</p>'; for ($i=0; $i <$num_results; $i++)
{
$row = $result->fetch_assoc();
echo '<p><strong>'.($i+1).'. 公司名称: ';
echo htmlspecialchars(stripslashes($row['company_name']));
echo '</strong><br />联系人: ';
echo stripslashes($row['person_name']);
echo '<br />联系地址: ';
echo stripslashes($row['address_name']);
echo'<br />';
echo '</p>';
}
$result->free();
?>
我的目的就是在每条信息后面都加一个删除按钮,然后可以删除就行了!应该怎么加呢?
echo "<td><a href=\"deleteRecord.php?id=".$delete."\">delete</a></td>";方式二(用按钮):
echo "<td><input type=\"button\" onclick=\"location.href='deleteRecord.php?id=".$delete."'\"></td>";deleteRecord.php:$sql = "delete from insert_file where id=".$_GET['id'];
我最后的解决方法是
for ($i=0; $i <$num_results; $i++)
{
$row = $result->fetch_assoc();
echo '<p><strong>'.($i+1).'. 公司名称: ';
echo htmlspecialchars(stripslashes($row['company_name']));
echo '</strong><br />联系人: ';
echo stripslashes($row['person_name']);
echo '<br />联系地址: ';
echo stripslashes($row['address_name']);
echo'<br />';
?>
<form action="deleteRecord.php" method="POST">
<?php
//$row['insert_id'];
?>
<input type="hidden" name="delete_id" value="<?=$row['insert_id']?>">
<td><input type="submit" value="删除" name="delete"></td>
</form>
deleteRecord.php:
<?php
@ $db = new mysqli('localhost', 'user', 'password', 'database');
$sql = "delete from insert_file where insert_id='" . $HTTP_POST_VARS['delete_id'] . "'";
$db->query($sql);
header("Location: http://localhost/th/show_file.php");
return session_write_close();
exit();
?>