PHP:
<?php
include 'blogpost.php';
// Change this info so that it works with your system.
$connection = mysql_connect('localhost', 'geheim', 'geheim') or die ("<p class='error'>Sorry, we were unable to connect to the database server.</p>");
$database = "geheim_blog";
mysql_select_db($database, $connection) or die ("<p class='error'>Sorry, we were unable to connect to the database.</p>");
function GetBlogPosts($inId=null, $inTagId =null)
{
if (!empty($inId))
{
$query = mysql_query("SELECT * FROM blog_posts WHERE id = " . $inId . " ORDER BY id DESC");
}
else if (!empty($inTagId))
{
$query = mysql_query("SELECT blog_posts.* FROM blog_post_tags LEFT JOIN (blog_posts) ON (blog_post_tags.postID = blog_posts.id) WHERE blog_post_tags.tagID =" . $tagID . " ORDER BY blog_posts.id DESC");
}
else
{
$query = mysql_query("SELECT * FROM blog_posts ORDER BY id DESC");
}
$postArray = array();
while ($row = mysql_fetch_assoc($query))
{
$myPost = new BlogPost($row["id"], $row['title'], $row['post'], $row['postfull'], $row["author_id"], $row['dateposted']);
array_push($postArray, $myPost);
}
return $postArray;
}
?>op rij 25...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/deb38778/domains/studieoverzicht.com/public_html/includes/includes.php on line 25
ik heb alle databases en tabellen
http://net.tutsplus.com/tutorials/php/how-to-create-an-object-oriented-blog-using-php/
kan iemand me helpen
Laatst bewerkt:
