Single page CRUDDatabase management web application
Single page CRUD form with dynamically changing buttons
Updating a SQL databases via a web interface has proven to be one of the most pragmatic inclusions to a website and this script can be customized and implemented under a wide variety of circumstances.
Due to the fact that it works by updating real databases, it seemed like the best way to show how it works is by providing a video rather than access to a deployed site. Why risk an unscrupulous character overwhelming the system by inputting large amounts of data? It is the world wide web after all!
Video of how it works
The screencast shows a new entry and highlights it automatically updating in the table view along with editing and finally the deletion process.
All project code and notes
Fork or clone from the GitHub repository.
Selecting the save button below the input form updates the table above without the need to refresh the page.
Create, read, update and delete interface
Edit the form data
Edit existing data
Once again the database is updated using a combination of PHP and SQL after the user confirms deletion of the unecessary information. Note that the button has converted back to blue.
Update finished, button changes back to blue
Making database management friendly
Sheri Rosalia | Data Engineer
Data Engineer | Data Analyst | Data Scientist