static function getProveedoresByFilter($filter)
{
$conn = ExternalDao::getConnection();
$result = new \stdClass();
$proveedores = array();
$sqlCount = "select * from vt020_proveedor p where p.n_proveedor not like '%NO USAR%' ";
$sqlData = "select top " . ($filter->pageSize + $filter->pageSize * ($filter->currentPage - 1)) . " c_proveedor, rtrim(ltrim(p.n_proveedor)) as n_proveedor, f.c_proveedor_primario as es_fresco " . "from vt020_proveedor p " . "left join VT020_PROVEEDOR_FRESCOS f on f.c_proveedor_primario = p.c_proveedor " . "where p.n_proveedor not like '%NO USAR%' ";
$sqlExept = "select top " . $filter->pageSize * ($filter->currentPage - 1) . " c_proveedor, rtrim(ltrim(p.n_proveedor)) as n_proveedor , f.c_proveedor_primario as es_fresco " . "from vt020_proveedor p " . "left join VT020_PROVEEDOR_FRESCOS f on f.c_proveedor_primario = p.c_proveedor " . "where p.n_proveedor not like '%NO USAR%' ";
if ($filter->multicolumnSearchText) {
$where = " and ( cast(c_proveedor as varchar(50)) like '%" . $filter->multicolumnSearchText . "%' or lower(p.n_proveedor) like '%" . strtolower($filter->multicolumnSearchText) . "%') ";
$sqlCount = $sqlCount . $where;
$sqlData = $sqlData . $where;
$sqlExept = $sqlExept . $where;
}
if (isset($filter->userId) && $filter->userId) {
$users_proveedor = SecurityDao::getUserProveedores($filter->userId);
$proveedorIds = Phinq::create($users_proveedor)->select(function ($item) {
return $item->proveedorId;
})->toArray();
$ids = implode(" , ", $proveedorIds);
if (!$ids) {
$ids = '-1';
}
$where = " and c_proveedor in ( " . $ids . ") ";
$sqlCount = $sqlCount . $where;
$sqlData = $sqlData . $where;
$sqlExept = $sqlExept . $where;
}
$sqlExept = $sqlExept . " order by N_PROVEEDOR";
$sqlData = $sqlData . " EXCEPT " . $sqlExept;
//echo $sqlData;
//region Count
$params = array();
$options = array("Scrollable" => SQLSRV_CURSOR_KEYSET);
$stmt = sqlsrv_query($conn, $sqlCount, $params, $options);
if ($stmt == false) {
die(print_r(sqlsrv_errors(), true));
}
$count = sqlsrv_num_rows($stmt);
sqlsrv_free_stmt($stmt);
//endregion
//region data
$stmt = sqlsrv_query($conn, $sqlData, null);
if ($stmt == false) {
die(print_r(sqlsrv_errors(), true));
}
while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
$proveedor = new \stdClass();
$proveedor->id = $row['c_proveedor'];
$proveedor->razonSocial = $row["n_proveedor"];
$proveedor->esFresco = $row["es_fresco"];
array_push($proveedores, $proveedor);
}
sqlsrv_free_stmt($stmt);
sqlsrv_close($conn);
//endregion
$result->data = $proveedores;
$result->count = $count;
return $result;
}
function get_count($MID)
{
$query = "SELECT * FROM riot4.users WHERE logged_MID = ?";
$params = array($MID);
$statement = sqlsrv_query($conn, $query, $params);
return sqlsrv_num_rows($statement);
}
/**
* Number of rows in the result set
*
* @return int
*/
public function num_rows()
{
// sqlsrv_num_rows() doesn't work with the FORWARD and DYNAMIC cursors (FALSE is the same as FORWARD)
if (!in_array($this->scrollable, [FALSE, SQLSRV_CURSOR_FORWARD, SQLSRV_CURSOR_DYNAMIC], TRUE)) {
return parent::num_rows();
}
return is_int($this->num_rows) ? $this->num_rows : ($this->num_rows = sqlsrv_num_rows($this->result_id));
}
public static function num_rows($queryDB = '', $objectStr = '')
{
$numRows = sqlsrv_num_rows($queryDB);
if (is_object($objectStr)) {
$objectStr($numRows);
}
return $numRows;
}
public function numRecords()
{
if (!is_resource($this->handle)) {
return false;
}
// WARNING: This will only work if the cursor type is scrollable!
if (function_exists('sqlsrv_num_rows')) {
return sqlsrv_num_rows($this->handle);
} else {
user_error('MSSQLQuery::numRecords() not supported in this version of sqlsrv', E_USER_WARNING);
}
}
function num_rows()
{
$num_rows = 0;
$out = "";
if ($this->result != false) {
$num_rows = sqlsrv_num_rows($this->result);
$out = $num_rows;
} else {
$out = 0;
}
//END if
return $out;
}
function fetchNRow($db, $query)
{
global $db;
$params = array();
$options = array("Scrollable" => SQLSRV_CURSOR_KEYSET);
$stmt = sqlsrv_query($db, $query, $params, $options);
$row_count = sqlsrv_num_rows($stmt);
if ($row_count === false) {
die(print_r(sqlsrv_errors(), true));
} else {
return $row_count;
}
return false;
}
public function _num_rows()
{
switch ($this->type) {
case 'mssql':
return mssql_num_rows($this->result);
break;
case 'sqlsrv':
return sqlsrv_num_rows($this->result);
break;
default:
case 'mysql':
return mysql_num_rows($this->result);
break;
}
}
function loginQuery($user, $psw)
{
global $serverName, $connectionInfo;
$conn = sqlsrv_connect($serverName, $connectionInfo);
$query = "Select TOP 1 * from usuario \n\tWHERE usuario='{$user}' OR correo='{$user}' AND contrasena='{$psw}'";
$params = array();
$options = array("Scrollable" => SQLSRV_CURSOR_KEYSET);
$stmt = sqlsrv_query($conn, $query, $params, $options);
$row_count = sqlsrv_num_rows($stmt);
$row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC);
if ($row_count === 1) {
$keys = array('result' => "true", 'id' => $row['id'], 'nombre' => $row['nombre'], 'correo' => $row['correo'], 'usuario' => $row['usuario'], 'pass' => $row['contrasena'], 'puesto' => $row['puesto']);
return $keys;
}
if ($stmt === false) {
die(print_r(sqlsrv_errors(), true));
}
sqlsrv_close($conn);
}
/**
* (non-PHPdoc)
*
* @see Core_DB::query()
*/
public function query($str, $key = '')
{
$this->query_str = $this->parse_prefix($str);
// 自动替换表前缀
if (!is_resource($this->link)) {
$this->connect();
}
N('db_query', 1);
// 记录开始执行时间
G('queryStartTime');
$this->lastqueryid = sqlsrv_query($this->link, $this->query_str, array(), array("Scrollable" => SQLSRV_CURSOR_KEYSET));
$this->debug();
if (false === $this->lastqueryid) {
$this->error();
return false;
} else {
$this->num_rows = sqlsrv_num_rows($this->lastqueryid);
return $this->get_all($key);
}
}
/**
* 执行查询 返回数据集
* @access public
* @param string $str sql指令
* @param array $bind 参数绑定
* @return mixed
*/
public function query($str,$bind=array()) {
$this->initConnect(false);
if ( !$this->_linkID ) return false;
//释放前次的查询结果
if ( $this->queryID ) $this->free();
N('db_query',1);
// 记录开始执行时间
G('queryStartTime');
$str = str_replace(array_keys($bind),'?',$str);
$bind = array_values($bind);
$this->queryStr = $str;
$this->queryID = sqlsrv_query($this->_linkID,$str,$bind, array( "Scrollable" => SQLSRV_CURSOR_KEYSET));
$this->debug();
if ( false === $this->queryID ) {
$this->error();
return false;
} else {
$this->numRows = sqlsrv_num_rows($this->queryID);
return $this->getAll();
}
}
function storePlayer($name, $email, $gcm_regid)
{
$db = new BaseDB();
// insert user into database
$sql = "INSERT INTO gcm_users(name, email, gcm_regid, created_at) VALUES('{$name}', '{$email}', '{$gcm_regid}', GETDATE())";
$result = $db->dbQuery($sql);
// check for successful store
if ($result) {
// get user details
$id = $db->getLastId('gcm_users');
// last inserted id
$result = $db->dbQuery("SELECT * FROM gcm_users WHERE id = {$id}") or die(dbGetErrorMsg());
// return user details
$NumRecords = sqlsrv_num_rows($result);
if ($NumRecords > 0) {
return sqlsrv_fetch_array($result, SQLSRV_FETCH_BOTH);
} else {
return false;
}
} else {
return false;
}
}
function sql_num_rows($sqltype, $result)
{
if ($sqltype == 'mysql') {
if (class_exists('mysqli_result')) {
return $result->mysqli_num_rows;
} elseif (function_exists('mysql_num_rows')) {
return mysql_num_rows($result);
}
} elseif ($sqltype == 'mssql') {
if (function_exists('sqlsrv_num_rows')) {
return sqlsrv_num_rows($result);
} elseif (function_exists('mssql_num_rows')) {
return mssql_num_rows($result);
}
} elseif ($sqltype == 'pgsql') {
return pg_num_rows($result);
} elseif ($sqltype == 'oracle') {
return oci_num_rows($result);
} elseif ($sqltype == 'sqlite3') {
$metadata = $result->fetchArray();
if (is_array($metadata)) {
return $metadata['count'];
}
} elseif ($sqltype == 'sqlite') {
return sqlite_num_rows($result);
} elseif ($sqltype == 'odbc') {
return odbc_num_rows($result);
} elseif ($sqltype == 'pdo') {
return $result->rowCount();
}
}
/**
* Return the number of rows in the result.
*
* @throws \Pop\Db\Adapter\Exception
* @return int
*/
public function numRows()
{
if (isset($this->statement)) {
return sqlsrv_num_rows($this->statement);
} else {
if (isset($this->result)) {
return sqlsrv_num_rows($this->result);
} else {
throw new Exception('Error: The database result resource is not currently set.');
}
}
}
?>
</h3><!---หัวเรื่องหลัก-->
<p> </p><!---หัวเรื่องรอง-->
<!----<input type="button" value="-จ่ายของเข้ารถ" id="btn" onclick="window.location='?page=add_picking_head';" class="inner_position_right" >
---->
</div><div class="sep"></div><br>
<form method="post" action="" id="frmSearch" name="frmSearch">
<table cellpadding="0" cellspacing="0" border="0" align="center" >
<tr><td colspan="2" align="center">
<b>คลัง : </b>
<select id="txt_location" name="txt_location" style="width:170px;" required/>
<option value="" > - เลือกคลังสินค้า - </option>
<?php
$sqlLoc = "select * from st_warehouse_location ";
$qryLoc = sqlsrv_query($con, $sqlLoc);
$row = sqlsrv_num_rows($qryLoc);
while ($detail = sqlsrv_fetch_array($qryLoc)) {
?>
<option value="<?php
print $detail['locationno'];
?>
" ><?php
print $detail['locationname'];
?>
</option>
<?php
}
?>
</select>
<b>จ่ายให้</b>
public static function getNumRows($query)
{
$database = self::GetInstance();
switch ($database->type) {
case 'mysql':
break;
case 'mssql':
if (extension_loaded('pdo_mssql')) {
} else {
if (extension_loaded('mssql')) {
$result = mssql_query($query);
if (!$result) {
echo 'Error in statement execution.\\n';
die('MSSQL error: ' . mssql_get_last_message());
}
$row_count = mssql_num_rows($result);
return $row_count;
} else {
if (extension_loaded('sqlsrv')) {
$params = array();
$options = array("Scrollable" => SQLSRV_CURSOR_KEYSET);
$result = sqlsrv_query($database->connection, $query, $params, $options);
if (!$result) {
echo 'Error in statement execution s.\\n';
die("Problemas en el select:" . sqlsrv_errors());
}
$row_count = sqlsrv_num_rows($result);
if ($row_count) {
return $row_count;
} else {
return 0;
}
}
}
}
break;
default:
//trigger_error('This database type is not supported',E_USER_ERROR);
break;
}
}
<th>Course Name</th>
<th>Worksheet Number</th>
<th>Performance</th>
<th>Go To</th>
</tr>
</thead>
<tbody>
<?php
$params = array($courseID, $enrollmentID);
$options = array("Scrollable" => SQLSRV_CURSOR_KEYSET);
$worksheetsubmissionsSQL = "SELECT CT.CourseName, WS.WorksheetNumber, SS.StudentSubmissionID, WS.WorksheetID\n FROM CourseTypes CT, Courses C, Enrollment ER, Worksheets WS, StudentSubmissions SS\n WHERE C.CourseID = ? AND\n ER.EnrollmentID = ? AND\n\t\t\t\t ER.CourseID = C.CourseID AND\n WS.CourseID = C.CourseID AND\n C.CourseTypesID = CT.CourseTypesID AND\n SS.EnrollmentID = ER.EnrollmentID AND\n SS.WorksheetID = WS.WorksheetID";
$worksheetsubmissions = sqlsrv_query($con, $worksheetsubmissionsSQL, $params, $options);
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>";
/**
* Count
*
* @return integer
*/
public function count()
{
return sqlsrv_num_rows($this->resource);
}
$stmt2 = sqlsrv_query($conn, $sql_opzioni);
$row_count = sqlsrv_num_rows($stmt2);
$row_op = sqlsrv_fetch_array($stmt2, SQLSRV_FETCH_ASSOC);
if ($row_count === 0) {
$prezzo_di_listino = "";
$prezzo_al_pubblico = "";
} else {
$prezzo_di_listino = $row_op['Prezzo_di_Listino'];
$prezzo_al_pubblico = $row_op['Prezzo_al_Pubblico'];
}
if (strtotime($data_ora_corrente) > strtotime($data_fine_offerta_completa)) {
$offerta_sospesa = 1;
}
$sql_count = "SELECT COUNT(*) as CouponStampati FROM acquisti WHERE offerta = " . $row['id'] . " AND Abilita = 1 AND Data_da <= '" . $dataoggi . "'";
$stmt3 = sqlsrv_query($conn, $sql_count);
$row_sql_count = sqlsrv_num_rows($stmt3);
$row_count_cop = sqlsrv_fetch_array($stmt3, SQLSRV_FETCH_ASSOC);
if ($row_sql_count !== 0) {
$CouponStampati = $row_count_cop['CouponStampati'];
}
$nome = $row['Nome'];
$titolo = $row_op['Titolo'];
if ($offerta_sospesa === 1) {
$coupon[] = array("id" => $row['id'], "nome" => $nome, 'sospesa' => $offerta_sospesa, 'esaurita' => $row['Offerta_Esaurita'], "foto_1" => 'http://www.tuttoshopping.com/' . $row['Foto_1'], "Offerta_Deluxe" => $row['Offerta_Deluxe'], "prezzo_di_listino" => number_format($row_op['Prezzo_di_Listino'], 2, '.', ''), "categoria" => $row['Categoria'], "prezzo_al_pubblico" => number_format($row_op['Prezzo_al_Pubblico'], 2, '.', ''), "stampati" => $CouponStampati, "Opzioni" => array("id" => $row_op['id'], "Data_da" => $row_op['Data_da'], "Titolo" => $titolo, "Prezzo_al_Pubblico" => $prezzo_al_pubblico, "Offerta" => $row_op['Offerta'], "Prezzo_di_Listino" => $prezzo_di_listino));
} else {
if ($row['Offerta_Esaurita'] === 1) {
$coupon[] = array("id" => $row['id'], "nome" => $nome, 'sospesa' => $offerta_sospesa, 'esaurita' => $row['Offerta_Esaurita'], "foto_1" => 'http://www.tuttoshopping.com/' . $row['Foto_1'], "Offerta_Deluxe" => $row['Offerta_Deluxe'], "prezzo_di_listino" => number_format($row_op['Prezzo_di_Listino'], 2, '.', ''), "categoria" => $row['Categoria'], "prezzo_al_pubblico" => number_format($row_op['Prezzo_al_Pubblico'], 2, '.', ''), "stampati" => $CouponStampati, "Opzioni" => array("id" => $row_op['id'], "Data_da" => $row_op['Data_da'], "Titolo" => $titolo, "Prezzo_al_Pubblico" => $prezzo_al_pubblico, "Offerta" => $row_op['Offerta'], "Prezzo_di_Listino" => $prezzo_di_listino));
} else {
$coupon[] = array("id" => $row['id'], "nome" => $nome, 'sospesa' => $offerta_sospesa, 'esaurita' => $row['Offerta_Esaurita'], "foto_1" => 'http://www.tuttoshopping.com/' . $row['Foto_1'], "Offerta_Deluxe" => $row['Offerta_Deluxe'], "prezzo_di_listino" => number_format($row_op['Prezzo_di_Listino'], 2, '.', ''), "categoria" => $row['Categoria'], "prezzo_al_pubblico" => number_format($row_op['Prezzo_al_Pubblico'], 2, '.', ''), "stampati" => $CouponStampati, "Opzioni" => array("id" => $row_op['id'], "Data_da" => $row_op['Data_da'], "Titolo" => $titolo, "Prezzo_al_Pubblico" => $prezzo_al_pubblico, "Offerta" => $row_op['Offerta'], "Prezzo_di_Listino" => $prezzo_di_listino));
}
}
<td bgcolor="#66CCFF"><?php
echo $reSP['PackStart'];
$PackStart = $PackStart + $reSP['PackStart'];
?>
</td>
<td bgcolor="#66CCFF"><?php
echo number_format($reSP['OrderTotal']);
$OrderTotalSP = $OrderTotalSP + $reSP['OrderTotal'];
?>
</td>
<td bgcolor="#66CCFF">
<?php
$sqlBySP = "SELECT count( distinct Order_List.Customer_Id) as CountByStart\nFROM Order_List left join ORDER_DETAIL\non Order_List.OrderID=ORDER_DETAIL.OrderID\n\nwhere Order_List.Orderdate ='{$re1['DATE_PLAN']}' \nand Order_List.SaleCode='{$sale}' \nand Order_List.ApproverStatus='Y'\nand Order_List.Canceled='N' \nand Order_List.Customer_Id <>'' \nand Order_List.ORDERTYPE='0'\nand ORDER_DETAIL.ProductID='FG201401'\n ";
$qryBySP = sqlsrv_query($con, $sqlBySP, $params, $options);
$reBySP = sqlsrv_fetch_array($qryBySP);
$rowBySP = sqlsrv_num_rows($qryBySP);
echo $reBySP['CountByStart'];
$CountByStart = $CountByStart + $reBySP['CountByStart'];
?>
</td>
<td bgcolor="#66CCFF"><?php
$vs33 = $reBySP['CountByStart'] / $reIn['CountIn'] * 100;
echo number_format($vs33) . "%";
$vs33Total = $vs33Total + $vs33;
?>
</td>
<td bgcolor="#F0F0F0"><?php
echo $sumBox = $reCa['sumBoxCarabao'] + $reSP['sumBoxStart'];
$sumBoxTotal = $sumBoxTotal + $sumBox;
?>
//------------------------------------------------------โดย PONG 14/10/2015-------------------
session_start();
set_time_limit(0);
include "../../includes/config.php";
$Tel = $_POST['Tel'];
$sim = $_POST['sim'];
$text_all = $_POST['text_all'];
$number = $_POST['number'];
$per_page = $number;
if ($text_all) {
$sql = "SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY phone_no desc) AS\nrownum,phone_no,sim_id FROM st_Device_PhoneSim where sim_id is not null)AS Table1 ";
} else {
$sql = "SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY phone_no desc) AS\nrownum,phone_no,sim_id FROM st_Device_PhoneSim \nwhere sim_id like '%{$sim}%' and phone_no like '%{$Tel}%' and sim_id is not null)AS Table1 ";
}
$result = sqlsrv_query($con, $sql, $params, $options);
$num_rows = sqlsrv_num_rows($result);
?>
<html>
<body>
<?php
if ($num_rows == 0) {
echo "<p align='center'><b>----------ไม่พบข้อมูล------------</b></p>";
} else {
?>
<table cellpadding="0" cellspacing="0" border="0" align="left" class="box" width="1050px">
<tr><td colspan="2">
<table cellpadding="0" cellspacing="0" BORDERCOLOR="#FF9933" border="1" align="center" width="450px">
<tr bgcolor="#FFCC99">
<td align="center"><font size="2">ลำดับ</font></td>
<td align="center"><font size="2">Serial Sim.</font></td>
/**
* Get the number of rows in the result set for the executed SQL given by the cursor.
*
* @return integer The number of rows in the result set.
*
* @since 12.1
* @see Countable::count()
*/
public function count()
{
return sqlsrv_num_rows($this->cursor);
}
if (!empty($_SESSION['LoggedIn']) && !empty($_SESSION['Username'])) {
if (!($_SESSION['Role'] == 'Admin' && $_SESSION['AccessType'] == 'Super')) {
?>
<p>You do not have permission to view this page. Redirecting in 5 seconds</p>
<p>Click <a href="/">here</a> if you don't want to wait</p>
<meta http-equiv='refresh' content='5;/' />
<?php
} else {
$params = array();
$options = array("Scrollable" => 'static');
$adminsSQL = "\n SELECT I.InstitutionName, A.FirstName, A.LastName, A.AdministratorID, R.Designation, CONVERT(VARCHAR(11), SU.date_added, 106)\n FROM Institutions as I, Administrators as A, RoleInstances as RI, Roles as R, SiteUsers as SU\n WHERE A.RoleInstanceID = RI.RoleInstanceID AND\n SU.username = A.SiteUsername AND\n RI.RoleID = R.RoleID AND\n R.Role = 'Admin' AND\n I.InstitutionID = A.InstitutionID";
$admins = sqlsrv_query($con, $adminsSQL, $params, $options);
if ($admins === false) {
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);
}
?>
$password = "******";
$database = "codigocar1";
$url = "sqlserver01.codigocar1.hospedagemdesites.ws";
$cod = $_REQUEST["cod"];
$conninfo = array("Database" => $database, "UID" => $username, "PWD" => $password, "CharacterSet" => "UTF-8");
$servidor = sqlsrv_connect($url, $conninfo) or die("Não foi possível a conexão com o servidor!");
//1_Se elige el formato de datos para lla conexion UTF8
//Se prepara la peticion
//2_Se establece la consulta a la BD
$params = array();
$options = array("Scrollable" => SQLSRV_CURSOR_KEYSET);
$consulta = "SELECT * FROM opcionaisXdescricao where codigo='" . $cod . "' or codprod=" . $cod . "";
//echo "sql: ".$consulta;
//die();
$sql = sqlsrv_query($servidor, $consulta, $params, $options);
$row_count = sqlsrv_num_rows($sql);
//3_Se declara un arreglo
$datos = array();
//SE genera el archivo JSON
$i = 0;
while ($obj = sqlsrv_fetch_object($sql)) {
//echo 'foi';
$i = $i + 1;
if ($i != $row_count) {
$datos[] = array('opcional' => $obj->opcional . ", ");
} else {
$datos[] = array('opcional' => $obj->opcional . ".");
}
}
echo '' . json_encode($datos) . '';
sqlsrv_close($servidor);
<B style="color:red;text-align:center;">*</B>
</td></tr>
</td></tr><tr><td colspan="2"> </td></tr>
<tr><td><B>รูป</B></td><td><input type="file" id="txt_file" name="txt_file"></td>
<tr><td colspan="2"> </td></tr>
<tr><td width="150"><B>หมายเหตุ</B></td><td><input type="text" id="txt_remark"align="center" name="txt_remark" size="35"></td></tr>
<tr><td colspan="2"> </td></tr>
<tr><td><B>บริษัท</B></td><td>
<select id="txt_COMPANY" name="txt_COMPANY" style="width:300px;">
<?php
$sql = "SELECT COMPANYCODE,COMPANYNAME FROM st_companyinfo_exp ";
$params = array();
$options = array("Scrollable" => SQLSRV_CURSOR_KEYSET);
$qry = sqlsrv_query($con, $sql, $params, $options);
$row = sqlsrv_num_rows($qry);
for ($j = 0; $j < $row; $j += 1) {
$detail = sqlsrv_fetch_array($qry);
?>
<option value="<?php
print $detail['COMPANYCODE'];
?>
" ><?php
print $detail['COMPANYNAME'];
?>
</option>
<?php
}
?>
</select>
$options = array("Scrollable" => 'static');
$query = "SELECT S.[FirstName], S.[LastName], L.[Language], S.[ID], COUNT(DISTINCT E.[Teachers&ClassesID])\nFROM Students as S, Expressions as E, Languages as L\nWHERE L.[LanguageID] = S.[Language] AND\nS.[ID] in (SELECT DISTINCT ES.StudentID FROM Expressions as ES) AND\nE.[StudentID] = S.[ID]";
/*if (!(empty($_POST['studentLastName'])))
{
$query = " = ?";
$params = array($_POST['studentID']);
}*/
$query .= " GROUP BY S.[FirstName], S.[LastName], S.[ID], L.Language";
$stmt = sqlsrv_query($con, $query, $params, $options);
if (!$stmt) {
die(print_r(sqlsrv_errors(), true));
}
/* Extract Pagination Paramaters */
$rowsPerPage = isset($_GET['pp']) ? $_GET['pp'] : 10;
// get rows per page, default = 50
$rowsReturned = sqlsrv_num_rows($stmt);
if ($rowsReturned === false) {
die(print_r(sqlsrv_errors(), true));
} elseif ($rowsReturned == 0) {
echo "No rows returned.";
exit;
} else {
/* Calculate number of pages. */
$numOfPages = ceil($rowsReturned / $rowsPerPage);
}
/* Echo results to the page */
$pageNum = isset($_GET['pageNum']) ? $_GET['pageNum'] : 1;
$page = Pagination::getPage($stmt, $pageNum, $rowsPerPage);
foreach ($page as $row) {
$studentPageLink = "ViewStudent/?studentID={$row['3']}";
echo "<tr><td>{$row['0']}</td><td>{$row['1']}</td><td>{$row['2']}</td><td><a href='{$studentPageLink}'>Student's Page</a></td><td>{$row['4']}</td></tr>";
/**
* Get the number of returned rows for the previous executed SQL statement.
*
* @param resource $cursor An optional database cursor resource to extract the row count from.
*
* @return integer The number of returned rows.
*
* @since 12.1
*/
public function getNumRows($cursor = null)
{
$this->connect();
return sqlsrv_num_rows($cursor ? $cursor : $this->cursor);
}
/**
* Returns number of rows in previous resultset. If no previous resultset exists,
* this returns false.
*
* @return integer Number of rows in resultset
*/
function lastNumRows()
{
if ($this->_result) {
return @sqlsrv_num_rows($this->_result);
}
return null;
}
/**
* Number of rows in the result set
*
* @access public
* @return integer
*/
function num_rows()
{
return @sqlsrv_num_rows($this->result_id);
}
/**
* Number of rows in the result set
*
* @access public
* @return integer
*/
function num_rows()
{
if (!$this->num_rows) {
$this->num_rows = @sqlsrv_num_rows($this->result_id);
}
return $this->num_rows;
}
