php - how to display data with where clause while page has loaded -
i want make function displaying database data without refreshing page. i've tried verify php code filling value , works. but, when try call jquery data not displaying.
this code
$(document).ready(function() { var data = $(this).serialize(); $.ajax({ data: data, type: "post", url: "../php/bkk_1/bkk_show.php", success: function(data){ var list = json.parse(data); for(var = 0; < list.length; i++){ $('#tanggal2').text((list[i]['nama'])); } return false; } }); }); <?php include("../../connections/koneksi.php"); $tanggal2=$_post['tanggal2']; // data titik1 $sql = "select * bkk_1 tanggal2='$tanggal2' limit 38, 38"; $query = mysqli_query($db,$sql); $rows = array(); while($tmp= mysqli_fetch_assoc($query)) { $rows[] = $tmp; } echo json_encode($rows); mysqli_close($db); ?> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.6.3/jquery.min.js"></script> <input type="text" id="tanggal2" type="text" name="tanggal2" maxlength="1" size="23" readonly="readonly" />
try this:
$(document).ready(function() { $.ajax({ data: { tanggal2: $('#tanggal2').val() }, type: "post", url: "../php/bkk_1/bkk_show.php", success: function(data) { var list = json.parse(data); for(var = 0; < list.length; i++){ $('#tanggal2').text((list[i]['nama'])); } return false; } }); });
Comments
Post a Comment