Showing the blogging application’s full source code - PHP

Welcome to the conclusion of a six-part series on building a MySQL-driven blogging application with the Code Igniter PHP framework. By using the framework, you'll be taking advantage of the MVC pattern to separate the application's logic from its visual presentation. This article will focus on the improving the appearance of the application's final details: the section concerned with receiving and displaying comments.

TABLE OF CONTENTS:

By: Alejandro Gervasio

Poor Best

Rating:

/ 5

January 13, 2009

print this article

SEARCH DEV SHED

TOOLS YOU CAN USE

As I mentioned in the section that you just read, below I listed the complete source code of this blog application, so you can play around with it and introduce your own improvements. Here it is:

// definition for 'blogger.php' file (located at /system/application/controllers/ folder)

class Blogger extends Controller{

function Blogger(){

// load controller parent

parent::Controller();

// load database class and connect to MySQL

$this->load->database();

// load pagination library

$this->load->library('pagination');

// load helper

$this->load->helper('url');

}

// display all blog entries

function blogs(){

$data['title']='Blog Entries Listing';

$data['result']=$this->db->get('blogs',3,$this->uri->segment(3));

// set pagination parameters

$config['base_url']='http://127.0.0.1/codeigniter/index.php/blogger/blogs/';

$config['total_rows']=$this->db->count_all('blogs');

$config['per_page']='3';

$config['full_tag_open']='<div id="paginglinks">';

$config['full_tag_close']='</div>';

$this->pagination->initialize($config);

// create pagination links

$data['links']=$this->pagination->create_links();

// load 'blogs_view' view

$this->load->view('blogs_view',$data);

}

// display all blog comments

function comments(){

$data['title']='Blog Comments Listing';

$this->db->where('blog_id',$this->uri->segment(3));

$data['result']=$this->db->get('blogs_comments');

// load 'blogs_comment_view' view

$this->load->view('blogs_comment_view',$data);

}

// insert new blog comment

function insert_comment(){

$this->db->insert('blogs_comments',$_POST);

redirect('blogger/comments/'.$_POST['blog_id']);

}

// definition for 'blogs_view.php' file (located at /system/application/views/ folder)

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<head>

body{

margin: 0;

padding: 0;

background: #fff;

}

h1{

font: bold 16pt Arial, Helvetica, sans-serif;

color: #003399;

margin: 18px 0 18px 0;

text-align: center;

}

h2{

font: bold 12pt Arial, Helvetica, sans-serif;

color: #333;

margin: 0 0 18px 0;

}

font: normal 11px Verdana, Arial, Helvetica, sans-serif;

color: #333;

margin: 0 0 18px 0;

}

#container{

width: 500px;

background: #ccf;

padding: 15px;

margin-left: auto;

margin-right: auto;

margin-bottom: 18px;

}

#paginglinks{

width: 500px;

background: #eee;

padding: 5px 15px 5px 15px;

margin-left: auto;

margin-right: auto;

}

a:link,a:visited{

font: normal 11px Verdana, Arial, Helvetica, sans-serif;

color: #00f;

text-decoration: none;

}

a:hover{

color: #f90;

}

</style>

</head>

<body>

<?php foreach($result->result_array() as $blog):?>

</div>

<?php endforeach;?>

<?php echo $links;?>

</body>

</html>

// definition for 'blogs_comment_view.php' file (located at /system/application/views/ folder)

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<head>

body{

margin: 0;

padding: 0;

background: #fff;

}

h1{

font: bold 16pt Arial, Helvetica, sans-serif;

color: #003399;

margin: 18px 0 18px 0;

text-align: center;

}

h2{

font: bold 12pt Arial, Helvetica, sans-serif;

color: #333;

margin: 0 0 18px 0;

}

font: normal 11px Verdana, Arial, Helvetica, sans-serif;

color: #333;

margin: 0 0 18px 0;

}

#container{

width: 500px;

background: #ccf;

padding: 15px;

margin-left: auto;

margin-right: auto;

margin-bottom: 18px;

}

a:link,a:visited{

font: normal 11px Verdana, Arial, Helvetica, sans-serif;

color: #00f;

text-decoration: none;

}

a:hover{

color: #f90;

}

textarea, input.textbox{

width: 300px;

padding: 3px;

font: normal 11px Verdana, Arial, Helvetica, sans-serif;

color: #000;

}

</style>

</head>

<body>

<?php if($result->num_rows()>0):?>

<?php foreach($result->result_array() as $comment):?>

<p><strong>Author: </strong><?php echo $comment['author'];?></p>

<p><strong>Comment:</strong></p>

</div>

<?php endforeach;?>

<?php endif;?>

<?php echo form_open('blogger/insert_comment');?>

<?php echo form_hidden('blog_id',$this->uri->segment(3));?>

<p>Author:</p>

<p>Enter your comments below:</p>

</form>

</div>

</body>

</html>

Now that you have at your disposal the complete source code of this MySQL-driven blogger, feel free to make your own changes and improvements. This will give you a more solid background in working with Code Igniter. If you’re like me, then you have a lot of fun ahead!

Final thoughts

Sad but true, we’ve come to the end of this series. Hopefully, after reading its tutorials, you’ll have a clear idea of how simple it is to build a database-driven application with Code Igniter.

Of course, a framework like this may not fit all of your needs, particularly when it comes to developing large-scale web programs. If you create small and middle-sized web sites frequently, however, Code Igniter is, in my opinion, one of the best frameworks available today.

I'll see you in the next PHP development tutorial!