SQLSRV_HAS_ROWS(3)SQLSRV_HAS_ROWS(3)sqlsrv_has_rows - Indicates whether the specified statement has rowsSYNOPSIS
bool sqlsrv_has_rows (resource $stmt)
DESCRIPTION
Indicates whether the specified statement has rows.
PARAMETERS
o $stmt
- A statement resource returned by sqlsrv_query(3) or sqlsrv_execute(3).
RETURN VALUES
Returns TRUE if the specified statement has rows and FALSE if the statement does not have rows or if an error occurred.
EXAMPLES
Example #1
sqlsrv_has_rows(3) example
<?php
$server = "serverNamesqlexpress";
$connectionInfo = array( "Database"=>"dbName", "UID"=>"username", "PWD"=>"password" )
$conn = sqlsrv_connect( $server, $connectionInfo );
$stmt = sqlsrv_query( $conn, "SELECT * FROM Table_1");
if ($stmt) {
$rows = sqlsrv_has_rows( $stmt );
if ($rows === true)
echo "There are rows. <br />";
else
echo "There are no rows. <br />";
}
?>
SEE ALSO sqlsrv_num_rows(3), sqlsrv_query(3).
PHP Documentation Group SQLSRV_HAS_ROWS(3)
Check Out this Related Man Page
SQLSRV_NUM_ROWS(3)SQLSRV_NUM_ROWS(3)sqlsrv_num_rows - Retrieves the number of rows in a result setSYNOPSIS
mixed sqlsrv_num_rows (resource $stmt)
DESCRIPTION
Retrieves the number of rows in a result set. This function requires that the statment resource be created with a static or keyset cursor.
For more information, see sqlsrv_query(3), sqlsrv_prepare(3), or Specifying a Cursor Type and Selecting Rows in the Microsoft SQLSRV docu-
mentation.
PARAMETERS
o $stmt
- The statement for which the row count is returned. The statment resource must be created with a static or keyset cursor. For
more information, see sqlsrv_query(3), sqlsrv_prepare(3), or Specifying a Cursor Type and Selecting Rows in the Microsoft SQLSRV
documentation.
RETURN VALUES
Returns the number of rows retrieved on success and FALSE if an error occurred. If a forward cursor (the default) or dynamic cursor is
used, FALSE is returned.
EXAMPLES
Example #1
sqlsrv_num_rows(3) example
<?php
$server = "serverNamesqlexpress";
$connectionInfo = array( "Database"=>"dbName", "UID"=>"username", "PWD"=>"password" );
$conn = sqlsrv_connect( $server, $connectionInfo );
$sql = "SELECT * FROM Table_1";
$params = array();
$options = array( "Scrollable" => SQLSRV_CURSOR_KEYSET );
$stmt = sqlsrv_query( $conn, $sql , $params, $options );
$row_count = sqlsrv_num_rows( $stmt );
if ($row_count === false)
echo "Error in retrieveing row count.";
else
echo $row_count;
?>
SEE ALSO sqlsrv_has_rows(3), sqlsrv_rows_affected(3).
PHP Documentation Group SQLSRV_NUM_ROWS(3)
Hi,
I am trying with do ...done loop command, but i am getting error..
can u give me an example so that i can be clear of the thing,,
and while statement also.. (7 Replies)
Dears,
I have a list as follows,
2
4
8
If I want to find the difference between two consecutive rows. Then I have to store the specific rows in two variables and then find the difference. Could someone tell how this can be done.
Regards, (7 Replies)
I am getting some spaces between the two lines(rows) in file.i want delete that empty rows in the file
example
1 abc xyz
2 def jkl
like i am having lots of rows in a file i want to delete the spce between the two rows give any... (7 Replies)
Hi everybody:
Could anybody tell me how I can delete repeated rows from a file?, this is, for exemple I have a file like this:
0.490 958.73 281.85 6.67985 0.002481
0.490 954.833 283.991 8.73019 0.002471
0.590 950.504 286.241 6.61451 0.002461
0.690 939.323 286.112 6.16451 0.00246
0.790... (8 Replies)
I have file
"1","x1897"," 89.10"
"1","x2232"," -12.12"
"1","x1897"," 389.10"
"1","x2232"," 212.12"
"1","x1897"," 19.10"
"1","x2232"," 2.12"
i want to add all 3 rd column rows (they have spaces also)for x1
and sum of 3rd column rows for x2 separately.
I am very... (8 Replies)
Friends,
I have text file with 700,000 rows.
Once I load this file to our database via our cutom process, it logs the row number for rejected rows.
How do I delete rows from a Large text file based on the Row Number?
Thanks,
Prashant (8 Replies)
Hi All,
I need to remove 1st 2 line from head and last 2 line from last.
I thought it would be possible by using the Head and tail command.
But after i am using it is not possible by it.
Example:Input file
1
2
3
4
5
Example: Output file
3
But my head and tail command are not... (12 Replies)
Hi pls help me out to short out this problem
rm PAB113_011.out
rm: PAB113_011.out: override protection 644 (yes/no)? n
If i give y it remove the file.
But i added the rm command as a part of ksh file and i tried to remove the file. Its not removing and the the file prompting as... (7 Replies)
#! /bin/ksh
rm -f ./xyz file --- this line is working
// Below any if stmt is not working.
if
then
echo " blah blah "
fi
or I replaced above if with
if
then
echo "dir exists"
fi
This is also not working.
I am new to KSH. So can someone help why if stmt is not... (31 Replies)
Hi there
Everytime it calls the second if statement it keeps calling the first echo message from the first if statement.
how do I get it to display the second echo message in the second if statement?
Thanks.
function (verbose) {
if ; then
echo "rm: cannot remove $1 : is a... (8 Replies)
Hi,
I have 2 files, each files contain about 1 millions lines and I want to joint them to build the new files which contain each 2 lines of file1 and 1 lines of file2.
Newfiles:
line1-file1
line2-file1
line1-file2
line3-file1
line4-file1
line2-file2
.....
Could someone help... (8 Replies)
1.04/1.05:ELA=20000,POLLK=35000,RH=5000,MH=7000,WH=4359
1.7:ELA=2000,POLLK=2000,RH=2000,MH=2000,WH=607
1.9:ELA=2000,POLLK=2000,RH=2000,MH=2000,WH=396
2.0:POLLK=6000,WENS=10000,ELA=7789
I have this above content where in i wan the total of the every row
i.e.
... (9 Replies)
Hi,
I have a big file, with thousands of rows, and I want to put every 7 rows in a line. Input file:
str1, val2, val3
str2, val4, val5
str3, val22, val33
str4, val44, val55
str5, val6, val7
str6, val77, val88
str7, val99, val00
str1, som2, som3
str2, som4, som5
str3, som22, som33 ... (11 Replies)