To store mysql row result as table format in php variable

Question

here is my code

<?php 
while($rowcall=mysql_fetch_array($qry_call))
{
?>
  <table>
  <tr>
  <td><?php echo $rowcall['caller_id'];?></td>
  <td><?php echo $rowcall['did']; ?></td>
  <td><?php echo $rowcall['start_time']; ?></td>
  <td><?php echo $rowcall['end_time']; ?></td>
  <td><?php echo $rowcall['call_duration']; ?></td>
  </tr>
 </table> 
 <?php } ?>

I need to store this table in php variable $result.

Answer 1

<?php

  $result = '';
  while($rowcall=mysql_fetch_array($qry_call))
  {
     $result .= '<table>';
     $result .= '<tr>';
     $result .= '<td>'.$rowcall['caller_id'].'</td>';
     $result .= '<td>'.$rowcall['did'].'</td>';
     $result .= '<td>'.$rowcall['start_time'].'</td>';
     $result .= '<td>'.$rowcall['end_time'].'</td>';
     $result .= '<td>'.$rowcall['call_duration'].'</td>';
     $result .= '</tr>';
     $result .= '</table>';
  }

  echo $result;

?>

Answer 2

Pretty basic PHP;

<?php 
$result="";
while($rowcall=mysql_fetch_array($qry_call))
{
    $result.="  <table>";
    $result.="  <tr>";
    $result.="  <td>".$rowcall['caller_id']."</td>";
    $result.="  <td>".$rowcall['did']."</td>";
    $result.="  <td>".$rowcall['start_time']."</td>";
    $result.="  <td>".$rowcall['end_time']."</td>";
    $result.="  <td>".$rowcall['call_duration']."</td>";
    $result.="  </tr>";
    $result.=" </table>"; 
}
?>

Answer 3

    *<?php

  $result = '';
  while($rowcall=mysql_fetch_array($qry_call))
  {
     $result .= '<table>';
     $result .= '<tr>';
     $result .= '<td>'.$rowcall['caller_id'].'</td>';
     $result .= '<td>'.$rowcall['did'].'</td>';
     $result .= '<td>'.$rowcall['start_time'].'</td>';
     $result .= '<td>'.$rowcall['end_time'].'</td>';
     $result .= '<td>'.$rowcall['call_duration'].'</td>';
     $result .= '</tr>';
     $result .= '</table>';
  }

  echo $result;

?>*

Answer 4

You could do it like this:

<?php 
    $result = "";
    while($rowcall=mysql_fetch_array($qry_call))
    {
        $result .= "<table>";
        $result .= "<tr>";
        $result .= "<td>".$rowcall['caller_id']."</td>";
        $result .= "<td>".$rowcall['did']."</td>";
        $result .= "<td>".$rowcall['start_time']."</td>";
        $result .= "<td>".$rowcall['end_time']."</td>";
        $result .= "<td>".$rowcall['call_duration']."</td>";
        $result .= "</tr>";
        $result .= "</table>";
    } 

    echo $result;
?>

Answer 5

Try on these lines. Also switch to mysqli_* rather than mysql_* as the one you are using is deprecated

<?php 
$str="";
while($rowcall=mysql_fetch_array($qry_call))
{
  $str .= "<table>
  <tr>
  <td>{$rowcall['caller_id']}</td>
  <td>{$rowcall['did']}</td>
  <td>{$rowcall['start_time']}</td>
  <td>{$rowcall['end_time']}</td>
  <td>{$rowcall['call_duration']}</td>
  </tr>
 </table>"; 
} 
?>

Answer 6

I strongly advise you to see docs at http://www.php.net/manual/en/language.types.string.php

Answer 7

start and end the <table></table> tag out side while loop no inside it will create a new table for every row but that's you don't want