?>
" class="btn btn-info"><i class="glyphicon glyphicon-file"></i> Nouveau</a>
</div>
</div>
<div class="table-responsive">
<table class="table text-center">
<thead>
<tr>
<td>Nom du dessin</td>
<td>Voir</td>
<td>Supprimer</td>
</tr>
</thead>
<tbody>
<?php
$donne = App::getDataBase()->prepare('SELECT * FROM drawings WHERE id_user = :id', ['id' => App::getAuth()->idAuth()]);
if ($donne == false) {
?>
<tr>
<td colspan="3">Pas de dessin.</td>
</tr>
<?php
} else {
foreach ($donne as $draw) {
?>
<tr>
<td><?php
echo $draw->nom;
?>
</td>
<td><a href="<?php
public function getAll()
{
return App::getDataBase()->prepare('SELECT * FROM users WHERE usr_id != :id ORDER BY usr_login', ['id' => Session::getInstance()->read('auth')], __CLASS__);
}
<?php
use core\App;
App::getAuth()->redirect();
if (!isset($_GET['dessin']) && !is_numeric($_GET['dessin'])) {
header('Location: ' . $dir . '/pictionnary/home');
exit;
}
$dessin = App::getDataBase()->prepare('SELECT * FROM drawings WHERE id = :id AND id_user = :user_id', ['id' => $_GET['dessin'], 'user_id' => App::getAuth()->idAuth()], true);
if ($dessin == false) {
header('Location: ' . $dir . '/pictionnary/home');
exit;
}
?>
<div class="row">
<div class="col-xs-12 content">
<h1>Mon dessin : <?php
echo $dessin->nom;
?>
</h1>
<div class="col-xs-12 text-center">
<canvas width="350" height="350" id="myCanvas" style="border: 1px solid grey;"></canvas>
</div>
<div class="col-xs-12 text-center">
<a href="<?php
echo $dir . '/pictionnary/home';
?>
" class="btn btn-primary">Retour</a>
</div>
</div>
$validator->isTel('number', 'Format du numéro de téléphone invalide', false);
$validator->isSexe('sexe', 'Format du sexe invalide', false);
$validator->isUrl('website', 'Format du site web invalide', false);
$validator->isDate('birthday', 'Format de la date invalide');
$validator->isAlphaCaractere('ville', 'Format de la ville invalide', false);
$validator->isColor('color', 'Format de la couleur invalide', false);
$validator->isPicture('picture', 'Format de la photo invalide', false);
$validator->isTaille('taille', 'Format de la taille invalide', false);
if ($validator->isValid()) {
$db = App::getDataBase();
$result = $db->prepare('SELECT * FROM users WHERE email = :email', ['email' => $_POST['email']]);
if (count($result) == 1) {
$errors = ['Email existant'];
} else {
$db->insert("INSERT INTO users (email, password, nom, prenom, tel, website, sexe, birthdate, ville, taille, couleur, profilepic)\n VALUES (:email, :password, :nom, :prenom, :tel, :website, :sexe, :birthday, :ville, :taille, :couleur, :profilepic)", ['email' => $_POST['email'], 'password' => hash('sha256', $_POST['passwd']), 'nom' => $_POST['firstname'], 'prenom' => $_POST['lastname'], 'tel' => $_POST['number'], 'website' => $_POST['website'], 'sexe' => empty($_POST['sexe']) ? null : $_POST['sexe'], 'birthday' => $_POST['birthday'], 'ville' => $_POST['ville'], 'taille' => $_POST['taille'], 'couleur' => str_replace('#', '', $_POST['color']), 'profilepic' => $_POST['picture']]);
App::getAuth()->login(App::getDataBase(), $_POST['email'], $_POST['passwd']);
}
} else {
$errors = $validator->getErrors();
}
}
?>
<div class="col-md-4 col-xs-12" style="opacity: 0.95">
<?php
if (empty($errors)) {
?>
<div class="alert alert-info">Les champs obligatoires sont indiqués par *</div>
<?php
} else {
?>
<div class="alert alert-danger">
<?php
use core\App;
use core\Validator;
App::getAuth()->redirect();
$donne = App::getDataBase()->prepare('SELECT couleur FROM users WHERE id = :id', ['id' => App::getAuth()->idAuth()], true);
if (!empty($_POST)) {
$validator = new Validator($_POST);
$validator->isAlphaNumeric('picturename', 'Format du nom incorrect');
if ($validator->isValid()) {
$req = App::getDataBase()->insert('INSERT INTO drawings (id_user, commands, dessin, nom)
VALUES (:id_user, :commands, :dessin, :nom)', ['id_user' => App::getAuth()->idAuth(), 'commands' => $_POST['commands'], 'dessin' => $_POST['picture'], 'nom' => $_POST['picturename']]);
header("Location: {$dir}/pictionnary/home");
exit;
}
}
?>
<div class="row">
<div class="col-xs-12 content">
<h1>Mon dessin</h1>
<form class="form-horizontal" method="post">
<div class="form-group">
<label for="size" class="col-sm-2 control-label">Taille</label>
<div class="col-sm-10">
<select id="size" name="size" class="form-control">
<option value="8" selected>8</option>
<option value="20">20</option>
<option value="44">44</option>
<option value="90">90</option>
</select>
</div>
