PHP如何用于列表视图搜索数据选择框（表） [英] php how to used select box for search data in list view (table)

问题描述

我有一个查询，用于选择表（数据库）的数据显示在列表视图（表），不是我想要做的列表视图（表）通过选择框code搜索数据，而无需按钮提交。

I have a query to select data from table(database) to show in List-view (table), than I want make code search data in list-view(table) by select-box without button submit.

这是我的code。在选择框中

this is my code in select box

<select onchange="selectrun(this);"> 
    <option value="">Select</option>
    <option value="1">one</option>
    <option value="2">two</option>
    <option value="3">three</option>
</select>

这是我的纸条

And this is my scrip

function selectrun(sel){
           var id= sel.value;  
            $.ajax({
                    type:"POST",
                    url:"./tab.php",
                    data:{id:id,task:'search'},
                     success: function(response){
                         //(I don't know what i should write for pass to php code)
                         //what I return in response is a query because I want it's execute at my main page,that why I want pass it to $querr_select in php code but I don know my solution is good or not because I never do with ajax   
                     }
        });

}

这是我的code主页

$query_select = "SELECT * FROM `table`";
$result=pg_query($query_select ) or die(pg_last_error());
while($row_info=pg_fetch_array($result)){ 
   //code for display view
}

*注：tab.php，我只是通过 ID 从主页，页面 tab.php 的编写一个查询在条件在选择;当我提醒响应我得到 SELECT * FROM表WHERE ID =1键，我想将它传递给 $ query_select ，是我的想法，但无法工作：（

*Note: in tab.php,I just pass id from main page to page tab.php for write a query to select in condition in where; when I alert response I get SELECT * FROM table WHERE ID ='1' And I want pass it to $query_select, is my idea but not work yet :(

推荐答案

我想你问的是如何展示一个Ajax查询的结果。这是否正确？

I think what you are asking is how to display the result of an Ajax query. Is that correct?

<select onchange="selectrun(this);"> 
    <option value="">Select</option>
    <option value="1">one</option>
    <option value="2">two</option>
    <option value="3">three</option>
</select>
<!-- A new HTML div for displaying Ajax call response: -->
<div id="response-area"></div>

<script>
function selectrun(sel){
           var id= sel.value;  
            $.ajax({
                    type:"POST",
                    url:"./tab.php",
                    data:{id:id,task:'search'},
                     success: function(response){
                        //Jquery sends response to browser div by setting html.
                        $('#response-area').html(response);
                     }
        });

}
</script>

tab.php： 您可能如何通过Ajax返回HTML的一个基本概念。这不是在混合HTML和PHP方面的巨大编程，但它可能是你想要做什么。

tab.php: A basic concept of how you might return HTML via Ajax. This isn't great programming in terms of mixing HTML and PHP, but it it probably does what you want.

假设你的数据库表中包含的字段称为字段1和场2，您可以使用字段名作为数组键通过数组迭代。需要注意的是pg_fetch_array有额外的参数来选择一个关联数组，而不是一个数字索引的。

Assuming that your database table contains fields called 'field1' and 'field2', you can iterate through the array using the field names as array keys. Note that pg_fetch_array has additional parameters to select an associative array rather than a numerically indexed one.

<?php
    $query_select = "SELECT * FROM `table`";
    $result=pg_query($query_select ) or die(pg_last_error());
    echo "<table>";
    while($row_info=pg_fetch_array($result, NULL, PGSQL_ASSOC)){ 
       echo "<tr>
                <td>
                      $row_info[field1]
                </td>
                <td>
                      $row_info[field2]
                </td>
              </tr>";
    }
    echo "</table>";
?>

修改后的code以上就可以显示从tab.php当您更改的选项返回的响应选择。

The modified code above should show you the response returned from tab.php when you change the option selected.

这篇关于PHP如何用于列表视图搜索数据选择框（表）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！