View data in Array

Question

I’m doing a query in a database and I need to display the information on the screen, but searching one at a time. I tried to do by array, but it is not displaying the vector.

Code:

<?php
$a = $_GET['a'];
if($a == "buscar"){
  $id = $_POST['id'];
  $sql = ibase_query("SELECT NOME FROM TB_CLIENTE WHERE ID_CLIENTE LIKE '%".$id."%'");
  $row = ibase_fetch_row($sql);
  $vetorDados = array();
  $i=0;
  $vetorDados[$i]= ibase_fetch_row($sql);
  echo '<tr>';
  echo '<td>' . $vetorDados[$i] . '</td>';
  echo '<td>' . $i . '</td>';
  echo '</tr>';
  $i++;
}
?>

Answer 1

You have yet to create one while to display data, another detail that became redundant was you create an array $vetorDados to print the bank result, with the variable $row is already a array, below follows the code to display the database data.

<?php
$a = $_GET['a'];
if($a == "buscar"){
$id = $_POST['id'];
$sql = ibase_query("SELECT NOME FROM TB_CLIENTE WHERE ID_CLIENTE LIKE '%".$id."%'");
$i = 1;
while($row = ibase_fetch_row($sql)){
   echo "<tr>";
   echo "<td>{$row['NOME']}</td>";
   echo "<td>{$i}</td>"; 
   echo "</tr>";
   $i++;
   }    
}
?>

The key to the variable $row is the name of the column of the bank to which you want to print the information.