0)
while($data = mysqli_fetch_assoc($result)){
$dataArray[]=$data;
}
return $dataArray;
return null;
}
function getarrayassoc($query){
$result = mysqli_query($GLOBALS['conn'],$query);
if(mysqli_num_rows($result)>0)
return mysqli_fetch_assoc($result);
return null;
}
function runQuery($query){
return mysqli_query($GLOBALS['conn'],$query);
}
if($_SERVER["REQUEST_METHOD"]=="POST")
if($_POST['submit']!=''){
$Date1=$_POST['Date1'];
$Scheme_no = $_POST['Scheme_no'];
$Agent_no = $_POST['Agent_no'];
$CustomerName = $_POST['CustomerName'];
$Policy_Amount = $_POST['Policy_Amount'];
$sql = "SELECT Commission FROM scheme_master WHERE Scheme_No = ".$Scheme_no;
$com = getarrayassoc($sql);
$Commission=($Policy_Amount*$com['Commission'])/100;
$sql = "INSERT INTO `policy_details`(`Date1`, `Scheme_no`, `Agent_No`, `CustomerName`, `Policy_Amount`, `Commission`) VALUES (
'{$Date1}',{$Scheme_no},{$Agent_no},'{$CustomerName}',{$Policy_Amount},{$Commission} )";
if(runQuery($sql))
echo "data insterted";
else
echo "something went wrong";
}
?>
Hartron Program 2
Please add the Policy
Output Data
| Agent |
Schemes |
No of Policies |
{$arow['Agent_Name']} |
{$srow['Scheme_Name']} |
{$polno['comm']} |
";
;
}}
?>
| Agent |
Commission |
".$arow['Agent_Name']." |
₹ ".($sum['comm']!=''? $sum['comm']:0) ." |
";
} ?>