How can I allow new content to be created, modified, and removed from your website via a database?

User Generated

wpunzc

Programming

Description

Phase II builds upon phase I of the project. Phase I is now database driven and should allow new content to be created, modified, and removed from your website via a database. Thus, develop a content management system (CMS) to manage the company website developed in Part 1. The CMS should store most of the website’s content in a database. Primary content on each page should be able to be added, updated, and removed from the CMS management interface. The CMS must meet the following requirements: 1. Review the grading rubric for more details on exactly how your website will be assessed. 2. A biblical worldview must be reflected on the website. There are many creative and unique ways to do this. 3. In order to meet its online goals, the company has determined a minimum of 15 pages are necessary. Some of the original pages from Part 1 may exist; however, content on many of these pages will now be database driven. 4. The website should clearly describe the vision, goals, and objectives of the company. Examples of pages could be “about us,” “mission,” “facts,” and/or “biographies.” 5. The website should use the PHP “include” and/or “require” function to allow easy management. a. Header.php containing the initial header development b. Menu.php containing the navigation for the website c. Footer.php containing W3C validation icons for XHTML & CSS and a timestamp of the last time the PHP file was modified i. Strict W3C XHTML and CSS are expected. Every page should exhibit the links to check compliance from http://www.w3.org. ii. Each page of the website should use a proper PHP function to show the date of last modification. 6. Web usability should be considered on every aspect of the design and implementation. The website should be centrally managed and use a single CSS style sheet to modify headings, paragraphs, font, and other styles. Navigation should be simple and follow an F-design or similar optimal navigation scheme. 7. A MySQL or MariaDB and/or SQL database should be created and named after the company. The database should store the website’s primary content. a. Do not forget to include the database script in your zip file for grading! 8. Create separate database tables to store the data for each individual project requirement. a. For example, a user’s table should store first name, last name, username, and email address for the login functionality to work. b. In addition, a login timestamp should exist. Each table should be designed to store sufficient information for the business strategy to be successful. CSIS 410 Page 5 of 5 c. Every table requires a unique ID. Make this unique ID auto_incremement in phpmyadmin. This will disallow you from having to determine the next ID for the next row that needs to be inserted into your table. 9. Account management must be developed to give at least three levels of access 1) customer, 2) publisher, and 3) administrator. The original login functionality can be used from Part 1, but it must now be database driven. All account information should be stored in a user’s table. a. Customers can add, update, or remove products/services in their shopping cart b. Publishers can add and modify text on the website c. Administrators can add, modify, and delete text on the website d. The username and password should match this exactly: i. Username = “admin” Password = “admin” (without the parentheses I should be able to login with admin admin) ii. “publisher” “publisher” for the publisher account iii. “customer” “customer” for the customer account 10. Create a fully functional checkout process and/or shopping cart solution similar to what exists on Amazon.com or Walmart.com where users can add, update, and delete products or services for purchase. a. Users should get the total price before checking out including calculated taxes b. Customers should be allowed to add, update, and remove items from the shopping cart. c. A table should be created that stores the products/services and a table should be created that stores the items in the user shopping cart. d. The shopping cart should be professional and navigation should be easy throughout. 11. Publishers should be allowed to add and modify content for at least two sections of the website such as the store / e-commerce solution, home page, blog, forum, and/or other justifiable service. 12. Administrators should be allowed to add, modify, and delete content for at least two sections of the website such as the store / e-commerce solution, home page, blog, forum, and/or other justifiable service. In addition, they should be able to add and remove users for the account management solution.

Unformatted Attachment Preview

