PHP JPDO Examples

Example #1

File: products_list3.php Project: AuTiMoThY/Dfocus-concord-php

<?php

include_once 'config.php';
include_once INC_PATH . 'headleader.php';
require_once INC_PATH . 'aunav.php';
//	include_once 'dist/chatroom_data.php';
$shownum = 6;
$p = isset($_GET["p"]) ? $p = $_GET["p"] : ($p = 1);
$db = new JPDO();
$sql = "SELECT *\n\t\t\tFROM `advisory`\n\t\t\tWHERE `enable`='Y'\n\t\t";
$rowPerPage = $shownum;
$pageNo = $p - 1;
$arrOrderBy = isset($_GET['_orderBy']) ? $_GET['_orderBy'] : array('`advisory`.`ord` ASC', '`advisory`.`id` DESC');
$pager = $db->queryFetchPage($sql, $pageNo, $shownum, $arrOrderBy);
$start = ($p - 1) * $shownum;
$maxPage = $pager->pageNum;
if ($p > $maxPage || $p < 1 || !is_int($p * 1) || !isset($_GET["p"])) {
    $p = 1;
    header("Location: products_list3.php?p={$p}");
}
?>
<title>康和期經產品介紹 | <?php 
echo $webTitle;
?>
</title>

<?php 
// -------------------------------
// SEO
// CSS
// Script in the HEAD

Example #2

File: fundprice-date.js.php Project: AuTiMoThY/Dfocus-concord-php

<?
	require_once('local.inc');
	header('Content-Type: text/html; charset=utf-8');
	sleep(1);
	$ret=array();
	$ret[0]=$_REQUEST['fieldId'];
	$ret[1]=true;
	$db = new JPDO();
	$r = $db->queryFetch(
				"SELECT * FROM `fundprice` WHERE `date`=:date",
				array(':date'=>$_REQUEST['fieldValue'])
			);
	if( $r!==false )	{
		$ret[1]=false;
	}
	die( json_encode($ret) );
?>

Example #3

File: news.php Project: AuTiMoThY/Dfocus-concord-php

<?php

include_once 'config.php';
include_once INC_PATH . 'headleader.php';
require_once INC_PATH . 'aunav.php';
include_once 'dist/news_data.php';
$shownum = 6;
$p = isset($_GET["p"]) ? $p = $_GET["p"] : ($p = 1);
$db = new JPDO();
$sql = "SELECT *\n\t\t\tFROM `news`\n\t\t\tWHERE `enable`='Y'\n\t\t\t\tAND `type`=:type\n\t\t";
$rowPerPage = $shownum;
$pageNo = $p - 1;
$arrOrderBy = isset($_GET['_orderBy']) ? $_GET['_orderBy'] : array('`news`.`date` DESC', '`news`.`id` DESC');
$pagerText = $db->queryFetchPage($sql, $pageNo, 6, $arrOrderBy, array(':type' => '圖文'));
$pagerVideo = $db->queryFetchPage($sql, $pageNo, 2, $arrOrderBy, array(':type' => '影音'));
$start = ($p - 1) * $shownum;
// 總頁數
$maxPage = $pagerText->pageNum >= $pagerVideo->pageNum ? $pagerText->pageNum : $pagerVideo->pageNum;
if ($p > $maxPage || $p < 1 || !is_int($p * 1) || !isset($_GET["p"])) {
    $p = 1;
    header("Location: news.php?p={$p}");
}
?>
<title>市場消息 / 康和快訊 | <?php 
echo $webTitle;
?>
</title>

<?php 
// -------------------------------
// SEO

Example #4

File: JPDO.inc.php Project: AuTiMoThY/Dfocus-concord-php

 public static function initConnFactory($fpathConnConfig)
 {
     //
     self::$arrConnConfig = parse_ini_file($fpathConnConfig, true);
 }

Example #5

File: news_search.php Project: AuTiMoThY/Dfocus-concord-php

<?php

include_once 'config.php';
include_once INC_PATH . 'headleader.php';
require_once INC_PATH . 'aunav.php';
$shownum = 6;
$p = isset($_GET["p"]) ? $p = $_GET["p"] : ($p = 1);
$db = new JPDO();
$sql = "SELECT *\n\t\t\tFROM `news`\n\t\t\tWHERE `enable`='Y'\n\t\t\t\tAND `type`='圖文'\n\t\t\t\tAND\n\t\t\t\t( `title` LIKE :search\n\t\t\t\t\tOR `content` LIKE :search\n\t\t\t\t)\n\t\t";
$rowPerPage = $shownum;
$pageNo = $p - 1;
$arrOrderBy = isset($_GET['_orderBy']) ? $_GET['_orderBy'] : array('`news`.`date` DESC', '`news`.`id` DESC');
$pager = $db->queryFetchPage($sql, $pageNo, 6, $arrOrderBy, array(':search' => "%{$_GET['search']}%"));
$start = ($p - 1) * $shownum;
// 總頁數
$maxPage = $pager->pageNum;
?>
<title>文章搜尋 | <?php 
echo $webTitle;
?>
</title>

<?php 
// -------------------------------
// SEO
// CSS
// Script in the HEAD
// -------------------------------
include_once INC_PATH . 'head.php';
?>