SQLite-PHP-Database

A simple example of a website with a backend using SQLite and PHP that you can host anywhere without any additional setup.

The example website is a basic student attendance system with essential features like adding and searching attendance records. There are two pages: one for submitting attendance and one for viewing the attendance data based on the student's roll number.

Getting Started

Download this repository and extract the zip file. ⬇

Upload all the files to your website hosting server. 🚀

Files

create_database.php: Run this script once to create the SQLite database and table ( database schema ).
index.html: HTML form for submitting attendance.
add_record.php: PHP script to save attendance data to the SQLite database.
search_record.html: HTML form to input a roll number to view attendance data.
search_record.php: PHP script to retrieve and display attendance data based on the roll number.
.htaccess: Configuration file to restrict access to the database file.

You can host these files on a web server that supports PHP. Ensure the server has write permissions to create and modify the students.db SQLite file.

Usage

Step 1: Create the Database

Run create_database.php once to create the SQLite database and table. You can do this by navigating to create_database.php in your browser:
http://yourdomain.com/create_database.php

Step 2: Submit Attendance

Navigate to index.html in your browser and use the form to submit attendance:
http://yourdomain.com/index.html

Notes

Ensure your web server has write permissions to create and modify the students.db SQLite file.
The database file students.db will be created in the directory specified in the PHP scripts.
Implement security measures like restricting access to the database file using .htaccess for Apache or appropriate configurations for other web servers.
Set correct file permissions for the SQLite database file (e.g., chmod 600 on Unix-based systems).

Summary

SQLite: A file-based database system.
Database File: students.db stores the entire database.
PHP Scripts: Use PHP Data Objects (PDO) to interact with the SQLite database.
- create_database.php: Sets up the database and table.
- submit_attendance.php: Inserts data into the database.
- view_attendance.php: Retrieves data from the database.

This simple setup makes SQLite an excellent choice for small to medium-sized applications, especially where ease of setup and use is important.