<?php
$con = mysqli_connect("localhost","root","","example_store");
$sql = "SELECT * FROM `category`";
$all_categories = mysqli_query($con,$sql);
if(isset($_POST['submit']))
{
$name = mysqli_real_escape_string($con,$_POST['Product_name']);
$id = mysqli_real_escape_string($con,$_POST['Category']);
$sql_insert =
"INSERT INTO `product`(`product_name`, `category_id`)
VALUES ('$name','$id')";
if(mysqli_query($con,$sql_insert))
{
echo '<script>alert("Product added successfully")</script>';
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport"
content="width=device-width, initial-scale=1.0">
</head>
<body>
<form method="POST">
<label>Name of Product:</label>
<input type="text" name="Product_name" required><br>
<label>Select a Category</label>
<select name="Category">
<?php
while ($category = mysqli_fetch_array(
$all_categories,MYSQLI_ASSOC)):;
?>
<option value="<?php echo $category["Category_ID"];
?>">
<?php echo $category["Category_Name"];
?>
</option>
<?php
endwhile;
?>
</select>
<br>
<input type="submit" value="submit" name="submit">
</form>
<br>
</body>
</html>
