基于下拉列表的自动填充功能 [英] Dropdown value based Autocomplete
本文介绍了基于下拉列表的自动填充功能的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试根据下拉选择值执行自动完成功能。
我的index.php页面:
< div > 选择城市< / div >
< 选择 id = < span class =code-keyword> city >
< 选项 value = 选择 > 选择< / option >
< 选项 value = Chennai > Chennai < / option >
< 选项 value = Madurai > Madurai < / option >
< 选项 value = Salem > Salem < / option >
< 选项 value = Trichy > Trichy < / option >
< / select > < br / >
< 输入 类型 = text id = search / >
< 脚本 >
$(document).ready(function(){
$('#search')。autocomplete({
minLength:1,
source:function(query,process){
var res = $('#city')。val();
$ .ajax({
url:'autocomplete.php',
类型:'GET',
数据:src =+ res +& value = + $('#search')。val(),
dataType:'JSON',
async:true,
success:function(data){
process(data) ;
}
});
}
});
});
< / script >
我的autocomplete.php页面:
<? php
if (isset($ _ GET) ['src'])) {
$ city = $ _ GET [' src'];
echo $ city;
}
? >
<? php
$ loc = $ _ GET [' value'];
echo $ loc;
$ conn = mysql_connect(' localhost', root, < span class =code-summarycomment>'');
if (!$ conn)
{
< span class =code-summarycomment> die('could 不 connect: ' 。 mysql_error());
<跨班=code-summarycomment>
}
if(!mysql_select_db(details))
{
die('could 不 connect database: ' 。 mysql_error());
}
$ sql = SELECT localty FROM localty where localty like'% 。$ loc。%' 和 city =' $城市 ;
echo $ sql;
$ result = mysql_query($ sql);
if($ result)
{
while($ row = mysql_fetch_array($ result))
< span class =code-summarycomment> {
echo $ row ['localty']。\ n;
}
}
? >
根据城市选择下拉值,在搜索文本框中,当输入第一个字母时,应显示localty。但我没有在auto中获取值complete.php页面。
请提供任何建议。
解决方案
(文件).ready(function(){
('#search')。autocomplete({
minLength:1,
source:function(query,process){
var res =
( '#城市')VAL();
I am trying to do autocomplete function based on dropdown selection value.
My index.php page:
<div>Select City</div>
<select id="city">
<option value="select">Select</option>
<option value="Chennai">Chennai</option>
<option value="Madurai">Madurai</option>
<option value="Salem">Salem</option>
<option value="Trichy">Trichy</option>
</select><br />
<input type="text" id="search" />
<script>
$(document).ready(function(){
$('#search').autocomplete({
minLength: 1,
source: function(query, process) {
var res = $('#city').val();
$.ajax({
url: 'autocomplete.php',
type: 'GET',
data: "src="+res + "&value=" + $('#search').val(),
dataType: 'JSON',
async: true,
success: function(data) {
process(data);
}
});
}
});
});
</script>
My autocomplete.php page:
<?php
if (isset($_GET['src'])) {
$city = $_GET['src'];
echo $city;
}
?>
<?php
$loc = $_GET['value'];
echo $loc;
$conn=mysql_connect('localhost', 'root', '');
if (!$conn)
{
die('Could not connect: ' . mysql_error());
}
if(!mysql_select_db("details"))
{
die('Could not connect database: ' . mysql_error());
}
$sql="SELECT localty FROM localty where localty like '%".$loc."%' and city='$city'";
echo $sql;
$result = mysql_query($sql);
if($result)
{
while($row=mysql_fetch_array($result))
{
echo $row['localty']."\n";
}
}
?>
Based on the city selection dropdown value,in search textbox localty should be displayed on entering first letter.But I'm not getting values in autocomplete.php page.
Please give any suggestions.
解决方案
(document).ready(function(){
('#search').autocomplete({ minLength: 1, source: function(query, process) { var res =
('#city').val();
这篇关于基于下拉列表的自动填充功能的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文