Set Search col data type Change data type of search column

You can set search col data type to date/datetime/time etc to make search more friendly. Default type is text. For example When you set search column data type to date-range, it will show date range options.

  
                                $pdocrud = new PDOCrud(); 
                                //set the search column data type
                                $pdocrud->setSearchColumnDataType("order_date", "date-range");// other options are time-range, datetime-range
                                echo $pdocrud->dbTable("orders")->render();
                                

Orders

Showing 1 to 10 of 73 entries

# ID Order no Order date Customer name Order amount Order status Actions
1 43 96349 2016-09-08 Deacon Tyson 21 Completed
2 44 22241 2016-09-08 Cooper Jensen 22 Completed
3 45 40334 2016-09-08 Cooper Jensen 87 Completed
4 46 30771 2016-09-08 Cooper Jensen 461 Completed
5 47 96349 2016-09-08 Deacon Tyson 71 Completed
6 48 72881 2016-09-08 18 Completed
7 50 77099 2016-09-08 20 Completed
8 51 37429 2016-09-08 77 Completed
9 52 44144 2016-09-08 26 Completed
10 53 62391 2016-09-08 96 Completed
# ID Order no Order date Customer name Order amount Order status Actions