MemoryLane is a digital scrapbook and journaling web app I built to learn web development with database persistence. Users can draw on an interactive canvas, add stickers and personal photos, pick background textures, and save their pages to a MySQL database tied to their account. I built it end to end: frontend canvas logic, PHP backend, and the relational database schema.
- Interactive Canvas Editor: HTML5 Canvas drawing area with freehand sketching, adjustable brush sizes, and color palettes.
- Custom Image Uploads & Stickers: Upload personal photos and decorate pages with stickers, pins, and background textures.
- User Authentication & Session Security: Multi-user login and registration with BCrypt password hashing (
password_hash/password_verify). - Canvas Persistence: Save canvas layouts to the MySQL database, linked to the authenticated user.
- Saved Memory Gallery: Load, view, and continue editing past scrapbook pages tied to your account.
- Confetti Animation: Plays celebratory confetti (
canvas-confetti) when you save a new page.
- Backend: PHP (native sessions, prepared MySQLi statements)
- Database: MySQL / MariaDB (relational user + canvas page schema)
- Frontend: HTML5 Canvas API, vanilla JavaScript (ES6+), CSS3 Flexbox/Grid
- Libraries: Google Fonts (Alata, Inter), Canvas Confetti, Ionicons
The schema in schema.sql defines two relational tables:
users: registered accounts with hashed credentials (id,username,email,password,created_at).canvas_pages: user-created scrapbook pages and snapshot references, with cascade delete (id,user_id,title,image_path,created_at).
- XAMPP (Apache + MySQL/MariaDB) or any local LAMP/WAMP/MAMP stack with PHP 7.4+ or 8.x
- Modern web browser (Chrome, Edge, Firefox, Safari)
Put this folder in your XAMPP web root:
C:\xampp\htdocs\MemoryLane
Or clone directly into htdocs:
cd C:\xampp\htdocs
git clone https://github.com/AsfaThahani/MemoryLane.git- Start Apache and MySQL from your XAMPP Control Panel.
- Open phpMyAdmin in your browser at
http://localhost/phpmyadmin. - Click the Import tab.
- Select
schema.sqlfrom the project root and click Import (or create a database namedmemorylaneand run the script).
schema.sql provisions:
CREATE DATABASE IF NOT EXISTS memorylane;
USE memorylane;
-- Creates `users` and `canvas_pages` tablesIf your local MySQL credentials differ from XAMPP defaults, update db.php:
$server_name = "127.0.0.1";
$username = "root";
$password = ""; // Your MySQL root password (default is empty in XAMPP)
$database_name = "memorylane";
$port = 3306; // Standard MySQL port (or 3307 if configured)Open your browser and navigate to:
http://localhost/MemoryLane
Sign up for a new account, log in, and start creating your memory canvas!

