 <?php
 // Get the product data 
$category_id = $_POST['category_id'];
 $code = $_POST['code'];
 $name = $_POST['name'];
 $price = $_POST['price'];
 
 // Validate inputs
 if (empty($code) || empty($name) || empty($price) ) {
 $error = "Invalid product data. Check all fields and try again."; 
include('error.php');
 } else {
 // If valid, add the product to the database 
reguire_once('database.php');
 $query = "INSERT INTO album
 (artistID, albumCode, albumName, listPrice) 
VALUES
 ('$category_id', '$code', '$name', '$price')"; 
$db->exec($query);
 // Display the Product List page 
include('index.php');
 }
 ?>