Is there a way to get a excel spreadsheet type of format with the things I echo out in PHP, without using a table?
$result = mysql_query("SELECT * FROM posts");
while($row = mysql_fetch_array($result))
{
echo $row['user'] . " " . $row['email'] . " " . $row['age'] . " " . $row['image'] . " " . $row['created_at'];
echo "<br />";
}
Try using div
. set the width
as you want.
<?php
mysql_select_db("test",mysql_connect("localhost","root",""));
$result = mysql_query("select * from test");
$count = mysql_num_rows($result);
$counter = 0;
while($row = mysql_fetch_array($result))
{
$counter++;
?>
<div style="clear:left; float:left; width:604px;<?php echo $counter == $count ? "border-bottom:1px solid black;" : ""; ?>">
<div style="float:left; border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; width:200px;"><?php echo $row['fullname'] ?></div>
<div style="float:left; border-right:1px solid black; border-top:1px solid black; width:200px;"><?php echo $row['email'] ?></div>
<div style="float:left; border-right:1px solid black; border-top:1px solid black; width:200px;"><?php echo $row['password'] ?></div>
</div>
<?php
}
?>
This will give you output like this,
Use blue print CSS for showing the grid.
Please look at the http://www.blueprintcss.org/
.
You can apply CSS to the HTML elements with PHP embedded in your code.
Example:
<table class="style_1">
<?php
while($row = mysql_fetch_array($result))
{
?>
<tr class="style_2">
<td class="style3"> <? $row['user'] ?></td>
<td class="style3"> <? $row['email'] ?></td>
<td class="style3"> <? $row['age'] ?></td>
</tr>
<? } ?>