User need a system which should be accessible from internet so that he can work from any machine (laptop\/desktop\/mobile).<\/p>\n\n\n\n
You need to develop a web application with best of your knowledge<\/p>\n\n\n\n
Roles: Admin<\/p>\n\n\n\n
With correct credentials admin should be able to login and see the dashboard.<\/p>\n\n\n\n
if credentials are wrong he will stay on login page and show a message \u2013 wrong credentials.<\/p>\n\n\n\n
On successful login admin can see users list perform all CRUDL operations.<\/p>\n\n\n\n
NOTE: you need to use vim editor to edit files<\/h1>\n\n\n\n
Following are the wireframes for reference.<\/p>\n\n\n\n
![\"\"\/](\"https:\/\/codeinsightacademy.com\/blog\/http:\/\/codeinsightacademy.com\/blog\/wp-content\/uploads\/2021\/05\/image-10.png\")
\n\n\n\n
![\"\"\/](\"https:\/\/codeinsightacademy.com\/blog\/http:\/\/codeinsightacademy.com\/blog\/wp-content\/uploads\/2021\/05\/image-11.png\")
\n\n\n\n
![\"\"\/](\"https:\/\/codeinsightacademy.com\/blog\/http:\/\/codeinsightacademy.com\/blog\/wp-content\/uploads\/2021\/05\/image-12.png\")
\n\n\n\n
![\"\"\/](\"https:\/\/codeinsightacademy.com\/blog\/http:\/\/codeinsightacademy.com\/blog\/wp-content\/uploads\/2021\/05\/image-13.png\")
\n\n\n\n
![\"\"\/](\"https:\/\/codeinsightacademy.com\/blog\/http:\/\/codeinsightacademy.com\/blog\/wp-content\/uploads\/2021\/05\/image-14.png\")
Technologies to be used<\/h2>\n\n\n\n- composer for package management and autoload<\/li>
- ini for configuration<\/li>
- git and gitlab for version control<\/li>
- HTML5 CSS3 Bootstrap 5 for UI\/UX<\/li>
- jquery 3.6 or javascript for validation and AJAX<\/li>
- php 7.4 or 8 as backend programming language<\/li>
- mysql 8 database<\/li>
- PDO for database operations<\/strong><\/li>
- PHPUnit for unit testing<\/li>
- python and php for automation script (Use cron jobs to automatically run script)<\/li>
- nginx web server<\/li>
- use infinityfree \/ webserver \/ cloudserver for website hosting<\/li>
- Jenkins and git-ftp for CI\/CD<\/li><\/ul>\n\n\n\n
MVP \/ Deliverable<\/h2>\n\n\n\n- P0
- Users Listing<\/li>
- Delete User Record<\/li>
- Add User Record with Profile Picture
(User status should be enum in database table: enable, disable, blocked, active, inactive)<\/li> - Update User Record<\/li>
- Session Management Login \/ Logout<\/li><\/ol><\/li>
- P1
- View User Details in Modal Window<\/li>
- Pagination<\/li>
- Sorting<\/li>
- Searching<\/li>
- Filtering<\/li><\/ol><\/li>
- P2
- Frontend – Backend Validation<\/li>
- Export CSV Users<\/li>
- Bulk Upload CSV<\/li>
- Activity Log<\/li>
- Export Activity Log<\/li><\/ol><\/li>
- P3
- Login with OTP i.e. 2FA (Use Redis to store OTP)<\/li>
- Login Logout for user account<\/li>
- Inactive User status if not logged in for 3 consecutive days<\/li>
- Change Admin and User Password from their respective account<\/li>
- Secret Questions and Forgot Password \/ Recover Password using secret questions or through the email link<\/li><\/ol><\/li>
- P4
- REST API (Web Services) for User CRUDL Operations<\/li>
- Protect REST API using Basic Authentication or JWT token<\/li>
- Login with google API or Facebook API<\/li>
- PHPUnit test for all functionalities<\/li>
- Licensing or limit user registration<\/li><\/ol><\/li>
- P5
- Dashboard showing following summary (Use highcharts)
- Total User<\/li>
- Active Users<\/li>
- License Count \/ Usage Count<\/li>
- Online Users<\/li>
- Weekly Registration Stats<\/li><\/ol><\/li><\/ol><\/li><\/ol>\n\n\n\n
Schema<\/h2>\n\n\n\n![\"\"](\"https:\/\/codeinsightacademy.com\/blog\/http:\/\/codeinsightacademy.com\/blog\/wp-content\/uploads\/2021\/06\/image-51.png\")
<\/a><\/figure>\n\n\n\nRef SQL Queries<\/h2>\n\n\n\nSELECT * FROM users ORDER BY id DESC;\n\nSELECT * FROM users WHERE id = 3;\n\nDELETE FROM users WHERE id = 3;\n\nINSERT INTO users (id, name, age, city, added_at, updated_at) VALUES (NULL, 'sonam gupta', 18, 'gorakhpur', NOW(), NOW());\n\nUPDATE users SET name = 'Sonam Gupta', age = 20, city = 'Gorakhpur', updated_at = NOW() WHERE id = 5;<\/code><\/pre>\n\n\n\nReference<\/h2>\n\n\n\n
PHP MySQL CRUD App<\/a><\/p>\n\n\n\nPhp CRUD Application \u2013 How to Create Website Using Php \u2013 YouTube<\/a><\/p>\n\n\n\nLinux Commands<\/a><\/p>\n\n\n\nSQL Cheat Sheet<\/a><\/p>\n\n\n\nHTML and CSS<\/a><\/p>\n\n\n\nPhp Fundamentals<\/a><\/p>\n\n\n\nPhp Basics Tutorial<\/a><\/p>\n\n\n\nPhp Advanced Tutorial<\/a><\/p>\n\n\n\n
MVP \/ Deliverable<\/h2>\n\n\n\n- P0
- Users Listing<\/li>
- Delete User Record<\/li>
- Add User Record with Profile Picture
(User status should be enum in database table: enable, disable, blocked, active, inactive)<\/li> - Update User Record<\/li>
- Session Management Login \/ Logout<\/li><\/ol><\/li>
- P1
- View User Details in Modal Window<\/li>
- Pagination<\/li>
- Sorting<\/li>
- Searching<\/li>
- Filtering<\/li><\/ol><\/li>
- P2
- Frontend – Backend Validation<\/li>
- Export CSV Users<\/li>
- Bulk Upload CSV<\/li>
- Activity Log<\/li>
- Export Activity Log<\/li><\/ol><\/li>
- P3
- Login with OTP i.e. 2FA (Use Redis to store OTP)<\/li>
- Login Logout for user account<\/li>
- Inactive User status if not logged in for 3 consecutive days<\/li>
- Change Admin and User Password from their respective account<\/li>
- Secret Questions and Forgot Password \/ Recover Password using secret questions or through the email link<\/li><\/ol><\/li>
- P4
- REST API (Web Services) for User CRUDL Operations<\/li>
- Protect REST API using Basic Authentication or JWT token<\/li>
- Login with google API or Facebook API<\/li>
- PHPUnit test for all functionalities<\/li>
- Licensing or limit user registration<\/li><\/ol><\/li>
- P5
- Dashboard showing following summary (Use highcharts)
- Total User<\/li>
- Active Users<\/li>
- License Count \/ Usage Count<\/li>
- Online Users<\/li>
- Weekly Registration Stats<\/li><\/ol><\/li><\/ol><\/li><\/ol>\n\n\n\n
Schema<\/h2>\n\n\n\n<\/a><\/figure>\n\n\n\nRef SQL Queries<\/h2>\n\n\n\nSELECT * FROM users ORDER BY id DESC;\n\nSELECT * FROM users WHERE id = 3;\n\nDELETE FROM users WHERE id = 3;\n\nINSERT INTO users (id, name, age, city, added_at, updated_at) VALUES (NULL, 'sonam gupta', 18, 'gorakhpur', NOW(), NOW());\n\nUPDATE users SET name = 'Sonam Gupta', age = 20, city = 'Gorakhpur', updated_at = NOW() WHERE id = 5;<\/code><\/pre>\n\n\n\nReference<\/h2>\n\n\n\n
PHP MySQL CRUD App<\/a><\/p>\n\n\n\nPhp CRUD Application \u2013 How to Create Website Using Php \u2013 YouTube<\/a><\/p>\n\n\n\nLinux Commands<\/a><\/p>\n\n\n\nSQL Cheat Sheet<\/a><\/p>\n\n\n\nHTML and CSS<\/a><\/p>\n\n\n\nPhp Fundamentals<\/a><\/p>\n\n\n\nPhp Basics Tutorial<\/a><\/p>\n\n\n\nPhp Advanced Tutorial<\/a><\/p>\n\n\n\n
- Users Listing<\/li>
- Delete User Record<\/li>
- Add User Record with Profile Picture
(User status should be enum in database table: enable, disable, blocked, active, inactive)<\/li> - Update User Record<\/li>
- Session Management Login \/ Logout<\/li><\/ol><\/li>
- P1
- View User Details in Modal Window<\/li>
- Pagination<\/li>
- Sorting<\/li>
- Searching<\/li>
- Filtering<\/li><\/ol><\/li>
- P2
- Frontend – Backend Validation<\/li>
- Export CSV Users<\/li>
- Bulk Upload CSV<\/li>
- Activity Log<\/li>
- Export Activity Log<\/li><\/ol><\/li>
- P3
- Login with OTP i.e. 2FA (Use Redis to store OTP)<\/li>
- Login Logout for user account<\/li>
- Inactive User status if not logged in for 3 consecutive days<\/li>
- Change Admin and User Password from their respective account<\/li>
- Secret Questions and Forgot Password \/ Recover Password using secret questions or through the email link<\/li><\/ol><\/li>
- P4
- REST API (Web Services) for User CRUDL Operations<\/li>
- Protect REST API using Basic Authentication or JWT token<\/li>
- Login with google API or Facebook API<\/li>
- PHPUnit test for all functionalities<\/li>
- Licensing or limit user registration<\/li><\/ol><\/li>
- P5
- Dashboard showing following summary (Use highcharts)
- Total User<\/li>
- Active Users<\/li>
- License Count \/ Usage Count<\/li>
- Online Users<\/li>
- Weekly Registration Stats<\/li><\/ol><\/li><\/ol><\/li><\/ol>\n\n\n\n
Schema<\/h2>\n\n\n\n
<\/a><\/figure>\n\n\n\nRef SQL Queries<\/h2>\n\n\n\n
SELECT * FROM users ORDER BY id DESC;\n\nSELECT * FROM users WHERE id = 3;\n\nDELETE FROM users WHERE id = 3;\n\nINSERT INTO users (id, name, age, city, added_at, updated_at) VALUES (NULL, 'sonam gupta', 18, 'gorakhpur', NOW(), NOW());\n\nUPDATE users SET name = 'Sonam Gupta', age = 20, city = 'Gorakhpur', updated_at = NOW() WHERE id = 5;<\/code><\/pre>\n\n\n\nReference<\/h2>\n\n\n\n
PHP MySQL CRUD App<\/a><\/p>\n\n\n\n
Php CRUD Application \u2013 How to Create Website Using Php \u2013 YouTube<\/a><\/p>\n\n\n\n
Linux Commands<\/a><\/p>\n\n\n\n
SQL Cheat Sheet<\/a><\/p>\n\n\n\n
HTML and CSS<\/a><\/p>\n\n\n\n
Php Fundamentals<\/a><\/p>\n\n\n\n
Php Basics Tutorial<\/a><\/p>\n\n\n\n
Php Advanced Tutorial<\/a><\/p>\n\n\n\n
- Dashboard showing following summary (Use highcharts)