mysql - Autocomplete JQuery Ui PHP PDO -


i try make autocomplete jquery ui , pdo connection on php can't result , not see anything.

here codes

html :

        <?php          require_once "../elements/header.php";          require_once "pemilihadd.php";         ?>         <!-- page content -->         <div class="right_col" role="main">             <div class="row">                 <div class="col-md-12 col-xs-12">                     <div class="x_panel">                         <div class="x_title">                             <h2>siswa <small> tambah pemilih</small></h2>                             <div class="clearfix"></div>                         </div>                         <div class="x_content">                             <br />                             <form class="form-horizontal form-label-left input_mask">                                 <div class="form-group">                                     <div class="col-md-1" style="margin-right:5%"></div>                                     <label class="control-label col-md-2 col-sm-2 col-xs-12" for="date-picker_1">nis</label>                                     <div class="col-md-6 col-sm-6 col-xs-12 form-group has-feedback">                                         <input type="text" name="studentid" class="form-control has-feedback-left" id="studentid" placeholder="type here ...">                                         <span class="fa fa-user form-control-feedback left" aria-hidden="true"></span>                                     </div>                                 </div>                                 <div class="ln_solid"></div>                                 <div class="form-group">                                     <div class="col-md-3" style="margin-right:4%"></div>                                     <div class="col-md-4 col-sm-4 col-xs-12 col-md-offset-4">                                         <button type="submit" class="btn btn-info">cancel</button>                                         <button type="submit" class="btn btn-info">submit</button>                                     </div>                                 </div>                             </form>                         </div>                     </div>                 </div>             </div>         </div>         <script>          $(function() {             $( "#studentid" ).autocomplete({               source: "pemilihadd.php"           });         });      </script>      <!-- /page content -->      <?php require_once "../elements/footer.php"; ?> 

java script :

$(function() {   $( "#studentid" ).autocomplete({     source: "pemilihadd.php"   }); }); 

and php code :

error_reporting(e_all*(e_notice | e_warning));    require_once '../../config/database.php';  if (isset($_get['term'])){     $return_arr = array();     try {         $ac_term = "%".$_get['term']."%";         $stmt = $db->prepare('select studentid students studentid :term');         $stmt->bindvalue(":term", $ac_term);         $stmt->execute();          while($row = $stmt->fetch(pdo::fetch_assoc)) {           $row_array[] = $row['studentid'];            array_push($return_arr, $row_array);         }     } catch(pdoexception $e) {         echo 'error: ' . $e->getmessage();     }      echo json_encode($return_arr); } 

connection database :

error_reporting(e_all*(e_notice | e_warning)); $dsn= 'mysql:host=localhost; dbname=simvosmp; charset=utf8'; $db_user = 'root'; $db_pass = ''; $db = new pdo($dsn, $db_user, $db_pass, $opt); $db->setattribute(pdo::attr_errmode, pdo::errmode_exception); $db->setattribute(pdo::attr_emulate_prepares, false); 

anyone can help?


Comments