dourang8305 2012-06-13 05:54
浏览 51

jquery autocomplete插件与json无法完美配合

i write a code for autocomplete a textbox using jquery autocomplete plugin..... but it cann't working properly

here is html

    <input type="submit" value="Search" />
    <input class="searchBox" id="isearch" name="isearch" value="" type="text" />
    <input type="hidden" name="hsearch" id="hsearch" />

and javascript

  $(document).ready(function(){
  $("#isearch").autocomplete(
     "search.php", 

      {
            select: function(event, ui) {
        event.preventDefault();
        $("#isearch").val(ui.item.label);
        $("#hsearch").val(ui.item.value);
        return false;
    },
    focus: function(event, ui) {
        event.preventDefault();
        $("#isearch").val(ui.item.label);
        return false;
    }
});
    });

the PHP code is

    <?php
       include 'config.php';

       $q=$_GET['q']; 
       $my_data=mysql_real_escape_string($q);
       $sql="SELECT emp_id,name FROM f_name WHERE name LIKE '%$my_data%' ORDER BY name";
       $result = mysql_query($sql) or die(mysql_error());
       $results = array();

while($row=mysql_fetch_array($result))
{
    $results[] = array('value' => $row['emp_id'],'label' => $row['name']);
}
echo json_encode($results);

    ?>

and json value that return in textbox is

   [
     {"value":"2","label":"AAA ZZZ"},
     {"value":"3","label":"Roger Fedrer"},
     {"value":"1","label":"Php Admin"}
   ]

i want that textbox only show "label" and "value" should store in hidden-field

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 ads仿真结果在圆图上是怎么读数的
    • ¥20 Cotex M3的调试和程序执行方式是什么样的?
    • ¥20 java项目连接sqlserver时报ssl相关错误
    • ¥15 一道python难题3
    • ¥15 用matlab 设计一个不动点迭代法求解非线性方程组的代码
    • ¥15 牛顿斯科特系数表表示
    • ¥15 arduino 步进电机
    • ¥20 程序进入HardFault_Handler
    • ¥15 oracle集群安装出bug
    • ¥15 关于#python#的问题:自动化测试