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 afegir($nom, $cognom, $correu, $ip) { require_once 'connexio.php'; $bd = new connexio(); $sql = "INSERT INTO newsletter (nom,cognoms,correu,ip) VALUES ('{$nom}','{$cognom}','{$correu}','{$ip}')"; if ($bd->query($sql)) { return $bd->insert_id; } else { return 0; } $bd->close(); }
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 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 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; } }
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(); }
<input type="radio" name="pastilla" id="Radio3" value="2" disabled> <?php echo $lang['BLACK_PILL']; ?> </label> </div> </div> <div class="col-md-1"> <div class="btn btn-sm btn-success" onclick="activateOptions();"><span class="glyphicon glyphicon-pencil"></span></div> <div class="btn btn-sm btn-info disabled" id="boptions" onclick="updateOptions(<?php echo $id; ?> );"><span class="glyphicon glyphicon-check"></span></div> </div> </div> </form> <button type="button" class="btn btn-info center-block" onclick="javascript: window.location.assign('./index2.php?p=3')">Tornar</button><br/> </div> </div> <?php $bd->close(); ?> <script src="js/moment.js" type="text/javascript"></script> <script src="js/bootstrap-datetimepicker.min.js" type="text/javascript"></script> <script src="js/bootstrap-datetimepicker.ca.js" type="text/javascript"></script> </body> </html> <?php } else { echo '<h1 style="color:red;">' . $lang['NO_LOGIN'] . '</h1>'; }
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(); }
<!--Fi capçalera--> <!--Menú lateral--> <div id="m"></div> <!--Fi menú lateral--> <div class="col-lg-offset-3 col-md-offset-3 col-lg-6 col-md-6 col-sm-12 col-xs-12"> <div class="caixa <?php echo $c; ?> col-lg-12 col-md-12 col-sm-12 col-xs-12 pull-left"> <h2>Ho sentim molt <strong><?php echo $user['nom']; ?> </strong></h2> </div> <div class="caixa <?php echo $c; ?> col-lg-12 col-md-12 col-sm-12 col-xs-12 pull-left"> <p>Hem tingut un problema per registrar el teu missatge, si us plau, intenta-ho més tard</p> </div> </div> <script src="js/jquery-2.1.4.min.js" type="text/javascript"></script> <script src="js/bootstrap.min.js" type="text/javascript"></script> <script src="js/menu.js" type="text/javascript"></script> </body> </html> <?php } $db->close();
<?php ob_start(); session_start(); require_once '../classes/connexio.php'; $bde = new connexio(); $dades = $bde->query("SELECT nom FROM empresa LIMIT 1"); $empresa = $dades->fetch_array(MYSQLI_ASSOC); $bde->close(); require_once '../lang.php'; ?> <!DOCTYPE html> <html> <head> <title><?php echo $empresa['nom']; ?> - login</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="//maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css"> <link rel="stylesheet" href="css/login.css"> </head> <body> <div class="jumbotron"> <div class="container"> <h1><?php echo $empresa['nom']; ?> </h1>
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; }