Notes

<!-- code to link the css -->
<link rel="stylesheet" type="text/css" href="main.css">
<?php
//connecting the database
$pdo = new PDO('mysql:dbname=assignment;host=localhost', 'root', '');
if(isset($_POST['add'])){
extract($_POST);
//declaring variable
$error = '';
//the below code is to print the paragraph if the values is not entered
if ($name == '') $error = $error . '<p>please enter your name :</p>';
if ($message == '') $error = $error . '<p>please enter the message :</p>';
if ($message == '') $error = $error . '<p>please enter the message</p> :';
if ($review_date == '') $error = $error . '<p>please enter the review date</p> :';
if ($prod_id == '') $error = $error . '<p>please enter name of product</p> :';


if(empty($error)){
//following code is to insert into the product table
$sql = "INSERT INTO review(name, message, review_date,prod_id) VALUES(:name, :message, :review_date,:prod_id)";
$stmt = $pdo ->prepare($sql);
unset($_POST['add']);
//following code is to display when all the products are entered
if($stmt ->execute($_POST)) echo '<h2>Review added successfully</h2>';
}
else{
echo $error;
}


}
?>
<!-- a div class named as hello is created -->
<div class="hello">
<h1>Please Enter the review of the products :</h1>
<!-- the following code is create a form -->
<form action="" method="POST">
<label>Please Enter your name</label><input type="text" name="name"><br><br>
<label>Please enter your message :</label><input type="text" name="message"><br><br>
<label>Please Enter reviewed date:</label><input type="date" name="review_date"><br><br>

<label>The name of product you want to review of :</label>
<select name="prod_id">
<?php
//code to select all the things from table
$stmt=$pdo->prepare("SELECT * FROM products");
$stmt->execute();
foreach ($stmt as $row ) {?>
<!-- displaying all the product category from id of category -->
<option value="<?php echo $row['prod_id'];?>"> <?php echo $row['prod_name']; ?></option>
<?php }
?>
}
</select>
<br><br>
<!-- a button is created -->
<input type="submit" name="add" value="add">
</form>
</div>