{"id":1124,"date":"2021-04-10T05:06:57","date_gmt":"2021-04-10T05:06:57","guid":{"rendered":"https:\/\/codeinsightacademy.com\/blog\/?page_id=1124"},"modified":"2021-04-17T08:13:43","modified_gmt":"2021-04-17T08:13:43","slug":"projects","status":"publish","type":"page","link":"https:\/\/codeinsightacademy.com\/blog\/projects\/","title":{"rendered":"Projects"},"content":{"rendered":"\n<h2>User management system<\/h2>\n\n\n\n<p><strong>Description:<\/strong><br>Create a project for user management.<\/p>\n\n\n\n<p>Roles:<br>Admin<\/p>\n\n\n\n<p>With correct credentials admin login and see the dashboard.<br>if credentials are wrong he will stay on login page and get a message of wrong credentials.<\/p>\n\n\n\n<p>On successful login admin can see users list perform all crud operations.<\/p>\n\n\n\n<p>The wireframe for the project UI is as follows:<\/p>\n\n\n\n<figure class=\"wp-block-gallery columns-2 is-cropped\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/codeinsightacademy.com\/blog\/http:\/\/codeinsightacademy.com\/blog\/wp-content\/uploads\/2021\/04\/login_form-1.jpeg\"><img loading=\"lazy\" width=\"476\" height=\"297\" src=\"https:\/\/codeinsightacademy.com\/blog\/http:\/\/codeinsightacademy.com\/blog\/wp-content\/uploads\/2021\/04\/login_form-1.jpeg\" alt=\"\" data-id=\"1133\" data-link=\"https:\/\/codeinsightacademy.com\/blog\/?attachment_id=1133\" class=\"wp-image-1133\" srcset=\"https:\/\/codeinsightacademy.com\/blog\/http:\/\/codeinsightacademy.com\/blog\/wp-content\/uploads\/2021\/04\/login_form-1.jpeg 476w, https:\/\/codeinsightacademy.com\/blog\/http:\/\/codeinsightacademy.com\/blog\/wp-content\/uploads\/2021\/04\/login_form-1-300x187.jpeg 300w\" sizes=\"(max-width: 476px) 100vw, 476px\" \/><\/a><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/codeinsightacademy.com\/blog\/http:\/\/codeinsightacademy.com\/blog\/wp-content\/uploads\/2021\/04\/dashboard_2-3.jpeg\"><img loading=\"lazy\" width=\"586\" height=\"411\" src=\"https:\/\/codeinsightacademy.com\/blog\/http:\/\/codeinsightacademy.com\/blog\/wp-content\/uploads\/2021\/04\/dashboard_2-3.jpeg\" alt=\"\" data-id=\"1134\" data-link=\"https:\/\/codeinsightacademy.com\/blog\/?attachment_id=1134\" class=\"wp-image-1134\" srcset=\"https:\/\/codeinsightacademy.com\/blog\/http:\/\/codeinsightacademy.com\/blog\/wp-content\/uploads\/2021\/04\/dashboard_2-3.jpeg 586w, https:\/\/codeinsightacademy.com\/blog\/http:\/\/codeinsightacademy.com\/blog\/wp-content\/uploads\/2021\/04\/dashboard_2-3-300x210.jpeg 300w\" sizes=\"(max-width: 586px) 100vw, 586px\" \/><\/a><\/figure><\/li><\/ul><\/figure>\n\n\n\n<figure class=\"wp-block-gallery columns-2 is-cropped\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/codeinsightacademy.com\/blog\/http:\/\/codeinsightacademy.com\/blog\/wp-content\/uploads\/2021\/04\/add_user_form-2.jpeg\"><img loading=\"lazy\" width=\"624\" height=\"461\" src=\"https:\/\/codeinsightacademy.com\/blog\/http:\/\/codeinsightacademy.com\/blog\/wp-content\/uploads\/2021\/04\/add_user_form-2.jpeg\" alt=\"\" data-id=\"1137\" data-full-url=\"https:\/\/codeinsightacademy.com\/blog\/http:\/\/codeinsightacademy.com\/blog\/wp-content\/uploads\/2021\/04\/add_user_form-2.jpeg\" data-link=\"https:\/\/codeinsightacademy.com\/blog\/?attachment_id=1137\" class=\"wp-image-1137\" srcset=\"https:\/\/codeinsightacademy.com\/blog\/http:\/\/codeinsightacademy.com\/blog\/wp-content\/uploads\/2021\/04\/add_user_form-2.jpeg 624w, https:\/\/codeinsightacademy.com\/blog\/http:\/\/codeinsightacademy.com\/blog\/wp-content\/uploads\/2021\/04\/add_user_form-2-300x222.jpeg 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/codeinsightacademy.com\/blog\/http:\/\/codeinsightacademy.com\/blog\/wp-content\/uploads\/2021\/04\/edit_user_form-2.jpeg\"><img loading=\"lazy\" width=\"624\" height=\"463\" src=\"https:\/\/codeinsightacademy.com\/blog\/http:\/\/codeinsightacademy.com\/blog\/wp-content\/uploads\/2021\/04\/edit_user_form-2.jpeg\" alt=\"\" data-id=\"1138\" data-full-url=\"https:\/\/codeinsightacademy.com\/blog\/http:\/\/codeinsightacademy.com\/blog\/wp-content\/uploads\/2021\/04\/edit_user_form-2.jpeg\" data-link=\"https:\/\/codeinsightacademy.com\/blog\/?attachment_id=1138\" class=\"wp-image-1138\" srcset=\"https:\/\/codeinsightacademy.com\/blog\/http:\/\/codeinsightacademy.com\/blog\/wp-content\/uploads\/2021\/04\/edit_user_form-2.jpeg 624w, https:\/\/codeinsightacademy.com\/blog\/http:\/\/codeinsightacademy.com\/blog\/wp-content\/uploads\/2021\/04\/edit_user_form-2-300x223.jpeg 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/figure><\/li><\/ul><\/figure>\n\n\n\n<p><strong>Plan of Action<\/strong><\/p>\n\n\n\n<ol><li>Create database ums<\/li><li>Create table users<\/li><li>Insert 10 records in users table<\/li><li>Create dashboard.php file<\/li><li>Create database connection in dashboard.php file using PDO and show all records from users table in html table refer wireframe<\/li><li>Add Edit and Delete link in Action column of table<\/li><li>Create delete.php file<\/li><li>Add delete functionality in delete.php file, Once the user get deleted redirect to dashboard.php page<\/li><li>Create add.php file<\/li><li>Create form in add.php file and keep action as add_action.php<\/li><li>Create add_action.php file<\/li><li>Add insert functionality in add_action.php file. Whatever data will come from html form will be inserted to database table user<\/li><li>Once the data get inserted in table redirect to dashboard.php file<\/li><li>Create edit.php file and link to Edit link in dashboard.php listing Ref: wireframe<\/li><li>Load userdata in edit.php form using select query<\/li><li>Create edit_action.php file<\/li><li>Add update functionality in edit_action.php file <\/li><li>Once the record get updated redirect to dashboard.php page<\/li><li>Create table admin and add 1 record for admin username and password<\/li><li>Create login.php file<\/li><li>Create form in login.php with username and password field and action as login_action.php<\/li><li>Create login_action.php<\/li><li>Add login functionality in login_action.php<\/li><li>Once the user credentials are correct then redirect to dashboard.php. In case credentials are incorrect then redirect to login.php with error message<\/li><li>Create header.php<\/li><li>include header.php file in all pages except action files<\/li><li>Add Login and Logout button in header.php<\/li><li>Add logout.php hyperlink to Logout button<\/li><li>Add logout functionality by destryoing session in logout.php file<\/li><li>Once User get logout then redirect to login.php page<\/li><\/ol>\n\n\n\n<p><strong>Deliverables:<\/strong><br>login \/ logout using php session management P0<br>listing and delete user records P1<br>add\/edit form with javascript\/jquery validation P2<br>view user details in popup using ajax P3<br>Activity Log(Add, Edit, Delete) P4<br>search, sort and pagination in listing page P5<\/p>\n\n\n\n<p><strong>Technologies to be used:<\/strong><br>git and gitlab for version control<br>HTML5 CSS3 Bootstrap 5 for UI\/UX<br>jquery 3.6 for validation<br>php 7.4 as backend programming language<br>mysql 8 database<br>nginx web server<br>infinityfree for website hosting<br>jenkins and git-ftp for CI\/CD<\/p>\n\n\n\n<p><strong>Reference link:<\/strong> <\/p>\n\n\n\n<p>linux commands<\/p>\n\n\n\n<p><br><a rel=\"noreferrer noopener\" href=\"https:\/\/www.youtube.com\/watch?v=xknP1ToJw1g&amp;list=PL8y0jzNQmUDWlr7od0qcBNDQ7TGIY26-Z\" data-type=\"URL\" data-id=\"https:\/\/www.youtube.com\/watch?v=xknP1ToJw1g&amp;list=PL8y0jzNQmUDWlr7od0qcBNDQ7TGIY26-Z\" target=\"_blank\">HTML and CSS<\/a><\/p>\n\n\n\n<p><a rel=\"noreferrer noopener\" href=\"https:\/\/www.youtube.com\/watch?v=1yYfcMS_r_U&amp;list=PL8y0jzNQmUDV_JfgeA_xCORFuG5JqHx_u\" data-type=\"URL\" data-id=\"https:\/\/www.youtube.com\/watch?v=1yYfcMS_r_U&amp;list=PL8y0jzNQmUDV_JfgeA_xCORFuG5JqHx_u\" target=\"_blank\">Php Fundamentals<\/a><\/p>\n\n\n\n<p><a rel=\"noreferrer noopener\" href=\"https:\/\/www.youtube.com\/watch?v=tui3J5YxFCE&amp;list=PL8y0jzNQmUDUUkuQZnaxmjPU9bRB2CDWt\" data-type=\"URL\" data-id=\"https:\/\/www.youtube.com\/watch?v=tui3J5YxFCE&amp;list=PL8y0jzNQmUDUUkuQZnaxmjPU9bRB2CDWt\" target=\"_blank\">Php Basics Tutorial<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/www.youtube.com\/watch?v=4iPq2K4jMZI&amp;list=PL8y0jzNQmUDU4jlMAU0oUOKXbIp6euDCt\" data-type=\"URL\" data-id=\"https:\/\/www.youtube.com\/watch?v=4iPq2K4jMZI&amp;list=PL8y0jzNQmUDU4jlMAU0oUOKXbIp6euDCt\" target=\"_blank\" rel=\"noreferrer noopener\">Php Advanced Tutorial<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/www.youtube.com\/watch?v=uf7eL2X8rlM&amp;t=8588s\">Php CRUD Application &#8211; How to Create Website Using Php &#8211; YouTube<\/a><\/p>\n\n\n\n<p><a rel=\"noreferrer noopener\" href=\"https:\/\/youtube.com\/playlist?list=PL8y0jzNQmUDWt3y6BGnqdO1zch8wshNeU\" data-type=\"URL\" data-id=\"https:\/\/youtube.com\/playlist?list=PL8y0jzNQmUDWt3y6BGnqdO1zch8wshNeU\" target=\"_blank\">Javascript Tutorial in Hindi<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/youtube.com\/playlist?list=PL8y0jzNQmUDWNqHiuJId9Oql_0qH5YzC0\" data-type=\"URL\" data-id=\"https:\/\/youtube.com\/playlist?list=PL8y0jzNQmUDWNqHiuJId9Oql_0qH5YzC0\" target=\"_blank\" rel=\"noreferrer noopener\">Javascript Tutorial in English<\/a><\/p>\n\n\n\n<p><strong>Coding standards:<\/strong> <a href=\"https:\/\/codeinsightacademy.com\/blog\/coding-standards.html\">Coding Conventions (codeinsightacademy.com)<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>User management system Description:Create a project for user management. Roles:Admin With correct credentials admin login and see the dashboard.if credentials are wrong he will stay on login page and get a message of wrong credentials. On successful login admin can see users list perform all crud operations. The wireframe for the project UI is as [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/pages\/1124"}],"collection":[{"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/comments?post=1124"}],"version-history":[{"count":9,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/pages\/1124\/revisions"}],"predecessor-version":[{"id":1200,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/pages\/1124\/revisions\/1200"}],"wp:attachment":[{"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/media?parent=1124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}