Build a Website

Project 1 Create a PHP form that allows input for an individual and displays the information on a subsequent page upon submission. The form should include a drop down field with each family or friend from the tree assignment and fields that match the web pages for each individual in the family or friend tree assignment. For example, fields could include career, favorite book, and interests. Use proper form validation. Upon submission of the form, the user should be transferred to the appropriate individual’s web page based upon the drop down selection. The web page of each friend or family member should now display updated results from the information entered into the form. For example, if a new goal was written in the goals field on the form, it should be appended to the goal’s section of the family or friend’s page. Project 2 In order to prevent unauthorized access to the family or friend tree, develop a login page that fronts these pages and requires a session for their viewing. Allow the username “test at yourdomainname dot com” and password “thisisonlyatest” to successfully login to the website. Create a proper session for this user upon authentication. Each page of the family tree should require a session to be set. If no session exists, the user should be given a message indicating they are not authenticated and be automatically redirected to the login page. Use a template to accomplish this. Proper form validation should be used and special characters for the password field that disallow bystanders from seeing the password. In addition, if a session exists the footer of each web page should have a logout link. When the logout link is clicked, the user should be asked to confirm or cancel their logout. Once confirmed, the session should be destroyed. Create a MySQL database on your web host named your first name and last name. Exclude any spaces; use one word such as “yourfirstnameyourlastname.” Create a table named “comments.” In the “comments” table, create the fields ID, name, title, comments, and comment date. Use the proper field types and allow comments to be over 100 characters. Comment date should be a timestamp field that is automatically updated with the current timestamp when a new record is inserted into the table. ID should be the primary key and auto increment. Develop a connection script that successfully connects to your database. It should use the MySQL_error() function appropriately to test whether a successful connection exists. Upon successful authentication to the tree page, a user should be given a new link to a new form. The form should have a name, title, and a comment field. Proper form validation should exist. Upon form submission, the name, title, and comment data should be inserted into the associated fields in the comments database table. Write an SQL select statement against the comments table in your database and display each row properly formatted on the main tree page. The most recent comment should be displayed first. All user comments should display under the tree like: Name of the person who made the comment Title Date Comments Write update and delete statements that allow comments to be updated and removed. Upon completion, comments can be added, updated, and removed from the database via the web page. All other required information is available. Most of the work is already done but I am unable to make it work correctly. Need some help on these assignments.