NO LOAD DATA
NO LOAD DATA
Lucianosilva
Posts: 1Questions: 1Answers: 0
Please help me with de question. I dont know . the debug of the chrome show erro:Uncaught TypeError: Cannot set property 'nTf' of undefined
`` `
<?php require_once('Connections/SGEM.php'); ?>
<?php
$query = mysql_query("SELECT Status, GREC, Material, Descricao,DATE_FORMAT(DataGrec,'%d/%m/%Y') AS DataGrec, QtddGrec, Locacao, Total, DURE, Indice FROM import WHERE DURE < 0 ORDER BY DataGrec ASC");
while($fetch = mysql_fetch_assoc($query))
{
$output[] = $fetch;
}
echo json_encode($output);
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<link rel="shortcut icon" type="image/ico" href="http://www.datatables.net/favicon.ico">
<meta name="viewport" content="initial-scale=1.0, maximum-scale=2.0">
<title>DataTables example - Language options</title>
<link href="libraries/DataTables-1.10.4/media/css/jquery.dataTables.css" rel="stylesheet" type="text/css">
<script type="text/javascript" language="javascript" src="libraries/DataTables-1.10.4/media/js/jquery.js"></script>
<script type="text/javascript" language="javascript" src="libraries/DataTables-1.10.4/media/js/jquery.dataTables.js"></script>
</head>
<body>
| Status | GREC | Material | Descrição | DataGrec | QtddGrec | Locacao | Total | DURE | Indice |
|---|---|---|---|---|---|---|---|---|---|
| Status | GREC | Material | Descrição | DataGrec | QtddGrec | Locacao | Total | DURE | Indice |
</body>
</html>
`` `
return No data available in table, o rerutn json is this:
[{"Status":"BF","GREC":"896165","Material":"A 3842900016","Descricao":"CJ PEDAL DA EMBREAGEM COMPL DI","DataGrec":"01\/08\/2014","QtddGrec":"15","Locacao":"BO 001","Total":"10","DURE":"-240.96","Indice":"0"},....}]