Skip to main content
Back to All Portfolio Projects
EdTech / Online Exam Preparation Live production project Hosted on Hostinger Database: SQLite

Studyly.online — Online Librarian Exam Preparation Platform

Studyly.online is an online exam preparation platform built to help librarian exam aspirants access quizzes and study materials through a structured learning experience.

Studyly.online — Online Librarian Exam Preparation Platform Banner
Executive Summary

Project Overview

Studyly.online is a specialized online exam preparation platform specifically built for aspirants preparing for state-level competitive examinations, such as the Bihar Library Eligibility Test (LET) and Bihar Librarian recruitment exams. The platform provides candidates with a focused, structured learning environment featuring syllabus-aligned study notes, video lectures, and real-time computer-based testing (CBT).

Target Audience & Community

Candidates preparing for librarian eligibility and recruitment examinations (including Bihar LET and Bihar Librarian exams), education aspirants, and students seeking structured practice tests and curated syllabus materials.

Category EdTech / Online Exam Preparation
Production Database SQLite
Hosting Infrastructure Hostinger
Production Capabilities

Key Features

Every feature detailed below represents functionality deployed, verified, and active in the live production application.

01

Online Quiz and Exam Preparation Experience

Timed Computer-Based Testing (CBT) engine featuring automated submission upon timer expiry, question palette navigation, mark-for-review capabilities, and instant score calculation with negative marking evaluation.

02

Study-Material Management

Hierarchical subject-wise and topic-wise PDF lecture note organization with download tracking, in-browser viewing, and responsive access across mobile and desktop devices.

03

Free and Paid Content Access

Granular access controls supporting both free sample materials and premium membership-gated test series and study notes, allowing candidates to evaluate resources before subscribing.

04

₹49/Month Membership Model

Affordable ₹49/month recurring membership model providing 30 days of full platform access, with stacking renewal logic that preserves remaining active days when renewed early.

05

Razorpay Checkout and Payment Verification

Two-phase payment workflow utilizing server-side order generation via Razorpay Orders API coupled with cryptographic HMAC-SHA256 signature verification to prevent price tampering and replay attacks.

06

Admin Content Management

Dedicated administrative back-office for managing subjects, topics, study materials, video lectures, question banks, student statuses, manual membership grants/revocations, and bilingual question parsing.

07

Protected Access to Paid Content

Server-mediated streaming headers and anti-cheating query projection that strictly gate access to paid content, protect download files, and prevent answer leaks.

System Architecture

Technical Implementation

Studyly.online is engineered on high-leverage modern web standards, emphasizing server-authoritative state, transactional data consistency, and reliable security boundaries.

Laravel and PHP Backend

Engineered on Laravel 12 and PHP 8.2+ following a modular monolith architecture. Business workflows are cleanly separated into dedicated domain controllers (MembershipController, StudentController, AdminController) and specialized services (QuizTextParser, ChatbotService) without unnecessary microservice overhead.

Database and Migration Architecture

Operates with SQLite in production (verified against the live environment) using Eloquent ORM relationships across 14 core domain tables (users, subjects, topics, study_materials, videos, quizzes, questions, quiz_options, quiz_attempts, quiz_answers, doubts, doubt_replies, memberships, membership_orders). Migrations maintain clean portability between SQLite and MySQL.

Server-Side Pricing and Payment Verification

Payment amounts are strictly server-authoritative. The membership price is hardcoded on the server as MembershipController::MEMBERSHIP_PRICE = 49.00 INR (4900 paise). The client amount parameter is completely ignored, and orders are created server-to-server via Razorpay HTTP BasicAuth API.

Razorpay Webhook & Payment Verification Handling

Direct payment callback verification workflow via POST /membership/verify that validates razorpay_order_id, razorpay_payment_id, and razorpay_signature using HMAC-SHA256 signature computation and constant-time string comparison (hash_equals). An idempotency gate on order status rejects duplicate verification attempts for already-processed orders.

Authorization for Paid Content & Anti-Cheating CBT

Paid quizzes and PDFs require an active membership verified via hasActiveMembership(). For the CBT exam engine, an anti-cheating query projection strictly omits the is_correct column from the options payload sent to candidate browsers, preventing inspect-element cheating. PDF materials are streamed through streamMaterial() with protected headers rather than exposed static links.

Production Deployment and Configuration

Deployed in live production on Hostinger Cloud Linux with PHP 8.2+, SQLite database storage, HTTPS/TLS 1.3 encryption, rate limiting (throttle:60,1), automated storage symlinks, AdSense readiness, and crawler boundaries (robots.txt, sitemap.xml, ads.txt).

Hurdles & Solutions

Engineering Challenges

Deploying an educational examination platform with paid subscriptions involves strict operational requirements around authorization, payments, and data security:

Challenge

Paid Content Access Protection

Startiz Labs Engineering Solution:

Direct static file links allow unauthorized sharing and search indexing. Solved by replacing static links with server-mediated binary streaming (streamMaterial) guarded by hasActiveMembership(). For CBT exams, the is_correct column is omitted from client SQL payloads, ensuring answers never exist in the browser DOM before server evaluation.

Challenge

Payment Verification & Cryptographic Integrity

Startiz Labs Engineering Solution:

Client-side confirmation requests can be forged or altered. Solved by recomputing the HMAC-SHA256 signature using the server secret key (hash_hmac('sha256', order_id . '|' . payment_id, secret)) and comparing it using constant-time hash_equals() to prevent timing-attack vulnerabilities.

Challenge

Duplicate Payment Callbacks & Replay Attacks

Startiz Labs Engineering Solution:

Network retries or malicious multiple POST submissions can lead to duplicate membership records or race conditions. Solved by checking order status at the verification entry gate: if $order->status === 'paid', the transaction is immediately rejected with HTTP 400 ('Order already processed.').

Challenge

Server-Side Price Validation

Startiz Labs Engineering Solution:

Client-manipulated price parameters (e.g., modifying request to pay ₹1 instead of ₹49) are eliminated by locking pricing on the server. The order creation endpoint reads only the internal constant (MEMBERSHIP_PRICE = 49.00 / 4900 paise), and verification confirms that round($order->amount * 100) === 4900.

Production Deliverables

Outcome

Studyly.online is deployed in live production on Hostinger, providing librarian exam aspirants with a dependable, secure, and structured preparation experience. The application demonstrates Startiz Labs' capabilities in end-to-end full-stack web engineering, resilient payment integrations, server-authoritative state management, and educational content protection.

Live production EdTech platform serving librarian exam candidates at https://studyly.online
Secure two-phase Razorpay checkout with server-authoritative ₹49/month membership billing
Anti-cheating timed CBT test engine with zero-leakage client answer protection
Protected PDF study material delivery with server-side streaming access control
Comprehensive administrative back-office for curriculum, quiz import, and student management
150 automated tests verifying authentication, payments, exam flow, and content security
Note on Verified Deliverables: In alignment with Startiz Labs transparency standards, the deliverables listed above represent verified architectural components, payment integrations, and code artifacts active in the production repository. No speculative business conversion metrics, estimated user tallies, or unverified revenue statistics are stated.

Technologies & Architecture Stack

Laravel PHP SQLite Razorpay JavaScript HTML CSS

Ready to Build Your Custom Digital Solution?

Partner with Startiz Labs — One place for your complete digital business solution: websites, mobile apps, AI automation, and custom software.