ไม่รู้ว่าติดตรงไหนค่ะ ถ้ารันบน pc ที่จำลองเป็น server แสดงผลได้ แต่พอเอาไปวางบน server จริง page ที่โชว์ขึ้นมาเป็น ข้อผิดพลาดของ HTTP 500 (Internal Server Error)
ไม่รู้ว่าติดตรงไหนค่ะCode (PHP) <html>
<head>
<title></title>
<style type="text/css">
center {
text-align: center;
}
</style>
</head>
<script language="javascript">
function printpr()
{
var OLECMDID = 7;
/* OLECMDID values:
* 6 - print
* 7 - print preview
* 1 - open window
* 4 - Save As
*/
var PROMPT = 1; // 2 DONTPROMPTUSER
var WebBrowser = '<OBJECT ID="WebBrowser1" WIDTH=0 HEIGHT=0 CLASSID="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2"></OBJECT>';
document.body.insertAdjacentHTML('beforeEnd', WebBrowser);
WebBrowser1.ExecWB(OLECMDID, PROMPT);
WebBrowser1.outerHTML = "";
}
</script>
<body>
<center>
<table width="941" border="1">
<tr>
<td align="center" bgcolor="#CCCCCC"><?php
$db = "../PCRental_App/DB/DB_PCRent.mdb" ; //ชื่อฐานข้อมูล MsAccess
$strConn = new COM("ADODB.Connection") or die("Cannot start ADO");
$strConn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath($db));
$strSQL = "SELECT tb_Equipment_Type.Equipment_Type, Sum([Act_Replace]+[Act_New]+[Act_Replace_Contract]) AS Total, tb_Equipment.Act_Price, Sum(([Act_Replace]+[Act_New]+[Act_Replace_Contract])*[Act_Price]) AS month,(Sum(([Act_Replace]+[Act_New]+[Act_Replace_Contract])*[Act_Price]))*12 AS year, (Sum(([Act_Replace]+[Act_New]+[Act_Replace_Contract])*[Act_Price]))*36 AS threeyear
FROM (tb_Contract INNER JOIN (tb_Function INNER JOIN ((tb_Equipment_Type INNER JOIN tb_Equipment ON tb_Equipment_Type.[ID_Equipment_Type] = tb_Equipment.[ID_Equipment_Type]) INNER JOIN tb_Purchase ON tb_Equipment.[ID_Equipment] = tb_Purchase.[ID_Equipment]) ON tb_Function.[ID_Function] = tb_Purchase.[ID_Function]) ON tb_Contract.ID_Contract = tb_Equipment.ID_Contract) INNER JOIN (tb_Center_Function INNER JOIN tb_Center ON tb_Center_Function.ID_Center = tb_Center.ID_Center) ON tb_Function.ID_Function = tb_Center_Function.ID_Function
WHERE tb_Contract.Contract_No='WL-169-11'
GROUP BY tb_Equipment_Type.Equipment_Type, tb_Equipment.Act_Price;";
$objRec = new COM("ADODB.Recordset");
$objRec->Open($strSQL, $strConn, 1,3);
if($objRec->EOF)
{
echo "Not found Record.";
}
else
{
$PageLen = 30;
$PageNo = $_GET["Page"];
if(!$PageNo)
{
$PageNo = 1;
}
$TotalRecord = $objRec->RecordCount();
$objRec->PageSize = $PageLen;
$TotalPage = $objRec->PageCount();
$objRec->AbsolutePage = $PageNo;
?>
เลขที่สัญญา WL-169-11</td>
</tr>
</table>
<table width="941" border="1">
<tr>
<th width="215" bgcolor="#CCCCCC"> <div align="center">Type </div></th>
<th width="143" bgcolor="#CCCCCC"> <div align="center">Unit/Price </div></th>
<th width="85" bgcolor="#CCCCCC"> <div align="center">Total </div></th>
<th width="164" bgcolor="#CCCCCC"> <div align="center">ค่าใช้จ่าย / เดือน </div></th>
<th width="150" bgcolor="#CCCCCC"> <div align="center">ค่าใช้จ่าย / ปี </div></th>
<th width="144" bgcolor="#CCCCCC"> <div align="center">ค่าใช้จ่าย / 3ปี </div></th>
</tr>
<?
While (!($objRec->EOF) and $No < $PageLen)
{
$Equipment_Type = $objRec->Fields['Equipment_Type']->Value;
$Act_Price =$objRec->Fields['Act_Price']->Value;
$Total= $objRec->Fields['Total']->Value;
$month = $objRec->Fields['month']->Value;
$year = $objRec->Fields['year']->Value;
$threeyear= $objRec->Fields['threeyear']->Value;
?>
<tr>
<td ><?php echo $Equipment_Type;?></td>
<td align="center"><?php echo number_format($Act_Price)."<br>";?></td>
<td align="center"><?php echo $Total;?></td>
<td align="center"><?php echo number_format($month)."<br>";?></td>
<td align="center"><?php echo number_format($year)."<br>";?></td>
<td align="center"><?php echo number_format($threeyear)."<br>";?></td>
</tr>
<?
$No = $No + 1;
$objRec->MoveNext();
}
?>
</table>
<table width="941" border="1">
<tr>
<td width="215" height="23" align="left" bgcolor="#CCCCCC"><strong>รวมทั้งหมด</strong></td>
<td width="143" align="center" bgcolor="#CCCCCC"> </td>
<td width="85" align="center" bgcolor="#CCCCCC"><?php
$Total = array(2,12,11,25,17,20,17,20,549 );
$SumTotal = number_format(array_sum($Total ));
echo " $SumTotal ";
?></td>
<td width="164" align="center" bgcolor="#CCCCCC"><?php
$Totalmonth = array(1400,24000,5500,6625,11441,18200,371124);
$SumTotalmonth = number_format(array_sum($Totalmonth ));
echo " $SumTotalmonth ";
?></td>
<td width="150" align="center" bgcolor="#CCCCCC"><?php
$Totalyear = array(16800,288000,66000,79500,137292,218400,4453488);
$SumTotalyear = number_format(array_sum($Totalyear));
echo " $SumTotalyear";
?></td>
<td width="144" align="center" bgcolor="#CCCCCC"><?php
$Totalyear3 = array(50400,864000,198000,238500,411876,655200,13360464);
$SumTotalyear3 = number_format(array_sum($Totalyear3));
echo " $SumTotalyear3 ";
?></td>
</tr>
</table>
<p><a href="Report1.php">กลับสู่หน้าหลัก</a>
<?
}
$objRec->Close();
$strConn->Close();
$strConn = null;
?>
Total :
<?=$TotalRecord?>
Page
<?=$PageNo?>
All Page
<?=$TotalPage?>
<? if($PageNo > 1){ ?>
<a href="<?=$_SERVER[SCRIPT_NAME];?>?Page=1"><< First</a> <a href="<?=$_SERVER[SCRIPT_NAME];?>?Page=<?=$PageNo-1?>">< Back</a>
<? }?>
<? if($PageNo < $TotalPage) { ?>
<a href="<?=$_SERVER[SCRIPT_NAME];?>?Page=<?=$PageNo+1?>">Next ></a> <a href="<?=$_SERVER[SCRIPT_NAME];?>?Page=<?=$TotalPage?>">Last >></a>
<?}?>
<a href="Report_Wl16911_1.php">แสดงรายละเอียดข้อมูลการเช่า</a></p>
<p>
<input name="btnPrint" style="width:120px;" type="button" id="btnPrint" value="Print Preview" onClick="JavaScript:this.style.display='none';printpr();">
</p>
</center>
</body>
</html>
Tag PHP, Ms Access, HTML/CSS
Date :
2012-11-20 09:20:55By :
mah_comsciView :
1317Reply :
1
คิดว่า Process คงจะ Query นานเกินไปหรือเปล่าครับ ?
Date :
2012-11-21 12:11:12By :
mr.win
Server 00
Load balance : Server 00
