this question has answer here:
<?php require_once 'init.php'; $selectpost = mysql_query(" select posts.id, posts.author, posts.posttext posts group posts.id "); while($row = mysqli_fetch_object($selectpost)) { //line 30 $posts[] = $row; } ?> <?php foreach($posts $post): ?> //line 37 <div class="post row"> <p><?php echo $post->author; ?> said: </p> <p><?php echo $post->posttext; ?></p> </div> <?php endforeach; ?>
i trying display posts database. code have written far. reason getting these errors:
warning: mysqli_fetch_object() expects parameter 1 mysqli_result, boolean given in posts.php on line 30
notice: undefined variable: posts in posts.php on line 37
warning: invalid argument supplied foreach() in posts.php on line 37
i have commented on appropriate lines.
you mixing mysql
& mysqli
.it should mysqli_query
instead of mysql_query
if using mysqli
. missing connection object
-
$selectpost = mysqli_query($conn, " select posts.id, posts.author, posts.posttext posts group posts.id ");
Comments
Post a Comment