本文整理匯總了PHP中ConnectionFactory::FiscDB方法的典型用法代碼示例。如果您正苦於以下問題：PHP ConnectionFactory::FiscDB方法的具體用法？PHP ConnectionFactory::FiscDB怎麽用？PHP ConnectionFactory::FiscDB使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類ConnectionFactory的用法示例。
在下文中一共展示了ConnectionFactory::FiscDB方法的2個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: getAssignedToOptions
function getAssignedToOptions()
{
$empno = '';
if (isset($_SESSION['Empno'])) {
$empno = $_SESSION['Empno'];
}
$role = '';
if (isset($_SESSION['Role'])) {
$role = $_SESSION['Role'];
}
$db = ConnectionFactory::getFactory()->getConnection();
$statement = "select lbr.empno,lbr.name from (" . " select Empno= Stnote_2" . " from " . ConnectionFactory::FiscDB() . ".dbo.fmdfsrq" . " where stnote_2 <> ''" . " group by stnote_2" . ")srq," . ConnectionFactory::FiscDB() . ".dbo.tcdflbr lbr" . " where srq.empno = lbr.empno";
$query = $db->prepare($statement);
$query->execute();
echo "<option value=\"\"></option>";
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
if ($role == 'T' && $row['empno'] == $empno) {
echo "<option value=\"" . $row['empno'] . "\" selected=\"selected\">" . $row['name'] . "</option>";
} else {
echo "<option value=\"" . $row['empno'] . "\"\\>" . $row['name'] . "</option>";
}
}
}示例2:
<?php
include_once '../includes/CamsDatabase.php';
$db = ConnectionFactory::getFactory()->getConnection();
$query = $db->prepare("SELECT Wrq,Descr FROM " . ConnectionFactory::FiscDB() . ".dbo.fmdfwrq");
$query->execute();
$result = $query->fetchAll(PDO::FETCH_ASSOC);
$Wrqs = json_encode($result);
echo $Wrqs;