Good day.
I need your help I am generating a graph in google charts with connection to php and postgresql through odbc. The code is as follows:
<?php
// Conectamos base de datos
$dsn = "IVRTST";
$usuario="IVR";
$clave="IVR";
$cid=odbc_connect($dsn, $usuario, $clave);
if (!$cid){
exit("<strong>Ya ocurrido un error tratando de conectarse con el origen de datos.</strong>");
}
$registro = "SELECT DISTINCT INPUT_FILENAME ARCHIVO_CENTRAL,
FILE_ID ARCHIVO_IME,
COLLECT_DATE FECHA_RECOLECTADA,
PROCESS_DATE FECHA_PROCESADA,
OPERATION OPERACION,
EVENT_DATE DIA_EVENTO,
EVENT_HOUR HORA_EVENTO,
SWITCH_CODE CODIGO_MATRIS,
TRAFFIC_TYPE TIPO_TRAFICO,
ERROR_CODE ERROR_CODIGO,
CDR_STATUS STATUS,
CDR_SOURCE SOURCE,
SUM(NUM_EVENTS) LLAMADAS,
SUM(MINUTOS_REDONDEADO) MINUTOS
FROM tgime_ime_voice_process
WHERE SWITCH_CODE IN ('307') AND COLLECT_DATE between 180401 and 180401
and
(( OPERATION = 'PRA_AXE10' AND CDR_STATUS='PRA') OR
(OPERATION IN ('VALID_MATRI','DRD_FSR')))
group by
INPUT_FILENAME,
FILE_ID,
COLLECT_DATE,
PROCESS_DATE,
OPERATION ,
EVENT_DATE,
EVENT_HOUR,
SWITCH_CODE,
TRAFFIC_TYPE,
ERROR_CODE,
CDR_STATUS,
CDR_SOURCE,
NUM_EVENTS";
$registro = odbc_exec($cid,$registro);
$numfilas = odbc_num_rows($registro);
$registro2[0] = array('hora_evento','llamadas');
for ($i=1; $i<($numfilas+1); $i++)
{
$registro2[$i] = array(odbc_result($registro, $i-1, "hora_evento"),
(int) odbc_result($registro, $i-1, "llamadas"));
}
?>
the code in html
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js" > </script>
<!-- Load the AJAX API -->
<script type="text/javascript" src="https://www.google.com/jsapi" > </script>
<script type="text/javascript"
src="https://www.google.com/jsapi?autoload={
'modules':[{
'name':'visualization',
'version':'1',
'packages':['corechart']
}]
}"></script>
<script type="text/javascript">
google.setOnLoadCallback(drawChart);
function drawChart() {
//cargamos nuestro array $datos creado en PHP para que se puede utilizar en JavaScript
var cargaDatos = <?php echo json_encode($registro2); ?>;
var datosFinales = google.visualization.arrayToDataTable(cargaDatos);
var options = {
title: 'Grafica de tendencias',
curveType: 'function',
legend: { position: 'bottom' }
};
var chart = new google.visualization.LineChart(document.getElementById('curve_chart'));
chart.draw(datosFinales, options);
}
</script>
</head>
<body>
<div id="curve_chart" style="width: 900px; height: 500px"></div>
</body>
</html>
When I upload the php file in the browser I see this error:
Data column (s) for axis # 0 can not be of type string ×
I appreciate your help beforehand.