Im certanley new on this, but I´m Trying to solve this problem.
I have to repeat a lot this kind of query to an sql server. My problem is when i call the php from html, the getjason function or any other method return any data.
The php
<?php
function getArraySQL()
{
$dsn = "prueba";
$connect = odbc_connect( $dsn, '', '' );
$query = " SELECT hist_statusevents.reason, Sum(hist_statusevents.duration/3600) AS 'Duracion'
FROM hist_statusevents, hist_eqmtlist, hist_exproot
WHERE hist_exproot.shiftindex = hist_statusevents.shiftindex AND hist_statusevents.shiftindex = hist_eqmtlist.shiftindex AND hist_statusevents.eqmt = hist_eqmtlist.eqmtid AND (hist_eqmtlist.eqmtid='SVEDALA') AND hist_statusevents.category In ('2')
GROUP BY hist_statusevents.reason
ORDER BY Duracion DESC";
if(!$rs = odbc_exec($connect, $query)) die();
$rawdata = array();
$i=0;
while($row = odbc_fetch_array($rs))
{
$rawdata[$i] = $row;
$i++;
}
odbc_close( $connect );
return $rawdata;
}
@$myarray =getArraySQL($query);
echo json_encode($myarray);The HTML and getJson
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title></title>
<link rel="stylesheet" href="">
<script type='text/javascript' src='js/jquery.js'></script>
<title></title>
</head>
<body>
<script>
$(document).ready(function() {
$.getJSON('php.php', function(data) {
$.each(data, function(key, val) {
$('ul').append('<li Reason="' + reason + '">' + Duration + '</li>');
});
});
});
</script>
<ul></ul>
</body>
</html>
</head>
<body>
</body>
</html>
console?