PHP BD类代码示例

function addRepMessage($com, $id)
{
    $Messagerie = new Messagerie();
    $BD = new BD('messagerie');
    $BD->update("luAuteur", 1, "idmessage", $id);
    $BD->update("luDestinataire", 1, "idmessage", $id);
    $BD->update("timestamp", time(), "idmessage", $id);
    $userMessage = $Messagerie->recupUser($_SESSION['iduser']);
    $message = $Messagerie->infoConvers($_GET['id']);
    $msg = '<div class="line3 frame white2">
			<img class="avatar-com" src="' . $userMessage->avatar . '" alt="default">
			<div class="inline-block vt-top">
				<p class="line2">
					<a class="txt-dec-none c-black1" href="index.php?page=profil&amp;nom=' . $userMessage->pseudo . '"><strong>' . $userMessage->pseudo . '</strong></a>
					, le <i>' . date('d/m/y H:i', time()) . '</i>
				</p>
				<div class="line2">
					<p>' . $com . '</p>
				</div>
			</div>
		</div><!-- .frame -->';
    $fp = fopen(Config::$path['messagerie'] . $message->link . $message->idauteur . $message->iddestinataire . '.msg', "r+");
    $contenu_message = '';
    while (($buffer = fgets($fp, 4096)) !== false) {
        $contenu_message .= $buffer;
    }
    fwrite($fp, $msg);
    fclose($fp);
}

 public function insertarComentario($idpincho, $login, $coment)
 {
     $db = new BD();
     $sentencia = "INSERT INTO comentarios(pincho_idpincho,usuarios_login,fecha,comentario) VALUES('" . $idpincho . "','" . $login . "',NOW(),'" . $coment . "')";
     $res = mysqli_query($db->connection, $sentencia);
     $db->desconectar();
     return $res;
 }

 public function insertar($login, $password, $email, $tipo)
 {
     $db = new BD();
     $sentencia = "INSERT INTO usuarios (login, password, email, tipo) VALUES('" . $login . "','" . $password . "','" . $email . "','" . $tipo . "')";
     $res = mysqli_query($db->connection, $sentencia);
     $db->desconectar();
     return $res;
 }

 public function insertar($login, $foto, $nombre, $reconocimientos)
 {
     $db = new BD();
     $sentencia = "INSERT INTO `juradoprofesional` (`usuarios_login`, `fotojuradoprofesional`, `nombrejuradoprofesional`, `reconocimientos`)\n            VALUES ('" . $login . "', '" . $foto . "', '" . $nombre . "', '" . $reconocimientos . "')";
     $res = mysqli_query($db->connection, $sentencia);
     $db->desconectar();
     return $res;
 }

function updateUser($pseudo, $nom, $prenom, $email)
{
    $BD = new BD('user');
    $BD->update('pseudo', $pseudo, 'iduser', $_SESSION['iduser']);
    $BD->update('nom', $nom, 'iduser', $_SESSION['iduser']);
    $BD->update('prenom', $prenom, 'iduser', $_SESSION['iduser']);
    $BD->update('mail', $email, 'iduser', $_SESSION['iduser']);
}

 public function destroy_session()
 {
     if (session_id() == '' || !isset($_SESSION)) {
         session_start();
     }
     $bd = new BD();
     $bd->record_log("log_login", 'logout');
     session_destroy();
     header('Location:' . $this->session_out);
     exit;
 }

function inscrit($Nom, $Prenom, $Age, $Sexe, $Pass, $Tel, $Mail, $Permis)
{
    $BD = new BD("user");
    $BD->addUser($Nom, $Prenom, $Age, $Sexe, $Pass, $Tel, $Mail, $Permis);
    $BD->update("banni", 1, "mail", $Mail);
    $token = uniqid(rand(), true);
    $token = sha1($token);
    $BD->update("tokens", $token, "mail", $Mail);
    $BD->update("avatar", "avatar/default.png", "mail", $Mail);
    $link = "http://62.210.110.24/S2go/dev/login.php?mail=" . $Mail . "&tok=" . $token;
    $mail = new mail($Mail, "Share2go : Validation de votre compte !", "Reservation", $link);
}

 function getFim()
 {
     //Retorna o numero da ultima rodada
     $datafim = 0;
     $db = new BD();
     $sql = sprintf("select\n\t\t\t\t\t   max(addtime(data,hora)) datafim\n\t\t\t\t\t   from\n\t\t\t\t\t   cad_rodada\n\t\t\t\t\t   where \n\t\t\t\t\t   campeonato= %d \n\t\t\t\t\t   and rodada = %d", $this->getCampeonato(), $this->getRodada());
     $db->Query($sql);
     $db->Next();
     $datafim = $db->getValue('datafim');
     $db->Close();
     return $datafim;
 }

