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