我想在我的网页上显示一个查询结果集作为表格。该查询不会导致任何错误,但脚本不会产生任何输出。
我在数据库(玩家)中有一张桌子。该表有3行(id,firstname,lastname)。
Script source code:
View RecordsView Records
error_reporting(E_ALL);
ini_set('display_errors','1');
$db = new PDO('mysql:host=localhost;dbname=records2', 'root', '');
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$players = $db->query('SELECT * FROM players');
echo "
echo "
".$row['firstname']. "";echo "
".$row['lastname']."";echo "";
}
$player->closeCursor();
echo "
";?>
我的数据库:
CREATE TABLE IF NOT EXISTS `players` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`firstname` varchar(32) CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
`lastname` varchar(32) CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;