This assignment is to create a full stack web app that allows a user to log in and manage data that belongs to them. The exact nature of the web app is up to you. The Database Tables You must have a...

It is a web app game in PHP and JavaScript


This assignment is to create a full stack web app that allows a user to log in and manage data that belongs to them. The exact nature of the web app is up to you. The Database Tables You must have a database table for user information and at least one table for the user’s data. The tables are related by the user’s unique id. Signup and Login : Users should be able to register new accounts and log in once they have an account. Every PHP file must use session management to make sure that the user is logged in and authorized to do what they are trying to do. It should not be possible to load any page (including pages intended for Ajax calls) or perform any actions when the user is not logged in. Ajax requests that are rejected due to the user not being logged in should be handled gracefully. Managing the Data : After logging in, at least some of these actions should be done through Ajax rather than whole page loads. The results of the Ajax calls should be communicated to the user through DOM manipulation rather than through a page reload. Look and Feel : All the pages of your app should have a similar look and feel. They should look like they belong together. They should be designed to be flexible with smaller screen users in mind (768px wide). It is ok to learn and use an HTML and CSS framework for this, but all JavaScript and PHP code must be written by you. Assignment Plan: 1.Name of the app: Sudoku Lite 2.Purpose of the app: This application is a game in which user have to sign in or log in. After logging in, there is a game page in that sudoku box can be shown and user have to set numbers so that one number cannot be repeated in vertical and horizontal row as well as in one box of sudoku box. If this game completed successfully then user will win. 3.Data Description: first is user table which has email address(email) (primary key), password(varchar), win(int), losses(int). This table has the data of each user and tracks the losses and wins. Second is sudoku data which has all the possible arrangements of data for one sudoku set which has position(int) and data(int). This arrangement will check the user’s arrangement.[YOU CAN UPDATE THIS DATA DECRIPTION ACCORDING TO POSSIBILITY AND WHATEVER GOOD FOR THIS ASSIGNMENT] 4.Functions performed by the app: This app has the basic functionality of registering as well as logging in and out. Also, user can check their score, see personal information, retrieve information and delete the account. 5.Role of PHP and JavaScript: This app will use PHP more for checking arrangements, updating and deleting data. JavaScript will be used for ajax request to php, reading arrangements, showing personal information and showing the result. The main operations will be performed in PHP only. Some other instructions: Do not use var in javascript to create variable. Use let. Use click event to submit any form Use PDO database type Use ajax in some or all of the operation Create separate folders of js,css,php and html Please send the sql file as well Please use very basic language as I am student doing diploma