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;
}
