問題描述
我正在創建一個表格以顯示在網頁上，該表格是從 MySQL 數據庫中的數據填充的.我正在嘗試做一些讓我感到困難的事情.
I am creating a table to display on a web page and that table is populated from data in a MySQL database. I am trying to do a couple of things that are making it difficult for me.
首先，我試圖通過 JavaScript 調用 HTML 中單獨文件中存在的 PHP 代碼.我想我可以正常工作，但我不是 100% 確定(因為表格不會顯示).我認為它運行正常，因為某些表格代碼(在 PHP 文件中)顯示在 FireBug 中.
First I am trying to have call the PHP code that exists in a separate file in HTML via JavaScript. I think I have that working right but I am not 100% sure (because the table will not display). I think it is working right because some of the code for the table (which is in the PHP file) displays in FireBug.
其次，我試圖使行交替顏色以便于查看.到目前為止，我的 PHP 代碼如下.該表格根本不會在任何瀏覽器中顯示.
Second I am trying to make it so the rows alternate colors for easy viewing too. My PHP code so far is below. The table does not display at all in any browser.
$query = "SELECT * FROM employees";
$result = mysql_query($query);
$num = mysql_num_rows($result);
echo '<table>';
for ($i = 0; $i < $num; $i++){
$row = mysql_fetch_array($result);
$id = $row['id'];
$l_name = $row['l_name'];
$f_name = $row['f_name'];
$ssn = $row['ssn'];
$class = (($i % 2) == 0) ? "table_odd_row" : "table_even_row";
echo "<tr>";
echo "<td class=" . $class . ">$wrap_id</td>";
echo "<td class=" . $class . ">$wrap_l_name</td>";
echo "<td class=" . $class . ">$wrap_f_name</td>";
echo "<td class=" . $class . ">$wrap_ssn</td>";
echo "</tr>";
}
echo '</table>';
mysql_close($link);
}
編輯
回答幾個問題:
@controlfreak123，我不確定您所說的include ('filename_with_php_in_it')"是什么意思.至于未被調用的頁面被解析，我認為它正在被調用并且正在聯系.我在最初的問題中指出，我相信這是真的，因為 FireBug 顯示了表格的代碼，并且該代碼位于單獨的 PHP 文件中，因此必須在 HTML 文件和 PHP 文件之間進行通信.如果您想知道，以下是我從 HTML 文件調用 PHP 文件的方法:
@controlfreak123, I am not sure what you mean by "include ('filename_with_php_in_it')". As far as the page not being called to be parsed, I think it is being called and contact is being made. I pointed out in my original question that I believe this is true because FireBug shows the code for the table, and that code is in separate PHP file, thus communication between the HTML file and the PHP file must be taking place. Here is how I am calling the PHP file from the HTML file you if you care to know:
<script language="javascript" type="text/javascript" src="/Management/Employee_Management.php?action=Edit_Employee"></script>
@Matt S，我對輸出的影響不大，事實上我根本不知道我得到了什么，直到我查看 FireBug 并看到 PHP 代碼(或其中一些)確實是被傳遞到 HTML 文件.具體問題是如何從我的 MySQL 數據庫中獲取我想要的數據并通過 PHP 將其填充到 HTML 表中.我還可以確認 employees 中確實有數據，我輸入了兩個條目進行測試.我可以嘗試按照您的建議將代碼放入它自己的文件中而不使用 JavaScript，但這會違背我的目的，因為我希望我的 HTML 和 PHP 文件是分開的，但我可以嘗試一下，看看 PHP 代碼是否好并確保 JavaScript 不會破壞它.
@Matt S, I am not getting much in the way of output, in fact I didn't know I was getting anything at all until I looked at FireBug and saw that the PHP code (or some of it) was indeed being passed to the HTML file. The specific question is how do I get the data I want from my MySQL database and populate it into an HTML table via PHP. I can also confirm that employees does have data in it, two entries I put in for testing. I can try to put the code into its own file without the JavaScript as you suggested, but that would defeat my purpose since I want my HTML and PHP files to be separate, but I may try it just to see if the PHP code is good and to make sure the JavaScript isn't breaking it.
@Aaron，我不確定你在問什么(抱歉).該代碼用于在 HTML 頁面上填充創建和填充表格.
@Aaron, I am not sure what you are asking (sorry). The code is meant to populate create and populate a table on an HTML page.
推薦答案
以下是您正在尋找的完整示例:
Here is a full example of what you're looking for:
- 使用php從mysql中提取一些數據
- 將該數據放入一個 html 表格中
- 將交替的彩色行應用于表格
對于樣式，我有點作弊并使用 jquery，我發現它比您嘗試做的要容易一些.
For the styling I cheat a little and use jquery which I find a bit easier then what you're trying to do.
另外，請記住 $row[field] 區分大小寫.所以 $row[id] != $row[ID].
希望這有幫助:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js" type="text/javascript"></script>
<style type="text/css">
tr.header
{
font-weight:bold;
}
tr.alt
{
background-color: #777777;
}
</style>
<script type="text/javascript">
$(document).ready(function(){
$('.striped tr:even').addClass('alt');
});
</script>
<title></title>
</head>
<body>
<?php
$server = mysql_connect("localhost","root", "");
$db = mysql_select_db("MyDatabase",$server);
$query = mysql_query("select * from employees");
?>
<table class="striped">
<tr class="header">
<td>Id</td>
<td>Name</td>
<td>Title</td>
</tr>
<?php
while ($row = mysql_fetch_array($query)) {
echo "<tr>";
echo "<td>".$row[ID]."</td>";
echo "<td>".$row[Name]."</td>";
echo "<td>".$row[Title]."</td>";
echo "</tr>";
}
?>
</table>
</body>
</html>
這是僅使用 PHP 來替換樣式的表格代碼，就像您在示例中嘗試做的那樣:
Here's the table code only using PHP to alternate the styles like you're trying to do in your example:
<table class="striped">
<tr class="header">
<td>Id</td>
<td>Title</td>
<td>Date</td>
</tr>
<?php
$i = 0;
while ($row = mysql_fetch_array($query)) {
$class = ($i == 0) ? "" : "alt";
echo "<tr class="".$class."">";
echo "<td>".$row[ID]."</td>";
echo "<td>".$row[Name]."</td>";
echo "<td>".$row[Title]."</td>";
echo "</tr>";
$i = ($i==0) ? 1:0;
}
?>
</table>
這篇關于用 PHP 創建表并從 MySQL 填充的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！