🌼 Daisy School Election — Setup Guide

Create the database

Run schema.sql in phpMyAdmin or via MySQL CLI:

mysql -u root -p < schema.sql

Set real password hashes

Use the generator above. Then update the houses table and election_config:

UPDATE houses SET password='YOUR_HASH' WHERE id=1;  -- Red
UPDATE houses SET password='YOUR_HASH' WHERE id=2;  -- Blue
UPDATE houses SET password='YOUR_HASH' WHERE id=3;  -- Green
UPDATE houses SET password='YOUR_HASH' WHERE id=4;  -- Yellow
UPDATE election_config SET value='YOUR_HASH' WHERE `key`='results_password';

Edit config.php

Set your actual database credentials:

define('DB_USER', 'your_cpanel_db_user');
define('DB_PASS', 'your_db_password');
define('DB_NAME', 'daisy_election');

Import candidates & students

Edit the INSERT statements in schema.sql with real names, or insert via phpMyAdmin.
Candidates need: name, class, section, house_id, role.
Students need: name, roll_no, class, section, house_id.

Upload all files to server

Upload to your public_html or a subfolder. Files needed:

index.html       ← Main dashboard
vote_red.html    ← Red House voting booth
vote_blue.html   ← Blue House voting booth
vote_green.html  ← Green House voting booth
vote_yellow.html ← Yellow House voting booth
api.php          ← Backend (all API calls)
config.php       ← DB credentials (keep private)

Test before election day

✓ Open each house voting page and verify password works
✓ Look up a test student roll number
✓ Cast a test vote and check the DB
✓ Verify the live count on index.html updates
✓ Test results unlock with the admin password
✓ Reset test votes: DELETE FROM votes; UPDATE students SET has_voted_house=0, has_voted_head=0, voted_at=NULL;