| ID | Category | Player (EN / AR) | Prompt & Clue | Correct Answer | Level / Points | Daily | Actions |
|---|---|---|---|---|---|---|---|
| Loading questions from Hostinger MySQL... | |||||||
| Code | Emoji | Title (EN) | العنوان (عربي) | Subtitle (EN) | الوصف الفرعي (عربي) |
|---|
Add New Category
Create MySQL Database in Hostinger hPanel
Go to your Hostinger Control Panel (hPanel) > Databases > MySQL Databases.
Enter a database name (e.g., footyquiz), username, and a strong password. Click Create.
Import schema.sql via phpMyAdmin
In Hostinger, click Enter phpMyAdmin next to your newly created database.
Click the Import tab at the top, select the file backend/schema.sql, and click Go.
All tables (categories, questions, leaderboard) and initial English/Arabic questions will be created instantly!
Upload backend files & set credentials
Upload the backend/ folder (or its files api.php, config.php, index.html) to your domain's public_html/ folder via Hostinger File Manager or FTP.
Edit config.php with your Hostinger database name, user, and password.
Connect your Android App
In the FootyQuiz Android App, open the Profile > Hostinger SQL Sync settings, enter your backend API URL (e.g., https://yourdomain.com/backend/api.php), and tap Sync Now!