CompletedSoftware Systems & Full-Stack

Matrimonial Hub — Database System

Matrimonial Hub: a secure PHP/MySQL matchmaking platform with encrypted user data, dynamic search, and real-time interactions. 1st-place winner.

Visual story

Watch a filter become a query

Scroll to watch it unfold. Each beat is one documented step of the project.

  1. 01

    Choose filters

    The visitor adjusts the search filters.

  2. 02

    AJAX request

    The change is sent in the background.

  3. 03

    SQL query

    PHP builds a query on the MySQL schema.

  4. 04

    Results

    Matching profiles update on the page.

  5. 05

    Outcome

    Results narrow smoothly as filters change, without a page reload.

  6. 06

    Message

    Messages and passwords are stored encrypted.

An illustration of how the system works, drawn from the write-up below. It is not recorded output.

Overview

Matrimonial Hub is a matchmaking platform built for CSE370 (Database Systems) with SQL, PHP, JavaScript and AJAX, and it won 1st place in the course competition. Rather than a simple listings site, it treats the database as the hard part: encrypted passwords and chat messages, and a dynamic, AJAX-driven search that narrows candidates smoothly as filters change.

Approach

The backend is a relational MySQL schema accessed through PHP, with AJAX calls handling search and messaging without full page reloads so the matching experience stays responsive. Security was treated as a first-class requirement rather than an add-on — user passwords and in-app chat messages are encrypted — and the team explicitly worked through error handling and edge cases (malformed input, missing fields, invalid searches) to keep the system robust rather than just demo-ready.

Highlights

  • 🥇 1st Place
  • Secure
  • Real-time

Tech stack & key skills

Core tools, methods and skills demonstrated in this project:

PHPMySQLAJAXFull-stack webRelational DB designCRUD / auth