Phase II builds upon phase I of the project. Phase I is now database driven and should allow new content to be created, modified, and removed from your website via a database. Thus, develop a content management system (CMS) to manage the company website developed in Part 1. The CMS should store most of the website’s content in a database. Primary content on each page should be able to be added, updated, and removed from the CMS management interface. The CMS must meet the following requirements: 1. Review the grading rubric for more details on exactly how your website will be assessed. 2. A biblical worldview must be reflected on the website. There are many creative and unique ways to do this. 3. In order to meet its online goals, the company has determined a minimum of 15 pages are necessary. Some of the original pages from Part 1 may exist; however, content on many of these pages will now be database driven. 4. The website should clearly describe the vision, goals, and objectives of the company. Examples of pages could be “about us,” “mission,” “facts,” and/or “biographies.” 5. The website should use the PHP “include” and/or “require” function to allow easy management. a. Header.php containing the initial header development b. Menu.php containing the navigation for the website c. Footer.php containing W3C validation icons for XHTML & CSS and a timestamp of the last time the PHP file was modified i. Strict W3C XHTML and CSS are expected. Every page should exhibit the links to check compliance from http://www.w3.org. ii. Each page of the website should use a proper PHP function to show the date of last modification. 6. Web usability should be considered on every aspect of the design and implementation. The website should be centrally managed and use a single CSS style sheet to modify headings, paragraphs, font, and other styles. Navigation should be simple and follow an F-design or similar optimal navigation scheme. 7. A MySQL or MariaDB and/or SQL database should be created and named after the company. The database should store the website’s primary content. a. Do not forget to include the database script in your zip file for grading! 8. Create separate database tables to store the data for each individual project requirement. a. For example, a user’s table should store first name, last name, username, and email address for the login functionality to work. b. In addition, a login timestamp should exist. Each table should be designed to store sufficient information for the business strategy to be successful. CSIS 410 Page 5 of 5 c. Every table requires a unique ID. Make this unique ID auto_incremement in phpmyadmin. This will disallow you from having to determine the next ID for the next row that needs to be inserted into your table. 9. Account management must be developed to give at least three levels of access 1) customer, 2) publisher, and 3) administrator. The original login functionality can be used from Part 1, but it must now be database driven. All account information should be stored in a user’s table. a. Customers can add, update, or remove products/services in their shopping cart b. Publishers can add and modify text on the website c. Administrators can add, modify, and delete text on the website d. The username and password should match this exactly: i. Username = “admin” Password = “admin” (without the parentheses I should be able to login with admin admin) ii. “publisher” “publisher” for the publisher account iii. “customer” “customer” for the customer account 10. Create a fully functional checkout process and/or shopping cart solution similar to what exists on Amazon.com or Walmart.com where users can add, update, and delete products or services for purchase. a. Users should get the total price before checking out including calculated taxes b. Customers should be allowed to add, update, and remove items from the shopping cart. c. A table should be created that stores the products/services and a table should be created that stores the items in the user shopping cart. d. The shopping cart should be professional and navigation should be easy throughout. 11. Publishers should be allowed to add and modify content for at least two sections of the website such as the store / e-commerce solution, home page, blog, forum, and/or other justifiable service. 12. Administrators should be allowed to add, modify, and delete content for at least two sections of the website such as the store / e-commerce solution, home page, blog, forum, and/or other justifiable service. In addition, they should be able to add and remove users for the account management solution. CSIS 410 CMS PROJECT: PART 2 GRADING RUBRIC Novice Web Host Biblical Worldview Content W3C XHTML and CSS Strict Compliance Website Usability Database Tables Competent Proficient 0 points Project must be developed on the student’s web host. 0 to 5 points 6 to 7 points Student makes a minimal Student makes a marginal attempt to integrate a attempt to integrate a biblical biblical worldview into worldview into his/her website his/her website solution. solution. Less than 2 paragraphs of content or pages exist. 8 to 10 points Student makes a strong attempt to integrate a biblical worldview into his/hers website solution. Two or more complete paragraphs or pages exhibit a clear biblical worldview. 0 to 8 points 9 to 11 points 12 to 15 points Inability to meet minimum Minimum of 15 separate web Minimum of 15 separate web page requirements and/or pages comprised of the pages. Every web page meets non-professional website appropriate material outlined in the optimal project content on the required the assignment instructions. requirements. pages. Acceptable requirements were met on most pages. 0 to 5 points 6 to 7 points 8 to 10 points Less than 10 pages W3C Less than 15 pages W3C 15 or more pages W3C compliant and/or do not compliant and/or do not have compliant. have the compliant logos. the compliant logos. 0 to 5 points 6 to 7 points 8 to 10 point Multiple CSS files and/or Multiple CSS files and/or Every page is controlled by varying template styles varying template styles exist the same CSS style sheet exist across more than 5 across more than 1 page. with the same tags for the pages. Five or more Inconsistent menu, header, and same headings. The design inconsistent menus, header, footer components. template is consistent and/footer components. including the menus, header, and footer. 0 to 2 points 3 to 3 points 4 to 5 points Database not created and/or MySQL database created but A proper MySQL database improperly created. inaccessible or not named created with a proper name appropriately. that aligns with the business and is accessible by PHP. 0 to 5 points 6 to 7 points 8 to 10 points Properly named tables do At least 2 MySQL tables At least 3 MySQL tables not exist and/or are not created with the proper created. Each table is in use usable. columns and field types to and has the proper field types support the data on each and columns to support the database driven website business needs of the component but insufficient website. Unique keys and indexes and unique keys are indices exist on each table. present. Page 1 of 2 CSIS 410 Account Management Customer CMS 0 to 5 points A database driven login page was not constructed and/or it is missing sessions and levels. 6 to 7 points An acceptable database driven login page is working but it is missing 1 or more levels of access and/or it does not use sessions. 8 to 10 points A working database driven login page exists that grants at least 3 levels of access 1) customer 2) publisher 3) administrator. 0 to 23 points Content is not properly stored or retrieved from a database table. 24 to 31 points Some content is stored and/or retrieved from a database table. Customers cannot login properly or can store some items in their shopping cart but not all items. Calculations or removals may not function properly. 24 to 31 points Some content is stored and/or retrieved from a database table. Publishers cannot login properly or cannot add and modify content for at least 1 page. 32 to 40 points All content is stored and retrieved from a database table. Customers can properly login. Customers can store and remove all store items in a shopping cart and calculate their total price. 0 to 23 points Content is not properly stored or retrieved from a Publisher CMS database table. Administrator CMS Last Modified Date Total 32 to 40 points All content is stored and retrieved from a database table. Publishers can properly login. Publishers can add and modify content for the home page and at least 1 other page. 0 to 23 points 24 to 31 points 32 to 40 points Content is not properly Some content is stored and/or All content is stored and stored or retrieved from a retrieved from a database table. retrieved from a database database table. Administrators cannot login table. Administrators can properly or cannot add, properly login. modify, and/or remove content Administrators can add, for at least 1 page. modify, and remove content for the home page and at least 1 other page. 0 to 5 points 6 to 7 points 8 to 10 points Less than 5 pages display a Less than 10 pages display a Every page shows a last last modified date using a last modified date using a modified date using a proper proper PHP function. proper PHP function. PHP function. 200 Points Page 2 of 2
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

please cross check...


Anonymous
Really useful study material!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags