SQL查询值从$ _GET更改

亚历克斯

如何从Php修改MySQL查询,因此,如果选择ALL,将不会出现Where语句,如果选择某些用户登录,将仅显示该用户记录?我需要,例如,如果我选择“<option value="All">ALL</option>查询将不带WHERE语句”,但是例如,如果我选择了“<option value="admin">Admin</option>将存在此查询”Where tsales_funnel.Darijuma_vaditajs = 'admin'

SQL语句:

$sql = "Select
  tsales_funnel.ID As ID,
  wp_users.display_name As Darijuma_vaditajs,
  tcportal_starpnieks.Cp_Name As Starpnieks,
  tcportal_stucture.Cp_Name As OWCA,
  n_products.Product_Nos As Produkts,
  tsales_funnel_mrecord.Deadline As Deadline,
  tsales_funnel_clients.Reg_nr As Klienta_Regnr,
  tfirmas_reg.name_in_quotes As Klients,
  tsales_funnel_mrecord.ID As Prod_ID,
  tsales_funnel.Statuss As Statuss
From
  tsales_funnel Left Join
  tsales_funnel_mrecord On tsales_funnel_mrecord.Funnel_ID = tsales_funnel.ID
  Left Join
  tcportal_starpnieks On tcportal_starpnieks.Cp_code = tsales_funnel.Starpnieks
  Left Join
  tcportal_stucture On tcportal_stucture.Cp_code = tsales_funnel.OWCA Left Join
  tsales_funnel_clients On tsales_funnel_clients.Funnel_ID = tsales_funnel.ID
  Left Join
  tfirmas_reg On tfirmas_reg.regcode = tsales_funnel_clients.Reg_nr Left Join
  n_products On tsales_funnel_mrecord.Product_type = n_products.Product_Code
  Left Join
  wp_users On tsales_funnel.Darijuma_vaditajs = wp_users.user_login ".$sqlselecteduser."
Order By
  Deadline";

表单中的GET方法:

<?php
if(isset($_GET['selecteduser'])){
    $selecteduser = esc_sql($_GET['selecteduser']);
} else {
    $selecteduser = $_SESSION['selecteduser'];
}
if($selecteduser == 'all') {
    $sqlselecteduser = '';
} else {
    $sqlselecteduser = " Where tsales_funnel.Darijuma_vaditajs = $selecteduser ";
}

?>

发送请求此表的表格:

<form action="" method="GET" id="selectdo">
<table border="1">
    <tr>
        <td>
            <label for="selector1">Darījuma vadītājs:</label>
        </td>
        <td>
            <select id="selector1" name="selecteduser">
            <option value="all">-ALL-</option>
            <?php 
                $sql = "SELECT display_name, user_login FROM wp_users";
                $results = $wpdb->get_results($sql);  // return an object, not ARRAY_N
            if ($results) {
                foreach ($results as $row) {
                    echo "<option value = '".$row->user_login."'>".$row->display_name."</option>"; 
            }}
                echo "</select></br>";                          
            ?>
        </td>
        <td><input type="submit" value="ok" /></td>
    </tr>
</table>
</form>

之后,数据显示到表格中。

Mynawaz

我更喜欢这样

$sql = "Select
    tsales_funnel.ID As ID,
    wp_users.display_name As Darijuma_vaditajs,
    tcportal_starpnieks.Cp_Name As Starpnieks,
    tcportal_stucture.Cp_Name As OWCA,
    n_products.Product_Nos As Produkts,
    tsales_funnel_mrecord.Deadline As Deadline,
    tsales_funnel_clients.Reg_nr As Klienta_Regnr,
    tfirmas_reg.name_in_quotes As Klients,
    tsales_funnel_mrecord.ID As Prod_ID,
    tsales_funnel.Statuss As Statuss
From
    tsales_funnel Left Join
    tsales_funnel_mrecord On tsales_funnel_mrecord.Funnel_ID = tsales_funnel.ID
    Left Join
    tcportal_starpnieks On tcportal_starpnieks.Cp_code = tsales_funnel.Starpnieks
    Left Join
    tcportal_stucture On tcportal_stucture.Cp_code = tsales_funnel.OWCA Left Join
    tsales_funnel_clients On tsales_funnel_clients.Funnel_ID = tsales_funnel.ID
    Left Join
    tfirmas_reg On tfirmas_reg.regcode = tsales_funnel_clients.Reg_nr Left Join
    n_products On tsales_funnel_mrecord.Product_type = n_products.Product_Code
    Left Join
    wp_users On tsales_funnel.Darijuma_vaditajs = wp_users.user_login 
WHERE
    IF('".$selecteduser."' = 'all', 1=1, tsales_funnel.Darijuma_vaditajs = '".$selecteduser."')
Order By
    Deadline";

本文收集自互联网,转载请注明来源。

如有侵权,请联系[email protected] 删除。

编辑于
0

我来说两句

0条评论
登录后参与评论

相关文章

来自分类Dev

sql查询更改值取决于id

来自分类Dev

SQL查询结果集将列值组更改为

来自分类Dev

SQL查询将列名更改为单列值

来自分类Dev

在SQL中运行选择查询时更改属性值

来自分类Dev

SQL查询更改列名

来自分类Dev

根据参数更改查询值

来自分类Dev

在SQL选择查询中将格式从数字值更改为文本值

来自分类Dev

Oracle PL SQL中的RO帐户,仅在查询中更改某些单元格的值

来自分类Dev

在SQL选择查询中将格式从数字值更改为文本值

来自分类Dev

SQL Server查询以按顺序计算一栏中更改值的数量

来自分类Dev

更改和优化SQL查询

来自分类Dev

SQL更改查询问题

来自分类Dev

更改 SQL 模式或编辑查询?

来自分类Dev

使用 SQL 查询更改顺序

来自分类Dev

更改多行SQL的值

来自分类Dev

更改request.GET QueryDict值

来自分类Dev

如何使用php中的htaccess更改已工作的GET查询以及所请求的GET数据的更改

来自分类Dev

将SQL Server查询更改为纯ANSI SQL查询

来自分类Dev

更改值的查询集中的字典键

来自分类Dev

需要帮助,以使用带数字范围的SQL查询值来更改PHP代码中的表格颜色

来自分类Dev

如何从GET生成SQL查询

来自分类Dev

在SQL视图上更改值

来自分类Dev

SQL查询:求和值

来自分类Dev

比较SQL查询的值

来自分类Dev

将SQL Server查询更改为sqlite

来自分类Dev

将数组更改为SQL查询

来自分类Dev

如何使用Ajax更改SQL查询?

来自分类Dev

SQL Developer正在更改查询的格式

来自分类Dev

如何动态更改SQL查询以添加周数?