Edición de Tablas en Línea con PHP y MySQL

Editing Tables Online with PHP and MySQL

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 application is carried out with the technologies of bootstrap, javascript, ajax, in addition to PHP and MySQL.

Specifically, the library is used dark-editable what with popper and moment.js make the online editing process possible.

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:

https://mauriciosevilla.com/edicion-linea/

Setting up the Online Table Editing System with PHP and MySQL on a local server

Previous Applications

To install the application on a local server, I recommend the prior installation of the following applications:

XAMPP, Git, Visual Studio Code

XAMPP is the application in charge of implementing a apache server for them to work scripts PHP on a local computer.

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:

Editing Tables Online with PHP and MySQL

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:

C:\xampp\htdocs

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:

http://localhost/phpmyadmin/index.php

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:

Online Table Editing System Database

After this you can access the following URL and the application will be ready for use:

http://localhost/edicion-linea

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:

Upload page with PHP + Database (MYSQL) to a Hosting

If you still have doubts about the process of setting up the application on a local server

Any questions I remain pending, if you require more PHP applications, in Python or JavaScript I recommend you subscribe to my content on Youtube and be on the lookout for any changes, that I make.

Leave a Reply

Your email address will not be published.