Create a quiz buzzer in PHP, SQL and jQUERY
Budget: £20 – £250 GBP
To create code using PHP, connect to a SQL database and jQuery. The objective is to create a quiz buzzer page and a host page to reset the buzzers and the round. This buzzer system will be used for friends quizes and not any professional use, so I am looking for a low cost solution, only low quotes please.
Here are my specifications.
1. SQL Database Setup. I need SQL code to set up the database.
2. Player Buzzer page (PHP). To join the game, the player should enter the game id which will be set up by the host and their name. After that they will be taken to a page with the buzzer. I have 3 images. 1st image is 'img/buzz-up.png' which should display when the player has not pressed the buzzer or the host has reset the buzzer. 2nd image is 'img/buzz-down.png' which is displayed after the player has pressed the buzzer and is the first player to press the buzzer. The 3rd image is 'img/buzz-lock.png' - this displayed when the first person to press their buzzer gets locked because they got the question wrong. The host will have the option to lock out the buzzed in player if they get the question wrong. The players will use this page on their mobile phones, so the page
should be mobile friendly and the images should adjust themselves to fit on the mobile screen with no scroll bars.
3. Group Buzzer page (PHP). This is a page which the host will present by sharing this page on the TV and will contain all of the players names side by side. Under each player name is will also display the buzz images. The 'img/buzz-up.png' will display if the player has not buzzed and is not locked. 'img/buzz-down.png' will display if the player is the active player to buzz in and 'img/buzz-lock.png' will display if the player is locked out of that round.
4. The host page (PHP). The host page will contain all player names, and will show the player status 'Idle' (they have not buzzed this round and are not locked), 'Buzz' if they were the first player to buzz in or 'Locked' if they are locked out from buzzing in that round. Next to each player name there will
be a button saying 'Lock', if pressed the player is locked out from that round. Then at the bottom of the page there will be a 'Reset Round' button, this
means all Locked players are now Unlocked and all players Status will go back to 'Idle'. When first going on to the host page, there should only be a button saying 'Start Game' and then generate a game id and display this game id on the host page to share with players to join on the Player Buzzer page.
5. Thing to take in to account.
a. Since this is live, the updates displayed should be instant. Suggest using jQuery.
b. Remember only 1 player can buzz in until either the buzzed in player has been locked by the host or the 'Reset Round' button has been pressed by the host.
c. When a player buzzes, the Group Buzzer Page, should play a buzz sound.
Here are my specifications.
1. SQL Database Setup. I need SQL code to set up the database.
2. Player Buzzer page (PHP). To join the game, the player should enter the game id which will be set up by the host and their name. After that they will be taken to a page with the buzzer. I have 3 images. 1st image is 'img/buzz-up.png' which should display when the player has not pressed the buzzer or the host has reset the buzzer. 2nd image is 'img/buzz-down.png' which is displayed after the player has pressed the buzzer and is the first player to press the buzzer. The 3rd image is 'img/buzz-lock.png' - this displayed when the first person to press their buzzer gets locked because they got the question wrong. The host will have the option to lock out the buzzed in player if they get the question wrong. The players will use this page on their mobile phones, so the page
should be mobile friendly and the images should adjust themselves to fit on the mobile screen with no scroll bars.
3. Group Buzzer page (PHP). This is a page which the host will present by sharing this page on the TV and will contain all of the players names side by side. Under each player name is will also display the buzz images. The 'img/buzz-up.png' will display if the player has not buzzed and is not locked. 'img/buzz-down.png' will display if the player is the active player to buzz in and 'img/buzz-lock.png' will display if the player is locked out of that round.
4. The host page (PHP). The host page will contain all player names, and will show the player status 'Idle' (they have not buzzed this round and are not locked), 'Buzz' if they were the first player to buzz in or 'Locked' if they are locked out from buzzing in that round. Next to each player name there will
be a button saying 'Lock', if pressed the player is locked out from that round. Then at the bottom of the page there will be a 'Reset Round' button, this
means all Locked players are now Unlocked and all players Status will go back to 'Idle'. When first going on to the host page, there should only be a button saying 'Start Game' and then generate a game id and display this game id on the host page to share with players to join on the Player Buzzer page.
5. Thing to take in to account.
a. Since this is live, the updates displayed should be instant. Suggest using jQuery.
b. Remember only 1 player can buzz in until either the buzzed in player has been locked by the host or the 'Reset Round' button has been pressed by the host.
c. When a player buzzes, the Group Buzzer Page, should play a buzz sound.