Embedding Look-up and Calculation Forms in PHPRunner Interfaces

I found recently that you can embed HTML or HTMX calculation and lookup forms directly into PHPRunner interfaces. These forms can add custom capabilities to the PHPRunner interfaces.

For example, here is a link to a demo Bicycle Shop database. The Order Form is an HTML form that looks up Customer and Product information and adjusts Customer Credit and Stock amounts on order submission.

https://customdataservices.net/bicycleshop/

The HTML is stored in a MySQL longtext column and is displayed a PHPRunner Custom View with $value = $data["YourColumnName"];. The form uses 3 additional PHP files, stored in the same directory as the PHPRunner main directory, to perform Customer and Product lookups and Submit functions.

This is a fairly simple demo but hopefully shows potential if you have projects that require this type of customization. Plus, the ability to secure forms within the PHPRunner security mechanisms is a major bonus.

Full disclosure, the HTML form and 3 PHP scripts were all written by Claude Sonnet 4.6. It took 6 iterations, after I provided the SQL schema, maybe 2 hours in total to implement.

Hope you find this information interesting and useful.