PHP SplitPage 예제들

예제 #1

파일: DetailView_list0304.php 프로젝트: airfox7412/ps01

$conn = ew_Connect();
$sql = "SELECT a.PatientID,a.StudyID,b.PatientID FROM patient_detail a , patient_main b ";
$sql .= "WHERE a.PatientID=b.PatientID ";
$sql .= $sstr;
$sql .= "GROUP BY a.StudyID ";
$sql .= "ORDER BY a.StudyDate";
//echo $sql."<br>";
$rs = $conn->Execute($sql);
$total = $rs->recordcount();
if (isset($_GET['page']) and $_GET['page'] != 0 and is_numeric($_GET['page'])) {
    //設定目前頁數
    $nowPage = $_GET['page'];
} else {
    $nowPage = 1;
}
$page = new SplitPage($nowPage, $total, 15, 20);
//建構出 SplitPage 物件
$page->setViewList("DetailView_list.php?", 'reportcode');
$rs->Close();
$sql = "SELECT * FROM patient_detail a , patient_main b ";
$sql .= "WHERE a.PatientID=b.PatientID ";
$sql .= $sstr;
$sql .= "GROUP BY a.StudyID ";
$sql .= "ORDER BY a.StudyDate ";
$sql .= "limit {$page->started_record}, {$page->records_per_page}";
//echo $sql;
if ($rs = $conn->Execute($sql)) {
    if ($nowPage != 1) {
        $rcnt = ($nowPage - 1) * 15 + 1;
    } else {
        $rcnt = 1;

예제 #2

파일: report_code_desc_list.php 프로젝트: airfox7412/ps01

	</tr>
</table>
</form>
<?php 
$sql = "select count(*) as total from report_code_desc ";
$sql .= $sstr;
//echo $sql."<br>";
$row = $conn->Execute($sql);
$total = $row->fields('total');
if (isset($_GET['page']) and $_GET['page'] != 0 and is_numeric($_GET['page'])) {
    //設定目前頁數
    $nowPage = $_GET['page'];
} else {
    $nowPage = 1;
}
$page = new SplitPage($nowPage, $total, 20, 20);
//建構出 SplitPage 物件
$page->setViewList("report_code_desc_list.php?", 'reportcode');
//設定導覽列資料,參數1為連結的頁面,參數2為連結的target(本參數可不設定)
//echo "<font color=#0000ff>".$page->viewlist."</font>";
$sSql = "SELECT * FROM report_code_desc ";
$sSql .= $sstr;
$sSql .= "ORDER BY ReportCode ";
$sSql .= " limit {$page->started_record}, {$page->records_per_page}";
//echo $sSql;
if ($rs = $conn->Execute($sSql)) {
    $rs->MoveFirst();
    ?>
<div align="right">
	<input type="button" name="new" value="新增代碼" onclick="window.location='report_code_desc_add.php?page=<?php 
    echo $nowPage;

예제 #3

파일: importlog_list.php 프로젝트: airfox7412/ps01

    <?php 
$conn = ew_Connect();
$sql = "SELECT * FROM import_log ";
$sql .= "WHERE (1) ";
$sql .= $sstr;
$sql .= "ORDER BY iid DESC ";
//echo $sql."<br>";
$rs = $conn->Execute($sql);
$total = $rs->recordcount();
if (isset($_GET['page']) and $_GET['page'] != 0 and is_numeric($_GET['page'])) {
    //設定目前頁數
    $nowPage = $_GET['page'];
} else {
    $nowPage = 1;
}
$page = new SplitPage($nowPage, $total, 30, 20);
//建構出 SplitPage 物件
$page->setViewList("importlog_list.php?", 'reportcode');
$rs->Close();
$sql = "SELECT * FROM import_log ";
$sql .= "WHERE (1) ";
$sql .= $sstr;
$sql .= "ORDER BY iid DESC ";
$sql .= "limit {$page->started_record}, {$page->records_per_page}";
//echo $sql;
if ($rs = $conn->Execute($sql)) {
    $rs->MoveFirst();
    while (!$rs->EOF) {
        $SN = $rs->fields('iid');
        $sname = $rs->fields('sname');
        $fname = $rs->fields('fname');

예제 #4

파일: hospital_list.php 프로젝트: airfox7412/ps01

            <td>資料庫名稱</td>
            <td style="white-space: nowrap;">&nbsp;</td>
            <!--<td style="white-space: nowrap;">&nbsp;</td>-->
        </tr>
    <?php 
$conn = ew_Connect();
$sql = "SELECT * FROM hospital";
$rs = $conn->Execute($sql);
$total = $rs->recordcount();
if (isset($_GET['page']) and $_GET['page'] != 0 and is_numeric($_GET['page'])) {
    //設定目前頁數
    $nowPage = $_GET['page'];
} else {
    $nowPage = 1;
}
$page = new SplitPage($nowPage, $total, 15, 20);
//建構出 SplitPage 物件
$page->setViewList("hospital_list.php?", "reportcode");
$rs->Close();
$sql = "SELECT * FROM hospital ";
$sql .= "LIMIT {$page->started_record}, {$page->records_per_page}";
//echo $sql;
if ($rs = $conn->Execute($sql)) {
    if ($nowPage != 1) {
        $rcnt = ($nowPage - 1) * 15 + 1;
    } else {
        $rcnt = 1;
    }
    $rs->MoveFirst();
    while (!$rs->EOF) {
        $sn = $rs->fields('sn');

예제 #5

파일: report_special_word_list.php 프로젝트: airfox7412/ps01

	</tr>
</table>
</form>
<?php 
$sql = "select count(*) as total from report_special_word ";
$sql .= $sstr;
//echo $sql."<br>";
$row = $conn->Execute($sql);
$total = $row->fields('total');
if (isset($_GET['page']) and $_GET['page'] != 0 and is_numeric($_GET['page'])) {
    //設定目前頁數
    $nowPage = $_GET['page'];
} else {
    $nowPage = 1;
}
$page = new SplitPage($nowPage, $total, 20, 20);
//建構出 SplitPage 物件
$page->setViewList("report_special_word_list.php?", 'reportcode');
//設定導覽列資料,參數1為連結的頁面,參數2為連結的target(本參數可不設定)
//echo "<font color=#0000ff>".$page->viewlist."</font>";
$sSql = "SELECT * FROM report_special_word ";
$sSql .= $sstr;
$sSql .= " limit {$page->started_record}, {$page->records_per_page}";
//echo $sSql;
if ($rs = $conn->Execute($sSql)) {
    $rs->MoveFirst();
    ?>
<div align="right">
	<input type="button" name="new" value="新增代碼" onclick="window.location='report_special_word_add.php?page=<?php 
    echo $nowPage;
    ?>