BookMyShow-Style CLI Ticketing System

BookMyShow-Style CLI Ticketing System

Python
MySQL
pandas
Git
pymysql

Overview

It allows users to create accounts, browse across multiple show categories (movies, comedy, adventure, music), select from multiple languages and time-slots (all stored in JSON columns), and make or manage bookings. The goal is to demonstrate a full end-to-end Python + MySQL system—covering database design, backend logic, and a friendly menu-driven interface—while handling real-world concerns like user authentication, data validation, and flexible show configurations.

Features

  • Multi‑Category Shows: Movies, comedy gigs, adventure events, and music festivals—all managed under one roof.
  • Multi‑Category ShowsUser Accounts: Sign‑up, sign‑in, profile management, and secure password updates.
  • Booking Flow: Choose a show, select language and time, specify ticket count, and confirm bookings.
  • Trending Shows: See the latest shows and their trending times.

Technical Details

Python CLI uses mysql-connector for MySQL, JSON columns for languages and time slots, pandas for display, and modular menus for user authentication, booking management, and trending shows.