Viewing file:  dd_acc_print2.php (2.82 KB) -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();
}
$counts=$_POST['count'];
for($i=0;$i<$counts;$i++)
{
$serialno=$receiptnew+1;
$agentcode=($_POST['agentcode'][$i]);
$agentname=($_POST['agentname'][$i]);
$clientname=($_POST['clientname'][$i]);
$accountno=($_POST['accountno'][$i]);
$planamount=($_POST['planamount'][$i]);
$amount=($_POST['amount'][$i]);
$years=($_POST['years'][$i]);
$dates=($_POST['dates'][$i]);
$sql = "INSERT INTO dd (agentname,cname,accountno,planamount,amount,days,agentcode,dates,serialno)
VALUES
('$agentname','$clientname','$accountno','$planamount','$amount','$years','$agentcode','$dates',$serialno)";
if (!mysqli_query($con,$sql)) {
die('Error: ' . mysqli_error($con));
}
}
}
mysqli_close($con);
?>
<?php
$countss=$_POST['count'];
echo "<table width=\"900\" border=\"1\" cellspacing=\"2\" style='table-layout:fixed' background='images/SARKLOLOG.jpg'>\n";
echo " <tbody>\n";
echo " <tr>\n";
echo " <td ><img src='images/aadharbanner.jpg' width='900' height='120' alt=''/></td>\n";
echo " </tr>\n";
echo " <tr bgcolor='#0CBCE4'>\n";
echo " <td>AGENT NAME</td>\n";
echo " <td>CLIENT NAME</td>\n";
echo " <td>CLIENT ACCOUNT</td>\n";
echo " <td>PLAN AMOUNT</td>\n";
echo " <td>TOTAL PAID AMOUNT</td>\n";
echo " <td>TODAY DEPOSIT AMOUNT</td>\n";
echo " <td>DAYS</td>\n";
echo " <td>DATE</td>\n";
echo " </tr>\n";
echo " \n";
echo " </tbody>\n";
echo "</table>\n";
for($i=0;$i<$countss;$i++)
{
$amount=($_POST['amount'][$i]);
if($amount>0)
{
$agentcode=($_POST['agentcode'][$i]);
$agentname=($_POST['agentname'][$i]);
$clientname=($_POST['clientname'][$i]);
$accountno=($_POST['accountno'][$i]);
$planamount=($_POST['planamount'][$i]);
$amount=($_POST['amount'][$i]);
$years=($_POST['years'][$i]);
$dates=($_POST['dates'][$i]);
$aalamount=$amount+$aalamount;
echo "<table width=\"900\" border=\"1\" cellspacing=\"2\" style='table-layout:fixed'>\n";
echo " <tbody>\n";
echo " <tr bgcolor='#4BE7E9'>\n";
echo " <td>$agentname</td>\n";
echo " <td>$clientname </td>\n";
echo " <td>$accountno</td>\n";
echo " <td>$planamount</td>\n";
echo " <td>$totalamount </td>\n";
echo " <td>$amount</td>\n";
echo " <td>$years</td>\n";
echo " <td>$dates</td>\n";
echo " </tr>\n";
echo " \n";
echo " </tbody>\n";
echo "</table>\n";
}
}
echo "<table width=\"900\" border=\"1\" cellspacing=\"2\" style='table-layout:fixed'>\n";
echo " <tbody>\n";
echo " <tr bgcolor='#9AE9D5'>\n";
echo " <td>Total Paid Amount :- $aalamount <td>\n";
echo " </tr>\n";
echo " \n";
echo " </tbody>\n";
echo "</table>\n";
?>
|