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