This Online Table Edition with PHP and MySQL allows you to update the tables shown in the html layer, without having to reload the page, the changes are made, which remain persistent in the database.
This library allows you to easily edit the DIV content by clicking on the content to be edited, after the editing is done, the update will be sent through Ajax to modify information in the MySQL database.
Online table editing system demo
In the following link you can see how the application works:
Setting up the Online Table Editing System with PHP and MySQL on a local server
To install the application on a local server, I recommend the prior installation of the following applications:
Git is the world's most widely used repository manager, with which you can cleanly download code from GitHub.
Visual Studio Code is the world's most popular code editor, which I highly recommend in virtually every post on this blog.
Download GitHub App
The following is the GitHub repository download link for the online store app on a local server:
Configuring Online Table Editing Software with PHP and MySQL to run on your computer
You must install the mentioned applications, with all the default parameters, after this procedure, from Visual Studio Code, you must open the following location:
From this location in Visual Studio Code, click View, Terminal. Inside the Terminal you choose the Git Bash option and copy the following code:
git clone https://github.com/configuroweb/edicion-linea.git
The folder will be created edicion-linea, inside the htdocs folder. Next, you must open XAMPP on your computer, activate the Apache and MySQL services, and access the following URL, to create the store-mail database:
Online Table Editing System Database with persistence
For the application to work correctly, from phpmyadmin, you must create the database with the name edicion-linea, then you must access the SQL section and paste the code found in the following link:
After this you can access the following URL and the application will be ready for use:
Upload of the Online Table Editing System with PHP and MySQL to a hosting
Due to the simplicity of the application, I will not address the issue directly, in the following related video (spanish), I explain the process at a general level:
If you still have doubts about the process of setting up the application on a local server