Get the record count before getting the records?

[jiehuang001]

I used the following code trying to display the total number of records and then dispaly all records. However, I can only be able to get the count number after the loop. How can I print the count number before printing the actual records?
-------------------the code--------------------------
$conn = // details omitted
$query = "select username, password from usertable";
$stmt = ociparse($conn,$query);
OCIDefineByName($stmt,"USERNAME",$username);
OCIDefineByName($stmt,"PASSWORD",$password);
OCIExecute($stmt);
while (OCIFetch($stmt)) {
print $username. " ". $password."/n";
}

$total_record = OCIRowCount($stmt);
print $total_record. " total records available".

[sdjensen]

$sql_count = "SELECT COUNT(*) FROM ($sqlstatement)";

  $row_count=OCIParse($db,$sql_count);

  $error=OCIExecute($row_count);

  if (OCIFetch($row_count)) {
    $num_rows = OCIResult($row_count,1);
  }	
  else {
    $num_rows = 0;
  }

[jiehuang001]

I want to print the count of records first, then print the records. Can your code do that??

[tsinka]

Hi,

you can use ocifetchstatement() which fetches all the rows from a result into an array and returns the number of rows.

Look at

http://www.php.net/manual/en/function.ocifetchstatement.php

for examples 🙂

[sdjensen]

What my code can do is getting the number of records from the sql-statement.

If you want to print the number of records, just do

print "Number of records : $num_rows ";