关于列表框选择更改的AJAX - PHP事件


AJAX - PHP event on listbox selection change

如何让查询在任何列表框选择更改上运行

if(isset($_POST['select'])){  
 $newselection=$_POST['select']; 
 $query  = "SELECT count(*) FROM listings where description=" . $newselection. "";
 $result = mysql_query($query);
 while($row = mysql_fetch_array($result, MYSQL_ASSOC))
 {
     echo "Number of rows: {$row['count(*)']}";
 }
}

目前只在按下提交按钮时有效

i'm try to avoid js.

*我也有其他查询运行ajax

if(isset($_POST['button1'])){ 
$selection=$_POST['select']; 
$queryres  = "SELECT * FROM listings where description=" . $selection. "";
$resultres = mysql_query($queryres);
while($rowres = mysql_fetch_array($resultres, MYSQL_ASSOC))
 {
    echo "<div style='position: absolute; left: 294px; top: 16px;' title='Site map' class='myclass'> <img src={$rowres['picture1']} alt=''/></div>" ;
    echo "<div style='position: absolute; left: 294px; top: 116px;' class='myclass'>Number:{$rowres['number']} <br>Description : {$rowres['description']} <br><br></div>" ;
 }
 }

试试这个(它与PHP代码无关,它是html)

<option onchange="this.submit();">

JS是用户点击提交按钮的唯一选择。像<select onchange="submit();">这样的名字可能就足够了。