function get_servico($dbconn) { $query = "SELECT * FROM servico"; $query_response = pg_query($dbconn, $query); $counter = 0; $servico = []; while ($row = pg_fetch_array($query_response, $counter, PGSQL_BOTH)) { $servico[$counter]['id'] = $row['id']; $servico[$counter]['pagina'] = $row['pagina']; $servico[$counter]['titulo'] = $row['titulo']; $servico[$counter]['texto'] = $row['texto']; //get associated items $servico[$counter]['items'] = get_servico_items($dbconn, $servico[$counter]['id']); //get associated images $equipa[$counter]['img'] = get_img($dbconn, 'servico', $servico[$counter]['id']); //get associated videos $equipa[$counter]['video'] = get_video($dbconn, 'servico', $servico[$counter]['id']); $counter++; //proxima medicao da tabela SQL if ($counter == pg_num_rows($query_response)) { break; //para a execução do ciclo para que não haja erro quando $counter>numero de linhas na tabela } } echo json_encode($servico); return $servico; }
function get_servico($dbconn) { $query = "SELECT * FROM requilib_website.servico"; $query_response = mysql_query($query, $dbconn) or die(mysql_error()); $counter = 0; $servico = []; while ($row = mysql_fetch_array($query_response)) { $servico[$counter]['id'] = $row['id']; $servico[$counter]['pagina'] = $row['pagina']; $servico[$counter]['titulo'] = $row['titulo']; $servico[$counter]['texto'] = $row['texto']; //get associated items $servico[$counter]['items'] = get_servico_items($dbconn, $servico[$counter]['id']); $counter++; //proxima medicao da tabela SQL } echo json_encode(utf8ize($servico)); return $servico; }