<?php
require "logic/connect.php";
if (arevalid(array("interessi"), $_POST)) {
$query = "INSERT INTO interesse VALUES ";
foreach ($_POST["interessi"] as $catid) {
$query .= "('{$_SESSION['user']}',{$catid}),";
}
$result = pg_query($conn, substr($query, 0, -1));
}
/* RECURSIVE -> KILL APACHE
$query = "SELECT * FROM categoria EXCEPT SELECT id, titolo FROM categoria AS c JOIN sottocategoria AS s ON c.id = s.categoriafiglio";
$result = pg_query($conn, $query);
if($result && pg_fetch_array($result, 0)){
$compose = "<ul>";
while($cat = pg_fetch_array($result)){
$compose .= printSubcategories($cat, $conn);
}
$compose.= "</ul>";
}
//register_window();
echo $compose;
//}
function printSubcategories($cat, $db){
$query = "SELECT DISTINCT id, titolo FROM categoria AS c JOIN sottocategoria AS s ON c.id = s.categoriafiglio and categoriapadre = {$cat["id"]}";
$result = pg_query($db, $query);
if($result){
if(pg_fetch_array($result, 0)){
$compose = "<li data-cat-id='{$cat["id"]}'>{$cat["titolo"]}<ul>";
<?php
require "logic/connect.php";
if (arevalid(array("text", "topic"), $_POST)) {
$id = NULL;
if ($_POST["sond"] !== NULL) {
$query = "INSERT INTO domanda(testo, autore, link, descrizione,sondaggio) VALUES ('{$_POST["text"]}','{$_SESSION["user"]}','{$_POST["image"]}','{$_POST["desc"]}','true') RETURNING id";
$result = pg_query($conn, $query);
$id = pg_fetch_array($result, 0)[0];
$query = "INSERT INTO rispostasondaggio(domanda, testo) VALUES ";
foreach ($_POST["risps"] as $risps) {
if ($risps !== "") {
$query .= "({$id},'{$risps}'),";
}
}
$result = pg_query($conn, substr($query, 0, -1));
} else {
$query = "INSERT INTO domanda(testo, autore, link, descrizione) VALUES ('{$_POST["text"]}','{$_SESSION["user"]}','{$_POST["image"]}','{$_POST["desc"]}') RETURNING id";
$result = pg_query($conn, $query);
$id = pg_fetch_array($result, 0)[0];
}
$query = "INSERT INTO argomentodomanda VALUES ";
foreach ($_POST["topic"] as $catid) {
$query .= "({$id},{$catid}),";
}
$result = pg_query($conn, substr($query, 0, -1));
}
if (arevalid(array("close"), $_POST)) {
$query = "UPDATE domanda SET open=false WHERE id={$_POST["close"]}";
pg_query($conn, $query);
}
<?php
require "logic/connect.php";
if (arevalid(array("sond_ans"), $_POST)) {
if (isset($_POST["anon"])) {
$query = "INSERT INTO votosondaggio(risposta, utente, anon) VALUES ({$_POST["sond_ans"]},'{$_SESSION["user"]}','true')";
} else {
$query = "INSERT INTO votosondaggio(risposta,utente) VALUES ({$_POST["sond_ans"]},'{$_SESSION["user"]}')";
}
$result = pg_query($conn, $query);
}
<?php
include "logic/connect.php";
if (arevalid(array("date"), $_POST)) {
$query = "UPDATE utente SET datanascita = '{$_POST["date"]}' WHERE username='******'";
$result = pg_query($conn, $query);
}
if (arevalid(array("res"), $_POST)) {
$query = "UPDATE utente SET residenza = '{$_POST["res"]}' WHERE username='******'";
$result = pg_query($conn, $query);
}
if (isset($_GET["user"]) && $_GET["user"] !== $_SESSION["user"]) {
$query = "SELECT * FROM utente WHERE username='******'";
$myself = pg_fetch_array(pg_query($conn, $query), 0);
echo "<div class=\"uk-vertical-align uk-text-center uk-height-1-1\">\n <div class=\"uk-vertical-align-middle\" style=\"width: 600px;\">\n <div class='uk-panel uk-panel-space'>\n <h2>{$myself["username"]}</h2>\n <p>email: {$myself["email"]}</p>\n <p>punteggio: {$myself["punteggio"]}</p>";
if ($myself["vip"] === 't') {
echo "<p>E' un utente VIP!</p>";
}
if (isset($myself["residenza"])) {
echo "<p>Residente a {$myself["residenza"]}</p>";
} else {
echo "<p>Residente a Sconosciuto</p>";
}
if (isset($myself["datanascita"])) {
echo "<p>Nato il {$myself["datanascita"]}</p>";
} else {
echo "<p>Nato il Sconosciuto</p>";
}
echo "<a class='uk-button uk-button-primary uk-button-large' href='index.php?user={$_SESSION["user"]}'>Mio profilo</a></div></div></div>";
} else {
$query = "SELECT * FROM utente WHERE username='******'";
<?php
require "logic/connect.php";
if (arevalid(array("qid"), $_GET) && arevalid(array("risp"), $_POST)) {
$query = "INSERT INTO rispostadiretta(testo, autore, domanda) VALUES ('{$_POST["risp"]}','{$_SESSION["user"]}',{$_GET["qid"]})";
$result = pg_query($conn, $query);
}
if (arevalid(array("qid"), $_GET) && arevalid(array("vote"), $_POST)) {
$query = "INSERT INTO votorisposta(utente, risposta,punteggio) VALUES ('{$_SESSION["user"]}',{$_GET["qid"]},'{$_POST["vote"]}')";
$result = pg_query($conn, $query);
}