brandonkirsch on Json Data not show in table

Fri, 11 May 2012 21:30:25 +0300

I can't see the definition of Reuniao::listar, but there is a very high chance that your code contains SQL injection vulnerabilities, especially around the page, limit and sord parameters. You cannot simply mysql_escape some of these parameters and remain protected.

Second, you are building the JSON object by hand, and improperly escaping data (quotes within your values) that would lead to invalid JSON syntax. Instead of:

foreach ($linha as $l):

if( $count == count($linha) ) {

$saida .= '{ "id": "' . $l['cod_reuniao'] . '", "cell": ["teste", "teste", "teste", "teste", "teste", "teste", "teste", "teste"] }';

} else {

$saida .= '{ "id": "' . $l['cod_reuniao'] . '", "cell": ["teste", "teste", "teste", "teste", "teste", "teste", "teste", "teste"] },';

}

You should try using json_encode to do all of the PHP array to JSON object conversion:

$saida = array();

foreach ($linha as $l):

if( $count == count($linha) ) {

$saida[] = array('id' => $l['code_reuniao'], 'cell' => array('teste', 'teste', 'teste, 'teste', etc....));

} else {

$saida[] = array('id' => $l['cod_reunaio'], 'cell' => array('teste', 'teste', 'testes', etc...));

}

endforeach;

echo json_encode($saida);

destrutorx on Json Data not show in table

Thu, 03 May 2012 21:00:20 +0300

Hello people.

I'm using PHP to load a JSON to JQGRID but the table is coming empty. I have printed the PHP result and I can't find the error.

My data (created via PHP):

{ "page": "", "total": "0", "records": "3", "rows": [{ "id": "1", "cell": ["teste", "teste", "teste", "teste", "teste"] },{ "id": "3", "cell": ["teste", "teste", "teste", "teste", "teste", "teste", "teste", "teste"] },{ "id": "2", "cell": ["teste", "teste", "teste", "teste", "teste", "teste", "teste", "teste"] }]}

My PHP code:

$conexao = new Conexao;

$code = mysql_escape_string($_GET['code']);

$page = mysql_escape_string($_GET['page']);

$limit = mysql_escape_string($_GET['rows']);

$sidx = mysql_escape_string($_GET['sidx']);

$sord = mysql_escape_string($_GET['sord']);

if( !$sidx ) { $sidx = 1; }

$contador = Reuniao::total_listar($code, true, 'Ativo'); // select data count in mysql table

if( $contador > 0 ) {

$total_pages = ceil($contador/$limit);

} else $total_pages = 0;

if($page > $total_pages) { $page = $total_pages; }

$start = $limit * $page – $limit;

$linha = Reuniao::listar($code, false, NULL, $sidx, $sord, $start, $limit); // select data in mysql table

$saida = '{ "page": "' . $page . '", "total": "' . $total_pages . '", "records": "' . $contador . '", "rows": [';

$count = 1;

foreach ($linha as $l):

if( $count == count($linha) ) {

$saida .= '{ "id": "' . $l['cod_reuniao'] . '", "cell": ["teste", "teste", "teste", "teste", "teste", "teste", "teste", "teste"] }';

} else {

$saida .= '{ "id": "' . $l['cod_reuniao'] . '", "cell": ["teste", "teste", "teste", "teste", "teste", "teste", "teste", "teste"] },';

}

$count++;

endforeach;

$saida .= ']}';

echo $saida;

Can anyone help me to see what is wrong here?

jQuery Grid Plugin - jqGrid - Topic: Json Data not show in table

brandonkirsch on Json Data not show in table

destrutorx on Json Data not show in table