PHP回波表的样式设计
PHP回波表的样式设计
提问于 2015-11-26 16:44:44
我终于弄明白了如何使用PHP来显示SQL表，但是，我很难让这些样式显示出来。到目前为止，有什么关于如何设计回声样式的建议吗？什么都没出现。我是如何这样做的不适当的方式风格的回声？我试着用引导CSS来设计它。
<html>
<head>
<title>Abacus PHP SQL Server Connection</title>
</head>
<body>
<?php
$db_host = '***';
$db_user = '***'; //recommend using a lower privileged user
$db_pwd = '***';
$database = '***';
$table = '***';
$connectionInfo = array("UID" => $db_user, "PWD" => $db_pwd, "Database"=>$database);
$conn = sqlsrv_connect( $db_host, $connectionInfo);
if( !$conn )
{
echo "Connection could not be established.\n";
die( print_r( sqlsrv_errors(), true));
}
$tsql = "SELECT category, data_desc, data_source, update_cycle,ISNULL(datename(mm,last_abadata_update) + + ' ' + DATENAME(dd,last_abadata_update) + ', ' + DATENAME(yyyy, last_abadata_update),'') AS last_abadata_update, ISNULL(datename(mm,last_abadata2_update) + ' ' + DATENAME(dd,last_abadata2_update) + ', ' + DATENAME(yyyy,last_abadata2_update),'') AS last_abadata2_update FROM {$table} ORDER BY category, data_source, data_desc";
$result = sqlsrv_query( $conn, $tsql);
if (!$result) {
die("Query to show fields from table failed");
}
echo "<table >";
echo "<tr>";
// printing table headers with desired column names
echo "<td style='border=1px solid black;Font-size=18;Font-Weight=bold'>";
echo "Category";
echo "</td>";
echo "<td style='border=1px solid black;Font-size=18;Font-Weight=bold'>";
echo "Description";
echo "</td>";
echo "<td style='border=1px solid black;Font-size=18;Font-Weight=bold'>";
echo "Source";
echo "</td>";
echo "<td style='border=1px solid black;Font-size=18;Font-Weight=bold'>";
echo "Update Cycle";
echo "</td>";
echo "<td style='border=1px solid black;Font-size=18;Font-Weight=bold'>";
echo "Last AbaData Update";
echo "</td>";
echo "<td style='border=1px solid black;Font-size=18;Font-Weight=bold'>";
echo "Last AbaData 2.0 Update";
echo "</td>";
echo "</tr>";
while($row = sqlsrv_fetch_array($result))
{
echo "<tr>";
echo "<td style='border=1px solid black'>";
echo $row['category'];
echo "</td>";
echo "<td style='border=1px solid black'>";
echo $row['data_desc'];
echo "</td>";
echo "<td style='border=1px solid black'>";
echo $row['data_source'];
echo "</td>";
echo "<td style='border=1px solid black'>";
echo $row['update_cycle'];
echo "</td>";
echo "<td style='border=1px solid black'>";
echo $row['last_abadata_update'];
echo "</td>";
echo "<td style='border=1px solid black'>";
echo $row['last_abadata2_update'];
echo "</td>";
echo "</tr>\n";
}
echo "</table>";
sqlsrv_free_stmt( $result);
sqlsrv_close( $conn);
?>
</body>
</html>Stack Overflow用户
发布于 2015-11-26 16:50:25
我不喜欢你用这个html做造型。使用CSS样式。将id或类添加到元素中。我甚至不回显html元素，而是打开和关闭php标记，并在平面html中编写元素，只有当我需要显示php var时，我才使用php。有人会说也许不好，但我就是这样做的。下面是我将如何执行您的代码：
<html><head><title>Abacus PHP SQL Server Connection</title></head><body>
<?php
$db_host = '***';
$db_user = '***'; //recommend using a lower privileged user
$db_pwd = '***';
$database = '***';
$table = '***';
$connectionInfo = array("UID" => $db_user, "PWD" => $db_pwd, "Database"=>$database);
$conn = sqlsrv_connect( $db_host, $connectionInfo);
if( !$conn )
{
echo "Connection could not be established.\n";
die( print_r( sqlsrv_errors(), true));
}
$tsql = "SELECT category, data_desc, data_source, update_cycle,ISNULL(datename(mm,last_abadata_update) + + ' ' + DATENAME(dd,last_abadata_update) + ', ' + DATENAME(yyyy, last_abadata_update),'') AS last_abadata_update, ISNULL(datename(mm,last_abadata2_update) + ' ' + DATENAME(dd,last_abadata2_update) + ', ' + DATENAME(yyyy,last_abadata2_update),'') AS last_abadata2_update FROM {$table} ORDER BY category, data_source, data_desc";
$result = sqlsrv_query( $conn, $tsql);
if (!$result) {
die("Query to show fields from table failed");
}
?>
<table>
<tr>
<td style="border:1px solid black;Font-size:18;Font-Weight:bold">
Category
</td>
<td style="border:1px solid black;Font-size:18;Font-Weight:bold">
Description
</td>
<td style="border:1px solid black;Font-size:18;Font-Weight:bold">
Source
</td>
<td style="border:1px solid black;Font-size:18;Font-Weight:bold">
Update Cycle
</td>
<td style="border:1px solid black;Font-size:18;Font-Weight:bold">
Last AbaData Update
</td>
<td style="border:1px solid black;Font-size:18;Font-Weight:bold">
Last AbaData 2.0 Update
</td>
</tr>
<?php
while($row = sqlsrv_fetch_array($result))
{
?>
<tr>
<td style="border:1px solid black">
<?php
echo $row['category'];
?>
</td>
<td style="border:1px solid black">
<?php
echo $row['data_desc'];
?>
</td>
<td style="border:1px solid black">
<?php
echo $row['data_source'];
?>
</td>
<td style="border:1px solid black">
<?php
echo $row['update_cycle'];
?>
</td>
<td tyle="border:1px solid black">
<?php
echo $row['last_abadata_update'];
?>
</td>
<td style="border:1px solid black">
<?php
echo $row['last_abadata2_update'];
?>
</td>
</tr>
<?php
}
?>
</table>
sqlsrv_free_stmt( $result);
sqlsrv_close( $conn);
?>
</body></html>页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/33943544
复制相关文章
相似问题
腾讯云开发者
