PHP Oracle CRUD Application

A complete CRUD (Create, Read, Update, Delete) application built with PHP and Oracle Database.

Features

• Create - Add new records to the database
• Read - View all records with pagination
• Update - Edit existing records
• Delete - Remove records from database
• Search - Search functionality
• Validation - Form validation and error handling

Tech Stack

Requirements

• PHP 7.4 or higher
• Oracle Database 11g or higher
• Oracle Instant Client
• PHP OCI8 Extension

Installation

1. Clone the repository

git clone https://github.com/kule-code/php-oracle-crud.git
cd php-oracle-crud

2. Configure database connection in config/database.php

$host = 'localhost';
$port = '1521';
$service_name = 'ORCL';
$username = 'your_username';
$password = 'your_password';

3. Run the SQL script to create tables

sqlplus username/password@//localhost:1521/ORCL @database/schema.sql

4. Start PHP development server

php -S localhost:8000

5. Open browser and navigate to http://localhost:8000

Project Structure

php-oracle-crud/
├── config/
│   └── database.php
├── includes/
│   ├── header.php
│   └── footer.php
├── database/
│   └── schema.sql
├── css/
│   └── style.css
├── js/
│   └── script.js
├── index.php
├── create.php
├── read.php
├── update.php
├── delete.php
└── README.md

Screenshots

Coming soon...

License

MIT License

Author

kule-code