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

# ID Order no Order date Customer name Order amount Order status Actions
1 66 36440 2016-09-08 Heather Terrell 8 Completed
2 67 37251 2016-09-08 Rose Barry 64 Completed
3 68 35643 2016-09-08 Bernard Gilmore 95 Completed
4 69 9551 2016-09-08 Meghan Mack 89 Completed
5 70 44898 2016-09-08 Lillith Terrell 43 Completed
6 71 91617 2016-09-08 Jaquelyn James 57 Completed
7 72 78062 2016-09-08 Karly Beard 56 Completed
8 73 87594 2016-09-08 Kareem Cooke 7 Completed
9 74 24386 2016-09-08 Amethyst Bass 70 Completed
10 75 49890 2016-09-08 Silas Bates 27 Completed
# ID Order no Order date Customer name Order amount Order status Actions