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. ("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", "INNER JOIN");
                            echo $pdocrud->dbTable("users")->render();
                        

Users

Showing 1 to 1 of 1 entries

# User id First name Last name User name Password Email Phone Gender Birth date Hobbies Educational status Company name Address City State Country Zip code About yourself User meta id Meta key Meta value Actions
1 70 afewaef fewafe afe 1111 2@aa.com 233114 mail 2020-05-14 fdewFE efwa fewa fea WF WDF WFA FEAW EWFA 92 FEWAFEA EFWAF
# User id First name Last name User name Password Email Phone Gender Birth date Hobbies Educational status Company name Address City State Country Zip code About yourself User meta id Meta key Meta value Actions