我正在尝试升级代码以删除选定的消息。下面是我现有的代码,我想更改它,
<input type="hidden" name="action" value="delete" />
<input type="submit" name="deletebtn" value="Delete" onclick="if(!confirm('Are you sure you want to delete selected messages?')) return false;" />
$template->assign('script', 'messages');
if(isset($_POST['action']))
{
$action = makesafe($_POST['action']);
$ids = $_POST['msgid'];
if(!empty($ids))
{
if($action == 'delete')
{
foreach($ids as $k => $v)
{
if(!empty($v))
{
if(mysql_num_rows(mysql_query("SELECT * FROM messages WHERE receiver = '"logged id"' AND msg_id = '$v' LIMIT 1")))
{
if(mysql_query("DELETE FROM messages WHERE msg_id = $v AND receiver = '"logged id"' LIMIT 1"))
{
$success_msg = "Message(s) Deleted.";
}
}
}
}
}
}
}
我试过使用这个代码,但它不起作用,
<button type="submit" class="btn" name="delete" onclick="if(!confirm('Are you sure you want to delete selected links?')) return false;" > <i class="icol-cross"></i> Delete </button>
我还想验证用户是否在没有选择任何消息的情况下单击了删除按钮(复选框)。
对于您的确认按钮,您应该使用如下代码:
<button type="submit" class="btn" name="delete" onclick="return confirm('Are you sure you want to delete selected links?')" > <i class="icol-cross"></i> Delete </button>
对于SQL语句,我不确定当在两个查询上都使用引号(也称为"登录")时,你会得到什么,我认为你应该在这里只使用一种,要么是"或''",因为你已经用双引号包装了这个查询。
祝你好运!