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"));
/**
* Add join between tables, supported join condition are "INNER JOIN" & "LEFT JOIN"
* @param string $joinTableName name of table to be joined
* @param string $joinCondition join condition e.g. ("table2.col = table1.col")
* @param string $joinType type of join (Inner or left join)-default is inner join
* return object Object of class
*/
$pdocrud->joinTable("user_meta", "user_meta.user_id = users.user_id", "LEFT JOIN");
echo $pdocrud->dbTable("users")->render();
Users