error_reporting(E_ALL);
ini_set('display_errors', 1);
include('config.php'); // FIXED: Ensure database connection is included
// Fetch owners for dropdown
$owners_result = $conn->query("SELECT id, name FROM owners");
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$name = $_POST['name'];
$species = $_POST['species'];
$breed = $_POST['breed'];
$neutered = $_POST['neutered'];
$age = $_POST['age'];
$passport_number = $_POST['passport_number'];
$microchip_number = $_POST['microchip_number'];
$owner_id = $_POST['owner_id'];
$sql = "INSERT INTO patients (name, species, breed, neutered, age, passport_number, microchip_number, owner_id)
VALUES (?, ?, ?, ?, ?, ?, ?, ?)";
$stmt = $conn->prepare($sql);
$stmt->bind_param("ssssissi", $name, $species, $breed, $neutered, $age, $passport_number, $microchip_number, $owner_id);
if ($stmt->execute()) {
echo "Patient added successfully!
";
} else {
echo "Error: " . $conn->error . "
";
}
}
?>
Fatal error: Uncaught mysqli_sql_exception: Unknown column 'owner_name' in 'SELECT' in /home/bonownyb/public_html/billing.php:11
Stack trace:
#0 /home/bonownyb/public_html/billing.php(11): mysqli->prepare()
#1 {main}
thrown in /home/bonownyb/public_html/billing.php on line 11