Subselect SQL Use sql to generate dynamic columns (Added in version 4.4)

You can use the subselect query to generate columns dynamically. You can get data from other tables using the query. It accepts two parameters, first one is column name/alias and second is query. 

  
                                $pdocrud = new PDOCrud();
                                $pdocrud->crudTableCol(array("first_name","last_name"));
                                 /**
                                 * Allows you to add the dynamic column based on sub query
                                 * @param   string   $columnName                      Alias column name to be used for the query
                                 * @param   string   $query                           Sub Query to be used
                                 * return   object                                    Object of class
                                 */
                                $pdocrud->subQueryColumn("order_id", "select sum(id) from orders where customer_name = {user_name}");
                                echo $pdocrud->dbTable("users")->render();

Users

Add

Showing 1 to 10 of 14 entries

Go
# First name Last name Order id Actions
1 aaa bbbb
2 fgfdg fdgd
3 b b
4 dfgdfg dfgdfg
5 ricks ricks
6 johsn asdasd
7 fdfsdfsd sdfsdfsafsa
8 ISSAH OKPOTI
9 sdf asdf
10 cyril slucki
# First name Last name Order id Actions