View data in PHP table

Question

I am making a sales report and need to organize the data coming from a bank in Firebird make a report on PHP, however I am not getting know how many data are coming from the bank. Because the function ibase_num_fields does not return how many are the data. And then how would the organization of this data in table ?

   $host='localhost:C:/bd_relatorio/clipp.FDB';    

   $dbh=ibase_connect($host,'SYSDBA','masterkey');

   $stmt = 'SELECT NOME FROM TB_CLIENTE';

   $sth = ibase_query($dbh, $stmt);   

   $total = ibase_num_fields($sth);

   if($total > 2){

     while ($row = ibase_fetch_row($sth)) {
         echo $row[0], "\n";
     }
   }
   echo $total;
   ibase_free_result($sth);
   ibase_close($dbh);
?>

Answer 1

There is no function in the library ibase_ returning the number of lines in a query.

There are two options:

• the first via SQL is to execute the same query with a count().

• The second way is to create a variable that stores the number of rows, something like:

--

$totalLinhas = 0;
if($sth){
   while ($row = ibase_fetch_row($sth)) {
      echo $row[0], "\n";
      $totalLinhas++;
   }
   echo "total: ". $totalLinhas;
}

Answer 2

// count of received lines in the array $total = ibase_num_rows($sth);

// loops the array, assembling the table rows. // Just print the variable

while($row = ibase_fetch_object($sth))
{
  $linhas = '<tr><td>Clientes: '. $row->NOME .'</td></tr>';
}