Small PHP Project
Budget: $250 – $750 USD
I need this following functionality for a client. I will do the CSS I need only the PHP, HTML and SQL part.
1.Create a MySQL table High scores in database M133 for high score list. The following columns are to be provided: ID, creation time stamp, alias, seconds, tip number. Find meaningful default values and forbid empty or meaningless entries. Optimize the table to handle large numbers of entries. Keyword-like description of the program flow as a website:
2. First visit: Welcome to the game, invitation to play with a clear explanation of what is involved, display of the top ten of the current high score list, input option for the alias, start button to start the game. The high score list shows: rank, alias, time in seconds, number of tips needed.
2.1 If you have played before, the alias is already entered as a default in the input field.
3. After pressing the start button: A stopwatch starts running internally. The website asks, "What's your 1st tip?" After entering a tip, the next page with the answer is displayed. From the 2nd tip, the time required so far is also displayed in seconds. It is always possible to abandon the game and return to 2.
4. The answer repeats the tip and only writes "Hit!", "Bigger", "Smaller".
4.1 For "larger" and "smaller" it is displayed "what is your x. Tip?". If there are more than 15 tips without a hit, the program no longer displays an input field, but instead explains that the hit should have been found long ago and displays the number you are looking for and the number of seconds that have elapsed so far. The limit of 15 should be easily changeable.
4.2 In the case of a hit, a congratulation, the number of tips and the number of seconds required for this will be displayed. The run is saved in the database. If your result is in the top 5, the top 5 list is displayed with your result highlighted. If you have reached the same time as an existing entry in the list, the program ranks the new time before the existing one. The number of top x displays should be easily changeable.
5. If "Hit" was achieved or too many hints were needed, the program will ask if you want to play again. If yes, continue with 3, if no with 2.
6. Operate the game with any desired from-to values, for example 100 to 900. Of course, the game explanations and end/cancel conditions must then also be adjusted
7. In point 4.1, variable instead of fixed limit: Calculation of the minimum number of bets required, calculation of the limit as (minimum + 50%). If 6 was realized, considering the range of values played.
8. At 4.2 it is still displayed whether it was the minimum number of bets. Was it less, output that you were lucky, got ... were it more, display "You needed x tips more than the minimum necessary y.", where x and y are of course to be calculated. If 6 was realized, considering the range of values played.
9. If point 7 is realized, adjustments to the high score table to record the number range of the game. The high score table should only list those in the score display that were entered for the same number range just played.
10. Adjustment to be able to set the weather report of the game yourself at every game start
11. Adaptation of the high-score list display: For each entry, the number of tips below or above optimum should be displayed in a new column Deviation at the back, i.e. -2, 0 or +4, with visible signs. If 6 was realized, considering the range of values played.
12. AJAX version of the game. The page does not reload after program start, communication with the server is based on AJAX only.
Important NOTE:
The project does NOT require a CSS file ONLY an HTML and PHP file. I do the CSS part myself
It must be done in HTML and PHP without a framework!
1.Create a MySQL table High scores in database M133 for high score list. The following columns are to be provided: ID, creation time stamp, alias, seconds, tip number. Find meaningful default values and forbid empty or meaningless entries. Optimize the table to handle large numbers of entries. Keyword-like description of the program flow as a website:
2. First visit: Welcome to the game, invitation to play with a clear explanation of what is involved, display of the top ten of the current high score list, input option for the alias, start button to start the game. The high score list shows: rank, alias, time in seconds, number of tips needed.
2.1 If you have played before, the alias is already entered as a default in the input field.
3. After pressing the start button: A stopwatch starts running internally. The website asks, "What's your 1st tip?" After entering a tip, the next page with the answer is displayed. From the 2nd tip, the time required so far is also displayed in seconds. It is always possible to abandon the game and return to 2.
4. The answer repeats the tip and only writes "Hit!", "Bigger", "Smaller".
4.1 For "larger" and "smaller" it is displayed "what is your x. Tip?". If there are more than 15 tips without a hit, the program no longer displays an input field, but instead explains that the hit should have been found long ago and displays the number you are looking for and the number of seconds that have elapsed so far. The limit of 15 should be easily changeable.
4.2 In the case of a hit, a congratulation, the number of tips and the number of seconds required for this will be displayed. The run is saved in the database. If your result is in the top 5, the top 5 list is displayed with your result highlighted. If you have reached the same time as an existing entry in the list, the program ranks the new time before the existing one. The number of top x displays should be easily changeable.
5. If "Hit" was achieved or too many hints were needed, the program will ask if you want to play again. If yes, continue with 3, if no with 2.
6. Operate the game with any desired from-to values, for example 100 to 900. Of course, the game explanations and end/cancel conditions must then also be adjusted
7. In point 4.1, variable instead of fixed limit: Calculation of the minimum number of bets required, calculation of the limit as (minimum + 50%). If 6 was realized, considering the range of values played.
8. At 4.2 it is still displayed whether it was the minimum number of bets. Was it less, output that you were lucky, got ... were it more, display "You needed x tips more than the minimum necessary y.", where x and y are of course to be calculated. If 6 was realized, considering the range of values played.
9. If point 7 is realized, adjustments to the high score table to record the number range of the game. The high score table should only list those in the score display that were entered for the same number range just played.
10. Adjustment to be able to set the weather report of the game yourself at every game start
11. Adaptation of the high-score list display: For each entry, the number of tips below or above optimum should be displayed in a new column Deviation at the back, i.e. -2, 0 or +4, with visible signs. If 6 was realized, considering the range of values played.
12. AJAX version of the game. The page does not reload after program start, communication with the server is based on AJAX only.
Important NOTE:
The project does NOT require a CSS file ONLY an HTML and PHP file. I do the CSS part myself
It must be done in HTML and PHP without a framework!