PDOCrud Join operation

PDOCrud supports both left join and inner join operation. If you want to apply master, detail table operation where master table contains single record and details table contains multiple records, use LEFT JOIN else INNER JOIN.

  
                            $pdocrud = new PDOCrud();
                            $pdocrud->crudTableCol(array("first_name","last_name","user_name","gender"));
                            $pdocrud->joinTable("user_meta", "users.user_id = user_meta.user_id", "LEFT JOIN");
                            echo $pdocrud->dbTable("users")->render();
                            

Users

Showing 1 to 10 of 23 entries

# First name Last name User name Gender Actions
1 harshit kalyani
2 harshit kalyani
3 harshit kalyani
4 ==Nancyabarm Nancyabarm
5 ==Stevenkneen Stevenkneen
6 Stevenkneen
7 ==Thomasbriff Thomasbriff
8 ==Cloesmef Cloesmef
9 Cloesmef
10 vcCKGJIOw zALRYPAtCvaqHgk
# First name Last name User name Gender Actions