<?php
include 'dbconnection.php';

$sno = $_POST['sno'];
$date = $_POST['date'];
$name = $_POST['name'];
$mobile = $_POST['mobile'];
$email = $_POST['email'];
$s_person = $_POST['s_person'];
$lead_source = $_POST['lead_source'];
$state = $_POST['state'];
$district = $_POST['district'];

$school_name = $_POST['school_name'];
$school_type = $_POST['school_type'];
$establishment_year = $_POST['establishment_year'];
$school_address = $_POST['school_address'];
$affiliation = $_POST['affiliation'];

$udise = $_POST['udise'];
$students = $_POST['students'];
$potential = $_POST['potential'];
$lead_status = $_POST['lead_status'];
$products_signed = $_POST['products_signed'];

$total_signed = $_POST['total_signed'];
$remark = $_POST['remark'];
$payment_date = $_POST['payment_date'];
$signup_amount = $_POST['signup_amount'];
$payment_mode = $_POST['payment_mode'];

$payment_id = $_POST['payment_id'];
$payment_remark = $_POST['payment_remark'];
$school_wsu = $_POST['school_wsu'];
$implementation_fees = $_POST['implementation_fees'];
$customisation_fees = $_POST['customisation_fees'];

$subscription_fees = $_POST['subscription_fees'];
$gst = $_POST['gst'];
$training_fees = $_POST['training_fees'];

$source = $_POST['source'];
$assign_by = $_POST['assign_by'];



$sql="UPDATE leads set date='$date',
name='$name',mobile='$mobile',email='$email',s_person='$s_person',lead_source='$lead_source',state='$state',district='$district',school_name='$school_name',school_type='$school_type',establishment_year='$establishment_year',school_address='$school_address',affiliation='$affiliation',udise='$udise',students='$students',potential='$potential',lead_status='$lead_status',products_signed='$products_signed',total_signed='$total_signed',remark='$remark',payment_date='$payment_date',signup_amount='$signup_amount',payment_mode='$payment_mode',payment_id='$payment_id',payment_remark='$payment_remark',school_wsu='$school_wsu',implementation_fees='$implementation_fees',customisation_fees='$customisation_fees',subscription_fees='$subscription_fees',gst='$gst',training_fees='$training_fees',source='$source',assign_by='$assign_by' WHERE  sno='$sno' ";	


if (!mysqli_query($conn,$sql))
  {
  die('Error: ' . mysqli_error());
  }
else {
header("location: ../view_leads?status=1");
}
mysqli_close($conn)
?> 