Question

我试图用检查箱删除多个记录。我把每个检查箱装上记录索引:

<?php $row_count = 1; do {  ?>
    <tr <?php if ($row_count%2) { ?>bgcolor="#F4F4F4"<?php } ?>>
      <td align="center" ><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<?php echo $row_contactlist[ contact_id ]; ?>"></td>
      <td align="center" ><p><?php echo $row_contactlist[ contact_id ];?></p></td>
    </tr>
    <?php $row_count++; } while ($row_contactlist = mysql_fetch_assoc($contactlist)); ?>

使用以下链条删除:

<a class="addcontact" href="delete.php?mContact=<?php for($i=0;$i<=$row_count;$i++) { $del_id = $checkbox[$i]; } echo $del_id ?>" style="border-bottom:0px" >Delete Contact(s)</a>

删除。 php

if (isset($_GET[ mContact ])) {
mysql_query("DELETE FROM contacts WHERE contact_id = ".$_GET[ mContact ]."");
mysql_query("DELETE FROM history WHERE history_contact = ".$_GET[ mContact ]."");
mysql_query("DELETE FROM notes WHERE note_contact = ".$_GET[ mContact ]."");
redirect( You have deleted some contacts ,"contacts.php");
}

间接工程,即与你接触的网页重载,已经删除了某些接触,它像我一样没有错误,但没有任何接触被删除。

UPDATE: Thanks guys very speedy response. Total newb to PHP so everything is massively appreciated.

因此,我用的是一笔总账,而不是一个超级链接:

<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>

Answer 1

我认为,你在选择应予删除的标准方面进行了组合。

用户与删除网页的联系与代码中的核对箱无关。

我认为,你们想要做的是:

Create the checkboxes (and if you want something to be deleted by default, set checked="checked"
Change the <a href..> to a submit button
In the delete.php the checkboxes will be in an array $_GET[ checkboxes ], which you can iterate through

NOW, onto the issues that @JohnP alluded to:

This is pretty insecure way to do this unless you have removed all your validation code before posting here.
I would recommend passing everything by $_POST for a little bit more security through obscurity
Check that the user has the privileges to delete the rows that they are attempting to delete.
Set a LIMIT 1 on each delete (or update) query so you don t accidentally delete all the rows in your database.

<>>>>>

如果您希望有一个单一的删除链接,则需要在<代码>do......while路段内添加这一链接。看来,在座右边外有链接,你通过一切结果,将其全部添加到<条码>。您的手稿没有限定人,就没有把这些信息区分开来。

Answer 2

不要将标题移至别处,而是评论你的后向功能,允许其在填写<条码>后留在网页上。参看其中报告的任何错误(如果display_errors = on in php.ini)。您的错误记录是否报告了错误?

而且,我肯定是说......的。页: 1 这极易受到卡片注射袭击。您必须核实,这是一种分类,或贵国记录的任何数据类型:<代码>contact_id。

此外,利用超级链接删除数据库中未经确认页面的记录是不明智的。这一页是否被索引人rawl弄? 索引员将击中删除链接和删除原因。更可取的方法是使用一种形式,并附有提交纽伦以供删除。

Answer 3

为什么你不将外国钥匙列入<代码>history_contact和注_contact 查询contact_id with CASCADE DELETE?

这样,如果你删除联系,我的孩子们就将照顾你们。

(如前几个员额所示,验证你对卡片注入的数据投入!)

友情链接