PHP Connection::db_connect Examples

Example #1

File: m_user.php Project: nruiz64/GestionCv

 public static function view($idUser)
 {
     $bdd = Connection::db_connect();
     $req = $bdd->query('SELECT * FROM user WHERE id_user ="******"');
     $reponse = $req->fetchAll();
     return $reponse ? $reponse : "erreur ou utilisateur non trouvé.";
 }

Example #2

File: Project.php Project: nruiz64/pluginWordpress

 public function Showproject($name = "S1")
 {
     $pull_quote_atts = shortcode_atts(array('name' => 'S1'), $name);
     $bdd = Connection::db_connect();
     echo 'test';
     $select = $bdd->prepare('SELECT * FROM startup where nom = ?');
     $req = $bdd->execute($select, $name);
     $ret = $req->fetchAll();
     var_dump($ret);
     return $ret;
 }

Example #3

File: m_cv.php Project: Azcatchi/gestion_cv

 public static function ajoutExp($intitule, $date_debut, $date_fin, $description, $idUser)
 {
     $bdd = Connection::db_connect();
     $req = $bdd->prepare("INSERT INTO CV_experience(intitule,date_debut,date_fin,description,id_user)\n\t\tVALUES (:intitule, :date_debut, :date_fin, :description, :idUser)");
     $req->bindParam(':intitule', $intitule);
     $req->bindParam(':date_debut', $date_debut);
     $req->bindParam(':date_fin', $date_fin);
     $req->bindParam(':description', $description);
     $req->bindParam(':idUser', $idUser);
     echo "test";
     $req->execute();
 }

Example #4

File: m_user.php Project: Harkeynn/Projet-MVC

 public static function delete($idUser)
 {
     $bdd = Connection::db_connect();
     $req = $bdd->prepare('DELETE FROM user WHERE id_user='******'');
     $req->execute();
 }

Example #5

File: ModelCrowd.php Project: nruiz64/pluginWordpress

 public function findIdUserByNicename($nicename)
 {
     $bdd = Connection::db_connect();
     $id_user = $bdd->query('SELECT * FROM wp_users where user_nicename = "' . $nicename . '"
          OR user_login ="******"');
     $id_user = $id_user->fetchAll();
     echo json_encode($id_user[0]);
 }