Mysql fetch assoc with PHP MYSQL in a table format

Question

I have a code like this.

Code:

        <?php
        $book_query = mysql_query("select * from book_master')");
        while($book_query_fetch = mysql_fetch_assoc($book_query)){
        echo "<pre>";
        print_r($book_query_fetch);  
        echo "</pre>"
        }
        ?>

Output:

        Array
        (
        [Book_Name] => Book1
        [Book_ID] => 123
        )

        Array
        (
        [Book_Name] => Book2
        [Book_ID] => 124
        )

Expected Output: (in a table)

        Book Name       Book_ID
        Book1           123
        Book2           124

How can I achieve this? EDIT: The header part is a dynamic load. so i need the table header also in a loop

Zoe - Save the data dump · Accepted Answer · 2019-05-25 13:56:03Z

2

I don't know where you stuck doing that, but you can do below,

 echo "<table>";
 $i = 0;
 while($row = mysql_fetch_assoc($book_query))
  {
     if($i == 0){
        $columns = array_keys($row);
        echo "<th>";
        foreach($columns as $column){
            echo "<td> $column</td>";
        }
        echo "</th>";
     }
     echo'<tr>';
     echo '<td>'.$row['Book_Name'].'</td>';
     echo '<td>'.$row['Book_ID'].'</td>';
     echo '</tr>';
     $i++;
  }
  echo "</table>";

Waring: Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO, or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial.

edited May 25, 2019 at 13:56

Zoe - Save the data dump

28.4k22 gold badges130 silver badges163 bronze badges

answered Apr 1, 2014 at 11:25

Rikesh

26.5k14 gold badges82 silver badges90 bronze badges

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

4 Comments

user3350885 Over a year ago

oh no. the fetch assoc is a dynamic one with values.. i need a dynamic for table header part also.

Rikesh Over a year ago

See my updated. Note: I haven't tested the code, it's just an idea.

user3350885 Over a year ago

rikesh - please check my other question here stackoverflow.com/questions/22786306/…

Rikesh Over a year ago

Will look into it but Kindly accept the answer if your problem is solved by this.

sunny · Accepted Answer · 2014-04-01 11:27:39Z

0

Try this-

 <?php
        $book_query = mysql_query("select * from book_master')");
echo "<table>";
echo"<tr><td>Book Name</td><td>Book_ID</td></tr>";        
while($book_query_fetch = mysql_fetch_assoc($book_query)){

echo"<tr><td>".$book_query_fetch['Book_Name']."</td><td>".$book_query_fetch['Book_ID']."</td></tr>"; 


        }
echo "</table>";
        ?>

answered Apr 1, 2014 at 11:27

sunny

1,1668 silver badges15 bronze badges

1 Comment

user3350885 Over a year ago

sunny - i have edited my question. the table header part ie. Book Name and Book_ID will change dynamically. so the header part also should be loaded using the $book_query. please help me

Harish Kanakarajan · Accepted Answer · 2014-04-01 11:30:38Z

0

Along with Rikesh's code, Use the array_keys() function. this will fetch all the keys of the subset array.

So you can fetch the keys also dynamically.

Hope this helps you.

answered Apr 1, 2014 at 11:30

Harish Kanakarajan

6854 silver badges15 bronze badges

Comments

Dexter · Accepted Answer · 2014-04-01 11:34:49Z

0

you can do this

<table>

<?php
        $book_query = mysql_query("select * from book_master')");
       $book_query_fetch = mysql_fetch_assoc($book_query); ?>
          <th>
          <td><?php echo $book_query_fetch['book_name']; ?></td>
         <td><?php echo $book_query_fetch['Book_ID']; ?> </td>
         </th>
     <?php    while($book_query_fetch){ ?>
     <tr>
    <td><?php echo $book_query_fetch['Book_Name']; ?></td>
    <td><?php echo $book_query_fetch['Book_ID']; ?></td>
     </tr>
<?php } ?>
</table>

edited Apr 1, 2014 at 11:34

answered Apr 1, 2014 at 11:27

Dexter

1,7964 gold badges27 silver badges55 bronze badges

1 Comment

user3350885 Over a year ago

Mohit - the header part is dynamic. sorry for my bad english <th> <td>Book Name </td> <td>Book ID </td> </th> This will change dynamically. so i don't want to hardcode this value. any help

SagarPPanchal · Accepted Answer · 2014-04-01 11:38:38Z

0

Try this

 while($row = mysql_fetch_assoc($book_query))
  {
     echo'<tr><th>'.
   $columns = array_keys($row);
    foreach($columns as $column){
        echo "<td> $column</td>";
    }
     .'</th></tr><tr>';
     echo '<td>'.$row['Book_Name'].'</td>';
     echo '<td>'.$row['Book_ID'].'</td>';
     echo '</tr>';
  }
  echo "</table>";

answered Apr 1, 2014 at 11:38

SagarPPanchal

10.2k6 gold badges36 silver badges66 bronze badges

1 Comment

user3350885 Over a year ago

Sagar - Thanks . please check my other question here. help me out. stackoverflow.com/questions/22786306/…

user3436157 · Accepted Answer · 2014-04-01 11:50:05Z

0

//try this      
  <?php
        $book_query = mysql_query("select * from book_master')");
        while($book_query_fetch = mysql_fetch_assoc($book_query)){
        echo "<pre>";
$a="<table><tr>";

foreach ($book_query_fetch as $key=>$value){
        $a="<th>".$key."</th>"
}
exit;
        }
$a="</tr>"



       while($book_query_fetch = mysql_fetch_assoc($book_query)){

$a="<tr>";

foreach ($book_query_fetch as $key=>$value){
        $a="<td>".$value."</td>"
}
$a="</tr>";
        }

 $a="</table>"

echo $a;       


?>

answered Apr 1, 2014 at 11:50

user3436157

864 bronze badges

1 Comment

user3436157 Over a year ago

check this one it will help you!

Collectives™ on Stack Overflow

Mysql fetch assoc with PHP MYSQL in a table format

Code:

Output:

Expected Output: (in a table)

6 Answers 6

4 Comments

1 Comment

Comments

1 Comment

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

Code:

Output:

Expected Output: (in a table)

6 Answers 6

4 Comments

1 Comment

Comments

1 Comment

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related