function sendPost($id_user, $post)
{
$PDOManager = new PDOManager();
$pdo = $PDOManager->newPdo();
$query = $pdo->prepare("INSERT INTO post(id_user, post, date_post) VALUES(:id_user, :post, NOW())");
$query->execute(array('id_user' => $id_user, 'post' => $post));
}
public function registration($pseudo, $password, $confirmation)
{
$PDOManager = new PDOManager();
$pdo = $PDOManager->newPdo();
$query = $pdo->prepare('SELECT pseudo FROM user WHERE pseudo = :pseudo ');
$query->execute(array('pseudo' => $pseudo));
$result = $query->fetchAll();
if (count($result) > 0) {
foreach ($result as $row) {
if ($pseudo == $row["pseudo"]) {
$this->message = "Le pseudo est deja utilisé";
}
}
} elseif (!preg_match("/^[a-zA-Z0-9_]{4,}\$/", $password)) {
$this->message = "Votre mot de passe doit contenir au moins 4 caracteres";
} elseif ($password != $confirmation) {
$this->message = "Les mots de passes sont différents";
} else {
$query1 = $pdo->prepare('INSERT INTO user(pseudo, password) VALUES(:pseudo, :password)');
$query1->execute(array('pseudo' => $pseudo, 'password' => sha1($password)));
$this->message = "Inscriptio reussie ! Vous pouvez des à présent vous connecter";
}
}
function __construct()
{
parent::__construct();
}
