将报告数据打印到打印机 [英] Printing report data to printer
问题描述
将数据打印到打印机
嗨。我在将报告打印到打印机时遇到问题。现在我可以打印php报告,但它会同时打开打印机对话框和页面。但我只需要一个打印机对话框。请帮助我
我的代码以下
连接数据库
`
< pre lang =PHP> <?php
尝试 {
< span class =code-sdkkeyword> $ hostname = sqlserver2005; // host
$ dbname = dbdata; // db name
$ username = sa; // 用户名如'sa'
$ pw = pass5; // 用户密码
$ dbh = new PDO( mssql:host = $ hostname; dbname = $ dbname, $ username, $ pw);
}
catch (PDOException $ e)
{
echo 找不到服务器。请检查管理员。 $ e-> getMessage()。 \ n;
file_put_contents(' PDOErrors.txt',$ e-> getMessage(),FILE_APPEND );
退出;
}
?>
索引文件
<?php
include_once ' ../ inc / connection.inc.php';
?>
<? php
尝试 {
$ stmt = $ dbh-> prepare(' SELECT * FROM StudentRecord order by Name');
$ stmt-> execute();
}
catch (PDOException $ e)
{
$ output = ' 从数据库中提取作者时出错!';
包括' ../ errormsg.php';
exit();
}
foreach ($ stmt as $ row)
{
$ sid [] = array(' SID' => $ row [' SID'],' 名称' => $ row [' 名称'] );
}
包括' searchform.html.php';
?>
searchform.html.php < br $> b $ b
<?php
包括' ../ templete / header.php';
?>
< 脚本 语言 = javascript >
function change_action()
{
var frm_obj = document .getElementById(< span class =code-string> frm);
frm_obj.action = data.php;
}
< / 脚本 >
< script language = javascript type = < span class =code-string> text / javascript>
< / script >
< table class = tbl_table align = center >
< 表单 action = 方法 = POST id = frm >
< tr >
< td class = td_title colspan = 2 > 帮助打印 < / td >
< / tr >
< tr >
< td class = td_class_right > 学生姓名< / td >
< td >
< 选择 名称 = sid id = sid > < span class =code-keyword>< 选项 value = > 学生ID < / option >
<? php foreach ($ sid as $ sids):?>
< 选项 value = < ?php htmlout($ sids ['SID']); ?> >
<? php htmlout($ sids [' 名称']); ?>
<? php htmlout($ sids [' SID']); ?>
< / option >
<? php endforeach; ?>
< / select >
< / td >
< tr >
< td class = td_button colspan = 2 < span class =code-keyword>>
< 输入 class = buttondesign type = < span class =code-keyword> submit value = 搜索 姓名 = 搜索 önclick = change_action() >
< 输入 class = buttondesign type = 提交 value = print name = print önclick = change_action() >
< / td >
< / tr >
< / form >
< / table >
data.php
<?php
include_once ' ../ inc / connection.inc.php';
?>
<? php
if (isset($ _ POST [' search'] )&& $ _POST [' search']!= )
{
$ sid = $ _POST [ sid];
$ stmt = $ dbh-> query( SELECT * FROM vwStatementOpen WHERE SID ='$ sid'ORDER BY RCDate);
$ stmt-> setFetchMode(PDO :: FETCH_ASSOC);
包括' view.html.php';
}
?>
<? php
if (isset($ _ POST [' print' ])&& $ _POST [' print']!= )
{
$ sid = $ _POST [ sid];
$ stmt = $ dbh-> query( SELECT * FROM vwStatementOpen WHERE SID ='$ sid'ORDER BY RCDate);
$ stmt-> setFetchMode(PDO :: FETCH_ASSOC);
包括' print.html.php';
}
?>
view .htm.php
<?php
include ' ../ templete / header.php';
$ total = 0;
$ scoursefee = 0 ;
$ sinipay = 0 ;
$ sdisc = 0 ;
$ scholar = 0 ;
$ nomonth = 0 ;
$ totalpaid = 0;
$ balance = 0;
$ totalother = 0;
$ totaloverall = 0;
?>
<? php
$ sid = $ _POST [ sid];
$ s = $ dbh-> query( SELECT * FROM StudentRecord WHERE SID ='$ sid');
$ s-> execute();
while($ row = $ s-> fetch())
{
$ ssid = $ row [' SID'];
$ sname = $ row [' 名称跨度>];
$ snric = $ row [' NRIC 跨度>];
$ scoursecode = $ row [' CourseCode 跨度>];
$ spaytype = $ row [' PayMode 跨度>];
$ scoursefee = $ row [' CourseFee 跨度>];
$ sinipay = $ row [' IniPayment 跨度>];
$ sdisc = $ row [' 折扣跨度>];
$ scholar = $ row [' ScholarShip 跨度>];
$ nomonth = $ row [' NoMonths 跨度>];
}
$ a = $ dbh-> query( SELECT SUM(Amount)as Amount FROM vwStatement WHERE SID ='$ sid');
$ a-> execute();
while($ row = $ a-> fetch())
{
$ totalpaid = $ row [' 金额跨度>];
}
$ balance = $ scoursefee- $ totalpaid;
$ b = $ dbh-> query( SELECT SUM(Amount)as Amount FROM vwStatementopen WHERE SID ='$ sid');
$ b-> execute();
while($ row = $ b-> fetch())
{
$ totaloverall = $ row [' 金额跨度>];
}
$ totalother = $ totaloverall- $ totalpaid
?>
< div class = title > 声明< / div >
< hr / >
< < span class =code-leadattribute> table align = center cellpadding = 1 cellspacing = < span class =code-keyword> 1 style = width:100% >
< tr >
< td class = tdempty style = width:30px > < / td >
< td class = labeldesign_statement 样式 = width:114px > 学生ID < / td >
< td class = labeldesign_statement style = width:34px > :< / td >
< td class = labeldesign_statement > <? php echo htmlout($ ssid); ?> < / td >
< td class = tdempty 样式 = width:30px > < / td >
< td class = labeldesign_statement style = width:114px > 课程费用< / td >
< td class = labeldesign_statement style = width:27px > :< / td >
< td class = labeldesign_statement > <? php echo number_format($ scoursefee,2); ?> < / td >
< td class = tdempty style = width:30px > < / td >
< td class = labeldesign_statement style = width:114px > 总付费(费用)< / td >
< td class = labeldesign_statement style = width:27px < span class =code-keyword>> :< / td >
< td class = labeldesign_statement > <? php echo number_format($ totalpaid,2); ?> < / td >
< / tr >
< tr >
< td class = tdempty style = width:30px > < / td >
< td class = labeldesign_statement style = width :114px > 学生姓名< / td >
< td class = labeldesign_statement 样式 = width:34px > :< / td < span class =code-keyword>>
< td class = labeldesign_statement > <? php echo htmlout($ sname); ?> < / td >
<td class=\"tdempty\" style=\"width: 30px\"></td>
<td class=\"labeldesign_statement\" style=\"width: 114px\">Initial Payment</td>
<td class=\"labeldesign_statement\" style=\"width: 27px\">:</td>
<td class=\"labeldesign_statement\"><?php echo number_format($sinipay,2);?></td>
<td class=\"tdempty\" style=\"width : 30px\"></td>
<td class=\"labeldesign_statement\" style=\"width: 114px\">Balance(Fee)</td>
<td class=\"labeldesign_statement\" style=\"width: 27px\">:</td>
<td class=\"labeldesign_statement\"><?php echo number_format($balance,2);?></td>
</tr>
<tr>
<td class=\"tdempty\" style=\"width: 30px\"></td>
<td class=\"labeldesign_statement\" style=\"width: 114px\">NRIC/PP</td>
<td class=\"labeldesign_statement\" style=\"width: 34px\">:</td>
& lt;td class=\"labeldesign_statement\"><?php echo htmlout($snric);?></td>
<td class=\"tdempty\" style=\"width: 30px\"></td>
<td class=\"labeldesign_statement\" style=\"width: 114px\">Discount</td>
<td class=\"labeldesign_statement\" style=\"width: 27px\">:</td>
<td class=\"labeldesign_statement\"><?php echo number_format($sdisc,2);?></td>
<td class =\"tdempty\" style=\"width: 30px\"></td>
<td class=\"labeldesign_statement\" style=\"width: 114px\">Total Paid(Others)</td>
<td class=\"labeldesign_statement\" style=\"width: 27px\">:</td>
<td class=\"labeldesign_statement\"><?php echo number_format($totalother,2);?></td>
</tr>
<tr>
<td class=\"tdempty\" style=\"width: 30px\"></td >
<td class=\"labeldesign_statement\" style=\"width: 114px\">Course</td>
<td class=\"labeldesign_statement\" style=\"width: 34px\">:</td>
<td class=\"labeldesign_statement\"><?php echo htmlout($scoursecode);?></td>
<td class=\"tdempty\" style=\"width: 30px\"></td>
<td class=\"labeldesign_statement\" style=\"width: 114px\">Scholarship</td>
<td class=\"labeldesign_statement\" style=\"width: 27px\">:</td>
<td class=\"labeldesign_statement\"><?php echo number_format($scholar,2);?></td>
<td class=\"tdempty\" style=\"width: 30px\"></td>
<td class=\"labeldesign_statement\" style=\"width: 114px\">Total Paid(Overall)</td>
<td class=\"labeldesign_statement\" style=\"width: 27px\">:</td>
<td class=\"labeldesign_statement\"><?php echo number_format($totaloverall,2);?></td>
</tr>
<tr>
<td class=\"tdem pty\" style=\"width: 30px\"></td>
<td class=\"labeldesign_statement\" style=\"width: 114px\">Pay Type</td>
<td class=\"labeldesign_statement\" style=\"width: 34px\">:</td>
<td class=\"labeldesign_statement\"><?php echo htmlout($spaytype);?></td>
<td class=\"tdempty\" style=\"width: 30px\"></td>
<td class=\"labeldesign_statement\" style=\"width: 114px\">No of Month</td>
<td class=\"labeldesign_statement\" style=\"width: 27px\">:</td>
<td class=\"labeldesign_statement\"><?php echo number_format($nomonth);?></td>
</tr>
</table>
<table width=\"100%\" al ign=\"center\" cellpadding=\"4\" cellspacing=\"1\">
<tr>
<td class=\"tdempty\"></td>
<td class=\"tbl_header\">Receipt No</td>
<td class=\"tbl_header\">Receipt Date</td>
<td class=\"tbl_header\">Description</td>
<td class=\"tbl_header\">Mode</td>
<td class=\"tbl_header\">Cheque No</td>
<td class=\"tbl_header_right\">Amount</td>
<td class=\"tdempty\"></td>
</tr>
<?php
if(isset($stmt))
{ while($row = $stmt->fetch())
{?>
<tr>
<td class=\"tdempty\"></td>
<td class=\"tbl_content\"><?php echo $row['RCNo'];?></td>
<td class=\"tbl_content\"><?php echo date(\"d-m-Y\", strtotime($row['RcDate']));?></td>
<td class=\"tbl_content\"><?php echo $row['Rcvdfor'];?></td>
<td class=\"tbl_content\"><?php echo $row['Mode'];?></td>
<td class=\"tbl_content\"><?php echo $row['ChqNo'];?></td>
<td class=\"tbl_content_right\"><?php echo number_format($row['Amount'],2) ;?></td>
<td class=\"tdempty\"></td>
</tr>
<?php
$total+=$row['Amount'];
}}?>
<tr><td colspan=\"9\"><hr /></td></tr>
<tr>
<td colspan=\"6\"></td>
<td class=\"tbl_subtotal_right\"> <?php echo number_format($total,2);?></td>
</tr>
</table>
<?php unset($dbh); unset($stmt); ?>
<?php
include '../templete/footer.php';
?>
print_head.php
<?php
include '../inc/connection.inc.php';
include_once '../inc/html_function.php';
$comp = $dbh->query(\"SELECT * FROM CompanyInfo\");
$comp->execute();
while($row = $comp->fetch())
{
$cname = $row['Name'];
$caddress = $row['Address'];
$ctel=$row['Tel'];
$cfax=$row['Fax'];
$cemail=$row['Email'];
}
?>
<!DOCTYPE html>
<html lang=\"en\">
<!--<META HTTP-EQUIV=\"REFRESH\" CONTENT=\"120\">-->
<head>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />
<title>HCK reporting Service-PHP</title>
<link rel=\"shortcut icon\" href=\"../image/102.ICO\" />
<link rel=\"stylesheet\" type=\"text/css\" href=\"../css/print.css\">
<!--<a href=\"http://www.silsnetwork.com\"><img id=\"logo\" src=\"../image/logo.jpg\" alt=\"sils\" /></a>-->
<div class=\"title\"><?php htmlout($cname)?></div>
<div class=\"address\"><?php htmlout($caddress)?></div>
<div class=\"address\">Tel:<?php htmlout($ctel)?> Fax:<?php htmlout($cfax)?> Email:<?php htmlout($cemail)?> </div>
<div class=\"address\"><hr /> </div>
<div class=\"clickon_display\">
<!--<a href=\"java<!-- no -->script:window.print();\">Printed on :- <?php echo date(\"M d, Y\"); ?> </a>-->
</div>
<!--<a href=\"java<!-- no -->script:window.print();\"><?php echo $title; ?> </a>-->
<!--<a href=\"java<!-- no -->script:window.print();\"><h6>Titel of reports</h6></a>-->
<script language=\"Javascript1.2\">
function printpage()
{
window.print();
}
</script>
</head>
<body önload=\"printpage()\">
print.html.php
<?php
include '../templete/print_head.php';
$total=0;
$scoursefee = 0;
$sinipay = 0;
$sdisc = 0;
$scholar = 0;
$nomonth = 0;
$totalpaid=0;
$balance=0;
$totalother=0;
$totaloverall=0;
?>
<?php
$sid = $_POST[\"sid\"];
$s = $dbh->query(\"SELECT * FROM StudentRecord WHERE SID='$sid'\");
$s->execute();
while($row = $s->fetch())
{
$ssid = $row['SID'];
$sname = $row['Name'];
$snric = $row['NRIC'];
$scoursecode = $row['CourseCode'];
$spaytype = $row['PayMode'];
$scoursefee = $row['CourseFee'];
$sinipay = $row['IniPayment'];
$sdisc = $row['Discount'];
$scholar = $row['ScholarShip'];
$nomonth = $row['NoMonths'];
}
$a = $dbh->query(\"SELECT SUM(Amount) as Amount FROM vwStatement WHERE SID='$sid'\");
$a->execute();
while($row = $a->fetch())
{
$totalpaid=$row['Amount'];
}
$balance=$scoursefee-$totalpaid;
$b = $dbh->query(\"SELECT SUM(Amount) as Amount FROM vwStatementopen WHERE SID='$sid'\");
$b->execute();
while($row = $b->fetch())
{
$totaloverall=$row['Amount'];
}
$totalother=$totaloverall-$totalpaid
?>
<div class=\"title\">Statement</div>
<hr />
<table align=\"center\" cellpadding=\"1\" cellspacing=\"1\" style=\"width: 100%\" >
<tr>
<td class=\"tdempty\" style=\"width: 30px\"></td>
<td class=\"labeldesign_statement\" style=\"width: 114px\">Student ID</td>
<td class< span class=\"code-keyword\">=\"labeldesign_statement\" style=\"width: 34px\">:</td>
<td class=\"labeldesign_statement\"><?php echo htmlout($ssid);?></td>
<td class=\"tdempty\" style=\"width: 30px\"></td>
<td class=\"labeldesign_statement\" style=\"width: 114px\">Course Fee</td>
<td class=\"labeldesign_statement\" style=\"width: 27px\">:</td>
<td class=\"labeldesign_statement\"><?php echo number_format($scoursefee,2);?></td>
<td class=\"tdempty\" style=\"width: 30px\"></td>
<td class=\"labeldesign_statement\" style=\"width: 114px\">Total Paid(Fee)</td>
<td class=\"labeldesign_statement\" style=\"width: 27px\">:<< span class=\"code-leadattribute\">/td>
<td class=\"labeldesign_statement\"><?php echo number_format($totalpaid,2);?></td>
</tr>
<tr>
<< span class=\"code-leadattribute\">td class=\"tdempty\" style=\"width: 30px\"></td>
<td class=\"labeldesign_statement\" style=\"width: 114px\">Student Name</td>
<td class=\"labeldesign_statement\" style=\"width: 34px\">:</td>
<td class=\"labeldesign_statement\"> ;<?php echo htmlout($sname);?></td>
<td class=\"tdempty\" style=\"width: 30px\"></td>
<td class=\"labeldesign_statement\" style=\"width: 114px\">Initial Payment</td>
<td class=\"labeldesign_statement\" style=\"width: 27px\">:</td>
<td class=\"labeldesign_statement\"><?php echo number_format($sinipay,2);?></td>
<td class=\"tdempty\" style=\"width: 30px\"></td>
<td class=\"labeldesign_statement\" style=\"width: 114px\">Balance(Fee)</td>
<td class=\"< span class=\"code-keyword\">labeldesign_statement\" style=\"width: 27px\">:</td>
<td class=\"labeldesign_statement\"><?php echo number_format($balance,2);?></td>
</tr>
<tr>
<td class=\"tdempty\" style=\"width: 30px\"></td>
<td class=\"labeldesign_statement\" style=\"width: 114px\">NRIC/PP</td>
<td class=\"labeldesign_statement\" style=\"width: 34px\">:</td>
<td class=\"labeldesign_statement\"><?php echo htmlout($snric);?></td>
<td class=\"tdempty\" style=\"width: 30px\"></td>
<td class=\"labeldesign_statement\" style=\"width: 114px\">Discount</td>
<td class=\"labeldesign_statement\" style=\"width: 27px\">:</td>
<td class=\"labeldesign_statement\"><?php echo number_format($sdisc,2);?></td>
<td< span class=\"code-attribute\"> class=\"tdempty\" style=\"width: 30px\"></td>
<td class=\"labeldesign_statement\" style=\"width: 114px\">Total Paid(Others)</td>
<td class=\"labeldesign_statement\" style=\"width: 27px\">:</td>
<td class=\"labeldesign_statement\"><?php echo number_format($totalother,2);?></td>
</tr>
<tr>
<td class=\"tdempty\" style=\"width: 30px\"></td>
<td class=\"labeldesign_statement\" style=\"width: 114px\">Course</td>
<td class=\"labeldesign_statement\" style=\"width: 34px\">:</td>
<td class=\"labeldesign_statement\"><?php echo htmlout($scoursecode);?></td>
<td class=\"tdempty\" style=\"width: 30px\"></td>
<td class=\"labeldesign_statement\" style=\"width: 114px\">Scholarship</td >
<td class=\"labeldesign_statement\" style=\"width: 27px\">:</td>
<td class=\"labeldesign_statement\"><?php echo number_format($scholar,2);?></td>
<td class=\"tdempty\" style=\"width: 30px\"></td>
<td class=\"labeldesign_statement\" style=\"width: 114px\">Total Paid(Overall)</td>
<td class=\"labeldesign_statement\" style=\"width: 27px\">:</td>
<td class=\"labeldesign_statement\"><?php echo number_format($totaloverall,2);?></td>
</tr>
<tr>
<td class=\"tdempty\" style=\"width: 30px\"></td>
<td class=\"labeldesign_statement\" style=\"width: 114px\">Pay Type</td>
<td class=\"labeldesign_statement\" style=\"width: 34px\">:</td>
<td class=\"labeldesign_statement\"><?php echo htmlout($spaytype);?></td>
<td class=\"tdempty\" style=\"width: 30px\"></td>
<td class=\"l abeldesign_statement\" style=\"width: 114px\">No of Month</td>
<td class=\"labeldesign_statement\" style=\"width: 27px\">:</td>
<< span class=\"code-leadattribute\">td class=\"labeldesign_statement\"><?php echo number_format($nomonth);?></td>
</tr>
</table>
<table width=\"100%\" align=\"center\" cellpadding=\"4\" cellspacing=\"1\">
<tr><td colspan=\"7\"><hr /></td></tr>
<tr>
<td class=\"tdempty\"></td>
< ;td class=\"tbl_header\">Receipt No</td>
<td class=\"tbl_header\">Receipt Date</td>
<td class=\"tbl_header\">Description</td>
<td class=\"tbl_header\">Mode</td>
<td class=\"tbl_header\">Cheque No</td>
<td class=\"tbl_header_right\">Amount</td>
<td class=\"tdempty\"></td>
</tr>
<tr><td colspan=\"7\"><hr /></td></tr>
<?php
if(isset($stmt))
{ while($row = $s tmt->fetch())
{?>
<tr>
<td class=\"tdempty\"></td>
<td class=\"tbl_content\"><?php echo $row['RCNo'];?></td>
<td class=\"tbl_content\"><?php echo date(\"d-m-Y\", strtotime($row['RcDate']));?></td>
<td class=\"tbl_content\"><?php echo $row['Rcvdfor'];?></td>
<td class=\"tbl_content\"><?php echo $row['Mode'];?></td>
<td class=\"tbl_content\"><?php echo $row['ChqNo'];?></td>
<td class=\"tbl_content_right\"><?php echo number_format($row['Amount'],2) ;?></td>
<td class=\"tdempty\"></td>
</tr>
<?php
$total+=$row['Amount'];
}}?>
<tr><td colspan=\"7\"><hr /></td></tr>
<tr>
<td colspan=\"6\"></td>
<td class=\"tbl_subtotal_right\"> <?php echo number_format($total,2);?></td>
</tr>
<tr><td colspan=\"7\"><hr /></td></tr>
</table>
<?php unset($dbh); unset($stmt); ?>
Please Help me
Maideen
hostname = \"sqlserver2005\"; //host
dbname = \"dbdata\"; //db name
username = \"sa\"; // username like 'sa'
print data to printer
hi. i have a problem in printing the report to printer. Now i can print the php reports, but it will open both printer dialog and page together. But I need only one to printer dialog box. Pls help me
Below my code
Connection database
`
<?php
try {
$hostname = "sqlserver2005"; //host
$dbname = "dbdata"; //db name
$username = "sa"; // username like 'sa'
$pw = "pass5"; // password for the user
$dbh = new PDO ("mssql:host=$hostname;dbname=$dbname","$username","$pw");
}
catch (PDOException $e)
{
echo "cannot find the server. pls check your administrator " . $e->getMessage() . "\n";
file_put_contents('PDOErrors.txt', $e->getMessage(), FILE_APPEND);
exit;
}
?>
Index file
<?php
include_once '../inc/connection.inc.php';
?>
<?php
try {
$stmt = $dbh->prepare('SELECT * FROM StudentRecord order by Name');
$stmt->execute();
}
catch (PDOException $e)
{
$output = 'Error fetching authors from database!';
include '../errormsg.php';
exit();
}
foreach ($stmt as $row)
{
$sid[] = array('SID' => $row['SID'], 'Name' => $row['Name']);
}
include 'searchform.html.php';
?>
searchform.html.php
<?php
include '../templete/header.php';
?>
<Script Language="javascript">
function change_action()
{
var frm_obj=document.getElementById("frm");
frm_obj.action="data.php";
}
</Script>
<script language="javascript" type="text/javascript">
</script>
<table class="tbl_table" align="center">
<form action="" method="POST" id="frm" >
<tr>
<td class="td_title" colspan="2">Help Printing</td>
</tr>
<tr>
<td class="td_class_right">Student Name</td>
<td>
<select name="sid" id="sid"><option value="">Student ID</option>
<?php foreach ($sid as $sids): ?>
<option value="<?php htmlout($sids['SID']); ?>">
<?php htmlout($sids['Name']);?>
<?php htmlout($sids['SID']);?>
</option>
<?php endforeach; ?>
</select>
</td>
<tr>
<td class="td_button" colspan="2">
<input class="buttondesign" type="submit" value="Search" name="search" önclick="change_action()">
<input class="buttondesign" type="submit" value="print" name="print" önclick="change_action()">
</td>
</tr>
</form>
</table>
data.php
<?php
include_once '../inc/connection.inc.php';
?>
<?php
if (isset($_POST['search']) && $_POST['search'] != "" )
{
$sid = $_POST["sid"];
$stmt = $dbh->query("SELECT * FROM vwStatementOpen WHERE SID='$sid' ORDER BY RCDate");
$stmt->setFetchMode(PDO::FETCH_ASSOC);
include 'view.html.php';
}
?>
<?php
if (isset($_POST['print']) && $_POST['print'] != "" )
{
$sid = $_POST["sid"];
$stmt = $dbh->query("SELECT * FROM vwStatementOpen WHERE SID='$sid' ORDER BY RCDate");
$stmt->setFetchMode(PDO::FETCH_ASSOC);
include 'print.html.php';
}
?>
view.htm.php
<?php
include '../templete/header.php';
$total=0;
$scoursefee = 0;
$sinipay = 0;
$sdisc = 0;
$scholar = 0;
$nomonth = 0;
$totalpaid=0;
$balance=0;
$totalother=0;
$totaloverall=0;
?>
<?php
$sid = $_POST["sid"];
$s = $dbh->query("SELECT * FROM StudentRecord WHERE SID='$sid'");
$s->execute();
while($row = $s->fetch())
{
$ssid = $row['SID'];
$sname = $row['Name'];
$snric = $row['NRIC'];
$scoursecode = $row['CourseCode'];
$spaytype = $row['PayMode'];
$scoursefee = $row['CourseFee'];
$sinipay = $row['IniPayment'];
$sdisc = $row['Discount'];
$scholar = $row['ScholarShip'];
$nomonth = $row['NoMonths'];
}
$a = $dbh->query("SELECT SUM(Amount) as Amount FROM vwStatement WHERE SID='$sid'");
$a->execute();
while($row = $a->fetch())
{
$totalpaid=$row['Amount'];
}
$balance=$scoursefee-$totalpaid;
$b = $dbh->query("SELECT SUM(Amount) as Amount FROM vwStatementopen WHERE SID='$sid'");
$b->execute();
while($row = $b->fetch())
{
$totaloverall=$row['Amount'];
}
$totalother=$totaloverall-$totalpaid
?>
<div class="title">Statement</div>
<hr />
<table align="center" cellpadding="1" cellspacing="1" style="width: 100%" >
<tr>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">Student ID</td>
<td class="labeldesign_statement" style="width: 34px">:</td>
<td class="labeldesign_statement"><?php echo htmlout($ssid);?></td>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">Course Fee</td>
<td class="labeldesign_statement" style="width: 27px">:</td>
<td class="labeldesign_statement"><?php echo number_format($scoursefee,2);?></td>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">Total Paid(Fee)</td>
<td class="labeldesign_statement" style="width: 27px">:</td>
<td class="labeldesign_statement"><?php echo number_format($totalpaid,2);?></td>
</tr>
<tr>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">Student Name</td>
<td class="labeldesign_statement" style="width: 34px">:</td>
<td class="labeldesign_statement"><?php echo htmlout($sname);?></td>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">Initial Payment</td>
<td class="labeldesign_statement" style="width: 27px">:</td>
<td class="labeldesign_statement"><?php echo number_format($sinipay,2);?></td>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">Balance(Fee)</td>
<td class="labeldesign_statement" style="width: 27px">:</td>
<td class="labeldesign_statement"><?php echo number_format($balance,2);?></td>
</tr>
<tr>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">NRIC/PP</td>
<td class="labeldesign_statement" style="width: 34px">:</td>
<td class="labeldesign_statement"><?php echo htmlout($snric);?></td>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">Discount</td>
<td class="labeldesign_statement" style="width: 27px">:</td>
<td class="labeldesign_statement"><?php echo number_format($sdisc,2);?></td>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">Total Paid(Others)</td>
<td class="labeldesign_statement" style="width: 27px">:</td>
<td class="labeldesign_statement"><?php echo number_format($totalother,2);?></td>
</tr>
<tr>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">Course</td>
<td class="labeldesign_statement" style="width: 34px">:</td>
<td class="labeldesign_statement"><?php echo htmlout($scoursecode);?></td>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">Scholarship</td>
<td class="labeldesign_statement" style="width: 27px">:</td>
<td class="labeldesign_statement"><?php echo number_format($scholar,2);?></td>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">Total Paid(Overall)</td>
<td class="labeldesign_statement" style="width: 27px">:</td>
<td class="labeldesign_statement"><?php echo number_format($totaloverall,2);?></td>
</tr>
<tr>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">Pay Type</td>
<td class="labeldesign_statement" style="width: 34px">:</td>
<td class="labeldesign_statement"><?php echo htmlout($spaytype);?></td>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">No of Month</td>
<td class="labeldesign_statement" style="width: 27px">:</td>
<td class="labeldesign_statement"><?php echo number_format($nomonth);?></td>
</tr>
</table>
<table width="100%" align="center" cellpadding="4" cellspacing="1">
<tr>
<td class="tdempty"></td>
<td class="tbl_header">Receipt No</td>
<td class="tbl_header">Receipt Date</td>
<td class="tbl_header">Description</td>
<td class="tbl_header">Mode</td>
<td class="tbl_header">Cheque No</td>
<td class="tbl_header_right">Amount</td>
<td class="tdempty"></td>
</tr>
<?php
if(isset($stmt))
{ while($row = $stmt->fetch())
{?>
<tr>
<td class="tdempty"></td>
<td class="tbl_content"><?php echo $row['RCNo'];?></td>
<td class="tbl_content"><?php echo date("d-m-Y", strtotime($row['RcDate']));?></td>
<td class="tbl_content"><?php echo $row['Rcvdfor'];?></td>
<td class="tbl_content"><?php echo $row['Mode'];?></td>
<td class="tbl_content"><?php echo $row['ChqNo'];?></td>
<td class="tbl_content_right"><?php echo number_format($row['Amount'],2) ;?></td>
<td class="tdempty"></td>
</tr>
<?php
$total+=$row['Amount'];
}}?>
<tr><td colspan="9"><hr /></td></tr>
<tr>
<td colspan="6"></td>
<td class="tbl_subtotal_right"> <?php echo number_format($total,2);?></td>
</tr>
</table>
<?php unset($dbh); unset($stmt); ?>
<?php
include '../templete/footer.php';
?>
print_head.php
<?php
include '../inc/connection.inc.php';
include_once '../inc/html_function.php';
$comp = $dbh->query("SELECT * FROM CompanyInfo");
$comp->execute();
while($row = $comp->fetch())
{
$cname = $row['Name'];
$caddress = $row['Address'];
$ctel=$row['Tel'];
$cfax=$row['Fax'];
$cemail=$row['Email'];
}
?>
<!DOCTYPE html>
<html lang="en">
<!--<META HTTP-EQUIV="REFRESH" CONTENT="120">-->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>HCK reporting Service-PHP</title>
<link rel="shortcut icon" href="../image/102.ICO" />
<link rel="stylesheet" type="text/css" href="../css/print.css">
<!--<a href="http://www.silsnetwork.com"><img id="logo" src="../image/logo.jpg" alt="sils" /></a>-->
<div class="title"><?php htmlout($cname)?></div>
<div class="address"><?php htmlout($caddress)?></div>
<div class="address">Tel:<?php htmlout($ctel)?> Fax:<?php htmlout($cfax)?> Email:<?php htmlout($cemail)?> </div>
<div class="address"><hr /> </div>
<div class="clickon_display">
<!--<a href="java<!-- no -->script:window.print();">Printed on :- <?php echo date("M d, Y"); ?> </a>-->
</div>
<!--<a href="java<!-- no -->script:window.print();"><?php echo $title; ?> </a>-->
<!--<a href="java<!-- no -->script:window.print();"><h6>Titel of reports</h6></a>-->
<script language="Javascript1.2">
function printpage()
{
window.print();
}
</script>
</head>
<body önload="printpage()">
print.html.php
<?php
include '../templete/print_head.php';
$total=0;
$scoursefee = 0;
$sinipay = 0;
$sdisc = 0;
$scholar = 0;
$nomonth = 0;
$totalpaid=0;
$balance=0;
$totalother=0;
$totaloverall=0;
?>
<?php
$sid = $_POST["sid"];
$s = $dbh->query("SELECT * FROM StudentRecord WHERE SID='$sid'");
$s->execute();
while($row = $s->fetch())
{
$ssid = $row['SID'];
$sname = $row['Name'];
$snric = $row['NRIC'];
$scoursecode = $row['CourseCode'];
$spaytype = $row['PayMode'];
$scoursefee = $row['CourseFee'];
$sinipay = $row['IniPayment'];
$sdisc = $row['Discount'];
$scholar = $row['ScholarShip'];
$nomonth = $row['NoMonths'];
}
$a = $dbh->query("SELECT SUM(Amount) as Amount FROM vwStatement WHERE SID='$sid'");
$a->execute();
while($row = $a->fetch())
{
$totalpaid=$row['Amount'];
}
$balance=$scoursefee-$totalpaid;
$b = $dbh->query("SELECT SUM(Amount) as Amount FROM vwStatementopen WHERE SID='$sid'");
$b->execute();
while($row = $b->fetch())
{
$totaloverall=$row['Amount'];
}
$totalother=$totaloverall-$totalpaid
?>
<div class="title">Statement</div>
<hr />
<table align="center" cellpadding="1" cellspacing="1" style="width: 100%" >
<tr>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">Student ID</td>
<td class="labeldesign_statement" style="width: 34px">:</td>
<td class="labeldesign_statement"><?php echo htmlout($ssid);?></td>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">Course Fee</td>
<td class="labeldesign_statement" style="width: 27px">:</td>
<td class="labeldesign_statement"><?php echo number_format($scoursefee,2);?></td>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">Total Paid(Fee)</td>
<td class="labeldesign_statement" style="width: 27px">:</td>
<td class="labeldesign_statement"><?php echo number_format($totalpaid,2);?></td>
</tr>
<tr>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">Student Name</td>
<td class="labeldesign_statement" style="width: 34px">:</td>
<td class="labeldesign_statement"><?php echo htmlout($sname);?></td>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">Initial Payment</td>
<td class="labeldesign_statement" style="width: 27px">:</td>
<td class="labeldesign_statement"><?php echo number_format($sinipay,2);?></td>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">Balance(Fee)</td>
<td class="labeldesign_statement" style="width: 27px">:</td>
<td class="labeldesign_statement"><?php echo number_format($balance,2);?></td>
</tr>
<tr>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">NRIC/PP</td>
<td class="labeldesign_statement" style="width: 34px">:</td>
<td class="labeldesign_statement"><?php echo htmlout($snric);?></td>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">Discount</td>
<td class="labeldesign_statement" style="width: 27px">:</td>
<td class="labeldesign_statement"><?php echo number_format($sdisc,2);?></td>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">Total Paid(Others)</td>
<td class="labeldesign_statement" style="width: 27px">:</td>
<td class="labeldesign_statement"><?php echo number_format($totalother,2);?></td>
</tr>
<tr>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">Course</td>
<td class="labeldesign_statement" style="width: 34px">:</td>
<td class="labeldesign_statement"><?php echo htmlout($scoursecode);?></td>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">Scholarship</td>
<td class="labeldesign_statement" style="width: 27px">:</td>
<td class="labeldesign_statement"><?php echo number_format($scholar,2);?></td>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">Total Paid(Overall)</td>
<td class="labeldesign_statement" style="width: 27px">:</td>
<td class="labeldesign_statement"><?php echo number_format($totaloverall,2);?></td>
</tr>
<tr>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">Pay Type</td>
<td class="labeldesign_statement" style="width: 34px">:</td>
<td class="labeldesign_statement"><?php echo htmlout($spaytype);?></td>
<td class="tdempty" style="width: 30px"></td>
<td class="labeldesign_statement" style="width: 114px">No of Month</td>
<td class="labeldesign_statement" style="width: 27px">:</td>
<td class="labeldesign_statement"><?php echo number_format($nomonth);?></td>
</tr>
</table>
<table width="100%" align="center" cellpadding="4" cellspacing="1">
<tr><td colspan="7"><hr /></td></tr>
<tr>
<td class="tdempty"></td>
<td class="tbl_header">Receipt No</td>
<td class="tbl_header">Receipt Date</td>
<td class="tbl_header">Description</td>
<td class="tbl_header">Mode</td>
<td class="tbl_header">Cheque No</td>
<td class="tbl_header_right">Amount</td>
<td class="tdempty"></td>
</tr>
<tr><td colspan="7"><hr /></td></tr>
<?php
if(isset($stmt))
{ while($row = $stmt->fetch())
{?>
<tr>
<td class="tdempty"></td>
<td class="tbl_content"><?php echo $row['RCNo'];?></td>
<td class="tbl_content"><?php echo date("d-m-Y", strtotime($row['RcDate']));?></td>
<td class="tbl_content"><?php echo $row['Rcvdfor'];?></td>
<td class="tbl_content"><?php echo $row['Mode'];?></td>
<td class="tbl_content"><?php echo $row['ChqNo'];?></td>
<td class="tbl_content_right"><?php echo number_format($row['Amount'],2) ;?></td>
<td class="tdempty"></td>
</tr>
<?php
$total+=$row['Amount'];
}}?>
<tr><td colspan="7"><hr /></td></tr>
<tr>
<td colspan="6"></td>
<td class="tbl_subtotal_right"> <?php echo number_format($total,2);?></td>
</tr>
<tr><td colspan="7"><hr /></td></tr>
</table>
<?php unset($dbh); unset($stmt); ?>
Please Help me
Maideen
hostname = "sqlserver2005"; //host
dbname = "dbdata"; //db name
username = "sa"; // username like 'sa'
这篇关于将报告数据打印到打印机的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!