1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / nagarajan /
Filename : form2.php
back
  <?php
  session_start();
include "dp.php";
//include("menu.php");
//if(isset($_POST['geetha']))
{
//session_start();
$id=$_POST['id'];

$name=$_POST['name'];
$residing_at=$_POST['residing_at'];
$rupees=$_POST['rupees'];
$date=date("Y-m-d",strtotime($_POST['date']));
$amount=$_POST['amount'];
$interest=$_POST['interest'];
$mode=$_POST['mode'];
$maturity_value=$_POST['maturity_value'];
$due_date=date("Y-m-d",strtotime($_POST['due_date']));
$within=$_POST['within'];
$month_on=$_POST['month_on'];
$nominees=$_POST['nominees'];
$c_payment=$_POST['c_payment'];
$pbac=$_POST['pbac'];
$pa=$_POST['pa'];
$rupees_words=$_POST['rupees_words'];

/*$created_by = $_SESSION['librarian_name'];
date_default_timezone_set("Asia/Kolkata");
$created_time=date('Y-m-d H:i:s');*/


if($id){
	$sql1 = "update geetha set `name`='$name',`residing_at`='$residing_at',`rupees`='$rupees',`date`='$date',`amount`='$amount',`interest`='$interest',`mode`='$mode',`maturity_value`='$maturity_value',`due_date`='$due_date',`within`='$within',`month_on`='$month_on',`nominees`='$nominees',`c_payment`='$c_payment',`pbac`='$pbac',`pa`='$pa',`rupees_words`='$rupees_words' where id = $id";
	
	$result1=$conn->query($sql1);
}else{
  $sql1="insert into geetha(`name`, `residing_at`, `rupees`, `date`,`amount`, `interest`, `mode`, `maturity_value`, `due_date`, `within`, `month_on`, `nominees`, `c_payment`, `pbac`, `pa`, `rupees_words`) 
 values('$name','$residing_at','$rupees','$date','$amount','$interest','$mode','$maturity_value','$due_date','$within','$month_on','$nominees','$c_payment','$pbac','$pa','$rupees_words')";
 
 $result2=$conn->insert_id;
 $_SESSION['id'] = $result2;
 $result1=$conn->query($sql1);
}
 
 
 


if($result1)
{
	
	
	header('Location:news_view.php');
	
}	
else
{
	echo "Please check form values";
	echo "<br>";
	echo "<a href='news_update.php'>Back</a>";
}
 
}
 ?>