function register($login, $pass, $mail, $prenom, $nom, $city, $birthday) { $connexion = \App\Model\Database::get()->prepare("\n\t\t\tINSERT INTO tp_users\n\t\t\t(email,login,password,first_name,last_name,city,birthday,register_date)\n\t\t\tVALUE ( '" . $mail . "', '" . $login . "', '" . $pass . "', '" . $prenom . "', '" . $nom . "','" . $city . "','" . $birthday . "', NOW() )"); $connexion->execute(); echo "true"; //Ajax }
function ReadMessage() { $connexion = \App\Model\Database::get()->prepare("SELECT * FROM `tp_messages` INNER JOIN tp_users on tp_users.id = expediteur_id WHERE expediteur_id = '" . $_SESSION["id"] . "'"); $connexion->execute(); $data = $connexion->fetchAll(); return $data; }
function User($login, $pass) { $connexion = \App\Model\Database::get()->prepare("\n\t\t\tSELECT * from tp_users\n\t\t\tWHERE (login = '******'\n\t\t\tOR email = '" . $login . "')\n\t\t\tAND password = '******'\n\t\t"); $connexion->execute(); $data = $connexion->fetchAll(); return $data; }
function Mefollower() { $connexion = \App\Model\Database::get()->prepare("\n\t\t\tSELECT *,count(follow_id) AS nbrFollow\n\t\t\tFROM `tp_follow` INNER JOIN tp_users\n\t\t\tON tp_follow.follower_id = tp_users.id\n\t\t\tWHERE follow_id = '" . $this->id . "'"); $connexion->execute(); $data = $connexion->fetchAll(); return $data; }
public function readTweet($id) { $connexion = \App\Model\Database::get()->prepare("SELECT * from tp_follow INNER JOIN tp_users on tp_users.id = tp_follow.follow_id INNER JOIN tp_tweets on tp_users.id = tp_tweets.user_id WHERE follower_id = '" . $id . "' OR follow_id = '" . $id . "' GROUP BY tp_tweets.id"); $connexion->execute(); $data = $connexion->fetchAll(); return $data; }
function allSearch($data) { $connexion = \App\Model\Database::get()->prepare("SELECT * FROM tp_tweets INNER JOIN tp_users ON tp_tweets.user_id = tp_users.id\n\t\t\tWHERE login LIKE '%" . $data . "%' OR content like '%" . $data . "%'"); $connexion->execute(); $data = $connexion->fetchAll(); $tab = ["type" => "*"]; $type = array_merge($tab, $data); return $type; }
/** * Crée un nouvel élément dans le tableau * @param array $fieldArray contient les infos à créer ['champ' => 'value'] */ public function create($fieldArray = array()) { $fields = ''; $values = ''; foreach ($fieldArray as $key => $value) { $fields .= "{$key}, "; $values .= "'{$value}', "; } $fields = substr($fields, 0, -2); $values = substr($values, 0, -2); $sql = "INSERT INTO {$this->table} ({$fields}) VALUES ({$values})"; $req = Database::get()->prepare($sql); $req->execute(); }
function SendMessage($content, $dest, $exp) { $connexion = \App\Model\Database::get()->prepare("INSERT INTO tp_messages\n\t\t\t(content,destinataire_id,expediteur_id,date)\n\t\t\tVALUE('" . $content . "','" . $dest . "','" . $exp . "',NOW()) "); $connexion->execute(); }
function addFollowSQL($follow) { $connexion = \App\Model\Database::get()->prepare("\n\t\t\tINSERT INTO tp_follow (follow_id,follower_id)\n\t\t\tVALUES ('" . $follow . "','" . $_SESSION["id"] . "') "); $connexion->execute(); }