function changepass($Mail, $Tokens, $Pass)
{
    $BD = new BD("user");
    $user = $BD->select("mail", $Mail);
    if ($user->tokens == $Tokens) {
        $Pass2 = sha1($Pass);
        $BD->update("mdp", $Pass2, "iduser", $user->iduser);
        $BD->update("tokens", NULL, "iduser", $user->iduser);
        return "ok";
    } else {
        return "Changement impossible ...";
    }
}

function getNbNewMess($iduser)
{
    $nbNewMess = 0;
    $BD = new BD("message");
    $conv = $BD->getConversations($iduser);
    foreach ($conv as $res) {
        $mess = $BD->getMessagesDesc($res->idtrajet);
        //echo $mess->date . " compare to " . $_SESSION['lastco'];
        if ($mess->date > $_SESSION['lastco']) {
            $nbNewMess = $nbNewMess + 1;
        }
    }
    return $nbNewMess;
}

function creaFormularioProductos()
{
    $productos = BD::obtieneProductos();
    $uri = "http://localhost/tienda/recursos_u5/TiendaOnlineOO/tienda";
    $url = "{$uri}/servicio_sin_wdsl.php";
    $cliente = new SoapClient(null, array('location' => $url, 'uri' => $uri, 'trace' => true));
    foreach ($productos as $p) {
        echo "<p><form id='" . $p->getcodigo() . "' action='productos.php' method='post'>";
        // Metemos ocultos los datos de los productos
        echo "<input type='hidden' name='cod' value='" . $p->getcodigo() . "'/>";
        echo "<input type='submit' name='enviar' value='Añadir'/>";
        echo $p->getnombrecorto() . ": ";
        echo $p->getPVP() . " euros.";
        echo "<input type='submit' name='detalle' value='Mostrar detalle'/>";
        echo "</p>";
        echo "</form>";
        if (isset($_POST['detalle'])) {
            if ($_POST['cod'] == $p->getcodigo()) {
                try {
                    //$unproducto=$cliente->obtieneProducto($p->getcodigo());
                    //echo $unproducto->getPVP();
                    $unprecio = $cliente->obtienePrecioProducto($p->getcodigo());
                    print "<p>Precio :" + $unprecio + "</p>";
                } catch (Exception $e) {
                    echo "Exception: " . $e->getMessage();
                }
                // echo $p->getPVP();
                echo "<p>" + $p->getcodigo() + "</p>";
                echo "<p>" + $p->getnombre() + "</p>";
                echo "<p>:" + $p->muestra() + "</p>";
            }
        }
    }
}

 public function persist()
 {
     $bd = BD::getConexion();
     $sql = "UPDATE login set estado = 1 WHERE id = :id";
     $stmt = $bd->prepare($sql);
     $stmt->execute([":id" => $this->id]);
 }

 public function persist()
 {
     $conexion = BD::getConexion();
     $update = "Update usuario SET id_liga = :id_liga where id_user = :id_user";
     $query = $conexion->prepare($update);
     $query->execute(array(":id_liga" => $this->id_liga, ":id_user" => $this->id_user));
 }

 public static function getInstance()
 {
     if (is_null(self::$instance)) {
         self::$instance = new BD();
     }
     return self::$instance;
 }

 function delete()
 {
     $conexion = BD::getConexion();
     $insert = "delete from libro where id_libro = :id_libro";
     $query = $conexion->prepare($insert);
     $query->execute([":id_libro" => $this->getId_libro()]);
 }