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>"; } } }
<?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;