README.md

mx-bet

a project for php classes - bookmacher site (modeled on the LV BET site)

🎈 Requirements

🌐 Hosting

• remote available - DEPLOYMENT ON HEROKU

💼 Accounts

• create an account
  • checking if login and email are UNIQUE
  • add record to database
• sign in
  • check if login exists
  • check if password exists
  • add record to database

🙋‍♂️ User after signing in

• betting
  • validation if user clicked at least 1 bet
  • validation if user added a stake
    • not empty
    • greater than 0
  • creating a bet
    • check if user has enough balance
    • user_balance = old_balance - stake
    • adding users_choices to database
  • betting results
    • coupon win validation
      • check from db if coupon won
        • check if every bet on coupon won
    • show users bet results (win/lose)
  • show potential win from each coupon
    • more bets on 1 coupon -> more money if won
• adding balance to account
  • amount validation (>0)
  • query
• show details of user's coupons

👮‍♂️ Admin after signing in

• add balance to any user
• create a bet_entity
  • create bet options
  • create odds for bets
• add results of a bet
• add new category
• add new region
• add new event
• see statistics

Admin panel overview

📝 Newsletter ONLY ON LOCALHOST

• after creating a coupon send details to user via email
• after adding a result send result details to users with such bet
• send info if coupon won or lost ?
  • Coupon lost:
  • Coupon won:
• send info about user's balance (above)

Screenshot from my inbox

✨ Additional functionalities

• user can filter available events from database
• validation if user is logged in on site
• responsive design?
• multibet - the more bets on one coupon the highest potential prize
• account details on user's page
• coupons details on user's page
• user's stats - coupons won, all coupons, etc.
• showing sponsored events on user's main page

📚 Database

On localhost I've used xampp with phpmyadmin and apache

• Server type: MariaDB

• Language: mysql

• PHP version: 8.0.6

📖 Database Schema