Notes

<?php
//connecting to the database named as csy2028
$pdo = new PDO('mysql:dbname=holidays;host=localhost', 'root', '');
if(isset($_POST['OK'])){
extract($_POST);
//declaring variable
$errors = '';
//the below code is to print the paragraph if the values is not entered
if ($name == '') $errors = $errors . '<p>The name of catagory you want to add :</p>';


if(empty($errors)){
//following code is to insert into the product table
$sql = "INSERT INTO category(name) VALUES(:name)";
$stmt = $pdo ->prepare($sql);
unset($_POST['OK']);
//following code is to display when all the products are entered
if($stmt ->execute($_POST)) echo '<h2>catagory has been added </h2>';
}
else{
echo $errors;
}


}
?>

<h1>Details :</h1>
<!-- create a form -->
<form action="" method="POST">
<label> name of catagory to add :</label><input type="text" name="name"><br><br>
<br><br>
<!-- a button is created -->
<input type="submit" name="OK" value="OK">
</form>
</div>