如何动态创建表？ [英] How to create a table dynamically?

问题描述

嗨



我正在尝试动态创建表格。它有效，但我有一个错误：

Hi

I am trying to create a table dynamically. It works but I have an error:

Notice: Undefined index: in C:\xampp\htdocs\asset-management\reports\querys\by-status.php on line 20

然后这是我写的代码：

Then here is the code I have written:

$query = "SELECT ".$columns." Item FROM tblitem WHERE Status=".$_POST['status'];
$result = mysql_query($query);

$tblCol = explode(",", $columns);

echo "<table>";

echo "<th>Item</th>";
foreach ($tblCol as $ColName){
	echo "<th>".$ColName."</th>";
}
while($row = mysql_fetch_array($result)){
	echo "<tr>";
	echo "<td>". $row['Item'] ."</td>";
	foreach ($tblCol as $columnName){
		echo "<td>". $row[$columnName] ."</td>";
	}
	echo "</tr>";
}

echo "</table>";

有人能帮助我吗？它工作正常，但错误不会消失。

Can some one help me? It works fine but the error does not disappear.

推荐答案

query = SELECT。

columns。 Item FROM tblitem WHERE Status =。

columns." Item FROM tblitem WHERE Status=".

_POST [' 状态];

_POST['status'];

这篇关于如何动态创建表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！