The first record is left behind

jiehuang001

I am using the following code to retrieve records from a table:
$conn = ......
$query="select * from the_table"
$stmt = ociparse($conn,$query);
OCIExecute($stmt);
if (!OCIFetch($stmt)) {
print "no record available";
}else {
print "Here are the records.<br>";
// OCIExecute($stmt);
while (OCIFetch($stmt)) {
.....
}
}

However, if there are 10 records in the table, only 9 will be displayed. This is because after " if (!OCIFetch($stmt)) " is evaluated, the pointer is pointing to the record after the first one.

One trick is to use "OCIExecute($stmt); " twice, as I commented out above. But I doubt this is the most effective way. In JSP, there is such function as resultSet.next(), resultSet.beforeFirst(). Is there any similar function in PHP with Oracle?

Please help.

Thanks.

Jie Huang

kevinsequeira

while checking
if (!OCIFetch($stmt)) {
print "no record available";
}else {

...
..

}

u are already moving of the first record if the condition is true, so in the else part the while loop is actually iterating from the second record

in mysql u check it with mysql_num_rows($result) > 0

in oracle i think its

 if (OCINumCols($stmt)<1) {
print "no record available";
}else {
print "Here are the records.<br>";
// OCIExecute($stmt);
while (OCIFetch($stmt)) {
.....
}
}

reg
kevin

jweissig

or you could use the following

$stmt = OCIParse($connect, "SELECT * FROM articles WHERE price<=100");
OCIExecute($stmt);
$counter = 0;
while (OCIFetch($stmt)) {
	$counter++;
	echo OCIResult($stmt, "ARTICLE")." costs $";
	echo OCIResult($stmt, "PRICE")."<BR>\n";
}
OCIFreeStatement($stmt);

if ($counter == 0) {
	echo "no records found";
} else {
	echo "$counter articles found.";
}

jiehuang001

Hi, Kevin:
For your code, even if there is no record returned. it still prints "Here are the records.<br>", instead of "no record available".

Hi, Jweissig:
Your code works well. Can you show me an easy way to print "$counter article found" before the records are shown? As you know, it doesn't make much sense to put that information at the bottom.

Thanks.

Jie Huang