Appointment Scheduling System

A simple and efficient web-based appointment scheduling system built with PHP and MySQL. This application allows businesses to manage appointments, track client schedules, and organize services effectively.

Features

• Add new appointments with client details
• View all appointments in a clean, tabulated format
• Edit existing appointments
• Delete appointments
• Responsive and user-friendly interface

Requirements

• PHP 7.0 or higher
• MySQL 5.6 or higher
• XAMPP/WAMP/LAMP server
• Web browser

Installation

1. Clone or download this repository to your XAMPP's htdocs folder
2. Create a new MySQL database named appointment_scheduler
3. Import the database structure (Create the following table):

CREATE TABLE appointments (
    id INT AUTO_INCREMENT PRIMARY KEY,
    client_name VARCHAR(255) NOT NULL,
    service VARCHAR(255) NOT NULL,
    appointment_date DATE NOT NULL,
    appointment_time TIME NOT NULL
);

4. Configure the database connection:
   • Open db.php
   • Update the following variables if needed:

     $host = 'localhost';
     $username = 'root';
     $password = '';
     $database = 'appointment_scheduler';

Usage

1. Start your XAMPP server (Apache and MySQL)
2. Open your web browser and navigate to http://localhost/appointment scheduling system
3. You can now:
   • View all appointments on the main page
   • Add new appointments using the "Add New Appointment" button
   • Edit existing appointments by clicking the "Edit" button
   • Delete appointments using the "Delete" button

File Structure

• index.php - Main page displaying all appointments
• add_appointment.php - Form to add new appointments
• db.php - Database connection configuration
• style.css - CSS styles for the application

Features in Detail

Adding Appointments

• Client Name
• Service Type
• Appointment Date
• Appointment Time

Viewing Appointments

• Sortable table view
• Clear display of all appointment details
• Easy access to edit and delete functions

Styling

The application features a clean, professional design with:

• Responsive layout
• User-friendly forms
• Clear navigation
• Consistent color scheme
• Modern button styling
• Easy-to-read tables

Security Note

This is a basic implementation. For production use, please implement:

• Input validation
• SQL injection prevention
• User authentication
• CSRF protection
• Proper error handling

Contributing

Feel free to fork this repository and submit pull requests for any improvements.

License

This project is open-source and available under the MIT License.