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

Showing 1 to 10 of 20 entries

# Id Order date Customer name Order amount Actions
1 189 0000-00-00 0
2 191 0000-00-00 Xenos Clarke 2
3 185 0000-00-00 Xenos Clarke 0
4 193 0000-00-00 32????? 34
5 190 0000-00-00 Xenos Clarke 1
6 176 0000-00-00 10
7 174 0000-00-00 Cooper Jensen 3
8 197 0000-00-00 Xenos Clarke 1000
9 182 2025-07-01 Deacon Tyson 82325
10 178 2025-09-02 Deacon Tyson 111
# Id Order date Customer name Order amount Actions