个人中心
gpt4 book ai didi

mysql - 查询删除所有条目而不是选定的条目

转载 作者：行者123 更新时间：2023-11-29 07:24:06 24 4
gpt4 key购买 nike

我制作了一个从 joomla 数据库填充的下拉菜单。该菜单包含特定用户的峰名称。这部分工作顺利。当用户从下拉菜单中选择峰值名称并单击删除按钮时，查询应该只删除具有特定用户 ID ($link_id) 和所选顶部名称 ($vrh_name2) 的行。

在我的例子中，查询会删除该用户的所有行，而不管所选顶部的名称如何

我哪里做错了？

<!DOCTYPE html>
<html>
<body>

<?php
echo '<div class="sender">';
$link_id = JRequest::getInt('link_id'); 
echo '<h4>Form for delete peak</h4>';

// Creating Dropdown menu from database
   
$db = JFactory::getDbo();
$query2 = $db->getQuery(true);
$query2->select('peak_name');
$query2->from($db->qn('#__climbing'));
$query2->where($db->quoteName('#__climbing.link_id')." = ".$db->quote($link_id));
$query2->order('peak_id ASC');
$db->setQuery($query2);
$peaks_list2 = $db->loadColumn();
$peaks_select2  = '<select name2="name2" id2="peaks">';
$peaks_select2 .= '<option value="">-- Select peak for delete --</option>';

foreach($peaks_list2 as $p2){
    $peaks_select2 .= '<option value="' . $p2 . '">' . $p2 . '</option>';  
}
$peaks_select2 .= '</select>';
?>

<form name="lista2" method="post" action="">
<?php echo $peaks_select2; ?>
<input type="submit" name="submit2" value="Delete" />
</form>
<?php

if(isset($_POST['submit2']))
{
$vrh_name2 = $_POST['name2'];

// Delete peak query

$db = JFactory::getDbo();
$q_4 = $db->getQuery(true);
$q_4->delete($db->quoteName('#__climbing'));
$q_4->where($db->quoteName('#__climbing.link_id')." = ".$db->quote($link_id))." AND ".($db->quoteName('#__climbing.peak_name')." = ".$db->quote($vrh_name2));
$db->setQuery($q_4);
$db->execute();
}
echo '</div>';
?>
</body> 
</html>

最佳答案

我们不要忘记 some of the past advice that I have offered .

在这个问题中最引人注目的是，$peaks_select2 = '<select name2=不管用。 name属性必须是纯粹的。

通过先执行潜在的删除操作，您可以允许您的用户在删除后进行删除，并始终在选择中看到最新的数据。

我不喜欢你使用 peak_name作为您的标识符。你的 table 有一个 peak_id ，这些在大多数情况下预计会自动递增且唯一，并且它们是专业人员关联相关数据的方式。 (您应该改变您的设计以采用这种做法。)

当一个选项的value属性值与选项的文本值相同，无需声明 name属性。因为我建议使用 ID，所以我声明 name属性。

未经测试的片段:

<!DOCTYPE html>
<html>
<body>

<?php
// get the $_POST['submit'] value; if missing, set as empty string (WORD is a Joomla-specific filter that strips unwanted characters for security reasons)
$action = JFactory::getApplication()->input->post->get('submit', '', 'WORD')

// get the $_POST['peak_id'] value; if missing set as 0 (INT strips any character that is not a digit)
$peak_id = JFactory::getApplication()->input->post->get('peak_id', 0, 'INT');

// try to get the $_POST['link_id'] value; if it is missing, try from $_GET['link_id']
$hiker_id = JFactory::getApplication()->input->post->get('link_id', 0, 'INT');
if (!$hiker_id)
{
    // there was no submission (this is the first load of the page)
    $hiker_id = JFactory::getApplication()->input->get->get('link_id', 0, 'INT');
}
echo "<div>Link Id: $hiker_id</div>";

$db = JFactory::getDbo();

if ($action === 'Delete' && $peak)  // if action is Delete and $peak is not empty or 0
{
    $delete_query = $db->getQuery(true)
        ->delete("#__climbing")
        ->where([
            "link_id = " . (int) $hiker_id,
            "peak_id = " . (int) $peak_id
        ]);
    $db->setQuery($delete_query);
    $db->execute();
    if ($db->getAffectedRows())  // check for successful deletion (if at least one row was deleted)
    {
        echo "<div>Successfully deleted row for hiker#: $hiker_id, peak#: $peak_id</div>";
    }
    else
    {
        echo "<div>Failed to delete row for hiker#: $hiker_id, peak#: $peak_id</div>";
    }
}

// now query the table for the fresh data after the (potential) delete was performed
$peaks_query = $db->getQuery(true)
    ->select("peak_id, peak_name")
    ->from("#__climbing")
    ->where("link_id = " . (int) $link_id)
    ->order("peak_id");
$db->setQuery($peaks_query);

$peaks_select = '<select name="peak_id">';
$peaks_select .= '<option value="0">-- Select peak to delete --</option>';
if (!$results = $db->loadAssocList())  // there were no rows in the result set
{
    // no peaks found for $link_id
}
else
{
    foreach ($results as $row)
    {
        $peaks_select .= "<option value=\"{$row['peak_id']}\">{$row['peak_name']}</option>";  // create option with name as text and id as the value
    }
}
$peaks_select .= '</select>';

// print the simple form...
?>
<div class="sender">
    <h4>Peak Delete Form</h4>
    <form method="post" action="">
        <?=$peaks_select?>
        <input type="hidden" name="link_id" value="<?=$hiker_id?>">
        <input type="submit" name="submit" value="Delete" />
    </form>
</div>
</body> 
</html>

关于mysql - 查询删除所有条目而不是选定的条目，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/54785998/

24 4 0
文章推荐： php - 如何将一行连接到数据库中的表？
文章推荐： java - 如何使用 Lambda 表达式过滤两个 map 并制作第三个 map java 8
文章推荐： mysql - 从连接表中选择名称，其中连接表行 id 在父表列集中
文章推荐： java - 如何在日期对象 JAVA 中将 'AM' 更改为 'PM'
行者123
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
全站热门文章
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com