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.

Interesting that no Stop Using mysql_* comments here yet, but really you should :) — Hanky Panky
– Hanky Panky, Commented Sep 6, 2013 at 6:19

Aldi Unanto · Accepted Answer · 2013-09-06 06:03:07Z

4

<?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;

?>

answered Sep 6, 2013 at 6:03

Aldi Unanto

3,6821 gold badge25 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Bjorn Smeets Over a year ago

With this code you would generate a seperate table for every element you get from the database

Aldi Unanto Over a year ago

Yep, I know. But that's what @user2732605 want if I see his question

rakeshjain Over a year ago

@BjornSmeets thats what the OP has asked, right? "To store mysql row result as table format in php variable"

Bjorn Smeets Over a year ago

You are right, my bad. I misunderstood the question and thought he wanted 1 big table with all the data as rows inside that table

Aldi Unanto Over a year ago

Exactly @rakeshjain .

GreyRoofPigeon · Accepted Answer · 2013-09-06 06:03:23Z

1

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>"; 
}
?>

answered Sep 6, 2013 at 6:03

GreyRoofPigeon

18.1k5 gold badges39 silver badges60 bronze badges

Comments

Love Trivedi · Accepted Answer · 2013-09-06 06:06:29Z

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;

?>*

answered Sep 6, 2013 at 6:06

Love Trivedi

4,0913 gold badges22 silver badges29 bronze badges

Comments

Bjorn Smeets · Accepted Answer · 2013-09-06 06:08:45Z

1

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;
?>

edited Sep 6, 2013 at 6:08

answered Sep 6, 2013 at 6:02

Bjorn Smeets

3201 silver badge8 bronze badges

Comments

rakeshjain · Accepted Answer · 2013-09-06 06:01:22Z

0

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>"; 
} 
?>

answered Sep 6, 2013 at 6:01

rakeshjain

1,76111 silver badges11 bronze badges

1 Comment

rakeshjain Over a year ago

@BjornSmeets thats what the OP has asked, right? "To store mysql row result as table format in php variable"

Alex · Accepted Answer · 2013-09-06 06:05:59Z

0

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

answered Sep 6, 2013 at 6:05

Alex

1,59311 silver badges14 bronze badges

Comments

Rahul Goswami · Accepted Answer · 2013-09-06 06:11:39Z

0

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

answered Sep 6, 2013 at 6:11

Rahul Goswami

114 bronze badges

Collectives™ on Stack Overflow

To store mysql row result as table format in php variable

7 Answers 7

5 Comments

Comments

Comments

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

5 Comments

Comments

Comments

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related