問題描述

我想創建一個包含兩列名稱的表，其中名稱取自數據庫，但我不知道如何..我需要幫助.

姓名:詹姆斯、約翰、保羅、彼得

這是我的代碼:

";$count = 0;$sql = "SELECT * FROM tbl_names";$q = mysql_query($sql);while($res = mysql_fetch_array($q)){$count++;echo "";for($i=1;$i<=2;$i++){echo "<td>{$res['id']}{$res['title']}</td>";}回聲</tr>";}echo "</table>";?>

我希望輸出是這樣的:

+-------+-------+|詹姆斯 |約翰 |+-------+-------+|保羅 |彼得 |+-------+-------+

但我的代碼返回:

+-------+-------+|詹姆斯 |詹姆斯 |+-------+-------+|約翰 |約翰 |+-------+-------+|保羅 |保羅 |+-------+-------+|彼得 |彼得 |+-------+-------+

我需要你的幫助.

好吧，如果沒有關系并且表格僅用于布局:

echo '
';while($res = mysql_fetch_array($q)){echo '
'.$res['id'] .$res['title'] .'</div>';}回聲'</div>';

在 css 中:

.container { 寬度:400px;向左飄浮;}.container .item { 寬度:50%;向左飄浮;高度:一些固定高度；}//或 200 像素

無論如何，我更喜歡只使用表格來顯示實際表格并避免將它們用于布局.你可以用 div 做任何你想做的事情(或者在這種情況下你也可以使用 ul 和 li.當然這不是必須的，但通常它需要較少的 HTML，對于 SEO 來說，html 內容比率是需要考慮的.如果你不這樣做"如果你想要固定的高度，你可以像上面的 td/tr 示例一樣包裹每一行.

I want to create a table of names with two columns where names are taken from the database but I don't know how.. I need help.

Names: James, John, Paul, Peter

Here's my code:

<?php
$con = mysql_connect("localhost","root","");
if(!$con){
echo "Unable to connect DB";
}else{
    $db = mysql_select_db("persons",$con);
    echo "Connected";
}
echo "<table border='1'>";
$count = 0;
$sql = "SELECT * FROM tbl_names";
$q = mysql_query($sql);
while($res = mysql_fetch_array($q)){
$count++;
    echo "<tr>";
        for($i=1;$i<=2;$i++){
                echo "<td>{$res['id']}{$res['title']}</td>";
        }
    echo "</tr>";   
}
echo "</table>";
?>

I want the output to be like this:

+-------+-------+
| James | John  |
+-------+-------+
| Paul  | Peter |
+-------+-------+

But my code return:

+-------+-------+
| James | Jame  |
+-------+-------+
| John  | John  |
+-------+-------+
| Paul  | Paul  |
+-------+-------+
| Peter | Peter |
+-------+-------+

I need your help.

well, if there's no relation and the table is used only for layout:

echo '<div class="container">';
while($res = mysql_fetch_array($q)){
    echo '<div class="item">'.  $res['id'] . $res['title'] . '</div>';
}
echo '</div>';

and in css:

.container { width: 400px; float: left; }
.container .item { width: 50%; float: left; height: someFixedHeight; }
// or 200px

anyways, it's my preference to use tables only for displaying actual tables and avoid using them for layout. you can do anything you want with div's (or in this case you can also use ul and li. Of course it's not a must but normally it requires less HTML and for SEO the html-content ratio is something to consider. if you don't want fixed heights you can wrap each row as with the td/tr examples above.

這篇關于如何使用數據庫中的值創建 PHP 兩列表?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！