0){ while($row = mysqli_fetch_assoc($result)) $data[] = $row; return $data; } return NULL; } function getarrayassoc( $query) { $data = array(); $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']!='') { $agent = $_POST['Agent_No']; $date = $_POST['PolicyDate']; $name = $_POST['CustomerName']; $amount = $_POST['PolicyAmount']; $commission = $amount > 10000 ? ($amount*2.5)/100 : ($amount<10000 ? ($amount*2)/100: 0) ; $sql = "INSERT INTO `policy_details`(`Agent_No`, `Policy_Date`, `CustomerName`, `PolicyAmount`, `Commission`) VALUES ({$agent},'{$date}','{$name}',{$amount},{$commission})"; if(runQuery($sql)) echo 'inserted Successfully'; else echo 'something went wrong'; } } ?> Junior Programmer Test of Vinay Kumar





Report Display as

"; } ?>
Agent Policy Date Policy Amount Commission
".$row['Agent_Name']." ".date('d-M-Y',strtotime($row['Policy_Date']))." ".$row['PolicyAmount']." ".$row['Commission']."