当前位置: 首页>>代码示例>>PHP>>正文


PHP ConnectionFactory::FiscDB方法代码示例

本文整理汇总了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>";
        }
    }
}
开发者ID:urisk,项目名称:cssServiceRequests,代码行数:23,代码来源:users.php

示例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;
开发者ID:urisk,项目名称:cssServiceRequests,代码行数:9,代码来源:getWrqCodes.php


注:本文中的ConnectionFactory::FiscDB方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。