session_start(); require "inc/db.php"; require "class/cut.php"; if (isset($_GET['x'])) { $x = 0; } else { $x = 1; } $a = "SELECT post.id,post.titolo, post.testo, log.data, rubrica.utente FROM main.log, main.usr, main.rubrica, main.post WHERE log.utente = usr.id AND log.record = post.id AND usr.rubrica = rubrica.id AND post.pubblica = 1 AND post.cat = 1 AND log.tabella = 'post' AND log.operazione = 'I' order by log.data desc;"; $b = pg_query($connection, $a); while ($c = pg_fetch_array($b)) { $data = split(" ", $c['data']); $data = $data[0]; //$testo = strip_tags($p['testo']); $testo = cutHtmlText($c['testo'], 300, "...", false, false, false); $post .= "<tr>"; $post .= "<td>"; $post .= "<header class='giallo'>" . $c['titolo'] . "</header>"; $post .= "<article>"; $post .= $testo; $post .= "<div class='buttonFooter'><a href='postView.php?p=" . $c['id'] . "' title='Leggi tutto'><i class='fa fa-arrow-right hidden-aria='true'></i> Leggi tutto</a></div>"; $post .= "</article>"; $post .= "<footer>Pubblicato da <strong>" . $c['utente'] . "</strong> il <strong>" . $data . "</strong></footer>"; $post .= "</td>"; $post .= "</tr>"; } ?> <!DOCTYPE html> <html> <head>
$extres = pg_query($connection, $extq); $ext = pg_fetch_array($extres); if (!$ext['ext']) { $extent = "594297.89483444,3654301.447749,6244523.0248882,6589483.3334912"; } else { $coo = explode(",", str_replace(" ", ",", substr($ext['ext'], 4, -1))); $extent = str_replace(" ", ",", substr($ext['ext'], 4, -1)); } //post $postq = "SELECT p.titolo, p.testo, p.pubblica, p.id FROM main.post p, main.log WHERE p.id = log.record AND log.tabella = 'post' AND log.operazione = 'I' AND p.pubblica = 1 order by log.data desc limit 5;"; $postr = pg_query($connection, $postq); $r = pg_num_rows($postr); while ($post = pg_fetch_array($postr)) { $data = explode(" ", $post["data"]); $p = strip_tags($post['testo']); $p = cutHtmlText($p, 140, "...", false, false, false); $postList .= "<li>"; $postList .= "<span class='headline'>"; $postList .= "<a href='postView.php?p=" . $post['id'] . "' class='transition' title='Visualizza post completo'>" . $post['titolo'] . "</a>"; $postList .= "</span>"; $postList .= "<p class='date'>" . $data[0] . "</p>"; $postList .= "<div class='postList'>" . $p . "</div>"; $postList .= "</li>"; } // open data documents lista $odquery = "SELECT odd.titolo, odd.categoria, odf.tipo, odf.link, l.sigla as licenza FROM liste.licenze l, main.log, main.opendata odd, main.opendatafile odf WHERE odd.id = log.record AND odf.licenza = l.id AND odf.opendata = odd.id AND log.tabella = 'opendata' AND log.operazione = 'I' ORDER BY log.data DESC LIMIT 10;"; $odres = pg_query($connection, $odquery); while ($od = pg_fetch_array($odres)) { switch ($od['tipo']) { case 'pdf': $ico = '<i class="fa fa-file-pdf-o" aria-hidden="true"></i>';
<?php session_start(); require "inc/db.php"; require "class/cut.php"; $a = "select l.id, l.anno, c.categoria, l.nome, l.descrizione from main.lavoro l, liste.cat c where l.tipo = c.id order by l.anno desc, l.nome asc;"; $b = pg_query($connection, $a); while ($c = pg_fetch_array($b)) { $descrizione = nl2br($c['descrizione']); $post .= "<tr>"; $post .= "<td><a href='lavoro.php?l=" . $c['id'] . "'><i class='fa fa-arrow-right'></i></a></td>"; $post .= "<td>" . $c['anno'] . "</td>"; $post .= "<td>" . $c['categoria'] . "</td>"; $post .= "<td>" . $c['nome'] . "</td>"; $post .= "<td>" . cutHtmlText($descrizione, 500, '...', false, false, true) . "</td>"; $post .= "</tr>"; } ?> <!DOCTYPE html> <html> <head> <?php require "inc/meta.php"; ?> <link href="css/style.css" rel="stylesheet" media="screen" /> <link href="lib/FooTable/css/footable.core.min.css" rel="stylesheet" media="screen" /> <style> .footable th:nth-child(1){width:5%;} .footable th:nth-child(2){width:5%;} .footable th:nth-child(3){width:20%;} .footable th:nth-child(4){width:30%;}