Add a travel site<\/title> \u00a0 <link\/> \u00a0 <link\/> \u00a0 <link> <\/link><\/head> <body> \u00a0<\/p>\n<nav> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<ul> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Colosseum<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Grand Canal<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Leaning Tower<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Tourist Attraction Sites<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Common Sites<\/a> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\n<li><a>Signup<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Contact me<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/li>\n<\/ul>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/nav>\n<p> \u00a0 <\/p>\n<div> \u00a0 \u00a0 <\/p>\n<div> \u00a0 \u00a0 \u00a0 <\/p>\n<h1>Add tourist attraction site<\/h1>\n<p> \u00a0 \u00a0 <\/p><\/div>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <?php \u00a0 \u00a0 if($_POST){ \u00a0 \u00a0 \u00a0 \u00a0 include 'config\/database.php'; \u00a0 \u00a0 \u00a0 \u00a0 try{ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $query = \"INSERT INTO traveltbl SET site=:site, city=:city, country=:country\"; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $stmt = $con->prepare($query); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \/\/ posted values \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $site=htmlspecialchars(strip_tags($_POST[‘site’])); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $city=htmlspecialchars(strip_tags($_POST[‘city’])); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $country=htmlspecialchars(strip_tags($_POST[‘country’])); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \/\/binding the parameters \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $stmt->bindParam(‘:site’, $site); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $stmt->bindParam(‘:city’, $city); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $stmt->bindParam(‘:country’, $country); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 if($stmt->execute()) { \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 echo “<\/p>\n<div>Site record was saved successfully.<\/div>\n<p>“; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 }else{ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 echo “<\/p>\n<div>Unable to save the site record.<\/div>\n<p>“; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 } \u00a0 \u00a0 \u00a0 \u00a0 }catch(PDOException $exception){ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 die(‘ERROR: ‘ .$exception->getMessage()); \u00a0 \u00a0 \u00a0 \u00a0 } \u00a0 \u00a0 } \u00a0 \u00a0 ?> \u00a0 \u00a0 <\/p>\n<form>” method=”post”> \u00a0 \u00a0 \u00a0 <\/p>\n<table> \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<tr> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td>Attraction Site<\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td><input\/><\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/tr>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<tr> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td>City<\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td><input\/><\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/tr>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<tr> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td>Country<\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td><input\/><\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/tr>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<tr> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td><\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<input\/> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<a>Back to All Sites<\/a> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/tr>\n<p> \u00a0 \u00a0 \u00a0 <\/table>\n<p> \u00a0 \u00a0 <\/p><\/form>\n<p> \u00a0 <\/p><\/div>\n<p> \u00a0 <script><\/script> \u00a0 <script><\/script> <\/body> <\/html> 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. <!DOCTYPE html><br \/>\n <html> <head> \u00a0 \u00a0<meta\/> \u00a0 \u00a0<meta\/> \u00a0 \u00a0<title>Update a record<\/title> \u00a0 \u00a0<link> \u00a0 \u00a0<link\/> \u00a0 \u00a0<link\/> <\/link><\/head> <body> \u00a0 <\/p>\n<nav> \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<ul> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Colosseum<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Grand Canal<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Leaning Tower<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Tourist Attraction Sites<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Common Sites<\/a> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\n<li><a>Signup<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Contact me<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/li>\n<\/ul>\n<p> \u00a0 \u00a0 <\/nav>\n<p> \u00a0 \u00a0 <\/p>\n<div> \u00a0 \u00a0 \u00a0 \u00a0<\/p>\n<div> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<h1>Update a site<\/h1>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<\/p><\/div>\n<p> \u00a0 \u00a0 \u00a0 \u00a0<?php \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $id=isset($_GET['id']) ? $_GET['id'] : die('ERROR: Record ID is not found.'); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 include 'config\/database.php'; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 try{ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$query = \"SELECT id, site, city, country FROM traveltbl WHERe id = ? LIMIT 0,1\"; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$stmt = $con->prepare($query); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$stmt->bindParam(1, $id); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$stmt->execute(); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$row = $stmt->fetch(PDO::FETCH_ASSOC); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$site = $row[‘site’]; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$city = $row[‘city’]; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$country = $row[‘country’]; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 }catch(PDOException $exception){ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 die(‘ERROR: ‘ .$exception->getMessage()); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 } \u00a0 \u00a0 \u00a0 \u00a0?> \u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<?php \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 if($_POST){ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 try{ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$query = \"UPDATE traveltbl SET site=:site, city=:city, country=:country WHERE id = :id\"; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$stmt = $con->prepare($query); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$site=htmlspecialchars(strip_tags($_POST[‘site’])); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$city=htmlspecialchars(strip_tags($_POST[‘city’])); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$country=htmlspecialchars(strip_tags($_POST[‘country’])); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$stmt->bindParam(‘:site’, $site); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$stmt->bindParam(‘:city’, $city); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$stmt->bindParam(‘:country’, $country); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$stmt->bindParam(‘:id’, $id); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0if($stmt->execute()) { \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0echo “<\/p>\n<div>Record was updated successfully.<\/div>\n<p>“; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0}else{ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0echo “<\/p>\n<div>Unable to update the record.<\/div>\n<p>“; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0} \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 }catch(PDOException $exception){ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 die(‘ERROR: ‘ . $exception->getMessage()); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 } \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 } \u00a0 \u00a0 \u00a0 \u00a0 ?> \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<form>” method=”post”> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<table> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<tr> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td>Site<\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td><input\/><\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/tr>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<tr> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td>City<\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td><input\/><\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/tr>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<tr> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td>Country<\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td><input\/><\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/tr>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<tr> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<\/p>\n<td><\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<\/p>\n<td> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<input\/> \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<a>Back to all tourist sites<\/a> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/tr>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/table>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/p><\/form>\n<p> \u00a0 \u00a0 <\/p><\/div>\n<p> \u00a0 \u00a0 <script><\/script> \u00a0 \u00a0 <script><\/script> \u00a0 <\/body> <\/html> 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. <!DOCTYPE html><br \/>\n <html> <head> \u00a0 <meta\/> \u00a0 <meta\/> \u00a0 <link> \u00a0 <link\/> \u00a0 <link\/> \u00a0 <title>Read One Record<\/title> <\/link><\/head> <body> \u00a0 <\/p>\n<nav> \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<ul> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Colosseum<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Grand Canal<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Leaning Tower<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Tourist Attraction Sites<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Common Sites<\/a> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\n<li><a>Signup<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Contact me<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/li>\n<\/ul>\n<p> \u00a0 \u00a0 <\/nav>\n<p> \u00a0 \u00a0 <\/p>\n<div> \u00a0 \u00a0 \u00a0 <\/p>\n<div> \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<h1>Read Tourist Site<\/h1>\n<p> \u00a0 \u00a0 \u00a0 <\/p><\/div>\n<p> \u00a0 \u00a0 \u00a0 <?php \u00a0 \u00a0 \u00a0 \u00a0 $id=isset($_GET['id']) ? $_GET['id'] : die('ERROR: Record ID nor found.'); \u00a0 \u00a0 \u00a0 \u00a0 include 'config\/database.php'; \u00a0 \u00a0 \u00a0 \u00a0 try{ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $query = \"SELECT id, site, city, country FROM traveltbl WHERE id = ? LIMIT 0,1\"; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $stmt = $con->prepare($query); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $stmt->bindParam(1, $id); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $stmt->execute(); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $row = $stmt->fetch(PDO::FETCH_ASSOC); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $site = $row[‘site’]; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $city = $row[‘city’]; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $country = $row[‘country’]; \u00a0 \u00a0 \u00a0 \u00a0 }catch(PDOException $exception){ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 die(‘ERROR: ‘ .$exception->getMessage()); \u00a0 \u00a0 \u00a0 \u00a0 } \u00a0 \u00a0 \u00a0 ?> \u00a0 \u00a0 \u00a0 <\/p>\n<table> \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<tr> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td>Site<\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td><?php echo htmlspecialchars($site, ENT_QUOTES); ?><\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/tr>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<tr> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td>City<\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td><?php echo htmlspecialchars($city, ENT_QUOTES); ?><\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/tr>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<tr> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td>Country<\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td><?php echo htmlspecialchars($country, ENT_QUOTES); ?><\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/tr>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<tr> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td><\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <a>Back to all Attraction Sites<\/a> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/tr>\n<p> \u00a0 \u00a0 \u00a0 <\/table>\n<p> \u00a0 \u00a0 <\/p><\/div>\n<p> \u00a0 \u00a0 <script><\/script> \u00a0 \u00a0 <script><\/script> <\/body> <\/html> I also added the delete.php page which deals with the deletion of a record. The following code is for the delete.php. <?php \u00a0 include 'config\/database.php'; \u00a0 try{ \u00a0 \u00a0 \u00a0 $id=isset($_GET['id']) ? $_GET['id'] : die('ERROR: Record ID not found'); \u00a0 \u00a0 \u00a0 $query = \"DELETE FROM traveltbl WHERE id = ?\"; \u00a0 \u00a0 \u00a0 $stmt = $con->prepare($query); \u00a0 \u00a0 \u00a0 $stmt->bindParam(1, $id); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 if($stmt->execute()) { \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 header(‘Location: attractionsites.php?action=deleted’); \u00a0 \u00a0 \u00a0 }else{ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 die(‘Unable to delete record’); \u00a0 \u00a0 \u00a0 } \u00a0 }catch(PODException $exception){ \u00a0 \u00a0 \u00a0die(‘ERROR: ‘ . $exception->getMessage()); \u00a0 } ?> 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.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>please see the attached question file please see the attached question file Fall 202 2 CIS 525 HW 10 \u2013 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 \u2022 The main task is […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_joinchat":[]},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/283314"}],"collection":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/comments?post=283314"}],"version-history":[{"count":0,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/283314\/revisions"}],"wp:attachment":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/media?parent=283314"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/categories?post=283314"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/tags?post=283314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

\n please see the attached question file\n <\/p>\n<\/div>\n

please see the attached question file
\n Fall 202 2 CIS 525 HW 10 \u2013 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 \u2022 The main task is to prove that you can pu blish (depl oy) your website from your local to the public domain. \u2022 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) \u2013include 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 \u2013 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 \u2026.) GitHub or other public site : Include Public URL and make sure I and Ni ha have access to this. Homework Summary: ( 100 \u2013 200 words): learning topics from this HW
\nplease see the attached question file
\n 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 \u201cCreate New Tourist Site\u201d 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 \u201cSave Site\u201d 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 \u201cdelete\u201d button depicted in the following screenshot. After clicking the \u201cDelete\u201d button, we will get a message asking us whether we are you about deleting the record. The following screenshot shows this. After clicking \u201cOK\u201d 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 \u201cNetherlands\u201d 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 \u201cNetherlands\u201d 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.
\n \u00a0 \u00a0 \u00a0 Add a travel site<\/title> \u00a0 <link\/> \u00a0 <link\/> \u00a0 <link> <\/link><\/head> <body> \u00a0<\/p>\n<nav> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<ul> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Colosseum<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Grand Canal<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Leaning Tower<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Tourist Attraction Sites<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Common Sites<\/a> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\n<li><a>Signup<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Contact me<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/li>\n<\/ul>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/nav>\n<p> \u00a0 <\/p>\n<div> \u00a0 \u00a0 <\/p>\n<div> \u00a0 \u00a0 \u00a0 <\/p>\n<h1>Add tourist attraction site<\/h1>\n<p> \u00a0 \u00a0 <\/p><\/div>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <?php \u00a0 \u00a0 if($_POST){ \u00a0 \u00a0 \u00a0 \u00a0 include 'config\/database.php'; \u00a0 \u00a0 \u00a0 \u00a0 try{ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $query = \"INSERT INTO traveltbl SET site=:site, city=:city, country=:country\"; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $stmt = $con->prepare($query); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \/\/ posted values \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $site=htmlspecialchars(strip_tags($_POST[‘site’])); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $city=htmlspecialchars(strip_tags($_POST[‘city’])); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $country=htmlspecialchars(strip_tags($_POST[‘country’])); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \/\/binding the parameters \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $stmt->bindParam(‘:site’, $site); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $stmt->bindParam(‘:city’, $city); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $stmt->bindParam(‘:country’, $country); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 if($stmt->execute()) { \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 echo “<\/p>\n<div>Site record was saved successfully.<\/div>\n<p>“; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 }else{ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 echo “<\/p>\n<div>Unable to save the site record.<\/div>\n<p>“; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 } \u00a0 \u00a0 \u00a0 \u00a0 }catch(PDOException $exception){ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 die(‘ERROR: ‘ .$exception->getMessage()); \u00a0 \u00a0 \u00a0 \u00a0 } \u00a0 \u00a0 } \u00a0 \u00a0 ?> \u00a0 \u00a0 <\/p>\n<form>” method=”post”> \u00a0 \u00a0 \u00a0 <\/p>\n<table> \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<tr> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td>Attraction Site<\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td><input\/><\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/tr>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<tr> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td>City<\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td><input\/><\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/tr>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<tr> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td>Country<\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td><input\/><\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/tr>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<tr> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td><\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<input\/> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<a>Back to All Sites<\/a> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/tr>\n<p> \u00a0 \u00a0 \u00a0 <\/table>\n<p> \u00a0 \u00a0 <\/p><\/form>\n<p> \u00a0 <\/p><\/div>\n<p> \u00a0 <script><\/script> \u00a0 <script><\/script> <\/body> <\/html> 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. <!DOCTYPE html><br \/>\n <html> <head> \u00a0 \u00a0<meta\/> \u00a0 \u00a0<meta\/> \u00a0 \u00a0<title>Update a record<\/title> \u00a0 \u00a0<link> \u00a0 \u00a0<link\/> \u00a0 \u00a0<link\/> <\/link><\/head> <body> \u00a0 <\/p>\n<nav> \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<ul> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Colosseum<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Grand Canal<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Leaning Tower<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Tourist Attraction Sites<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Common Sites<\/a> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\n<li><a>Signup<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Contact me<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/li>\n<\/ul>\n<p> \u00a0 \u00a0 <\/nav>\n<p> \u00a0 \u00a0 <\/p>\n<div> \u00a0 \u00a0 \u00a0 \u00a0<\/p>\n<div> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<h1>Update a site<\/h1>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<\/p><\/div>\n<p> \u00a0 \u00a0 \u00a0 \u00a0<?php \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $id=isset($_GET['id']) ? $_GET['id'] : die('ERROR: Record ID is not found.'); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 include 'config\/database.php'; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 try{ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$query = \"SELECT id, site, city, country FROM traveltbl WHERe id = ? LIMIT 0,1\"; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$stmt = $con->prepare($query); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$stmt->bindParam(1, $id); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$stmt->execute(); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$row = $stmt->fetch(PDO::FETCH_ASSOC); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$site = $row[‘site’]; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$city = $row[‘city’]; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$country = $row[‘country’]; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 }catch(PDOException $exception){ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 die(‘ERROR: ‘ .$exception->getMessage()); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 } \u00a0 \u00a0 \u00a0 \u00a0?> \u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<?php \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 if($_POST){ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 try{ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$query = \"UPDATE traveltbl SET site=:site, city=:city, country=:country WHERE id = :id\"; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$stmt = $con->prepare($query); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$site=htmlspecialchars(strip_tags($_POST[‘site’])); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$city=htmlspecialchars(strip_tags($_POST[‘city’])); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$country=htmlspecialchars(strip_tags($_POST[‘country’])); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$stmt->bindParam(‘:site’, $site); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$stmt->bindParam(‘:city’, $city); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$stmt->bindParam(‘:country’, $country); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$stmt->bindParam(‘:id’, $id); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0if($stmt->execute()) { \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0echo “<\/p>\n<div>Record was updated successfully.<\/div>\n<p>“; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0}else{ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0echo “<\/p>\n<div>Unable to update the record.<\/div>\n<p>“; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0} \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 }catch(PDOException $exception){ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 die(‘ERROR: ‘ . $exception->getMessage()); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 } \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 } \u00a0 \u00a0 \u00a0 \u00a0 ?> \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<form>” method=”post”> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<table> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<tr> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td>Site<\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td><input\/><\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/tr>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<tr> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td>City<\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td><input\/><\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/tr>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<tr> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td>Country<\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td><input\/><\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/tr>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<tr> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<\/p>\n<td><\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<\/p>\n<td> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<input\/> \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<a>Back to all tourist sites<\/a> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/tr>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/table>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/p><\/form>\n<p> \u00a0 \u00a0 <\/p><\/div>\n<p> \u00a0 \u00a0 <script><\/script> \u00a0 \u00a0 <script><\/script> \u00a0 <\/body> <\/html> 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. <!DOCTYPE html><br \/>\n <html> <head> \u00a0 <meta\/> \u00a0 <meta\/> \u00a0 <link> \u00a0 <link\/> \u00a0 <link\/> \u00a0 <title>Read One Record<\/title> <\/link><\/head> <body> \u00a0 <\/p>\n<nav> \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<ul> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Colosseum<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Grand Canal<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Leaning Tower<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Tourist Attraction Sites<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Common Sites<\/a> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\n<li><a>Signup<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<li><a>Contact me<\/a><\/li>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/li>\n<\/ul>\n<p> \u00a0 \u00a0 <\/nav>\n<p> \u00a0 \u00a0 <\/p>\n<div> \u00a0 \u00a0 \u00a0 <\/p>\n<div> \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<h1>Read Tourist Site<\/h1>\n<p> \u00a0 \u00a0 \u00a0 <\/p><\/div>\n<p> \u00a0 \u00a0 \u00a0 <?php \u00a0 \u00a0 \u00a0 \u00a0 $id=isset($_GET['id']) ? $_GET['id'] : die('ERROR: Record ID nor found.'); \u00a0 \u00a0 \u00a0 \u00a0 include 'config\/database.php'; \u00a0 \u00a0 \u00a0 \u00a0 try{ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $query = \"SELECT id, site, city, country FROM traveltbl WHERE id = ? LIMIT 0,1\"; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $stmt = $con->prepare($query); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $stmt->bindParam(1, $id); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $stmt->execute(); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $row = $stmt->fetch(PDO::FETCH_ASSOC); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $site = $row[‘site’]; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $city = $row[‘city’]; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $country = $row[‘country’]; \u00a0 \u00a0 \u00a0 \u00a0 }catch(PDOException $exception){ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 die(‘ERROR: ‘ .$exception->getMessage()); \u00a0 \u00a0 \u00a0 \u00a0 } \u00a0 \u00a0 \u00a0 ?> \u00a0 \u00a0 \u00a0 <\/p>\n<table> \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<tr> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td>Site<\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td><?php echo htmlspecialchars($site, ENT_QUOTES); ?><\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/tr>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<tr> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td>City<\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td><?php echo htmlspecialchars($city, ENT_QUOTES); ?><\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/tr>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<tr> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td>Country<\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td><?php echo htmlspecialchars($country, ENT_QUOTES); ?><\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/tr>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<tr> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td><\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/p>\n<td> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <a>Back to all Attraction Sites<\/a> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/td>\n<p> \u00a0 \u00a0 \u00a0 \u00a0 <\/tr>\n<p> \u00a0 \u00a0 \u00a0 <\/table>\n<p> \u00a0 \u00a0 <\/p><\/div>\n<p> \u00a0 \u00a0 <script><\/script> \u00a0 \u00a0 <script><\/script> <\/body> <\/html> I also added the delete.php page which deals with the deletion of a record. The following code is for the delete.php. <?php \u00a0 include 'config\/database.php'; \u00a0 try{ \u00a0 \u00a0 \u00a0 $id=isset($_GET['id']) ? $_GET['id'] : die('ERROR: Record ID not found'); \u00a0 \u00a0 \u00a0 $query = \"DELETE FROM traveltbl WHERE id = ?\"; \u00a0 \u00a0 \u00a0 $stmt = $con->prepare($query); \u00a0 \u00a0 \u00a0 $stmt->bindParam(1, $id); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 if($stmt->execute()) { \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 header(‘Location: attractionsites.php?action=deleted’); \u00a0 \u00a0 \u00a0 }else{ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 die(‘Unable to delete record’); \u00a0 \u00a0 \u00a0 } \u00a0 }catch(PODException $exception){ \u00a0 \u00a0 \u00a0die(‘ERROR: ‘ . $exception->getMessage()); \u00a0 } ?> 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.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>please see the attached question file please see the attached question file Fall 202 2 CIS 525 HW 10 \u2013 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 \u2022 The main task is […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_joinchat":[]},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/283314"}],"collection":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/comments?post=283314"}],"version-history":[{"count":0,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/283314\/revisions"}],"wp:attachment":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/media?parent=283314"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/categories?post=283314"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/tags?post=283314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}