它的一个非常简单的逻辑,对不起,我不使用你的完整代码:
的index.php:
your pagecolumn with checkboxcolumn with text
// get your databaseresult to an array called $result
$connection = mysql_connect("server", "user", "password");
mysql_select_database("databasename");
$resultHash = mysql_query("SELECT * FROM mytable");
while($row = mysql_fetch_array($resultHash)){
$result[] = $row;
}
mysql_close($connection); // never forget to close the connection if not longer needed
foreach($result as $key => $value)
{
echo "
\r\n";echo "
\r\m";// $key is the index of your numeric $result array
echo "
".$value[0]."\r\n";echo "
\r\n";}
?>
那简直是所有你需要做的我思考,请与mysql_fetch_array() http://php.net/manual/en/function.mysql-fetch-array.php工作,它甚至更快
我希望的代码是否正确,如不看什么阵列$result和$value就像通过使用var_dump()。没有测试它,并没有写PHP 4周或类似这样的东西
编辑: 我昨晚做了一个错误,对不起,这里有一点修正。
我认为你的数据库表的设计就像。
表(ID INT AUTO_INCREMENT,东西VARCHAR(255)NOT NULL,PRIMARY KEY(ID))
foreach($result as $index => $row){
echo "
";echo "
";echo ""; // now every checkbox has an unique identifier
echo "
";foreach($row as $column => $value){
echo "
";echo "column = ".$column;
echo "\r\n";
echo "value = ".$value;
echo "
";}
echo "
";}
?>