PDOCrud Parse sql operation

Parse sql operation allows you to use simple sql queries with crud operation. Simple database queries containing "WHERE", "ORDER BY", "LIMIT" etc can be parsed by our system and you can use it to generate the crud table similar to the other operations. It can't be used against UNION or JOIN operations.

                            //Added in version 7.1.1
                                $pdocrud = new PDOCrud();
                                $pdocrud->setQuery("select id,order_date,customer_name,order_amount from orders where id > 50  order by order_date");                     
                                echo $pdocrud->render("PARSESQL");

Orders

Add

Showing 1 to 10 of 30 entries

Go
# Id Order date Customer name Order amount Actions
1 67 2016-09-08 Rose Barry 64
2 68 2016-09-08 Bernard Gilmore 95
3 69 2016-09-08 Meghan Mack 89
4 70 2016-09-08 Lillith Terrell 43
5 71 2016-09-08 Jaquelyn James 57
6 72 2016-09-08 Karly Beard 56
7 73 2016-09-08 Kareem Cooke 7
8 74 2016-09-08 Amethyst Bass 70
9 75 2016-09-08 Silas Bates 27
10 76 2016-09-08 Sybil Watts 24
# Id Order date Customer name Order amount Actions