<?php
include 'Database/config.php';

if (isset($_POST['submit'])) {
	$cid = $_GET['id'];
 $cust_name = mysqli_real_escape_string($conn, $_POST['cust_name']);
 $cust_address = mysqli_real_escape_string($conn, $_POST['cust_address']);
 $cust_no = mysqli_real_escape_string($conn, $_POST['cust_no']);
 $cust_mail = mysqli_real_escape_string($conn, $_POST['cust_mail']);
 $purchase_date = mysqli_real_escape_string($conn, $_POST['purchase_date']);
 $model_name = mysqli_real_escape_string($conn, $_POST['model_name']);
 $install_date = mysqli_real_escape_string($conn, $_POST['install_date']);
 $service = mysqli_real_escape_string($conn, $_POST['service']);
 


$sql = "SELECT * FROM customers WHERE cust_mail ='{$cust_mail}'";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) >0 ) {
 $error = "<p>Customer already Exist.</p>";
}else{
  $sql1 = "UPDATE `customers` SET `cust_name`='{$cust_name}',`cust_address`='{$cust_address}',`cust_ph`='{$cust_no}',`cust_mail`='{$cust_mail}',`cust_pdate`='{$purchase_date}',`cust_model`='{$model_name}',`cust_insdate`='{$install_date}',`cust_service`='{$service}' WHERE id = '{$cid}'";
  if (mysqli_query($conn, $sql1)) {
    header('location:dashboard.php');
  }else{
    echo "Customer not Updated";
  }
  
}

}
?>