Massive Data Deletion System in PHP and MySQL

Massive Data Deletion System in PHP and MySQL

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:

Cómo hacer un Insert Masivo en MySQL

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)

Sistema de Eliminación Masiva de Datos

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:

XAMPPGitVisual 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:

Massive Data Deletion System in PHP and MySQL

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:

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 You can still see in the following publication in more detail the implementation of PHP applications:

How to Install PHP Applications 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.

One comment

Leave a Reply

Your email address will not be published. Required fields are marked *