Passing database query rows with ajax json

[joseluistim]

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.

 

[vekia]

and what you see if you use var_dump() on $comp_arr variable?

[joseluistim]

It returns NULL.

[joseluistim]

More information and tests..

 

If I execute same query and var_dump directly to database, with $cfg_server= "localhost"; $cfg_database = "xxxx"; $cfg_username = "xxxxx"; $cfg_password = "xxxxx"; instead of  Db::getInstance()->ExecuteS($qr), it works correctly and return 19 records with all its fields.

[joseluistim]

Solved...it was a mistake between table name and DB_PREFIX..now var_dump returns records.