我有这段代码:
if (isset($_POST['username']) && isset($_POST['email'])) {
$query = $pdo->prepare('INSERT INTO users (name, email, joined) VALUES (?, ?, ?)') or die ('Error.');
$query->bindValue(1, $_POST['username']);
$query->bindValue(2, $_POST['email']);
$query->bindValue(3, time());
$query->execute();
$sql = mysql_query('SELECT * FROM users;');
while ($row = mysql_fetch_array($sql)) {
echo ('<div style="font-weight: bold;">' .$row['name']. '</div>');
echo ($row['email']);
echo ('<br>');
echo ('Posted: ');
echo date('F j, Y, g:i a', strtotime($row['joined']));
}
}
它指责此错误:
mysql_fetch_array()期望参数1为资源,在第21行的C:\ WebServer \ htdocs \ newsSite \ register.php中给出布尔值
并在另一个文件(如下)上,它工作正常,但我看不到它们之间的区别:
<body>
<?php
$query = mysql_query('SELECT * FROM posts;');
while ($row = mysql_fetch_array($query)) {
echo ('<div style="font-weight: bold;">' .$row['title']. '</div>');
echo ($row['post']);
echo ('<br>');
echo ('Posted: ');
echo date('F j, Y, g:i a', strtotime($row['date']));
}
?>
</body>
尝试这样,这是我很久以前使用过的代码段,
// PDO
$pdo = new PDO('mysql:dbname=test;host=127.0.0.1', 'example', 'example');
print '<h3>PDO: simple select</h3>';
foreach($pdo->query( 'SELECT * FROM users;' ) as $row)
{
//Fetching data
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句