PHP BD::isInDb Beispiele

Beispiel #1

Datei: login.php Projekt: sebspas/Aurora

<?php

session_start();
ini_set('error_reporting', E_ALL);
ini_set('display_errors', 1);
require_once '../Config.class.php';
require_once '../../../app/Bd.class.php';
header('Cache-Control: no-cache, must-revalidate');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Content-type: application/json');
extract($_GET);
$BD = new BD('user');
if ($BD->isInDb('pseudo', $pseudo)) {
    $user = $BD->select('pseudo', $pseudo);
    if ($user->passwd == sha1($password)) {
        $BD->setUsedTable('connecté');
        if (!$BD->isInDb('iduser', $user->iduser)) {
            $BD->addCo($user->iduser);
            $_SESSION['pseudo'] = $pseudo;
            $_SESSION['iduser'] = $user->iduser;
            $energy = $user->energie / $user->maxenergie * 100;
            $_SESSION['energie'] = $energy;
            $_SESSION['money'] = $user->money;
            $_SESSION['avatar'] = $user->avatar;
            $_SESSION['rang'] = $user->rang;
            $error = "Ok";
        } else {
            $error = "Vous etes déja connecté !";
        }
    } else {
        $error = "Mot de passe incorecte !";

Beispiel #2

Datei: login.php Projekt: sebspas/AFK-WEB

<?php

if (isset($_SESSION['login'])) {
    header('Location : index.php');
    exit;
}
require_once Config::$path['model'] . 'login.php';
if (isset($_POST['login'])) {
    $BD = new BD('user');
    if ($BD->isInDb("pseudo", $_POST['pseudo']) && (($User = $BD->select("pseudo", $_POST['pseudo'])) && $User->pass == sha1($_POST['password'])) && $User->rang != 0) {
        $BD->update("online", 1, "pseudo", $_POST['pseudo']);
        $iduser = $BD->select("pseudo", $_POST['pseudo']);
        $_SESSION['rang'] = $iduser->rang;
        $_SESSION['iduser'] = $iduser->iduser;
        $_SESSION['avatar'] = $iduser->avatar;
        $_SESSION['pseudo'] = htmlentities($_POST['pseudo']);
        $_SESSION['login'] = '******';
        $_SESSION['msg'][0] = 'success';
        $_SESSION['msg'][1] = "Vous êtes connecté !";
        header('Location: index.php');
    } else {
        echo "<div class='error'>Echec de connexion !!! </div>";
    }
}
require_once Config::$path['views'] . 'login.php';

Beispiel #3

Datei: connexion-secure.php Projekt: sebspas/Aurora

<?php

session_start();
ini_set('error_reporting', E_ALL);
ini_set('display_errors', 1);
require_once '../Config.class.php';
require_once '../Bd.class.php';
header('Cache-Control: no-cache, must-revalidate');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Content-type: application/json');
$BD = new BD('connecté');
$userCo = $BD->isInDb('iduser', $_SESSION['iduser']);
echo json_encode($userCo);

Beispiel #4

Datei: inscription.php Projekt: sebspas/Share2Go

function isMailInDb($Mail)
{
    $BD = new BD("user");
    return $BD->isInDb("mail", $Mail);
}

Beispiel #5

Datei: admin.php Projekt: sebspas/AFK-WEB

function isForumInDb($nom)
{
    $BD = new BD('forum');
    return $BD->isInDb('nom', $nom);
}

Beispiel #6

Datei: isInDb.php Projekt: sebspas/Aurora

<?php

session_start();
ini_set('error_reporting', E_ALL);
ini_set('display_errors', 1);
require_once '../../app/Config.class.php';
require_once '../../app/Bd.class.php';
header('Cache-Control: no-cache, must-revalidate');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Content-type: application/json');
extract($_GET);
$BD = new BD('user');
$return = $BD->isInDb($nom, $valeur);
echo json_encode($return);