Notes

<?php
session_start();//session gets started
require 'ad_header.php';//header is called and is shown at the top of the page
$log= new PDO('mysql:dbname=assignment;host=localhost', 'root','root');

//updating and setting the name of the category
if(isset($_POST['edits'])){
$sub =$log->prepare("UPDATE table_category SET c_name=:c_name WHERE c_id =:c_id");
$case=[
'c_id' =>$_POST['c_id'],
'c_name' =>$_POST['new_name']
];
//if executed and if the edit button pressed then the location is set to display category
if($sub->execute($case)){
header('Location: ad_discategory.php');
}
}

//selcting id from the category table
if(isset($_GET['c_id'])){
$sub =$log->prepare("SELECT * FROM table_category WHERE c_id =:c_id");
$sub->execute($_GET);
$catg = $sub->fetch();
}
?>
<main>
<!-- title is set -->
<h4>Edit category name</h4>
<!-- form has been started by using post method -->
<form action="" method="POST">
<!-- id of category has been get -->
<input type="hidden" name="c_id" value ="<?php echo $_GET['c_id']?>">
<input type="text" name="new_name" value="<?php echo $catg['c_name']?>">
<!-- button for the edit category -->
<input type="submit" name="edits" value="edits">
<button <input type="submit" name="edcat" value="edit"><a href="ad_discategory.php">Go to category display</a></button>
</form>
</main>