Home  >  Article  >  Backend Development  >  PHP calling methods mssql_fetch_row, mssql_fetch_array, mssql_fetch_assoc and m_PHP tutorial

PHP calling methods mssql_fetch_row, mssql_fetch_array, mssql_fetch_assoc and m_PHP tutorial

WBOY
WBOYOriginal
2016-07-21 15:17:17835browse

Method name: mssql_fetch_row()

Test:

Copy code The code is as follows:

require 'dbconn.php';
$sql = 'select * from _Test';
$query = mssql_query($sql);
while($row=mssql_fetch_row($query))
{
echo $row['UserId'].'::'.$row[1].'
';
}

returns:

Notice: Undefined index: UserId in D:/_PHP_Test/Test2/test_connLocalDB.php on line 32 ::王小一
Notice: Undefined index: UserId in D:/_PHP_Test/Test2/test_connLocalDB.php on line 32 ::王小二
Notice: Undefined index: UserId in D:/_PHP_Test/Test2/test_connLocalDB.php on line 32 ::王小三
Notice: Undefined index: UserId in D:/_PHP_Test/Test2/ test_connLocalDB.php on line 32::王小思
Notice: Undefined index: UserId in D:/_PHP_Test/Test2/test_connLocalDB.php on line 32::王小五

Analysis:

mssql_fetch_row() is exactly the same as mssql_fetch_array() plus the second optional parameter MYSQL_NUM. Gets a row of data from the result set associated with the specified result identifier and returns it as an array. Each result column is stored in a cell of the array, starting at offset 0. Note that the offset here starts from 0, and the key value (field name) cannot be used to obtain the value, only the index can be used to obtain the value. Therefore, the value cannot be obtained using $row['key value'] here.

Method name: mssql_fetch_assoc()

Test:
Copy code The code is as follows:

$query = mssql_query($sql);
while($row=mssql_fetch_assoc($query))
{
echo $row['UserId'].':: '.$row[1].'
';
}

Return:

Notice: Undefined offset: 1 in D:/_PHP_Test/Test2/ test_connLocalDB.php on line 43 1::
Notice: Undefined offset: 1 in D:/_PHP_Test/Test2/test_connLocalDB.php on line 43 2::
Notice: Undefined offset: 1 in D:/_PHP_Test/ Test2/test_connLocalDB.php on line 43 3::
Notice: Undefined offset: 1 in D:/_PHP_Test/Test2/test_connLocalDB.php on line 43 4::
Notice: Undefined offset: 1 in D:/ _PHP_Test/Test2/test_connLocalDB.php on line 43 5::
Analysis:
mssql_fetch_assoc() is exactly the same as using mssql_fetch_array() plus the second optional parameter MYSQL_ASSOC. It just returns an associative array. This is also how mssql_fetch_array() initially works. Therefore, the value cannot be obtained using $row[index value].

Method name: mssql_fetch_array()

Test:
Copy code The code is as follows:

$query = mssql_query($sql);
while($row=mssql_fetch_array($query))
{
echo $row[' UserId'].'::'.$row[1].'
';
}
?>


Return:
1 ::Wang Xiaoyi
2::Wang Xiaoer
3::Wang Xiaosan
4::Wang Xiaosi
5::Wang Xiaowu

Analysis:
mssql_fetch_array() is an extended version of mssql_fetch_row(). In addition to storing data in an array as a numerical index, you can also store data as an associative index, using the field name as the key. Therefore, both $row['key value'] and $row[index value] can be used here to get the value.

The second parameter result_type (which is a constant) in mssql_fetch_array() is an optional parameter, and the value range is: MYSQL_ASSOC, MYSQL_NUM and MYSQL_BOTH. Where:
mssql_fetch_array($query, MYSQL_ASSOC) == mssql_fetch_assoc($query);
mssql_fetch_array($query, MYSQL_NUM) == mssql_fetch_row($query);
So the mssql_fetch_array() function works to some extent The above can be regarded as a collection of mssql_fetch_row() and mssql_fetch_assoc (). Therefore, mssql_fetch_array() also has the MYSQL_BOTH parameter and will get an array containing both associations and numeric indexes.

Method name: mssql_fetch_object()

Test:
Copy code The code is as follows:

$query=mssql_query($sql);
while($row=mssql_fetch_object($query))
{
echo $row->UserId.'::' .$row->CreateTime."
";
}

Return:
1::06 7 2011 4:46PM
2::06 7 2011 4:46PM
3::06 7 2011 4:46PM
4::06 7 2011 4:46PM
5::06 7 2011 4:46PM

Analysis:

mysql_fetch_object() is similar to mssql_fetch_array, with only one difference, that is, it returns an object instead of an array, and Field names are used as attributes. Indirectly also means that it can only be accessed by the field name, not the offset.

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/325763.htmlTechArticleMethod name: mssql_fetch_row() Test: Copy the code as follows: require 'dbconn.php'; $sql = ' select * from _Test'; $query = mssql_query($sql); while($row=mssql_fetch_row($query...
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn