Viewing file:  loannewform.php (876 B) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
$con=mysqli_connect("localhost","sarkmicr_user","rb!sar838","sarkmicr_data");
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$pamount=($_POST[lamount])*2.50/100;
$sql="INSERT INTO microfianceloan (pname,groupname,fname,address,mobile,idno,addprof,ramount, lamount,pamount,fdate,sndate,branchname)
VALUES ('$_POST[pname]', '$_POST[q]','$_POST[fname]','$_POST[address]','$_POST[mobile]','$_POST[idno]','$_POST[addprof]','$_POST[ramount]','$_POST[lamount]',$pamount,'$_POST[fdate]','$_POST[sndate]','$_POST[branchname]')";
if (!mysqli_query($con,$sql)) {
die('Error: ' . mysqli_error($con));
}
mysqli_close($con);
?>
<?php echo "Your Loan is Successfully Registered" ;?>
<form action=""><input type="button" value="New" onclick="window.location.href='loan_new_form.php';"/> </form>
|