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
Post a Comment