function loadAjaxSeries() { $uni_id = $_POST["Uni_id"]; $sql = "SELECT \r\n ser_id,\r\n ser_par,\r\n ser_categoria\r\n\t\tFROM\r\n\t\ttab_series\r\n\t\tWHERE\r\n tab_series.ser_estado = '1' AND\r\n tab_series.uni_id = '{$uni_id}'\r\n ORDER BY tab_series.ser_orden,\r\n tab_series.ser_codigo "; $series = new tab_series(); $result = $series->dbSelectBySQL($sql); $res = array(); foreach ($result as $row) { if ($row->ser_par == '-1') { $res[$row->ser_id] = $row->ser_categoria; } else { $res[$row->ser_id] = "-- " . $row->ser_categoria; } } echo json_encode($res); }
function loadAjax() { $res = array(); $ser_id = $_POST["Ser_id"]; $series = new tab_series(); $sql = "SELECT\r\n ser_id,\r\n ser_codigo,\r\n ser_contador\r\n FROM\r\n tab_series\r\n WHERE (ser_estado = '1' AND ser_id='{$ser_id}')"; $result = $series->dbSelectBySQL($sql); foreach ($result as $row) { $res['ser_codigo'] = $row->ser_codigo; $res['ser_contador'] = sprintf("%02d", $row->ser_contador + 1); } echo json_encode($res); }