This Massive Data Deletion System in PHP and MySQL allows you to select one or several records to delete them directly from the database.
This application can be combined with a previous publication where I explain how to do a massive insert in MySQL, after you eliminate the records that the application brings by default, you can upload more data following the step by step of the following video:
This application is very simple, it does not have a login, nor more options than a landing page with a table that shows the records that it has entered in a table called post.
El nombre de la base de datos asociada al Sistema de Eliminación Masiva de Datos en PHP y MySQL es eliminacion-masiva, esta aplicación se puede implementar como un feature de otras aplicaciones más complejas y es plenamente gratuita.
Explanatory video (spanish)
Commissioning of the Massive Data Deletion System in 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 Mass Data Deletion System application on a local server:
Configuration of the Massive Data Deletion System in PHP and MySQL for its operation 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/eliminacion-masiva.git
The folder will be created eliminacion-masiva, 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
Mass Data Elimination System Database
For the application to work correctly, from phpmyadmin, you must create the database with the name eliminacion-masiva, then you must access the SQL section and paste the code found in the following link:
Database Massive Data Deletion System in PHP and MySQL
After this you can access the following URL and the application will be ready for use:
http://localhost/inventario-basico
Upload of the Massive Data Elimination System 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 You can still see in the following publication in more detail the implementation of PHP applications:
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.
One comment