<?php
include 'dbconnection.php';

$sno = $_POST['sno'];
$date = $_POST['date'];
$name = $_POST['name'];
$mobile = $_POST['mobile'];
$email = $_POST['email'];
$designation = $_POST['designation'];
$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'];

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



$sql="UPDATE leads set date='$date',
name='$name',mobile='$mobile',email='$email',designation='$designation',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',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)
?> 