Hello.
I want to get sql query rows result info through ajax and json.
Here´s jquery code:
var mod_url = baseDir + '/json_2.php';
var query = $.ajax({
type: 'POST',
url: mod_url,
dataType: 'json',
success: function(comp_arr) {
alert(comp_arr);
},
error: function (response) {
alert(response.responseText);
},
});
And here´s php file code :
<?php
include(dirname(__FILE__).'/../config/config.inc.php');
include(dirname(__FILE__).'/../init.php');
$qr = 'SELECT * FROM '._DB_PREFIX_.'infos_it WHERE infoit=1';
if ($results = Db::getInstance()->ExecuteS($qr))
foreach ($results as $row) {
$comp_arr[$i]["id_item"] = $row["id_id_item"];
$comp_arr[$i]["infoit"] = $row["infoit"];
$comp_arr[$i]["icon"] = $row["icon"];
}
echo(json_encode($comp_arr));
//return(json_encode($comp_arr));
?>
Jquery Ajax Response is success but null...what I´m doing wrong?
Thanks.