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.

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

Users

Showing 1 to 10 of 154985 entries

# First name Last name User name Gender Actions
1 UAJEBYOQPMaosHIndj GsSHLUPnYLIkeEy lcfxzLnQUjijMcVoteC RotaKmGpnByjwRqIw
2 UAJEBYOQPMaosHIndj GsSHLUPnYLIkeEy lcfxzLnQUjijMcVoteC RotaKmGpnByjwRqIw
3 UAJEBYOQPMaosHIndj GsSHLUPnYLIkeEy lcfxzLnQUjijMcVoteC RotaKmGpnByjwRqIw
4 UAJEBYOQPMaosHIndj GsSHLUPnYLIkeEy lcfxzLnQUjijMcVoteC RotaKmGpnByjwRqIw
5 UAJEBYOQPMaosHIndj GsSHLUPnYLIkeEy lcfxzLnQUjijMcVoteC RotaKmGpnByjwRqIw
6 FPXngMdV vcutvVNCTLvhM ExWHGjNnOKtPr epeYMRwrAJQXjkdPv
7 FPXngMdV vcutvVNCTLvhM ExWHGjNnOKtPr epeYMRwrAJQXjkdPv
8 FPXngMdV vcutvVNCTLvhM ExWHGjNnOKtPr epeYMRwrAJQXjkdPv
9 FPXngMdV vcutvVNCTLvhM ExWHGjNnOKtPr epeYMRwrAJQXjkdPv
10 FPXngMdV vcutvVNCTLvhM ExWHGjNnOKtPr epeYMRwrAJQXjkdPv
# First name Last name User name Gender Actions