本文整理汇总了PHP中mssql_num_rows函数的典型用法代码示例。如果您正苦于以下问题:PHP mssql_num_rows函数的具体用法?PHP mssql_num_rows怎么用?PHP mssql_num_rows使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了mssql_num_rows函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: query
public function query($sql, $start = null, $perpage = null, $nolimit = false)
{
$start and !$perpage and $perpage = 10000;
$query = mssql_query($sql, $this->dbConnection());
if ($start) {
$qcount = mssql_num_rows($query);
if ($qcount < $start) {
return array();
} else {
mssql_data_seek($query, $start);
}
}
if ($query) {
$result = array();
while ($row = mssql_fetch_assoc($query)) {
if (DBCHARSET == 'gbk' && CHARSET != 'gbk') {
$row = Base_Class::gbktoutf($row);
}
$result[] = $row;
if ($perpage && count($result) >= $perpage) {
break;
}
}
return $result;
} else {
$this->halt("数据库查询错误", $sql);
}
}
开发者ID:huangbinzd,项目名称:kppwGit,代码行数:28,代码来源:mssql_driver.php
示例2: executeQuery
private function executeQuery()
{
$return = false;
if ($this->queryType == 'other') {
if (mssql_query($this->query, $this->link) === true) {
$return = true;
$this->error = mssql_get_last_message();
}
} else {
if ($result = mssql_query($this->query, $this->link)) {
// Conteo de registros
if ($this->queryType == 'insert' || $this->queryType == 'update' || $this->queryType == 'delete') {
$this->numRows = mssql_rows_affected($this->link);
$return = true;
} else {
$this->numRows = mssql_num_rows($result);
$fetchType = MSSQL_NUM;
if ($this->queryReturn == 'assoc') {
$fetchType = MSSQL_ASSOC;
} elseif ($this->queryReturn == 'both') {
$fetchType = MSSQL_BOTH;
}
$return = array();
while ($row = mssql_fetch_array($result, $fetchType)) {
array_push($return, $row);
}
}
$this->error = mssql_get_last_message();
mssql_free_result($result);
} else {
$this->error = mssql_get_last_message();
}
}
return $return;
}
开发者ID:foreverphp,项目名称:framework,代码行数:35,代码来源:MSSQLEngine.php
示例3: query
/**
* @param $sql
*
* @return array
*/
public function query($sql)
{
//
$this->connection = $this->getConnection();
// Run query
$query = mssql_query($sql, $this->connection);
// On error
if ($query === false) {
Response::error(500, $_SERVER["SERVER_PROTOCOL"] . ' DB query failed (SQL): ' . mssql_get_last_message());
}
// E.g. boolean is returned if no rows (e.g. no resource found or on UPDATE)
if ($query === true) {
$response = $query;
} else {
// Response
$response = array();
//
// Loop rows and add to response array
if (mssql_num_rows($query) > 0) {
while ($row = mssql_fetch_assoc($query)) {
$response[] = $row;
}
}
// Free the query result
mssql_free_result($query);
}
// Close link
$this->closeConnection();
//
return $response;
}
开发者ID:skrodal,项目名称:relay-fusjonator-api,代码行数:36,代码来源:relaysqlconnection.class.php
示例4: __construct
public function __construct($account)
{
try {
global $ldMssql;
$this->clearVars();
$checkVault = $ldMssql->query("SELECT [DbVersion] FROM [" . DATABASE_ACCOUNTS . "].[dbo].[warehouse] WHERE [AccountId] = '" . $account . "'");
if (mssql_num_rows($checkVault) == 0) {
throw new Exception("<script> alert('Essa conta não possui baú.'); location = '?page=paneluser'; </script>");
}
$dbVersion = mssql_fetch_object($checkVault);
if (is_numeric($dbVersion->DbVersion) == false) {
throw new Exception("Vault class error: dbVersion must be numeric.");
}
if ($dbVersion < 1 || $dbVersion->DbVersion > 3) {
throw new Exception("Vault class error: dbVersion invalid.");
}
$this->dbVersion = $dbVersion->DbVersion;
$this->account = $account;
if ($this->dbVersion == 3) {
$getLenghts = $ldMssql->query("USE [" . DATABASE_ACCOUNTS . "]; SELECT [length] FROM [syscolumns] WHERE OBJECT_NAME([id]) = 'warehouse' AND [name] = 'Items'; USE [" . DATABASE . "];");
$getLenghts = mssql_fetch_object($getLenghts);
$this->slotNumbers = $getLenghts->length * 2 / 32;
}
} catch (Exception $msg) {
exit($msg->getMessage());
}
}
开发者ID:neilor,项目名称:MuSite-v2-5-x,代码行数:27,代码来源:ldVault.class.php
示例5: getRecord
/**
* mengambil record dari sebuah tabel dalam bentuk array
* @param sqlString ini sql string
* @param offset
*
*/
public function getRecord($sqlString, $offset = 1)
{
// echo $sqlString;
if (mssql_num_rows($result = $this->query($sqlString)) >= 1) {
if ($offset == '') {
$offset = 1;
}
$ft = $this->getFieldTable("field");
// print_r($ft);
$countFieldTable = count($ft);
$counter = 1;
while ($row = mssql_fetch_array($result)) {
//echo $row . "<br>";
$tempRecord['no'] = $offset;
for ($i = 0; $i < $countFieldTable; $i++) {
$tempRecord[$ft[$i]] = trim($row[$ft[$i]]);
}
$ListRecord[$counter] = $tempRecord;
$counter++;
$offset++;
}
// print_r($ListRecord);
$this->ListRecord = $ListRecord;
} else {
$this->ListRecord = array();
}
return $this->ListRecord;
}
开发者ID:silotester,项目名称:silo,代码行数:34,代码来源:MSSQL.php
示例6: dbquery_func_old
function dbquery_func_old($connection_info, $query, $debug = "off")
{
if ($connection_info['db_type'] == "mysql") {
mysql_connect($connection_info['db_host'] . ":" . $connection_info['db_port'], $connection_info['username'], $connection_info['password']) or die("Unable to connect to " . $connection_info['db_host']);
mysql_select_db($connection_info['db_name']) or die("Unable to select database " . $connection_info['db_name']);
$return = mysql_query($query);
if ($debug == "on") {
$merror = mysql_error();
if (!empty($merror)) {
print "MySQL Error:<br />" . $merror . "<p />Query<br />: " . $query . "<br />";
}
print "Number of rows returned: " . mysql_num_rows($return) . "<br />";
}
} else {
if ($connection_info['db_type'] == "mssql") {
mssql_connect($connection_info['db_host'] . "," . $connection_info['db_port'], $connection_info['username'], $connection_info['password']) or die("Unable to connect to " . $connection_info['db_host'] . "<br />" . $query);
mssql_select_db($connection_info['db_name']) or die("Unable to select database " . $connection_info['db_name']);
$return = mssql_query($query);
if ($debug == "on") {
$merror = mssql_get_last_message();
if (!empty($merror)) {
print "MySQL Error: " . $merror . "<br />Query" . $query . "<br />";
}
print "Number of rows returned: " . mssql_num_rows($result) . "<br />";
}
}
}
return $return;
}
开发者ID:JhunCabas,项目名称:avarice-nms,代码行数:29,代码来源:db_config.php
示例7: __construct
public function __construct($BuyID, $searchItem = false)
{
global $LD_Items;
$this->searchItem = $searchItem;
$SQL_Q = $this->query("SELECT ConnectStat, DATEDIFF(MI, DisConnectTM, getdate()) DisConnectTM FROM MEMB_STAT WHERE memb___id='" . $_SESSION['Login'] . "'");
if (mssql_num_rows($SQL_Q) == 0) {
exit("<ul><li>Você deve entrar no jogo ao menos uma vez para efetuar esta ação!</li></ul>");
}
$SQL = mssql_fetch_object($SQL_Q);
if ($SQL->ConnectStat != 0) {
exit("<ul><li>Você deve estar offline do jogo para efetuar esta ação!</li></ul>");
}
$this->BuyID = $BuyID;
$this->VerifyBuy();
$this->FindItem();
if ($this->searchItem == true) {
exit;
}
if ((int) RECOVERY_LIMIT_ITEM > 0 && $this->recovery >= (int) RECOVERY_LIMIT_ITEM) {
exit(Print_error("<ul><li>Erro, excedido o número de vezes que o item ser recuperado (" . RECOVERY_LIMIT_ITEM . " vezes).</li></ul>"));
}
$this->Find_Details();
$LD_Items->Write_Variables($this->ProductID, $this->TP, $this->ID, $this->ProductSerial, $this->DUR, $this->X, $this->Y, $this->Item_Level, $this->Item_Option, $this->Item_Ancient, $this->Item_Skill, $this->Item_Luck, $this->Item_OpExc_1, $this->Item_OpExc_2, $this->Item_OpExc_3, $this->Item_OpExc_4, $this->Item_OpExc_5, $this->Item_OpExc_6, $this->Item_JH, $this->Item_Refine, $this->Item_Socket_Slot_1, $this->Item_Socket_Slot_2, $this->Item_Socket_Slot_3, $this->Item_Socket_Slot_4, $this->Item_Socket_Slot_5, $this->Item_Socket_Slot_1_Option, $this->Item_Socket_Slot_2_Option, $this->Item_Socket_Slot_3_Option, $this->Item_Socket_Slot_4_Option, $this->Item_Socket_Slot_5_Option);
$LD_Items->GenerateHex();
$LD_Items->GetVaultContent();
$LD_Items->CutSlotsVault();
$LD_Items->CutHexSlotsVault();
$LD_Items->RestructureSlotsFree();
$LD_Items->FindSlotsFree();
$this->WriteLog();
$LD_Items->WriteVault();
print "<ul><li>Seu item foi recuperado com sucesso! Obrigado.</li></ul>";
}
开发者ID:axlduff,项目名称:teste,代码行数:33,代码来源:recover_lost_item.class.php
示例8: login
function login($email, $password)
{
/* query db and set session variables, as necessary */
$theQuery = "SELECT * FROM users WHERE email = '" . $email . "' AND userpassword = '" . $password . "'";
$theData = queryG0($theQuery);
if (!mssql_num_rows($theData)) {
echo 'No records found';
} else {
while ($row = mssql_fetch_array($query)) {
$thisEmail = $row['username'];
$thisPassword = $row['userpassword'];
$thisID = $row['id'];
$thisAccessLevel = $row['accesslevel'];
}
if ($email == $thisEmail && $password == $thisPassword) {
createSessionVariables($thisID, $thisAccessLevel);
/* Redirect to admin landing page */
header("Location: " . $GLOBALS['adminLandingPage']);
} else {
clearSessionVariables();
/* Redirect to login with error msg */
header("Location: " . $GLOBALS['loginWithError']);
}
}
}
开发者ID:rhammonds1,项目名称:tejasapplication,代码行数:25,代码来源:global-functions.php
示例9: xcopy
function xcopy($mssql, $mysql, $db, $table, $sql)
{
$start = microtime(true);
mysqli_select_db($mysql, $db);
mssql_select_db($db, $mssql);
$result = mssql_query($sql, $mssql, 20000);
if ($result === false) {
die("Error creating sync data\n");
}
$s = 0;
$r = mssql_num_rows($result);
$name_count = mssql_num_fields($result);
$name_list = "";
$update_list = "";
$value_list = "";
$sql = "";
$radix = 0;
for ($i = 0; $i < $name_count; $i++) {
$x = strtolower(mssql_field_name($result, $i));
$name_list .= "{$x},";
if ($x != "dex_row_id") {
$update_list .= "{$x} = values({$x}),";
}
}
$name_list = rtrim($name_list, ",");
$update_list = rtrim($update_list, ",");
do {
while ($row = mssql_fetch_row($result)) {
for ($i = 0; $i < $name_count; $i++) {
$value_list .= "'" . str_replace("'", "''", trim($row[$i])) . "',";
}
$value_list = rtrim($value_list, ",");
$radix++;
$sql .= "\n({$value_list}),";
$value_list = "";
if ($radix > 2000) {
$sql = trim($sql, ",");
$sql = "insert into {$table} ({$name_list}) values {$sql} on duplicate key update {$update_list};";
$rset = mysqli_query($mysql, $sql);
if ($rset === false) {
die("Error inserting mysql data. \n" . mysqli_error($mysql) . "\n\n{$sql}\n\n");
}
$radix = 0;
$sql = "";
}
$s++;
}
} while (mssql_fetch_batch($result));
if ($sql != "") {
$sql = trim($sql, ",");
$sql = "insert into {$table} ({$name_list}) values {$sql} on duplicate key update {$update_list};";
$rset = mysqli_query($mysql, $sql);
if ($rset === false) {
die("Error inserting mysql data. \n" . mysqli_error($mysql) . "\n\n{$sql}\n\n");
}
}
$end = microtime(true);
$total = $end - $start;
echo "imported {$db}.{$table} [ {$s} ] records in {$total} sec.\n";
}
开发者ID:afindlator,项目名称:gpApi,代码行数:60,代码来源:xcopy.php
示例10: queryContainsNewUsers
private function queryContainsNewUsers($query)
{
if ($query == false) {
return false;
}
return mssql_num_rows($query) > 0 ? true : false;
}
开发者ID:skrodal,项目名称:relay-mediasite-harvest,代码行数:7,代码来源:UserImport.php
示例11: findFlights
function findFlights($flight)
{
//Connects to database
require 'connect_db.php';
$query = mssql_query('SELECT * FROM FLIGHT');
if (!mssql_num_rows($query)) {
echo 'No records found';
} else {
//Creates tables and fills it with flight numbers and their delays
echo '<br><br><br><br><table border = 1>';
echo '<th>Flight Number</th><th>Delayed</th><th>Depature Time</th>';
while ($row = mssql_fetch_assoc($query)) {
$i = 0;
//Check if flight is what is looking for
if (strcmp($row['Flight_number'], $flight) == 0) {
$i = $i + 1;
echo '<tr><td>' . $row['Flight_number'] . '</td>';
if (strcmp($row['Delayed'], '1') != 0) {
echo '<td>' . 'On Time' . '</td>';
} else {
echo '<td>' . 'Delayed' . '</td>';
}
echo '<td>' . $row['Depature_time'] . '</td></tr>';
//^End else
}
}
//^ends while
echo '</table>';
}
}
开发者ID:NDSUFlyByNight,项目名称:FlyByNightWebSite,代码行数:30,代码来源:flightStatus.php
示例12: count
function count()
{
// Attention! See notes above.
if ($this->rs === true) {
return 0;
}
return mssql_num_rows($this->rs);
}
开发者ID:jijkoun,项目名称:ssscrape,代码行数:8,代码来源:resultset.lib.php
示例13: numRows
function numRows($r = 0)
{
if (!$r) {
$r = $this->lastResult;
}
$cnt = mssql_num_rows($r);
return $cnt;
}
开发者ID:techczech,项目名称:tuit,代码行数:8,代码来源:driver-mssql.inc.php
示例14: num_rows
public static function num_rows($queryDB = '', $objectStr = '')
{
$numRows = mssql_num_rows($queryDB);
if (is_object($objectStr)) {
$objectStr($numRows);
}
return $numRows;
}
开发者ID:neworldwebsites,项目名称:noblessecms,代码行数:8,代码来源:DatabaseMSSQL.php
示例15: loginCookies
public function loginCookies($id, $hash)
{
$queryCookies = "SELECT id, hash FROM [user] WHERE id={$id} AND hash='{$hash}'";
if (mssql_num_rows(mssql_query($queryCookies)) == 1) {
$userEntry = mssql_fetch_array(mssql_query($queryCookies));
setcookie("id", $userEntry['id'], time() + 60 * 60 * 24, "/");
setcookie("hash", $userEntry['hash'], time() + 60 * 60 * 24, "/");
return true;
}
}
开发者ID:Tacit007,项目名称:Tacit007-php-framework,代码行数:10,代码来源:user.php
示例16: mssqlAdapter
/**
* Constructor method for the adapter. This constructor implements the setting of the
* 3 required properties for the object.
*
* @param resource $d The datasource resource
*/
function mssqlAdapter($d)
{
parent::RecordSetAdapter($d);
$fieldcount = mssql_num_fields($d);
// grab the number of fields
$ob = "";
$be = $this->isBigEndian;
$fc = pack('N', $fieldcount);
if (mssql_num_rows($d) > 0) {
mssql_data_seek($d, 0);
while ($line = mssql_fetch_row($d)) {
// write all of the array elements
$ob .= "\n" . $fc;
foreach ($line as $value) {
// write all of the array elements
if (is_string($value)) {
// type as string
$os = $this->_directCharsetHandler->transliterate($value);
//string flag, string length, and string
$len = strlen($os);
if ($len < 65536) {
$ob .= "" . pack('n', $len) . $os;
} else {
$ob .= "\f" . pack('N', $len) . $os;
}
} elseif (is_float($value) || is_int($value)) {
// type as double
$b = pack('d', $value);
// pack the bytes
if ($be) {
// if we are a big-endian processor
$r = strrev($b);
} else {
// add the bytes to the output
$r = $b;
}
$ob .= "" . $r;
} elseif (is_bool($value)) {
//type as bool
$ob .= "";
$ob .= pack('c', $value);
} elseif (is_null($value)) {
// null
$ob .= "";
}
}
}
}
$this->serializedData = $ob;
for ($i = 0; $i < $fieldcount; $i++) {
// loop over all of the fields
$this->columnNames[] = $this->_directCharsetHandler->transliterate(mssql_field_name($d, $i));
}
$this->numRows = mssql_num_rows($d);
}
开发者ID:ksecor,项目名称:civicrm,代码行数:61,代码来源:mssqlAdapter.php
示例17: SetRow
/**
* Go to a row int the RecordSet.
*
* @param int $row Row to go to.
* @return bool Returns TRUE on success, FALSE if failed.
*/
function SetRow($row = 0)
{
if (!mssql_num_rows($this->result)) {
return FALSE;
}
if (!mssql_data_seek($this->result, $row)) {
return FALSE;
}
$this->row = $row;
return TRUE;
}
开发者ID:JAMNConsultoria,项目名称:snaids,代码行数:17,代码来源:RS_MSSQL.class.php
示例18: count
public function count()
{
//print_r($this);
$lastresult = $this->results[$this->lasthash];
//print_r($this->results);
$count = mssql_num_rows($lastresult);
if (!$count) {
$count = 0;
}
return $count;
}
开发者ID:mustafakarali,项目名称:orchidframework,代码行数:11,代码来源:mssqldriver.php
示例19: Valid_UserName
public function Valid_UserName()
{
if (empty($this->login) == true) {
exit(Print_error("Usuário", 3));
}
$Temp_Q = $this->query("SELECT memb___id FROM MEMB_INFO WHERE memb___id='" . (string) $this->login . "'");
$Temp = mssql_num_rows($Temp_Q);
if ($Temp == 0) {
exit(Print_error(" incorreto."));
}
}
开发者ID:neilor,项目名称:MuShopping-v3,代码行数:11,代码来源:login.class.php
示例20: traerNombrePlanAlim
function traerNombrePlanAlim($cod_pa)
{
$sql = "SELECT nombre FROM palimt WHERE codigo = '" . $cod_pa . "';";
$res = mssql_query($sql);
if (mssql_num_rows($res) > 0) {
$row = mssql_fetch_array($res);
return $row["nombre"];
} else {
return "";
}
}
开发者ID:JonathanEstay,项目名称:panamericanaturismo.cl,代码行数:11,代码来源:vouchea.php
注:本文中的mssql_num_rows函数示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论