wyf
新手上路
UID 73227
精华
0
积分 7
帖子 3
金钱 7 喜悦币
威望 0
人脉 0
阅读权限 10
注册 2006-5-12
状态 离线
|
[推荐阅读] 前一段时间,用PHP封装了MTIR的用法,值得分享(原创)!!
回复 #3 115300111 的帖子
谢谢你的方法，但我不明白所谓的第一行声明是什么标签啊？
我是用的PHP＋MYSQL嵌套在HTML的页面。页面内容如下：
<?php
include_once("include/whetherlogin.php");
include_once("./include/page.php");
include_once("./include/conn_db.php");
include_once("./include/gettitlefunc.php");
$QueryStr=sprintf("
SELECT
studentinfo.StuID
FROM
studentinfo
WHERE
(studentinfo.StuSubjection = %s)",$_GET['uid']);
$sth=DBQuery(array($QueryStr));
$recruitgoal=DBNumRows(array($sth));//目标招生总数
DBFreeResult($sth);
$QueryStr=sprintf("
SELECT
studentinfo.StuID
FROM
studentinfo
WHERE
(studentinfo.StuSubjection = %s) AND
(studentinfo.StuSignupFee = '已交')",$_GET['uid']);
$sth=DBQuery(array($QueryStr));
$signupfee=DBNumRows(array($sth));//已交报名费总数
DBFreeResult($sth);
$QueryStr=sprintf("
SELECT
studentinfo.StuID
FROM
studentinfo
LEFT JOIN stuvehicleinfo ON (studentinfo.StuID = stuvehicleinfo.StuVehicleStudentID)
WHERE
(studentinfo.StuSubjection = %s) AND
(stuvehicleinfo.StuVehicleTypeID <> 0)",$_GET['uid']);
$sth=DBQuery(array($QueryStr));
$bespoketicket=DBNumRows(array($sth));//订车票总数
DBFreeResult($sth);
$QueryStr=sprintf("
SELECT
studentinfo.StuID
FROM
studentinfo
WHERE
(studentinfo.StuSubjection = %s) AND
(studentinfo.StuTuition = '已交')",$_GET['uid']);
$sth=DBQuery(array($QueryStr));
$handtuition=DBNumRows(array($sth));//交学费总数
DBFreeResult($sth);
$QueryStr=sprintf("
SELECT
studentinfo.StuID
FROM
studentinfo
WHERE
(studentinfo.StuSubjection = %s) AND
(studentinfo.StuLeaveSchool = '是')",$_GET['uid']);
$sth=DBQuery(array($QueryStr));
$leaveschool=DBNumRows(array($sth));//退学总数
DBFreeResult($sth);
$QueryStr=sprintf("
SELECT
studentinfo.StuID
FROM
studentinfo
WHERE
(studentinfo.StuSubjection = %s) AND
(studentinfo.StuTuition = '已交') AND
(studentinfo.StuLeaveSchool = '否')",$_GET['uid']);
$sth=DBQuery(array($QueryStr));
$fruitbalance=DBNumRows(array($sth));//招生成果总数
DBFreeResult($sth);
$QueryStr=sprintf("
SELECT
studentinfo.StuID,
studentinfo.StuName,
districtinfo.DistrictID,
districtinfo.DistrictName,
studentinfo.StuSignupFee,
stuvehicleinfo.StuVehicleTypeID,
studentinfo.StuTuition,
studentinfo.StuLeaveSchool,
studentinfo.StuLeaveSchoolDate,
specialityinfo.SpecialityName,
academy.AcademyName,
studentinfo.StuTypeTime
FROM
studentinfo
LEFT JOIN districtinfo ON (studentinfo.StuComeFrom = districtinfo.DistrictID)
LEFT JOIN stuvehicleinfo ON (studentinfo.StuID = stuvehicleinfo.StuVehicleStudentID)
LEFT JOIN specialityinfo ON (studentinfo.StuFirstWish = specialityinfo.SpecialityID)
LEFT JOIN academy ON (specialityinfo.SpecialityAcademyID = academy.AcademyID)
WHERE
(studentinfo.StuSubjection = %s)
",$_GET['uid']);
//获取总记录条数
$sth=DBQuery(array($QueryStr));
$RecCounts=DBNumRows(array($sth));
DBFreeResult($sth);
//exit;
//创建分页类对象
$page = @new show_page;
$RowCountPerPage=10;//设置每页行数
$page->setvar ( array (
"uid" => $_GET['uid']
));
if (isset($_GET["p"]))
{$currpage=$_GET["p"];}
else
{$currpage=1;}//设置当前页
$page->set($RowCountPerPage,$RecCounts,$currpage);
$QueryStr.=" limit " . $page->limit();
$sth=DBQuery(array($QueryStr));
$RecCountSum=DBNumRows(array($sth));
?>
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
<TITLE>招生成果结算</TITLE>
<LINK HREF="css/css.css" REL="stylesheet" TYPE="text/css">
<SCRIPT LANGUAGE="JavaScript">
function PrintPage(printpage)
{
window.open(printpage,null,"left=0,top=0,height="+screen.height+",width="+screen.width+'"');
}
</SCRIPT>
</HEAD>
<BODY>
<TABLE WIDTH="98%" ALIGN="center" BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR ALIGN="center" CLASS="biaoti-s">
<TD WIDTH="5%" HEIGHT="32" NOWRAP>序号</TD>
<TD WIDTH="9%" NOWRAP >学生姓名</TD>
<TD WIDTH="12%" NOWRAP>所在区域</TD>
<TD WIDTH="6%" NOWRAP>报名费</TD>
<TD WIDTH="6%" NOWRAP>订票</TD>
<TD WIDTH="6%" NOWRAP>学费</TD>
<TD WIDTH="11%" NOWRAP>退学</TD>
<TD WIDTH="13%" NOWRAP>就读学院</TD>
<TD WIDTH="14%" NOWRAP>专业</TD>
<TD WIDTH="18%" NOWRAP>录入时间</TD>
</TR>
<?php
for ($i=0;$i<$RecCountSum;$i++)
{
$Rec=DBFetchRow(array($sth,0));
?>
<TR ALIGN="center">
<TD NOWRAP><?php echo $i+1; ?></TD>
<TD NOWRAP><A HREF="studentmanage3.php?StuID=<?php echo $Rec['StuID']; ?>"><?php echo $Rec['StuName']; ?></A></TD>
<TD NOWRAP><A HREF="viewdistrict1.php?id=<?php echo $Rec['DistrictID']; ?>" TITLE="<?php echo GetTitleForDistrict($Rec['DistrictID']); ?>" TARGET="_BLANK" ><?php echo $Rec['DistrictName']; ?></A></TD>
<TD NOWRAP><?php echo ($Rec['StuSignupFee']=='已交')?'√':'－'; ?></TD>
<TD NOWRAP><?php echo ($Rec['StuVehicleTypeID']!=0)?'√':'－'; ?></TD>
<TD NOWRAP><?php echo ($Rec['StuTuition']=='已交')?'√':'－'; ?></TD>
<TD NOWRAP><?php echo ($Rec['StuLeaveSchool']=='是')?$Rec['StuLeaveSchoolDate']:'－'; ?></TD>
<TD NOWRAP><?php echo ($Rec['AcademyName']=='')?' ' Rec['AcademyName']; ?></TD>
<TD NOWRAP><?php echo ($Rec['SpecialityName']=='')?' 'Rec['SpecialityName']; ?></TD>
<TD NOWRAP><?php echo $Rec['StuTypeTime']; ?></TD>
</TR>
<?php
}
?>
<?php for ($j=$i;$j<10;$j++)
{
?>
<TR ALIGN="center">
<TD NOWRAP> </TD>
<TD NOWRAP> </TD>
<TD NOWRAP> </TD>
<TD NOWRAP> </TD>
<TD NOWRAP> </TD>
<TD NOWRAP> </TD>
<TD NOWRAP> </TD>
<TD NOWRAP> </TD>
<TD NOWRAP> </TD>
<TD NOWRAP> </TD>
</TR>
<?php
}
?>
<TR>
<TD HEIGHT="30" COLSPAN="10" ALIGN="right" NOWRAP >共<?php echo $RecCounts;?>条/<?php echo $page->tpage;?>页 <?php echo $page->output; ?></TD>
</TR>
<TR ALIGN="center" CLASS="biaoti-s">
<TD HEIGHT="30" NOWRAP>总计</TD>
<TD COLSPAN="2" NOWRAP><?php echo ($recruitgoal=='')?'0'recruitgoal; ?></TD>
<TD NOWRAP><?php echo ($signupfee=='')?'0':$signupfee; ?></TD>
<TD NOWRAP><?php echo ($bespoketicket=='')?'0':$bespoketicket; ?></TD>
<TD NOWRAP><?php echo ($handtuition=='')?'0':$handtuition; ?></TD>
<TD NOWRAP><?php echo ($leaveschool=='')?'0':$leaveschool; ?></TD>
<TD COLSPAN="2" NOWRAP>招生成果总计</TD>
<TD NOWRAP><SPAN STYLE="color:#FF0000; font-size:16px"><?php echo ($fruitbalance=='')?'0':$fruitbalance; ?></SPAN></TD>
</TR>
<TR>
<TD HEIGHT="30" COLSPAN="10" ALIGN="center" CLASS="td1"><INPUT NAME="print" TYPE="BUTTON" ID="print" VALUE="打印预览" onClick=" rintPage('printfruitbalance.php?<?php echo $_SERVER['QUERY_STRING'];?>');"></TD>
</TR>
</TABLE>
</BODY>
</HTML>
<?php
DBFreeResult($sth);
?>
请帮忙分析一下问题出在那儿。谢谢。
|
|
