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 246 entries

# ID Order no Order date Customer name Order amount Order status Actions
1 62 34490 2016-09-08 Xenos Clarke 200 Pending
2 63 37920 2016-09-08 Xenos Clarke 67 Completed
3 64 28431 2016-09-08 Cooper Jensen 5 Completed
4 65 94701 2016-09-08 25 Completed
5 66 36440 2016-09-08 8 Completed
6 67 37251 2016-09-08 64 Completed
7 68 35643 2016-09-08 95 Completed
8 69 9551 2016-09-08 89 Completed
9 70 44898 2016-09-08 Lillith Terrell 43 Completed
10 71 91617 2016-09-08 Jaquelyn James 57 Completed
# ID Order no Order date Customer name Order amount Order status Actions