Notes

<?php
//connecting the database
$pdo = new PDO('mysql:dbname=csy2028;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 ($rev_name == '') $error = $error . '<p>name :</p>';
if ($messages == '') $error = $error . '<p> message :</p>';
if ($r_date == '') $error = $error . '<p>date</p> :';
if ($id_pr == '') $error = $error . '<p> product</p> :';


if(empty($error)){
//following code is to insert into the product table
$sql = "INSERT INTO reviewss(rev_name, messages, r_date,id_pr) VALUES(:rev_name, :messages, :r_date,:id_pr)";
$stmt = $pdo ->prepare($sql);
unset($_POST['add']);
//following code is to display when all the reviews are entered
if($stmt ->execute($_POST)) echo '<h2>Review has been added </h2>';
}
else{
echo $error;
}


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

<label>The name of product :</label>
<?php require 'selectpro.php'; ?>
<br><br>
<!-- a button is created -->
<input type="submit" name="add" value="add">
</form>
</div>