function __construct($ter) { parent::__construct(); require_once 'connexio.php'; $bd = new connexio(); $bd->query("INSERT INTO territori (territori) VALUES ('" . utf8_decode($ter) . "')"); $bd->close(); }
function __construct($cat) { parent::__construct(); require_once 'connexio.php'; $bd = new connexio(); $bd->query("INSERT INTO categoria (categoria) VALUES ('" . utf8_decode($cat) . "')"); $bd->close(); }
public function llistar() { require_once 'connexio.php'; include_once '../lang.php'; global $lang; $bd = new connexio(); $usuaris = $bd->query("SELECT id,nom,cognoms,correu FROM usuaris ORDER BY id"); while ($usuari = $usuaris->fetch_array(MYSQLI_ASSOC)) { echo '<tr><td>' . $usuari['id'] . '</td><td>' . utf8_encode($usuari['nom']) . ' ' . utf8_encode($usuari['cognoms']) . '</td><td>' . $usuari['correu'] . '</td><td><button type="button" class="btn btn-warning btn-xs" onclick="window.location.href=\'edituser.php?id=' . $usuari['id'] . '\'"><span class="glyphicon glyphicon-pencil"></span> ' . $lang['EDIT'] . '</button></td><td><button type="button" class="btn btn-danger btn-xs" onclick="if (confirm(\'' . $lang['CONFIRM_DELETE_USER'] . '\')){window.location.href=\'deleteuser.php?id=' . $usuari['id'] . '\'}"><span class="glyphicon glyphicon-trash"></span> ' . $lang['DELETE'] . '</button></td></tr>'; } $bd->close(); }
public function view_all() { $db = new connexio(); $sql = "SELECT * FROM Partida_Enemigo;"; $query = $db->query($sql); $rtn = array(); while ($obj = $query->fetch_assoc()) { $Partida_Enemigo = new Partida_Enemigo($obj["id_enemigo"], $obj["id_partida"]); //var_dump($Partida_Enemigo); array_push($rtn, $Partida_Enemigo); } $db->close(); return $rtn; }
public function view_all() { $db = new connexio(); $sql = "SELECT * FROM Usuari_Partida;"; $query = $db->query($sql); $rtn = array(); while ($obj = $query->fetch_assoc()) { $Usuari_Partida = new Usuari_Partida($obj["id_usuari"], $obj["id_partida"], $obj["master"]); //var_dump($Usuari_Partida); array_push($rtn, $Usuari_Partida); } $db->close(); return $rtn; }
public function view_all() { $db = new connexio(); $sql = "SELECT * FROM Partida_Item;"; $query = $db->query($sql); $rtn = array(); while ($obj = $query->fetch_assoc()) { $Partida_Item = new Partida_Item($obj["id_partida"], $obj["id_item"]); //var_dump($Usuari_Partida); array_push($rtn, $Partida_Item); } $db->close(); return $rtn; }
public function llistar() { require_once 'connexio.php'; $bd = new connexio(); $sql = "SELECT * FROM newsletter"; $n = $bd->query($sql); $i = 1; while ($news = $n->fetch_array(MYSQLI_ASSOC)) { echo '<tr>'; echo "<td>" . $i . "</td>"; echo "<td>" . utf8_encode($news['nom']) . "</td>"; echo "<td>" . utf8_encode($news['cognoms']) . "</td>"; echo "<td>" . $news['correu'] . "</td>"; echo "</tr>"; $i++; } }
public function get_all($id) { $db = new connexio(); $sql = "SELECT * FROM Enemigo WHERE id_enemigo = '{$id}'"; $query = $db->query($sql); $count = 0; $datos = ""; if ($query->num_rows > 0) { while ($row = $query->fetch_assoc()) { $count++; $datos = $row; } } else { $count = 0; } $db->close(); if ($count == 1) { return $datos; } else { return null; } }
<?php $id = $_REQUEST['id']; $url = $_REQUEST['url']; require_once '../classes/connexio.php'; $bd = new connexio(); $bd->query("UPDATE videos SET url={$url} WHERE id={$id}"); $bd->close();
<?php $id = $_REQUEST['id']; require_once '../classes/connexio.php'; $bd = new connexio(); $bd->query("DELETE from usuaris WHERE id={$id}"); $bd->close(); header('Location: index2.php');
<?php session_start(); $nom = utf8_decode(filter_input(INPUT_POST, 'nom')); $cognom = utf8_decode(filter_input(INPUT_POST, 'cognom')); $edat = filter_input(INPUT_POST, 'edat'); $pais = utf8_decode(filter_input(INPUT_POST, 'pais')); $correu = filter_input(INPUT_POST, 'correu'); $tipus = filter_input(INPUT_POST, 'tipus'); $contrasenya = filter_input(INPUT_POST, 'contrasenya'); require_once 'class/connexio.php'; $encriptada = crypt($contrasenya); $sql = "INSERT INTO usuaris(nom,cognom,edat,pais,correu,tipus,contrasenya) VALUES ('{$nom}','{$cognom}',{$edat},'{$pais}','{$correu}','{$tipus}','{$encriptada}')"; $sqlcheck = "SELECT id FROM usuaris WHERE correu='{$correu}'"; $db = new connexio(); $a = $db->query($sqlcheck); if ($a->num_rows === 0) { if ($db->query($sql)) { $iduser = $db->insert_id; setcookie('personatge[id]', $iduser); setcookie('personatge[nom]', $nom); setcookie('personatge[cognom]', $cognom); setcookie('personatge[tipus]', $tipus); switch ($tipus) { case 'lite': $sqlfoto = "INSERT INTO fotos (usuari,foto,llegenda) VALUES ('{$iduser}','fotos/{$tipus}/M40A9006.jpg','Foto: Salvador Maluquer.'),('{$iduser}','M40A9028.jpg','Foto: Salvador Maluquer.'),('{$iduser}','Tortosa_026.jpg','Foto: Archivo General Militar de Ávila.')"; $db->query($sqlfoto); $sqlvideo = "INSERT INTO videos (usuari,video,llegenda) VALUES " . "('{$iduser}','videos/{$tipus}/GuillermoBores_RegressioPerduaPerSempre','Guillermo Borés, propietari de la part privada de l’illa de Buda, explica quina és la principal característica de l’indret: la seva fragilitat.')," . "('{$iduser}','videos/{$tipus}/JMEspinas_ArrivadaDelta','Josep M. Espinàs explica quina va ser la seva sensació en trepitjar per primer cop el Delta després de setmanes seguint el curs de l’Ebre.')," . "('{$iduser}','videos/{$tipus}/JMEspinas_GranExperienciaBuda','Josep M. Espinàs recorda la seva experiència en penetrar a l’illa de Buda.')," . "('{$iduser}','videos/{$tipus}/JMEspinas_SensacioForaster','Josep M. Espinàs recorda les seves sensacions a la platja de l’illa de Buda.')"; $db->query($sqlvideo); $sqltextos = "INSERT INTO textos (usuari,imatge,url) VALUES ('{$iduser}','textos/{$tipus}/Arbo.jpg','textos/{$tipus}/Arbo.html')," . "('{$iduser}','textos/{$tipus}/Blade.jpg','textos/{$tipus}/Blade.html')," . "('{$iduser}','textos/{$tipus}/Espinas.jpg','textos/{$tipus}/Espinas.html')"; $db->query($sqltextos);
<?php $videoid = $_REQUEST['i']; $d = $_REQUEST['d']; require_once 'classes/connexio.php'; require_once 'classes/videos.php'; require_once './lang.php'; $v = new video(); $v->seleccionar($videoid); $bd = new connexio(); $dades = $bd->query("SELECT nom FROM empresa LIMIT 1"); $empresa = $dades->fetch_array(MYSQLI_ASSOC); $bd->close(); ?> <script> function tancar(){ $(".desc").hide("slow",function(){ $(".desc").remove(); }); $(".descexistent").hide("slow",function(){ $(".descexistent").remove(); }); history.pushState('', document.title, window.location.pathname); document.title = "<?php echo $empresa['nom']; ?>
$per = $_COOKIE['personatge']; switch ($per['tipus']) { case 'lite': $c = 'groc'; break; case 'cine': $c = 'blau'; break; case 'foto': $c = 'roig'; break; case 'orni': $c = 'verd'; break; } $f = $db->query('SELECT * FROM fotos WHERE usuari=' . $per['id']); $v = $db->query('SELECT * FROM videos WHERE usuari=' . $per['id']); $t = $db->query('SELECT * FROM textos WHERE usuari=' . $per['id']); $apac = $db->query('SELECT * FROM ap_actual WHERE usuari=' . $per['id']); $apfi = $db->query('SELECT * FROM ap_final WHERE usuari=' . $per['id']); ?> <div class="col-lg-offset-1 col-md-offset-1 col-lg-10 col-md-10 col-sm-12 dossierapartat"> <div class="blau"> <img src="img/tancar.png" alt="icona tancar" onclick="tancarvideo()"/> </div> <h1>Llibreta de viatge</h1> <div id="objectes" class="col-md-12"> <div id="botomapa" class="botodossier <?php echo $c; ?> "></div>
<?php ob_start(); session_start(); require_once '../classes/connexio.php'; require_once '../classes/videos.php'; if (isset($_SESSION['id'])) { $id = $_REQUEST['id']; $bd = new connexio(); $dades = $bd->query("SELECT nom FROM empresa LIMIT 1"); $empresa = $dades->fetch_array(MYSQLI_ASSOC); $v = new video(); $v->seleccionar($id); require_once '../lang.php'; ?> <!DOCTYPE html> <html> <head> <title><?php echo $empresa['nom']; ?> </title> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="css/bootstrap.min.css"> <link rel="stylesheet" href="css/style.css"> <script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script> <script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js"></script> <script src="js/scripts.js" type="text/javascript"></script> <script>
<?php session_start(); // Recollida de dades $msg = filter_input(INPUT_POST, 'missatge'); $fot = filter_input(INPUT_POST, 'fotografia'); $per = $_COOKIE['personatge']['id']; $dat = date("Y-m-d H:i:s"); $lik = 0; $val = 1; require_once 'class/connexio.php'; $db = new connexio(); $msg = $db->real_escape_string($msg); $sql = "INSERT INTO mur(comentari,foto,data,usuari,validat) VALUES ('" . utf8_decode($msg) . "','{$fot}','{$dat}',{$per},{$val})"; if ($db->query($sql)) { $user = $_COOKIE['personatge']; switch ($user['tipus']) { case 'lite': $c = 'groc'; break; case 'cine': $c = 'blau'; break; case 'foto': $c = 'roig'; break; case 'orni': $c = 'verd'; break; } ?>
<?php $id = $_REQUEST['id']; $cat = $_REQUEST['cat']; require_once '../classes/connexio.php'; $bd = new connexio(); $bd->query("UPDATE videos SET categoria='" . utf8_decode($cat) . "' WHERE id={$id}"); $bd->close();
<?php $id = $_REQUEST['id']; $r = $_REQUEST['r']; require_once '../classes/connexio.php'; $bd = new connexio(); $bd->query("UPDATE videos SET referit2='" . utf8_decode($r) . "' WHERE id={$id}"); $bd->close();
<?php $thumb = $_FILES['imatge']['name']; $thumbtemp = $_FILES['imatge']['tmp_name']; $arxiu = $_SERVER['DOCUMENT_ROOT'] . '/media/' . $thumb; $id = $_REQUEST['id']; if (move_uploaded_file($thumbtemp, $arxiu)) { require_once '../classes/connexio.php'; $bd = new connexio(); $bd->query("UPDATE videos SET imatge='{$thumb}' WHERE id={$id}"); $bd->close(); echo 'OK'; header("Location: //{$_SERVER['HTTP_HOST']}/login/editvideo.php?id={$id}"); } else { echo 'Error'; }
case 'lite': $c = 'groc'; break; case 'cine': $c = 'blau'; break; case 'foto': $c = 'roig'; break; case 'orni': $c = 'verd'; break; } require_once 'class/connexio.php'; $db = new connexio(); $f = $db->query('SELECT * FROM fotos WHERE usuari=' . $per['id']); $v = $db->query('SELECT * FROM videos WHERE usuari=' . $per['id']); $t = $db->query('SELECT * FROM textos WHERE usuari=' . $per['id']); ?> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <title>Buda, l'illa del Delta</title> <meta name="description" content="Documental interactiu sobre Buda, la illa del Delta"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link href="css/estil.css" rel="stylesheet" type="text/css"/> <link href="css/registre.css" rel="stylesheet" type="text/css"/> <link href="css/font-awesome.min.css" rel="stylesheet" type="text/css"/>
<?php $id = $_REQUEST['id']; $desc = $_REQUEST['desc']; require_once '../classes/connexio.php'; $bd = new connexio(); $bd->query("UPDATE videos SET descripcio='" . utf8_decode(addslashes($desc)) . "' WHERE id={$id}"); $bd->close();
<?php $id = $_REQUEST['id']; $l = $_REQUEST['l']; require_once '../classes/connexio.php'; $bd = new connexio(); $bd->query("UPDATE videos SET latitud='{$l}' WHERE id={$id}"); $bd->close();
</ul> </div><!-- /.navbar-collapse --> </div><!-- /.container-fluid --> </nav> <!--Fi capçalera--> <!--Menú lateral--> <div id="m"></div> <!--Fi menú lateral--> <div class="col-lg-offset-1 col-md-offset-1 col-lg-10 col-md-10 col-sm-12 col-xs-12"> <?php $db = new connexio(); $i = 0; while ($msg = $msgs->fetch_array(MYSQLI_ASSOC)) { $query = "SELECT nom,cognom FROM usuaris WHERE id=" . $msg['usuari']; $us = $db->query($query); $u = $us->fetch_array(MYSQLI_ASSOC); $dia = new DateTime($msg['data']); ?> <div class="col-lg-3 col-md-3 col-sm-12 col-xs-12"> <div class="fotomur text-center"> <img src="<?php echo $msg['foto']; ?> " alt="Imatge del mur" class="fotom"> <img src="img/polaroid.png" alt="Superposició" class="polaroid"/> <div class="peufoto"> <cite><strong><?php echo utf8_decode($u['nom']); ?>
public function test3($var) { $db = new connexio(); $sql = "SELECT * FROM Usuari WHERE telefon= '{$var}';"; $query = $db->query($sql); if ($query->num_rows > 0) { while ($row = $query->fetch_assoc()) { $res = true; } } else { $res = false; } $db->close(); return $res; }
<?php $id = $_REQUEST['id']; $title = $_REQUEST['title']; require_once '../classes/connexio.php'; $bd = new connexio(); $bd->query("UPDATE videos SET titol='" . utf8_decode(addslashes($title)) . "' WHERE id={$id}"); $bd->close();
<?php $id = $_REQUEST['id']; $ln = $_REQUEST['ln']; $p = $_REQUEST['p']; require_once '../classes/connexio.php'; $bd = new connexio(); switch ($p) { case "0": $bd->query("UPDATE videos SET lletranegra='{$ln}',pastillablanca='0',pastillanegra='0' WHERE id={$id}"); break; case "1": $bd->query("UPDATE videos SET lletranegra='{$ln}',pastillablanca='1',pastillanegra='0' WHERE id={$id}"); break; case "2": $bd->query("UPDATE videos SET lletranegra='{$ln}',pastillablanca='0',pastillanegra='1' WHERE id={$id}"); break; } $bd->query("UPDATE videos SET referit1='" . utf8_decode($r) . "' WHERE id={$id}"); $bd->close();
<?php $id = $_REQUEST['id']; $a = $_REQUEST['a']; require_once '../classes/connexio.php'; $bd = new connexio(); $bd->query("UPDATE videos SET autorvideo='" . utf8_decode($a) . "' WHERE id={$id}"); $bd->close();
<?php $id = $_REQUEST['id']; require_once '../classes/connexio.php'; $bd = new connexio(); $bd->query("DELETE from videos WHERE id={$id}"); $bd->close(); header('Location: index2.php');
<li><a href="#categories" data-toggle="tab"><?php echo $lang['MANAGE_CATEGORY']; ?> </a></li> <li><a href="#territoris" data-toggle="tab"><?php echo $lang['MANAGE_TERRITORY']; ?> </a></li> <li><a href="#newsletter" data-toggle="tab">Newsletter</a></li> </ul> <div id="contingut" class="tab-content"> <div id="home" class="tab-pane col-md-12"> <?php include_once '../classes/connexio.php'; $bd = new connexio(); $dades = $bd->query("SELECT * FROM empresa WHERE id=1"); $empresa = $dades->fetch_array(MYSQLI_ASSOC); ?> <img class="img-responsive imgprincipal center-block" src="../media/<?php echo $empresa['logo']; ?> " alt="Logo empresa"/> </div> <div class="tab-pane col-md-6 col-md-offset-3" id="insertar"> <form id="fnouvideo" class="form" method="post" enctype="multipart/form-data" accept-charset="UTF-8" action="insertavideo.php"> <input type="text" class="form-control" name="url" placeholder="<?php echo $lang['URL']; ?> "> <input type="text" class="form-control" name="titol" placeholder="<?php echo $lang['TITLE'];
public function seleccionar($id) { require_once 'connexio.php'; $bd = new connexio(); $sql = "SELECT * FROM videos WHERE id = {$id} LIMIT 1"; $consulta = $bd->query($sql); $video = $consulta->fetch_array(MYSQLI_ASSOC); $this->setId($video['id']); $this->setUrl($video['url']); $this->setTitol($video['titol']); $this->setCategoria($video['categoria']); $this->setTerritori($video['territori']); $this->setDescripcio($video['descripcio']); $this->setAutor($video['autor']); $this->setAutorVideo($video['autorvideo']); $this->setData($video['data']); $this->setImatge($video['imatge']); if ($video['lletranegra'] != 0) { $this->setLletraNegra(1); } else { $this->setLletraNegra(0); } if ($video['pastillablanca'] != 0) { $this->setPastillaBlanca(1); } else { $this->setPastillaBlanca(0); } if ($video['pastillanegra'] != 0) { $this->setPastillaNegra(1); } else { $this->setPastillaNegra(0); } $this->setTags($video['tags']); $this->setReferit1($video['referit1']); $this->setLatitud($video['latitud']); $this->setLongitud($video['longitud']); $bd->close(); }
<?php session_start(); $url = $_GET['url']; $correu = filter_input(INPUT_POST, 'correu'); $contrasenya = filter_input(INPUT_POST, 'contrasenya'); require_once 'class/connexio.php'; $sql = "SELECT * FROM usuaris WHERE correu='{$correu}'"; $db = new connexio(); $data = $db->query($sql); $db->close; $usuari = $data->fetch_array(MYSQLI_ASSOC); if ($a->num_rows === 0) { echo 'Usuari no existeix, torna a entrar i registra\'t'; } else { if (crypt($usuari['contrasenya'] == $contrasenya, $usuari['contrasenya'])) { setcookie('personatge[id]', $usuari['id']); setcookie('personatge[nom]', $usuari['nom']); setcookie('personatge[cognom]', $usuari['cognom']); setcookie('personatge[tipus]', $usuari['tipus']); setcookie('personatge[sexe]', $usuari['sexe']); if (isset($url)) { header('Location: ' . $url); } else { header('Location: inici.php'); } } else { echo 'Contrasenya incorrecta'; } }