PDOCrud Inner Join between tables

SQL INNER JOIN returns all rows from tables where the key record of one table is equal to the key records of another table. You can easily perform the INNER JOIN operation using pdcrud, all you need to do is specify the join table name and the join condition between two tables. Below examples shows inner join between user table and usermeta table that has matching column 'user_id'. It will select all records having matching user_id from both of these tables. During select/insert/update operation, data from both tables will be shown for inner join operation.

  
                            $pdocrud = new PDOCrud();
                            /**
                            * 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. 
                            * @param   string  $joinType                                  type of join (Inner or left join)-default is inner join
                            * return   object                                             Object of class
                            */
                            $pdocrud->colRename("meta_key", "Meta Key Info");
                            $pdocrud->joinTable("user_meta", "users.user_id = user_meta.user_id", "INNER JOIN");
                            $pdocrud->crudTableCol(array("first_name","last_name","meta_key"));
                            echo $pdocrud->dbTable("users")->render();
                        

Users

Showing 1 to 10 of 11 entries

# User id First name Last name Meta Key Info Actions
1 26 Jon Snow Total Experience1
2 26 Jon Snow Total Experience2
3 26 Jon Snow Total Experience3
4 26 Jon Snow Total Experience4
5 26 Jon Snow Total Experience5
6 26 Jon Snow Total Experience6
7 26 Jon Snow Total Experience7
8 26 Jon Snow Total Experience8
9 31 Dev Smith k1
10 31 Dev Smith k2
# User id First name Last name Meta Key Info Actions