第一步：数据库的创建
1.使用phpmyadmian创建一个数据库，名字可以自己选，因为是博客有可能需要输入中文，所以MySQL连接校对选择：uft8_unicode_ci（或utf8_general_ci）
2.创建数据表
需要建立的数据表如图：
以创建blog_posts为例：
需要注意的是，blog_post_tags这张表无需设置主键。
第二步：使用PHP创建对象
创建blogpost.php文件，文件内容为：
以下是代码片段：
<?php
class BlogPost
{
public $id;
public $title;
public $post;
public $author;
public $tags;
public $datePosted;
//构造函数
function __construct($inId=NULL,$inTitle=NULL,$inPost=NULL,$inPostFull=NULL,$inAuthorId=NULL,$inDatePosted=NULL)
{
if (!empty($inId))
{
$this->id = $inId;
}
if (!empty($inTitle))
{
$this->title = $inTitle;
}
if (!empty($inPost))
{
$this->post =$inPost;
}
if (!empty($inDatePosted))
{
//将2005-05-03格式化为2005/05/03
$splitDate =explode("-",$inDatePosted);
$this->datePosted = $splitDate[0]."/".$splitDate[1]."/".$splitDate[2];
}
if (!empty($inAuthorId))
{
//获取全名
$query = mysql_query("SELECT first_name, last_name FROM people WHERE id = ".$inAuthorId);
$row = mysql_fetch_assoc($query);
$this->author = $row["first_name"] ." " . $row["last_name"];
}
$postTags = "No Tags";
if (!empty($inId))
{
//获取文章标签
$query = mysql_query("SELECT tags.* From blog_post_tags LEFT JOIN(tags) ON (blog_post_tags.tag_id =tags.id) WHERE blog_post_tags.blog_post_id= ".$inId);
$tagArray = array();
$tagIDArray = array();
while ($row = mysql_fetch_assoc($query))
{
array_push($tagArray,$row["name"]);
array_push($tagIDArray,$row["id"]);
}
if (sizeof($tagArray)>0)
{
foreach ($tagArray as $tag)
{
if ($postTags == "No Tags")
{
$postTags = $tag;
}
else
{
$postTags = $postTags.",".$tag;
}
}
}
}
$this->tags = $postTags;
}
}
?>第三步：从MySQL获取数据，并显示内容
1.创建includes.php
以下是代码片段：
<?php
include ’blogpost.php’;
$connection = mysql_connect("localhost","root","") or die("<p class=’error’>Sorry, we ware unable to connect to the datebase server.</p>");
$query = mysql_query("SET NAMES ’utf8’"); //如果需要显示中文，则必须要在数据库连接后面加上此句
$database = "myblog";
mysql_select_db($database,$connection) or die("<p class=’error’>Sorry, We were unable to connect the datebase.</p>");
function GetBlogPosts($inId=NULL,$inTagId=NULL)
{
if (!empty($inId))
{
$query = mysql_query("SELECT * FROM blog_posts WHERE id=".$inId."ORDER BY id DESC");
}
elseif (!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["date_posted"]);
array_push($postArray,$myPost);
}
return $postArray;
}
?>2.创建实例index.php
| 以下是代码片段： <div id="main"> <h1>My Simple Blog</h1> <div id="blogPosts"> <?php include ’includes.php’; $blogPosts = GetBlogPosts(); foreach ($blogPosts as $post) { echo "<div class=’post’>"; echo "<h2>".$post->title."</h2>"; echo "<p>".$post->post."</p>"; echo "<span class=’footer’>Posted By: " . $post->author . " Posted On: " . $post->datePosted . " Tags: " . $post->tags . "</span>"; echo "</div>"; } ?> </div> </div> |
原文链接：http://net.tutsplus.com/news/how-to-create-an-object-oriented-blog-using-php/