PHP DataAccessLayer::selectById Exemples

Exemple #1

Fichier : post.php Projet : rexghadaffi/newPacion

 function display()
 {
     include_once "../../data-access/mysql-db.php";
     $obj = new DataAccessLayer();
     $this->assign("replies", $obj->selectColumnWhere("tblreply", "postID", $_GET["postid"]));
     $this->assign("postresult", $obj->selectById("tblpost", "postID", $_GET["postid"]));
 }

Exemple #2

Fichier : topic.php Projet : rexghadaffi/newPacion

 function display()
 {
     include_once "../data-access/mysql-db.php";
     $obj = new DataAccessLayer();
     $this->assign("topic", $obj->selectById("tbltopic", "topicID", $_GET["topicid"]));
     $this->assign("posts", $obj->selectColumnWhere("tblpost", "postStatus", 1));
 }

Exemple #3

Fichier : user_edit_record.php Projet : rexghadaffi/newPacion

 function edit()
 {
     include_once "../../data-access/mysql-db.php";
     $obj = new DataAccessLayer();
     $this->assign("clientinfo", $obj->selectById("tblclientuser", "userID", $_GET["id"]));
     $this->assign("type", $obj->select("tblusertype"));
 }

Exemple #4

Fichier : edit_category.php Projet : rexghadaffi/Pacion

 function edit()
 {
     include_once "../../data-access/mysql-db.php";
     $obj = new DataAccessLayer();
     $this->assign("forumcategory", $obj->selectById("tblforumcategory", "forumCatID", $_GET["id"]));
 }

Exemple #5

Fichier : jobs_edit_record.php Projet : rexghadaffi/newPacion

 function edit()
 {
     include_once "../../data-access/mysql-db.php";
     $obj = new DataAccessLayer();
     $this->assign("jobs", $obj->selectById("tbljob", "jobID", $_GET["id"]));
 }