master detail form read create edit delete forms #master detail crud
Edit
by Sreekanth P - 7 years ago (2018-02-10)
i want to create add records into a master detail form
| I am a beginner and stuck on creating CRUD on master details forms.
Examples : Journal header and Journal lines joined by JVno.
When i use frameworks or tools like phprunner i cannot learn how to create a basic master detail form. searched the web and returns null..! |
Ask clarification
2 Recommendations
Luminova Framework: PHP Luminova framework: simple, powerful MVC/HMVC.
PHP Luminova Framework is a robust MVC and HMVC framework, supporting Twig, Smarty, and PHP templating with layout inheritance and extensions using methods like `begin`, `end`, `import`, and `extend`.
It also offers:
- Unique database caching and ORM for query builders.
- Database migration and seeding with `NovaKit` commands for execution, rollback, and version control.
- Template view caching and built-in DOM minification configurable via the env file.
- OpenAI models for creating AI-powered applications.
- Command-line tools for building CLI tools and managing the framework via `NovaKit CLI`.
- Sitemap generation with a single `NovaKit` command.
- CronJobs management for scheduling and execution using the `NovaKit` command.
- Easy SCO schema object integration on web pages.
- Optimized HTTP and CLI routing.
- Cloud Storages, support different storage types like Locale, AWS S3, Azure Blob, Google Cloud Storage, etc.
- Support symlink creation for local and cloud storage that supports temporal public URLs.
- CDN module for local storage, to deliver files in the browser without the need for `symlink`, it also supports browser caching, large files, and any file type.
- Easy file uploads with support for browser-side chunking using libraries `Pluupload.js` etc.
- Utility classes and helper functions for various tasks.
- Comprehensive error handling and logging, along with support for maintenance mode.
| by Ujah Chigozie peter package author 25 - 2 months ago (2025-02-04) Comment
Luminova framework has an easy way to create CRUD for both HTTP and CLI. You can also find a full working example that allows you to also read an image from private storage with cache options:
Here on GitHub: luminovang/luminova-rest-api-example |
Simple CRUD with MySQL 2: Output SQL and CRUD forms based on remoteDB class
This class can generate SQL and CRUD forms based on remoteDB class.
It is a class derived from the original work by Mahboobz. This version was improved in the following ways:
Version 4:
Update: replaced irp_commonSQL.php (obsolete) with common_pdo.php
Version 3:
- Added 2 more callback: before_save(), before_updated()
- Tested on Master-detail tables: see example pages
- Tested on view tables.
Version 3: added 2 new hooks, and master->detail capability
added 2 functions: setEdit() and setDelete() to control buttons
Version 2:
- Added $this->index array to store one or more PK names (in place of one pre-defined PK='id')
- Added get_where(), get_hidden($record) to handle multiple PKs
- Added optional hook and callback to customize the CRUD page:
1) special input fields: select, radio... (crud_get_input)
2) special edit fields: select, radio... (crud_get_edit)
3) special show fields: links, references... (crud_get_show)
4) more actions in table (crud_action_hook)
- Added 3 static utility: make_select, make_radio and make_checkbox for input/edit fields
- Added CONFIRM to delete
- Added $extrasql parameter to renderVertically(), to extend the basic sql: "SELECT * FROM ".$this->table
- Cosmetic minor variations, use of css file (in: remoteDB/css/style.css)
| by Marco Sillano package author 255 - 7 years ago (2018-02-19) Comment
This simple CRUD class allows extended customization, and maybe can solve your problems.
You can use lookup tables, and drop-down list in your pages.
And you can add 'detail' buttons to any row of a table.
Hope that class can help you (see example pages). |