>好吧。我有几个疑问
<?php
// Make a MySQL Connection
mysql_connect("mm.hostname.net", "user", "pass") or die(mysql_error());
mysql_select_db("db_name") or die(mysql_error());
$query = "SELECT card_id,item_bar FROM cards";
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result))
{
echo "Id :{$row['card_id']} <br>" .
"Title :($row['title']}" .
"Description :($row['description']}";
}
include 'closedb.php';
?>
我的问题是我如何让查询在如下所示的表格中对齐?
Id | Title | Description
============================
1 | card | cute and fluffy
1 | card | cute and fluffy
1 | card | cute and fluffy
1 | card | cute and fluffy
1 | card | cute and fluffy
我对使用 php 的查询很陌生(无论如何,我真的仍在尝试掌握它们的窍门)
您可以使用表格:
<?php
// Make a MySQL Connection
mysql_connect("hostname", "user", "pass") or die(mysql_error());
mysql_select_db("db_name") or die(mysql_error());
$query = "SELECT card_id,item_bar FROM cards";
$result = mysql_query($query);
echo '<table>';
echo '<th><td>Id</td><td>Title</td><td>Description</td></th>';
while($row = mysql_fetch_assoc($result))
{
echo "<tr><td>$row['card_id']</td>" .
"<td>$row['title']</td>" .
"<td>$row['description']</td></tr>";
}
echo '</table>';
?>