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();
                            

Deprecated: Optional parameter $op declared before required parameter $task is implicitly treated as a required parameter in /home/javad/domains/javadfk.ir/public_html/pdocrud/script/classes/PDOCrud.php on line 924

Deprecated: Creation of dynamic property PDOCrud::$langData is deprecated in /home/javad/domains/javadfk.ir/public_html/pdocrud/script/classes/PDOCrud.php on line 2075

Deprecated: Optional parameter $page declared before required parameter $totalrecords is implicitly treated as a required parameter in /home/javad/domains/javadfk.ir/public_html/pdocrud/script/classes/PDOCrudHelper.php on line 191

Deprecated: Creation of dynamic property PDOModel::$characterSet is deprecated in /home/javad/domains/javadfk.ir/public_html/pdocrud/script/classes/PDOModel.php on line 117

Deprecated: strtoupper(): Passing null to parameter #1 ($string) of type string is deprecated in /home/javad/domains/javadfk.ir/public_html/pdocrud/script/classes/PDOModel.php on line 964

Deprecated: Creation of dynamic property PDOModel::$characterSet is deprecated in /home/javad/domains/javadfk.ir/public_html/pdocrud/script/classes/PDOModel.php on line 117

Deprecated: strtoupper(): Passing null to parameter #1 ($string) of type string is deprecated in /home/javad/domains/javadfk.ir/public_html/pdocrud/script/classes/PDOModel.php on line 964

Deprecated: strtoupper(): Passing null to parameter #1 ($string) of type string is deprecated in /home/javad/domains/javadfk.ir/public_html/pdocrud/script/classes/PDOModel.php on line 964

Deprecated: Creation of dynamic property PDOCrud::$dataHTML is deprecated in /home/javad/domains/javadfk.ir/public_html/pdocrud/script/classes/PDOCrud.php on line 2139

Deprecated: Creation of dynamic property PDOCrud::$fieldList is deprecated in /home/javad/domains/javadfk.ir/public_html/pdocrud/script/classes/PDOCrud.php on line 2140

Users

Showing 1 to 5 of 91 entries

# 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