Create a Lightweight Blogging System Using PHP and MYSQL

By Sidharth Patnaik -
This post will help you to create your very own lightweight blogging system. This system is completely created by using PHP and mysql. This system consists of 4 files namely admin.php, index.php, art.php and .htaccess. We will go through each files deeply. This time on we have used automatic setup system which will automatically create database and tables. In this system we have created a database article and table article.

Lets see the screens of various pages:

The homepage of the Blogging system showing the titles of the posts.


When clicked on any post, the page of the blogging system


The admin control panel of the blogging system where the admin can add new articles
Lets go through various sections of this blogging system Lets create the index.php file 
// A function to initiate automatic setup of database and tables
function setup()
{
echo('
<p style="color: #008000; text-align: left; font-size: 15pt;"">-Automatic setup is started...</p>
');
global $host,$username,$password,$link;
//$link=mysql_connect($host, $username, $password);
$sql= 'CREATE DATABASE article';
if (!mysql_query ($sql, $link)) die('
<p style="text-align: center; font-size: 20pt;"><span style="color: #FF0000;">Failed to 
create database! </span><br><span style="font-size: 12pt;">&gt;&gt;Please check the parameters and database server&lt;&lt;</span></p>
');
$sql = "CREATE TABLE `article`.`article` (
`ID` INT NOT NULL ,
`title` TEXT NOT NULL,
`body` TEXT NOT NULL,
`time` TEXT NOT NULL
) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;";

mysql_query($sql) or die('Setup Failed');
echo('
<p style="color: #008000; text-align: left; font-size: 15pt;"">-Automatic setup completed successfully. Your Database is ready!</p>
');
}

// Setting up your blog title
echo "<div class='header'>Your Blog Title Here</div><br/><div class='container'>";

//Displaying the post title in the index page
while(@$rows=mysql_fetch_array($result)){
 $title=$rows['title'];
 $time=$rows['time'];
 $link=$_SERVER['PHP_SELF'];
 $l=strrpos($link,'/');
 $link=substr($link,1,$l-1);
 $link=$_SERVER['HTTP_HOST'].'/'.$link.'/'.str_replace(' ','_',$title);
 echo"<div class='time'>$time</div><a style='text-decoration:none;' href='http://$link'><span style='font-size: 14pt;'>$title</span></a><br/>";
}

Lets create the admin.php file 
// Inserting data into the article table when post is clicked !

if (isset($_POST['add'])){
 $id=$cn;
 $title=$_POST['title'];
 $body=$_POST['body'];
 $time=date('H:i', time());
 $body=str_replace("\n",'<br>',$body);
 //var_dump( $body); 
 $body=str_replace("<",'\r\n<',$body);
 $sql="INSERT INTO article(ID,title,body,time)VALUES('$id', '$title', '$body', '$time')";
 $result=mysql_query($sql);
 if (!$result) die (mysql_error());
}

// Changing the title of the Blog

echo "<div class='header' align='center'>Your Blog Title Here</div>";

// Displaying the List of articles published 

$sql="SELECT * FROM article";
$result=mysql_query($sql);
while(@$rows=mysql_fetch_array($result)){
 $title=$rows['title'];
 $link=$_SERVER['PHP_SELF'];
 $l=strrpos($link,'/');
 $link=substr($link,1,$l-1);
 $link=$_SERVER['HTTP_HOST'].'/'.$link.'/'.str_replace(' ','_',$title);
 echo"<br><a style='text-decoration: none;color: white;font-size: 10pt;' href='http://$link'><span>>$title</span></a>
 ";
}

Lets create the art.php file 
// Selecting the clicked post from the index page and displaying it here

$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$link=mysql_connect($host, $username, $password);
$sql="SELECT * FROM article";
$db_name="article"; 
$result=mysql_select_db($db_name);
$result=mysql_query($sql);
@$cn=mysql_num_rows($result);
$cn++; 
if (isset($_GET['title']))
{
 $title=str_replace('_',' ',$_GET['title']);
 $sql="SELECT * FROM article WHERE title='$title'";
 $result=mysql_query($sql);
 $rows=mysql_fetch_array($result);
 echo "<div class='header'>Your Blog Title Here</div><br/>";
 echo '<div class="link"><a href="index.php" >Back</a></div><div class="tm">'.$rows['time'].'<br/><center><span>Time</span></center></div><div class="post"><p align="center" style="font-size: 20pt;"><b>'.$rows['title'].'</b></p><p align="left">'.$rows['body'].'</p></div><div class="footer">CMS Designed By dProBuk. <a href="admin.php">Admin Panel</a></div>'; 
}

Lets create the .htaccess file 
RewriteEngine on
RewriteRule ^([A-Za-z0-9\_]+)$ art.php?title=$1

Alternatively you can download the whole system here.
Found bugs, feel free to report them. We'll be glad to fix them ! :D

Comments

Post a Comment

Popular posts from this blog

Non Restoring Division Algorithm Implementation in C

By Sidharth Patnaik -
Image
This  is a Dynamic program for the implementation of the NON RESTORING Division Algorithm in C Language. Non Restoring Division uses Left Shift Operations, Twos' Compliment and Binary Addition. Screenshots[Demo] The Code #include<stdio.h> #include<malloc.h> int *a,*q,*m,*mc,*c,n,d; int powr(int x,int y) { int s=1,i; for(i=0;i<y;i++) s=s*x; return s; } void print(int arr[],int n) { int i; for(i=0;i<n;i++) printf("%d ",arr[i]); } void bin(int n, int arr[]){ int r, i = 0; do{ r = n % 2; n /= 2; arr[i] = r; i++; }while(n > 0); } void set(int array[], int x){ int i,tmp[20]={0}; for(i = x -1; i >=0; i--) tmp[x-1-i]=array[i]; for(i=0;i<x;i++) array[i]=tmp[i]; } int len(int x) { int i=0; while(powr(2,i)<=x) i++; return ++i; } void addBinary(int a1[], int a2[]) { int bi[2]={0},ca[20]={0}; int t=len(n),tmp=0; int *su=(int*)malloc(sizeof(int)*len(n)); while(t...
Read more

Hackerrank Modified Kaprekar Numbers Solution

By Sidharth Patnaik -
Image
This is the solution to the Modified Kaprekar Numbers found in the implementation section of the algorithm domain in Hackerrank. A modified Kaprekar number is a positive whole number n with d digits, such that when we split its square into two pieces - a right hand piece r with d digits and a left hand piece l that contains the remaining d or d−1 digits, the sum of the pieces is equal to the original number (i.e. l + r = n) . Screenshot The Code def sendKap(x,s): y=x*x y=str(y) s1=y[:len(y)/2:] s2=y[len(y)/2::] s3=int(s1)+int(s2) if(s3==x): s.append(str(x)) st=input() en=input() s=[] for i in range(st,en+1): if(i>9): sendKap(i,s) elif(i==1): s.append(str(i)) elif(i==9): s.append(str(i)) if(len(s)==0): print 'INVALID RANGE' else: print ' '.join(s) Got any problems feel free to comment them here !
Read more

Bit Stuffing Code Implementation in Java

By -
Image
This is an implementation of the Bit Stuffing popularly used in data communication, also known as one of the concepts of Framing data bits. To know more please  click here. Sample Output: This is a sample output with data binary data entered as 11001111110. Program Code: import java.util.*; public class BitStuffing { public static void main(String[] args) { System.out.print("Enter the Binary message: "); Scanner sn=new Scanner(System.in); String data = sn.nextLine(); String res = new String(); String out=new String(); int counter = 0; for(int i=0;i<data.length();i++) { if (data.charAt(i)!='1' && data.charAt(i)!='0') { System.out.println("Enter only Binary values!!!"); return; } ...
Read more