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

Showing 1 to 10 of 2539 entries

# User id First name Last name User name Gender Actions
1 33 Vavc BKTwGDuKD asdfg ZFaEHFvuqpHsnedSn
2 34 FslCPnopJJB ZaHSdUbHhOCuMzh MTPDKZuAmcxfqz 1
3 35 neccvmGluZPHKxSsABk BZEdFPBVGVCdlW rQsfwHXmkBbCLqih SvRmKatbulMseIdPKw
4 38 bswfUqstX nuaSCMni rHyPOoiI 0
5 39 oJWvSPZLXePrT BsHAvtIFxyTWx HmiQpRMpQzmqxRSLJVA ErhvrCbG
6 40 lAjDKeNbygHTbgsWdd GDtRyTZnpwRuJtlKKk XNfWtzlqVJWKtXmpzy 0
7 41 KVjnCgja doiRuUhSsVLbjn YJjlPBQvGmNmiOxm LUGzjEHqsRKCwbpCal
8 42 ATRFNBLmhXzDKdl FYekVCOqWzGGpzdp UqpeceLoYXTuiW 0
9 43 kbfoRJqhLRCjHDZUMeY hQUFzEZgZp fHmwTrFAmwYRUEMH xMoknFMgySpsxen
10 44 IOhlNGDti GSOAAnYGsOYPJeRjZ YzWGHecbJBwrOW 0
# User id First name Last name User name Gender Actions