adnen / php-crud-with-cli
This is a simple PHP CLI application that performs basic CRUD (Create, Read, Update, Delete) operations on a user table in a MySQL database using PDO (PHP Data Objects). The script interacts with the database through a Command-Line Interface (CLI) and outputs results as JSON in the terminal.
Installs: 0
Dependents: 0
Suggesters: 0
Security: 0
Stars: 0
Watchers: 1
Forks: 0
Open Issues: 0
Type:project
Requires
- vlucas/phpdotenv: ^5.6
This package is not auto-updated.
Last update: 2025-07-03 03:45:59 UTC
README
This is a simple PHP CLI application that performs basic CRUD (Create, Read, Update, Delete) operations on a user table in a MySQL database using PDO (PHP Data Objects). The script interacts with the database through a Command-Line Interface (CLI) and outputs results as JSON in the terminal.
Prerequisites
Before running the script, make sure you have the following:
- PHP (Version 7.4 or higher)
- Composer (for dependency management)
- MySQL or MariaDB database running
- A
.env
file configured with your database credentials
Installation
Step 1: Clone the Repository
Clone this repository to your local machine:
git clone https://github.com/yourusername/php-with-CRUD-cli.git
cd php-crud-with-cli
composer install
Step 2: Install Dependencies
composer install
Step 3: Set Up Environment Variables
modifie the name of .env.example file in the root directory of the project and configure the database credentials:
Step 4: Set Up Database
CREATE DATABASE your_database_name; USE your_database_name;
Step 5: Run the CLI Script
php public/CLI.php
CLI Menu and Commands
PHP PDO CRUD CLI
Choose an option:
- Create User
- Read All Users
- Read User by ID
- Update User
- Delete User
- Exit Your choice: