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

Add

Showing 1 to 10 of 67 entries

Go
# ID Order no Order date Customer name Order amount Order status Actions
1 40 93062 2016-09-08 Cooper Jensen 32 qsdCompleted
2 41 76778 2016-09-08 Deacon Tyson 77 Pending
3 42 66729 2016-09-08 Xenos Clarke 90 Completed
4 43 62940 2016-09-08 Cooper Jensen 20 Completed
5 44 22241 2016-09-08 29 Completed
6 45 40334 2016-09-08 Cooper Jensen 87 Completed
7 46 30771 2016-09-08 Xenos Clarke 461 Completed
8 47 96349 2016-09-08 Xenos Clarke 71 Completed
9 48 72881 2016-09-08 Deacon Tyson 18 Completed
10 49 3691 2016-09-08 Cooper Jensen 75 Completed
# ID Order no Order date Customer name Order amount Order status Actions