Quote Finder

A web application for searching and managing famous quotes and their authors. Built with Express.js and MySQL.

Features

Browse all quotes and authors
Search quotes by author, keyword, category, or likes range
Add new authors and quotes
Edit existing author information
Filter quotes (e.g., inspirational, by female authors, American authors, quotes starting with “T”, life quotes)
View non-USA authors
REST API endpoint for author data

Technologies

Express.js - web framework
MySQL - database
EJS - templating engine
Bootstrap - frontend styling

Getting Started

Ensure MySQL is running and the database is set up
Update database credentials in index.js
Install dependencies and start:

npm install
node index.js

The server will run on http://localhost:3000.

Routes

Route	Description
`/`	Add quote form
`/home`	Main search page
`/authors`	List all authors
`/author/new`	Add new author
`/author/edit`	Edit author
`/allQuotes`	Display all quotes
`/searchByAuthor`	Search by author
`/searchByKeyword`	Search by keyword
`/searchByLikes`	Search by likes range
`/quoteByCategory`	Search by category
`/api/author/:id`	Author API endpoint

Project Structure

index.js          - main application
views/            - EJS templates
  partials/       - reusable template partials
public/           - static assets (CSS, JS)