please see the attached question file
Fall 202 2 CIS 525 HW 10 – Preparing for Final Project (Step 4) Date last modifie d: 202 2_11_08 Preparation for Final Project: HW 10 – One submission for the entire group. Concepts: Deployment to live server • The main task is to prove that you can pu blish (depl oy) your website from your local to the public domain. • Also you will be including website navigation with Auth , timeout, and redi rection details. Documentation: Submit assignment to Canvas (Assignment 10 ) as Word or PDF and include the following: Student (s) Name and Section Number (s) : One for entire Group Website Navigation : (hierarchy) –include authentication re qu ire d ( yes,no ) and any redirec t, and inactivity . You do n ot have to prove these are working, just the diagram . Website issues – include how you resolved (regarding dep loyment /publishing ) Readme file: Readme file will state the deployment and configuration. How you depl oy, you can modify this later. For no w i nclude the commands( such as install npm ….) GitHub or other public site : Include Public URL and make sure I and Ni ha have access to this. Homework Summary: ( 100 – 200 words): learning topics from this HW
please see the attached question file
Homework 9 Table of Contents Website Navigation 1 Website Issues 2 Summary about CRUD Operations 2 Debug 26 Homework Summary 27 Future Plans 28 Website Navigation I have added a folder called config which contains database.php. I have also added the various files that support our CRUD operations. They are create.php, read_one.php, delete.php, and update.php. Website Issues I did not find any issue while implementing the travel website. The implementation went smoothly as depicted in the next section while showing screenshots of the CRUD operations of the website. Summary about CRUD Operations The website allows creating, reading, updating, deleting of tourist attraction sites from the website. The following screenshot reads all the tourist attraction sites from the database. The page that reads all tourist attraction sites is called attractionsites.php. You can read, edit, and delete each record by using the respective buttons. The following screenshot shows us adding a new record to the database. We will click on the “Create New Tourist Site” button as shown from the above screenshot. The following screenshot shows us a form that will allow us to add a new record. The following screenshot shows us filling the form with our new record and when we are done, we will click on “Save Site” button. The following screenshot shows that our data has been saved successfully. The next screenshot shows our data saved in the database. The following screenshot shows us reading one record, the one that I have created. The next screenshot shows us editing the record that I had created. We will change the country to Netherlands and then show if it is reflected in our database. From the following screenshot we can see that our record has been updated successfully. The following screenshot shows our record in the database. We can also delete data by clicking the “delete” button depicted in the following screenshot. After clicking the “Delete” button, we will get a message asking us whether we are you about deleting the record. The following screenshot shows this. After clicking “OK” the record will be deleted from the database and also removed from the website. The following screenshot shows us the success deletion message. From the above screenshot we can also see that the record that had “Netherlands” as a country has been deleted. The following screenshot shows the same from the database. From the screenshot above we can see that the record that had “Netherlands” as a country and an id of 25 has been removed from the database. I added several pages to our website to deal with CRUD operations. The first page is the create.php page. This page helps in creating a single record. It has a form that facilitates the user to create a record. The following screenshot shows the form and the code.
             

    I also added an update.php page which deals with updating a record. It also has a form where the user can update the selected record. The following screenshot shows the form and the code.
                         

          I also added a read_one.php page which shows a single record that has been selected. The following screenshot shows one record selected and the code follows.
             

        I also added the delete.php page which deals with the deletion of a record. The following code is for the delete.php. prepare($query);       $stmt->bindParam(1, $id);             if($stmt->execute()) {           header(‘Location: attractionsites.php?action=deleted’);       }else{           die(‘Unable to delete record’);       }   }catch(PODException $exception){      die(‘ERROR: ‘ . $exception->getMessage());   } ?> Debug PHP shows errors when they arise, and it also shows the type of error and where it is located. The errors were easy to manage and rectify. The following screenshot shows an error page. From the above screenshot we can see that I have error of undefined variables and I have also been given the lines where they occur for easy troubleshooting. Homework Summary This exercise has helped me to understand CRUD operations and also create a website that communicates with the database. The website is a travel website that shows tourist attraction sites in different countries. The user of the website can now add, delete, and update these sites. The website is inside a folder called Hw9_ksaxena and the database configuration is inside a folder called config. At the root of the website is a Readme file that indicates the deployment and the configuration of the website. Future Plans I intend to work on database integrity in the future where a user cannot register with an existing email etc.