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.


Example of inner join 1
Example of inner join 2 
  
                            $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

Add

Showing 1 to 5 of 91 entries

Go
# User id First name Last name User name Gender Actions
1 26 Jon Snow jon 1
2 30 yemqHDGbASghVu hcWntOcErdNAcklhyj QIuDjsqpMkLGUDESEm fVZnYMKEtIa
3 31 rQyHdOEtbBQDVdWsvl mIVEEVbYtdkIS ljCapMeRfuS qnlHXbfweSGNiBuFhk
4 32 OeRYlrBjh VYDSPjGaVTyYKJL teMndfHJqDefpgdn FlqQVzfkots
5 33 XPoKwJOeqAJIS RccmFGQWGBLY GFGHozmAbtWPG 0
# User id First name Last name User name Gender Actions