javascript - Issue on Quering Database Using jQuery Ajax and PHP -
can please take @ this demo , allow me know why getting empty array? have jquery ajac request as:
$( "#appinfo" ).on( "submit", function( e ) { var etraget = $(".opacity").html().replace(/\d/g,''); var senario = current; if(qtype =="econo"){ var col = senario +"_"+etraget; var data='column='+col; $.ajax({ type:"post", url:"assets/econo.php", data:data, datatype : 'json', success:function(html) { coords = html; console.log(data); st = map.set(); (var = 0; < coords.length; i++) { var circle = map.circle(coords[i][0], coords[i][1], 6); st.push(circle); } e.preventdefault(); });
and econo.php as:
<?php include 'conconfig.php'; $con = new mysqli(db_host,db_user,db_pass,db_name); $collm = $_post['column']; $query = "select x, y econo where".$collm."=1"; $results = $con->query($query); $return = array(); if($results) { while($row = $results->fetch_assoc()) { $return[] = array((float)$row['x'],(float)$row['y']); } } $con->close(); echo json_encode($return); ?>
as can see console.log(data); , console display result column=ce_3000
$collm = $_post['column'];
empty because whrn tried dump got empty []. can please allow me know why happening?
javascript php jquery ajax
No comments:
Post a Comment