function cs_sql_count($cs_file, $sql_table, $sql_where = 0, $distinct = 0)
{
global $cs_db;
$row = empty($distinct) ? '*' : 'DISTINCT ' . $distinct;
$sql_query = 'SELECT COUNT(' . $row . ') FROM ' . $cs_db['prefix'] . '_' . $sql_table;
$sql_query .= empty($sql_where) ? '' : ' WHERE ' . $sql_where;
$sql_query = str_replace('{pre}', $cs_db['prefix'], $sql_query);
if (!($sql_data = sqlsrv_query($cs_db['con'], $sql_query))) {
cs_error_sql($cs_file, 'cs_sql_count', cs_sql_error(0, $sql_query));
return NULL;
}
sqlsrv_fetch($sql_data);
$sql_result = sqlsrv_get_field($sql_data, 0);
sqlsrv_free_stmt($sql_data);
cs_log_sql($cs_file, $sql_query);
return $sql_result;
}
public static function query($queryStr = '', $objectStr = '')
{
$queryDB = sqlsrv_query(self::$dbConnect, $queryStr);
if (preg_match('/insert into/i', $queryDB)) {
sqlsrv_next_result($queryDB);
sqlsrv_fetch($queryDB);
self::$insertID = sqlsrv_get_field($queryDB, 0);
}
if ($queryDB) {
if (is_object($objectStr)) {
$objectStr($queryDB);
}
// sqlsrv_free_stmt($queryDB);
return $queryDB;
} else {
self::$error = sqlsrv_errors();
return false;
}
}
function get_topic_id($topic)
{
$params = array($topic);
$options = array("Scrollable" => 'static');
$addTopicSQL = "INSERT into Topics Values (?)";
$getTopicIDSQL = "SELECT TOP 1 TopicID FROM Topics \n WHERE Topic = ?\n ORDER BY TopicID Desc";
$TopicID = 0;
$addTopic = sqlsrv_query($con, $addTopicSQL, $params, $options);
if ($addTopic === false) {
die(print_r(sqlsrv_errors(), true));
}
$getTopicID = sqlsrv_query($con, $getTopicIDSQL, $params, $options);
if ($getTopicID === false) {
die(print_r(sqlsrv_errors(), true));
}
if (sqlsrv_fetch($getTopicID) === true) {
$TopicID = sqlsrv_get_field($getTopicID, 0);
}
return $TopicID;
}
/**
* Returns a single column from the next row of a result set.
*
* @param int $col OPTIONAL Position of the column to fetch.
* @return string
* @throws \Zend\DB\Statement\Exception
*/
public function fetchColumn($col = 0)
{
if (!$this->_stmt) {
return false;
}
if (!sqlsrv_fetch($this->_stmt)) {
if (null !== ($error = sqlsrv_errors())) {
throw new Exception($error);
}
// If no error, there is simply no record
return false;
}
$data = sqlsrv_get_field($this->_stmt, $col);
//0-based
if ($data === false) {
throw new Exception(sqlsrv_errors());
}
return $data;
}
die(print_r(sqlsrv_errors(), true));
}
$num_admins = sqlsrv_num_rows($admins);
$institutions = [];
$fnames = [];
$lnames = [];
$adminids = [];
$designations = [];
$dates = [];
while (sqlsrv_fetch($admins) === true) {
$institutions[] = sqlsrv_get_field($admins, 0);
$fnames[] = sqlsrv_get_field($admins, 1);
$lnames[] = sqlsrv_get_field($admins, 2);
$adminids[] = sqlsrv_get_field($admins, 3);
$designations[] = sqlsrv_get_field($admins, 4);
$dates[] = sqlsrv_get_field($admins, 5);
}
?>
<body>
<div id="wrapper">
<div id="sidebar"></div>
<div id="page-content-wrapper">
<button type="button" class="hamburger is-closed" data-toggle="offcanvas">
<span class="hamb-top"></span>
<span class="hamb-middle"></span>
<span class="hamb-bottom"></span>
</button>
<div class="container-fluid">
<div class="row">
<div class="col-lg-8">
<h1>Smalltalk Admins</h1>
function _query($sql, $inputarr = false)
{
$this->_errorMsg = false;
if (is_array($sql)) {
$sql = $sql[1];
}
$insert = false;
// handle native driver flaw for retrieving the last insert ID
if (preg_match('/^\\W*insert\\s(?:(?:(?:\'\')*\'[^\']+\'(?:\'\')*)|[^;\'])*;?$/i', $sql)) {
$insert = true;
$sql .= '; ' . $this->identitySQL;
// select scope_identity()
}
if ($inputarr) {
$rez = sqlsrv_query($this->_connectionID, $sql, $inputarr);
} else {
$rez = sqlsrv_query($this->_connectionID, $sql);
}
if ($this->debug) {
ADOConnection::outp("<hr>running query: " . var_export($sql, true) . "<hr>input array: " . var_export($inputarr, true) . "<hr>result: " . var_export($rez, true));
}
if (!$rez) {
$rez = false;
} else {
if ($insert) {
// retrieve the last insert ID (where applicable)
while (sqlsrv_next_result($rez)) {
sqlsrv_fetch($rez);
$this->lastInsertID = sqlsrv_get_field($rez, 0);
}
}
}
return $rez;
}
protected function insert_id($db, $result)
{
sqlsrv_next_result($result);
sqlsrv_fetch($result);
return (int) sqlsrv_get_field($result, 0);
}
/**
* @brief 결과를 fetch
**/
function _fetch($result)
{
if (!$this->isConnected() || $this->isError() || !$result) {
return;
}
$c = sqlsrv_num_fields($result);
$m = null;
$output = array();
while (sqlsrv_fetch($result)) {
if (!$m) {
$m = sqlsrv_field_metadata($result);
}
unset($row);
for ($i = 0; $i < $c; $i++) {
$row->{$m[$i]['Name']} = sqlsrv_get_field($result, $i, SQLSRV_PHPTYPE_STRING('utf-8'));
}
$output[] = $row;
}
if (count($output) == 1) {
return $output[0];
}
return $output;
}
$pwd = "123456";
$connectionInfo = array("UID" => $uid, "PWD" => $pwd, "Database" => "MBOOK");
$conn = sqlsrv_connect($serverName, $connectionInfo);
sqlsrv_query($conn, "set names GB2312");
$sql = "SELECT * FROM TBook WHERE TBook.ISBN='{$isbn}'";
$result = sqlsrv_query($conn, $sql);
$row = sqlsrv_fetch($result);
$book_name = sqlsrv_get_field($result, 1);
$author = sqlsrv_get_field($result, 2);
$publisher = sqlsrv_get_field($result, 3);
$publish_date = sqlsrv_get_field($result, 4, SQLSRV_PHPTYPE_STRING(SQLSRV_ENC_CHAR));
$price = sqlsrv_get_field($result, 5);
$fuben_num = sqlsrv_get_field($result, 6);
$store_num = sqlsrv_get_field($result, 7);
$type_num = sqlsrv_get_field($result, 8);
$content_view = sqlsrv_get_field($result, 9);
$sql = "SELECT * FROM TBLend WHERE ISBN='{$isbn}' AND 是否借出=0";
$result = sqlsrv_query($conn, $sql);
require_once "top_menu.php";
?>
<!--内容模块-->
<div class="container">
<div class="content_display_book">
<table class="table table-bordered">
<thead>
<th colspan="3"><p class="text-center">图书信息表</p></th>
</thead>
<tbody>
<tr>
<td><strong>ISBN</strong></td>
<td><?php
<?php
include 'DBConnection.php';
$lng_min = $_REQUEST['lng_min'];
$lat_min = $_REQUEST['lat_min'];
$lng_max = $_REQUEST['lng_max'];
$lat_max = $_REQUEST['lat_max'];
$tsql = "SELECT event_id, latitude, longtitude, name, working_on, looking_for FROM event WHERE longtitude >= {$lng_min} AND longtitude <= {$lng_max} AND latitude >= {$lat_min} AND latitude <= {$lat_max}";
$stmt = sqlsrv_query($conn, $tsql);
if ($stmt === false) {
echo "Error in statement preparation/execution.\n";
die(print_r(sqlsrv_errors(), true));
}
echo '[';
$is_first = 1;
while (sqlsrv_fetch($stmt)) {
$event_id = sqlsrv_get_field($stmt, 0);
$lat = sqlsrv_get_field($stmt, 1);
$lng = sqlsrv_get_field($stmt, 2);
$name = sqlsrv_get_field($stmt, 3, SQLSRV_PHPTYPE_STRING(SQLSRV_ENC_CHAR));
$working_on = sqlsrv_get_field($stmt, 4, SQLSRV_PHPTYPE_STRING(SQLSRV_ENC_CHAR));
$looking_for = sqlsrv_get_field($stmt, 5, SQLSRV_PHPTYPE_STRING(SQLSRV_ENC_CHAR));
if ($is_first == 0) {
echo ",";
}
echo "[\"{$event_id}\", \"{$lat}\",\"{$lng}\",\"{$name}\", \"{$working_on}\", \"{$looking_for}\"]";
$is_first = 0;
}
echo ']';
include 'DBConnectionClose.php';
public function insert_records($tablename, $datas)
{
//Before any Query, first get the table description
if (!$this->describe_table($tablename)) {
return false;
}
if (!(gettype($datas) == 'array')) {
trigger_error("Unsupported datatype for datas. Array expected, " . gettype($datas) . " passed", E_USER_ERROR);
return false;
}
if (sizeof($datas) < 1) {
trigger_error("No values passed to insert query", E_USER_ERROR);
return false;
}
$sql = "INSERT INTO " . $tablename . " ";
//$tempdata = array_values($datas);
$insertclause = $this->insert_clause_builder($datas[0]);
$placeholder = array();
$i = sizeof($datas);
while ($i > 0) {
$placeholder[] = $insertclause[1];
$i--;
}
$insertclause[1] = implode(",", $placeholder);
$sql .= $insertclause[0] . " VALUES " . $insertclause[1] . "; SELECT SCOPE_IDENTITY();";
$tempArray = array();
foreach ($data as $key => $value) {
$tempArray[] =& $value;
}
$stmt = sqlsrv_query($this->connection, $sql, $tempArray);
if (!$stmt) {
return false;
}
sqlsrv_next_result($stmt);
sqlsrv_fetch($stmt);
$newId = sqlsrv_get_field($stmt, 0);
if ($newId > 0) {
return $newId;
} else {
return true;
}
}
function user_is_role($email, $role)
{
$return_value = 0;
$user_id = user_exist_sqlsrv($email);
$role_id = role_to_roleid($role);
global $conn;
$qry = "SELECT count(*) AS count FROM user_role WHERE user_id = ? AND role_id = ? AND active = 1";
$params = array(&$user_id, &$role_id);
$rst = sqlsrv_prepare($conn, $qry, $params);
sqlsrv_execute($rst);
sqlsrv_fetch($rst);
error_log("checked {$email} for role {$role} using {$user_id} and {$role_id}");
$return_value = sqlsrv_get_field($rst, 0);
sql_errors_display("from user is role");
return $return_value;
}
/**
* Returns the next ID of a table
*
* @param string $table the name of the table
* @param string $id the name of the ID column
* @return int
*/
public function nextID($table, $id)
{
$select = sprintf("\n SELECT \n max(%d) as current_id \n FROM \n %s", $id, $table);
$result = $this->query($select);
$stmt = sqlsrv_fetch($result);
return sqlsrv_get_field($stmt, 0) + 1;
}
if ($conn) {
echo "Connection established.<br />";
} else {
echo "Connection could not be established.<br />";
die(print_r(sqlsrv_errors(), true));
}
$sql = "SELECT MasterPatientID FROM vCrgvrPrtl_User\tWHERE vCrgvrPrtl_User.CaregiverPin = '{$pin}' AND UPPER(vCrgvrPrtl_User.FirstName) = '{$firstname}' AND UPPER(vCrgvrPrtl_User.LastName) ='{$lastname}';";
$stmt = sqlsrv_query($conn, $sql);
if ($stmt === false) {
die(print_r(sqlsrv_errors(), true));
} else {
if (sqlsrv_has_rows($stmt) != 1) {
header("location: logerror.php");
// Redirecting To Invalid pin Page
} else {
// Make the first (and in this case, only) row of the result set available for reading.
if (sqlsrv_fetch($stmt) === false) {
die(print_r(sqlsrv_errors(), true));
} else {
// Get the row fields. Field indeces start at 0 and must be retrieved in order.
// Retrieving row fields by name is not supported by sqlsrv_get_field.
$mpi = sqlsrv_get_field($stmt, 0);
$_SESSION['mpi'] = $mpi;
sqlsrv_free_stmt($stmt);
sqlsrv_close($conn);
header("location: portal.php");
// Redirecting To Other Page
}
}
}
}
/**
* Returns a single column from the next row of a
* result set or FALSE if there are no more rows.
*
* @param integer $columnIndex 0-indexed number of the column you wish to retrieve from the row. If no
* value is supplied, Doctrine_Adapter_Statement_Interface->fetchColumn()
* fetches the first column.
*
* @return string returns a single column in the next row of a result set.
*/
public function fetchColumn($columnIndex = 0)
{
if (!is_integer($columnIndex)) {
$this->handleError(array('message' => "columnIndex parameter should be numeric"));
}
if (!$this->statement) {
return false;
}
if (false === sqlsrv_fetch($this->statement)) {
if (null !== ($error = sqlsrv_errors())) {
$this->handleError();
}
// If no error, there is simply no record
return false;
}
$data = sqlsrv_get_field($this->statement, $columnIndex);
//0-based
if ($data === false) {
$this->handleError();
}
return $data;
}
<div class="panel panel-primary" style="min-height:220px">
<div class="panel-heading">
Worksheet Details
</div>
<div class="panel-body">
<?php
$params = array($courseID, $worksheetNum, $courseID, $worksheetNum);
$options = array("Scrollable" => 'static');
$worksheetInfoQuery = "\n SELECT DISTINCT [TO].Topic, LEFT(CONVERT(VARCHAR, E.Date, 120), 10) \n\t\t FROM Expressions as E, Topics as [TO]\n WHERE E.[Teachers&ClassesID] = ? AND\n E.[Worksheet#] = ? AND\n\t\t\t\t [TO].Topic_ID = E.[Topic_ID] AND\n E.Date = (SELECT min(Date) FROM Expressions WHERE [Teachers&ClassesID] = ? AND [Worksheet#] = ?)";
$stmt = sqlsrv_query($con, $worksheetInfoQuery, $params, $options);
if ($stmt === false) {
die(print_r(sqlsrv_errors(), true));
}
if (sqlsrv_fetch($stmt) === true) {
$topic = sqlsrv_get_field($stmt, 0);
$date = sqlsrv_get_field($stmt, 1);
}
echo "<p>Topic: {$topic}</p><p>Date: {$date}";
?>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-lg-10">
<div class="panel panel-primary">
<div class="panel-heading">Worksheet display</div>
<!-- Select Rows Per Page -->
<div class="dropdown">
<button class="btn btn-default dropdown-toggle" type="button" id="dropdownMenu1" data-toggle="dropdown" aria-haspopup="true" aria-expanded="true">
include '../../../../base.php';
if (isset($_POST['worksheetID']) && isset($_POST['courseID'])) {
$sentence_number = isset($_POST['newexpressionnumber']) ? $_POST['newexpressionnumber'] : 0;
$worksheetID = $_POST['worksheetID'];
$courseID = $_POST['courseID'];
$params = array($worksheetID);
$options = array("Scrollable" => 'static');
$coursestudentsSQL = "SELECT S.StudentID, S.FirstName, S.LastName\n FROM Enrollment as ER, Worksheets as W, Courses C, Students S\n WHERE W.WorksheetID = ? AND\n C.CourseID = W.CourseID AND\n ER.CourseID = C.CourseID AND\n S.StudentID = ER.StudentID";
$coursestudents = sqlsrv_query($con, $coursestudentsSQL, $params, $options);
if ($coursestudents === false) {
die(print_r(sqlsrv_errors(), true));
}
$num_students = sqlsrv_num_rows($coursestudents);
$studentsids = [];
$first_names = [];
$last_names = [];
while (sqlsrv_fetch($coursestudents) === true) {
$studentids[] = sqlsrv_get_field($coursestudents, 0);
$first_names[] = sqlsrv_get_field($coursestudents, 1);
$last_names[] = sqlsrv_get_field($coursestudents, 2);
}
echo "\n<div class=\"panel-body\">\n <div class=\"control-group controls\" id=\"fields\">\n <form>\n <input hidden type=\"text\" name=\"newexpressionnumber\" value=\"{$sentence_number}\">\n <input hidden type=\"text\" name=\"worksheetID\" value=\"{$worksheetID}\">\n <input hidden type=\"text\" name=\"courseID\" value=\"{$courseID}\">\n <div class=\"form-group row\">\n \n <div class=\"col-xs-4 col-md-6\">\n <h4 style=\"text-decoration:underline\">Sentence #{$sentence_number}</h4>\n <label>Student:\n <select class=\"form-control\" name=\"selectstudent\">\n <option selected=\"selected\" value=\"0\">--Select Student--</option>";
for ($i = 0; $i < $num_students; $i++) {
echo "<option value=\"{$studentids[$i]}\">{$first_names[$i]} {$last_names[$i]}</option>";
}
echo " \n </select></label>\n </div>\n <div class=\"col-xs-2\">\n <div class=\"radio\">\n <label><input type=\"radio\" value=\"all\" name=\"alldo\">All-Do</label>\n </div>\n <div class=\"radio\">\n <label><input type=\"radio\" value=\"individual\" name=\"alldo\" checked=\"checked\">Individual</label>\n </div>\n\n \n </div>\n </div>\n <div class=\"form-group row\">\n <div class=\"col-md-8 col-xs-12\">\n <label for=\"CorrectedExpr\">Expression:</label>\n <input type=\"text\" class=\"form-control\" name=\"Expression\">\n </div>\n </div>\n <div class=\"form-group row\">\n <div class=\"col-md-5 col-xs-7\">\n <label for=\"ContextVocab\">Context/Vocab: </label>\n <input name=\"ContextVocab\" type=\"text\" class=\"form-control\">\n </div>\n <div class=\"col-md-3 col-xs-5\">\n <label for=\"PronCorr\">Pronunciation:</label>\n <input type=\"text\" class=\"form-control\" name=\"Pronunciation\">\n </div>\n </div>\n \n <div class=\"form-group row\">\n <div class=\"col-xs-12\">\n <div class=\"btn-group\" role=\"group\">\n <button type=\"button\" name=\"SaveExpression\" class=\"btn btn-primary\">Save</button>\n </div>";
/*<div class=\"btn-group\" role=\"group\">
<button type=\"button\" id=\"SaveAndCreateNewExpression\" class=\"btn btn-primary\">Save and Create a New Expression</button>
</div>*/
echo "\n </div>\n </div>\n </form>\n </div>\n</div>\n";
}
/**
* Low level handling getting a row from a result set; automatically
* makes all fetched values strings, just like the other PHP db functions.
* We have to do this since the sqlsrv extension returns row values in thier
* native types, which causes problems with how we handle things.
*
* @param resource $result
* @return array
*/
private function _fetchRowAssoc($result)
{
if (!is_resource($result)) {
return false;
}
$row = array();
$fieldnames = $this->getFieldsArray($result);
$fieldMetaData = sqlsrv_field_metadata($result);
if (sqlsrv_fetch($result)) {
for ($i = 0; $i < sqlsrv_num_fields($result); $i++) {
if ($fieldMetaData[$i]['Type'] == -9 || $fieldMetaData[$i]['Type'] >= SQLSRV_SQLTYPE_NVARCHAR(1) && $fieldMetaData[$i]['Type'] <= SQLSRV_SQLTYPE_NVARCHAR(8000) || $fieldMetaData[$i]['Type'] >= SQLSRV_SQLTYPE_NCHAR(1) && $fieldMetaData[$i]['Type'] <= SQLSRV_SQLTYPE_NCHAR(8000) || $fieldMetaData[$i]['Type'] == SQLSRV_SQLTYPE_NVARCHAR('max') || $fieldMetaData[$i]['Type'] == SQLSRV_SQLTYPE_NCHAR('max')) {
$row[$fieldnames[$i]] = iconv("utf-16le", "utf-8", sqlsrv_get_field($result, $i, SQLSRV_PHPTYPE_STRING(SQLSRV_ENC_BINARY)));
} else {
$row[$fieldnames[$i]] = sqlsrv_get_field($result, $i, SQLSRV_PHPTYPE_STRING(SQLSRV_ENC_CHAR));
}
}
} else {
sqlsrv_free_stmt($result);
}
return $row;
}
$worksheetsubmissions = sqlsrv_query($con, $worksheetsubmissionsSQL, $params, $options);
if ($worksheetsubmissions === false) {
die(print_r(sqlsrv_errors(), true));
}
$num_submissions = sqlsrv_num_rows($worksheetsubmissions);
$sub_first_names = [];
$sub_last_names = [];
$sub_ids = [];
$sub_dates = [];
$sub_attempts = [];
while (sqlsrv_fetch($worksheetsubmissions) === true) {
$sub_first_names[] = sqlsrv_get_field($worksheetsubmissions, 0);
$sub_last_names[] = sqlsrv_get_field($worksheetsubmissions, 1);
$sub_ids[] = sqlsrv_get_field($worksheetsubmissions, 2);
$sub_dates[] = sqlsrv_get_field($worksheetsubmissions, 3);
$sub_attempts[] = sqlsrv_get_field($worksheetsubmissions, 4);
}
?>
<body>
<div id="wrapper">
<div id = "sidebar"></div>
<div id="page-content-wrapper">
<button type="button" class="hamburger is-closed" data-toggle="offcanvas">
<span class="hamb-top"></span>
<span class="hamb-middle"></span>
<span class="hamb-bottom"></span>
</button>
<div class="container-fluid">
<div class="row">
<meta http-equiv='refresh' content='5;/' />
<?php
} else {
$params = array();
$options = array("Scrollable" => 'static');
$query = "SELECT * FROM CLAWS7";
$stmt = sqlsrv_query($con, $query, $params, $options);
if ($stmt === false) {
die(print_r(sqlsrv_errors(), true));
}
$tag_names = [];
$tag_desc = [];
$num_rows = sqlsrv_num_rows($stmt);
while (sqlsrv_fetch($stmt) === true) {
$tag_names[] = sqlsrv_get_field($stmt, 0);
$tag_desc[] = sqlsrv_get_field($stmt, 1);
}
?>
<body>
<div class="container-fluid">
<div class="panel panel-primary">
<div class="panel-heading">
CLAWS7 Tagset
</div>
<div class="panel-body">
<table class="table table-hover">
<thead>
<tr>
<th>Tag</th>
<th>Description</th>
</tr>
if ($worksheetsubmissions === false) {
die(print_r(sqlsrv_errors(), true));
}
$resultlength = sqlsrv_num_rows($worksheetsubmissions);
if ($resultlength == 0) {
echo "No Submissions!";
} else {
$coursenames = [];
$worksheetnumbers = [];
$studentsubmissionids = [];
$worksheetids = [];
while (sqlsrv_fetch($worksheetsubmissions) === true) {
$coursenames[] = sqlsrv_get_field($worksheetsubmissions, 0);
$worksheetnumbers[] = sqlsrv_get_field($worksheetsubmissions, 1);
$studentsubmissionids[] = sqlsrv_get_field($worksheetsubmissions, 2);
$worksheetids[] = sqlsrv_get_field($worksheetsubmissions, 3);
}
for ($i = 0; $i < $resultlength; $i++) {
echo "<tr><td>{$coursenames[$i]}</td><td>{$worksheetnumbers[$i]}</td><td>TBD</td><td><form method =\"post\" action=\"/Teacher/MyCourses/ViewCourse/ViewWorksheet/ViewSubmission/\" name=\"viewsubmissionlink{$i}\" id=\"viewsubmissionlink{$i}\"><input hidden type=\"text\" name=\"worksheetID\" value=\"{$worksheetids[$i]}\"><input hidden type=\"text\" name=\"submissionID\" value=\"{$studentsubmissionids[$i]}\"><button class=\"btn btn-primary\">View Submission</button></form></td></tr>";
}
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</head>
<?php
if (!empty($_SESSION['LoggedIn']) && !empty($_SESSION['Username'])) {
$params = array($_SESSION['Username']);
$options = array("Scrollable" => SQLSRV_CURSOR_KEYSET);
$ListRolesQuery = "SELECT DISTINCT R.Role, RI.RoleID FROM Roles as R, RoleInstances as RI WHERE RI.SiteUsername = ? AND RI.RoleID = R.RoleID ORDER BY RI.RoleID";
$stmt = sqlsrv_query($con, $ListRolesQuery, $params, $options);
if ($stmt === false) {
die(print_r(sqlsrv_errors(), true));
}
// Make the first (and in this case, only) row of the result set available for reading.
$RolesList = [];
while (sqlsrv_fetch($stmt) === true) {
$RolesList[] = sqlsrv_get_field($stmt, 0);
}
?>
<body>
<div class="navbar navbar-default navbar-fixed-top ng-scope">
<div class="container-fluid">
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-ex1-collapse">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a href="/<?php
echo $_SESSION['Role'];
</tr>
</thead>
<?php
$params = array();
$options = array("Scrollable" => 'static');
$adminsQuery = "\n SELECT I.InstitutionName, A.FirstName, A.LastName, R.Designation\n FROM Institutions as I, Administrators as A, RoleInstances as RI, Roles as R\n WHERE A.RoleInstanceID = RI.RoleInstanceID AND\n RI.RoleID = R.RoleID AND\n R.Role = 'Admin' AND\n I.InstitutionID = A.InstitutionID";
$stmt = sqlsrv_query($con, $adminsQuery, $params, $options);
if ($stmt === false) {
die(print_r(sqlsrv_errors(), true));
}
while (sqlsrv_fetch($stmt) === true) {
$institution = sqlsrv_get_field($stmt, 0);
$fname = sqlsrv_get_field($stmt, 1);
$lname = sqlsrv_get_field($stmt, 2);
$designation = sqlsrv_get_field($stmt, 3);
echo "<tr>";
echo "<td>{$institution}</td>";
echo "<td>{$fname} {$lname}</td>";
echo "<td>{$designation}</td>";
}
?>
<tbody>
</tbody>
</table>
</div>
</div>
</div>
include 'DBConnection.php';
if ($is_new == 0) {
echo '<br/>This is an old request';
$tsql = "SELECT name, location, start_time, end_time FROM Event WHERE uid = '" . $u_id . "'";
$stmt = sqlsrv_query($conn, $tsql);
if ($stmt === false) {
echo "Error in statement preparation/execution.\n";
die(print_r(sqlsrv_errors(), true));
}
$check = sqlsrv_fetch($stmt);
echo "<br/>The query returned: {$check}";
if ($check) {
$username_new = sqlsrv_get_field($stmt, 0);
$location_new = sqlsrv_get_field($stmt, 1);
$start_time_new = sqlsrv_get_field($stmt, 2);
$end_time_new = sqlsrv_get_field($stmt, 3);
echo 'Name: ' + $username_new;
echo 'Location' + $location_new;
echo 'Start:' + $start_time_new;
echo 'End:' + $end_time_new;
} else {
$is_new = 1;
}
sqlsrv_free_stmt($stmt);
}
if ($is_new == 1) {
$tsql = "INSERT INTO Event( name, location, start_time, end_time, working_on, looking_for, comment, uid, latitude, longtitude) VALUES ( '{$name}', '{$location}', '{$t_start}', '{$t_end}', '{$working_on}', '{$looking_for}', '{$comment}', '{$u_id}', {$lat}, {$lng} )";
} else {
$tsql = "UPDATE Event SET name = '{$name}', location = '{$location}', start_time = '{$t_start}', end_time = '{$t_end}', working_on = '{$working_on}', looking_for = '{$looking_for}', comment = '{$comment}', longtitude = {$lng}, latitude = {$lat} WHERE uid = '" . $u_id . "'";
}
echo '<p>' . $tsql . '</p>';
public function SqlSrvMoveNext()
{
if (!isset($this->sqlsrvConnection)) {
return false;
}
if (!isset($this->sqlsrvStatement)) {
return false;
}
if (!sqlsrv_fetch($this->sqlsrvStatement)) {
return false;
}
foreach ($this->columnBindings as $k => $col) {
if ($col[1]) {
$col[0] = sqlsrv_get_field($this->sqlsrvStatement, $k, SQLSRV_PHPTYPE_STREAM(SQLSRV_ENC_CHAR));
} else {
$col[0] = sqlsrv_get_field($this->sqlsrvStatement, $k);
}
}
return true;
}
$numexpressions = sqlsrv_num_rows($studentexpressions);
$expressions = [];
$contexts = [];
$sessionnames = [];
$years = [];
$coursenames = [];
$worksheetnums = [];
$worksheetids = [];
while (sqlsrv_fetch($studentexpressions) === true) {
$expressions[] = sqlsrv_get_field($studentexpressions, 0);
$contexts[] = sqlsrv_get_field($studentexpressions, 1);
$sessionnames[] = sqlsrv_get_field($studentexpressions, 2);
$years[] = sqlsrv_get_field($studentexpressions, 3);
$coursenames[] = sqlsrv_get_field($studentexpressions, 4);
$worksheetnums[] = sqlsrv_get_field($studentexpressions, 5);
$worksheetids[] = sqlsrv_get_field($studentexpressions, 6);
}
for ($i = 0; $i < $numexpressions; $i++) {
echo "<tr><td>{$expressions[$i]}</td>\n <td>{$contexts[$i]}</td>\n <td>{$sessionnames[$i]} {$years[$i]}</td>\n <td>{$coursenames[$i]}</td>\n <td>{$worksheetnums[$i]}</td>\n <td><form method=\"POST\" action=\"/teacher/Archive/Courses/ViewCourse/ViewWorksheet/\" name=\"worksheet{$worksheetids[$i]}\">\n <input hidden type=\"text\" value=\"{$worksheetids[$i]}\" name =\"worksheetID\">\n <button class=\"btn btn-primary\">View Worksheet</button></form></td></tr>";
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
public function execute($params = null)
{
if ($params) {
$hasZeroIndex = array_key_exists(0, $params);
foreach ($params as $key => $val) {
$key = $hasZeroIndex && is_numeric($key) ? $key + 1 : $key;
$this->bindValue($key, $val);
}
}
$this->stmt = sqlsrv_query($this->conn, $this->sql, $this->params);
if (!$this->stmt) {
throw SQLSrvException::fromSqlSrvErrors();
}
if ($this->lastInsertId) {
sqlsrv_next_result($this->stmt);
sqlsrv_fetch($this->stmt);
$this->lastInsertId->setId(sqlsrv_get_field($this->stmt, 0));
}
}
public function debugTable()
{
/* Retrieve the number of fields. */
$numFields = sqlsrv_num_fields($this->result);
echo '<table>';
echo '<tr><td colspan="' . $numFields . '">' . $this->currentQuery . '</td></tr>';
/* Iterate through each row of the result set. */
do {
echo '<tr>';
/* Iterate through the fields of each row. */
for ($i = 0; $i < $numFields; $i++) {
echo '<td>' . sqlsrv_get_field($this->result, $i, SQLSRV_PHPTYPE_STRING(SQLSRV_ENC_CHAR)) . '</td>';
}
echo '</tr>';
echo "\n";
} while (sqlsrv_fetch($this->result));
echo '</table>';
// Avoir un objet connexion et reeécuter la requete
}
/**
* Returns a single column from the next row of a result set.
*
* @param int $col OPTIONAL Position of the column to fetch.
* @return string
* @throws Zend_Db_Statement_Exception
*/
public function fetchColumn($col = 0)
{
if (!$this->_stmt) {
return false;
}
if (!sqlsrv_fetch($this->_stmt)) {
if (null !== ($error = sqlsrv_errors())) {
require_once 'include/Zend/Db/Statement/Sqlsrv/Exception.php';
throw new Zend_Db_Statement_Sqlsrv_Exception($error);
}
// If no error, there is simply no record
return false;
}
$data = sqlsrv_get_field($this->_stmt, $col);
//0-based
if ($data === false) {
require_once 'include/Zend/Db/Statement/Sqlsrv/Exception.php';
throw new Zend_Db_Statement_Sqlsrv_Exception(sqlsrv_errors());
}
return $data;
}
function isInserted($stmt)
{
sqlsrv_next_result($stmt);
sqlsrv_fetch($stmt);
return sqlsrv_get_field($stmt, 0);
}
