![SEO Friendly URLs with PHP](https://lh4.googleusercontent.com/_N9kpbq3FL74/TZs5oR0zwpI/AAAAAAAAEgs/T7Rp8Y3zqR4/seo.png)
Database
Sample database blog table columns id, title, body and url.
(
id INT PRIMARY KEY AUTO_INCREMENT,
title TEXT UNIQUE,
body TEXT,
url TEXT UNIQUE,
);
Publish.php
Contains PHP code. Converting title text to friendly url formate and storing into blogtable.
include(‘db.php’);
function string_limit_words($string, $word_limit)
{
$words = explode(‘ ‘, $string);
return implode(‘ ‘, array_slice($words, 0, $word_limit));
}
if($_SERVER["REQUEST_METHOD"] == “POST“)
{
$title=mysql_real_escape_string($_POST['title']);
$body=mysql_real_escape_string($_POST['body']);
$title=htmlentities($title);
$body=htmlentities($body);
$date=date(“Y/m/d”);
//Title to friendly URL conversion
$newtitle=string_limit_words($title, 6); // First 6 words
$urltitle=preg_replace(‘/[^a-z0-9]/i’,‘ ‘, $newtitle);
$newurltitle=str_replace(” “,“-”,$newtitle);
$url=$date.’/’.$newurltitle.’.html’; // Final URL
//Inserting values into my_blog table
mysql_query(“insert into blog(title,body,url) values(‘$title’,'$body’,'$url’)”);
}
?>
//HTML Part
<form method=”post” action=”">
Title:
<input type=”text” name=”title”/>
Body:
<textarea name=”body”></textarea>
<input type=”submit” value=” Publish ”/>
</form>
Article.php
Contains HTML and PHP code. Displaying content from blog table.
include(‘db.php’);
if($_GET['url'])
{
$url=mysql_real_escape_string($_GET['url']);
$url=$url.’.html’; //Friendly URL
$sql=mysql_query(“select title,body from blog where url=’$url’”);
$count=mysql_num_rows($sql);
$row=mysql_fetch_array($sql);
$title=$row['title'];
$body=$row['body'];
}
else
{
echo ’404 Page.’;
}
?>
//HTML Part
<body>
<?php
if($count)
{
echo ”<h1>$title</h1><div class=’body’>$body</div>”;
}
else
{
echo ”<h1>404 Page.</h1>”;
}
?>
</body>
.htaccess
URL rewriting file. Redirecting original URL 9lessons.info/article.php?url=test.htmlto 9lessons.info/test.html
RewriteRule ^([a-zA-Z0-9-/]+).html$ article.php?url=$1
RewriteRule ^([a-zA-Z0-9-/]+).html/$ article.php?url=$1
![Print Print](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/printfriendly.png)
![Digg Digg](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/digg.png)
![Sphinn Sphinn](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/sphinn.png)
![del.icio.us del.icio.us](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/delicious.png)
![Facebook Facebook](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/facebook.png)
![Mixx Mixx](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/mixx.png)
![Google Bookmarks Google Bookmarks](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/googlebookmark.png)
![Blogplay Blogplay](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/blogplay.png)
![Add to favorites Add to favorites](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/addtofavorites.png)
![BarraPunto BarraPunto](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/barrapunto.png)
![Bitacoras.com Bitacoras.com](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/bitacoras.png)
![BlinkList BlinkList](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/blinklist.png)
![blogmarks blogmarks](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/blogmarks.png)
![Blogosphere News Blogosphere News](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/blogospherenews.png)
![blogtercimlap blogtercimlap](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/blogter.png)
![connotea connotea](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/connotea.png)
![Current Current](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/current.png)
![Design Float Design Float](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/designfloat.png)
![Diggita Diggita](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/diggita.png)
![Diigo Diigo](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/diigo.png)
![DotNetKicks DotNetKicks](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/dotnetkicks.png)
![DZone DZone](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/dzone.png)
![eKudos eKudos](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/ekudos.png)
![email email](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/email_link.png)
![Fark Fark](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/fark.png)
![Faves Faves](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/bluedot.png)
![Fleck Fleck](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/fleck.png)
![FriendFeed FriendFeed](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/friendfeed.png)
![FSDaily FSDaily](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/fsdaily.png)
![Global Grind Global Grind](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/globalgrind.png)
![Gwar Gwar](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/gwar.png)
![HackerNews HackerNews](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/hackernews.png)
![Haohao Haohao](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/haohao.png)
![HealthRanker HealthRanker](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/healthranker.png)
![HelloTxt HelloTxt](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/hellotxt.png)
![Hemidemi Hemidemi](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/hemidemi.png)
![Hyves Hyves](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/hyves.png)
![Identi.ca Identi.ca](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/identica.png)
![IndianPad IndianPad](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/indianpad.png)
![Internetmedia Internetmedia](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/im.png)
![Kirtsy Kirtsy](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/kirtsy.png)
![laaik.it laaik.it](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/laaikit.png)
![LaTafanera LaTafanera](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/latafanera.png)
![LinkaGoGo LinkaGoGo](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/linkagogo.png)
![LinkArena LinkArena](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/linkarena.png)
![LinkedIn LinkedIn](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/linkedin.png)
![Linkter Linkter](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/linkter.png)
![Live Live](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/live.png)
![Meneame Meneame](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/meneame.png)
![MisterWong MisterWong](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/misterwong.png)
![MisterWong.DE MisterWong.DE](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/misterwong.png)
![MOB MOB](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/mob.png)
![MSN Reporter MSN Reporter](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/msnreporter.png)
![muti muti](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/muti.png)
![MyShare MyShare](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/myshare.png)
![MySpace MySpace](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/myspace.png)
![N4G N4G](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/n4g.png)
![Netvibes Netvibes](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/netvibes.png)
![Netvouz Netvouz](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/netvouz.png)
![NewsVine NewsVine](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/newsvine.png)
![NuJIJ NuJIJ](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/nujij.png)
![PDF PDF](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/pdf.png)
![Ping.fm Ping.fm](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/ping.png)
![Posterous Posterous](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/posterous.png)
![Propeller Propeller](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/propeller.png)
![QQ书签 QQ书签](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/qq.png)
![Ratimarks Ratimarks](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/ratimarks.png)
![Rec6 Rec6](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/rec6.png)
![Reddit Reddit](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/reddit.png)
![RSS RSS](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/rss.png)
![Scoopeo Scoopeo](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/scoopeo.png)
![Segnalo Segnalo](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/segnalo.png)
![SheToldMe SheToldMe](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/shetoldme.png)
![Simpy Simpy](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/simpy.png)
![Slashdot Slashdot](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/slashdot.png)
![Socialogs Socialogs](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/socialogs.png)
![SphereIt SphereIt](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/sphere.png)
![StumbleUpon StumbleUpon](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/stumbleupon.png)
![Suggest to Techmeme via Twitter Suggest to Techmeme via Twitter](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/techmeme.png)
![Technorati Technorati](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/technorati.png)
![ThisNext ThisNext](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/thisnext.png)
![Tipd Tipd](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/tipd.png)
![Tumblr Tumblr](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/tumblr.png)
![Twitter Twitter](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/twitter.png)
![Upnews Upnews](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/upnews.png)
![viadeo FR viadeo FR](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/viadeo.png)
![Webnews.de Webnews.de](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/webnews.png)
![Webride Webride](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/webride.png)
![Wikio Wikio](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/wikio.png)
![Wikio FR Wikio FR](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/wikio.png)
![Wikio IT Wikio IT](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/wikio.png)
![Wists Wists](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/wists.png)
![Wykop Wykop](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/wykop.png)
![Xerpi Xerpi](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/xerpi.png)
![Yahoo! Bookmarks Yahoo! Bookmarks](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/yahoomyweb.png)
![Yahoo! Buzz Yahoo! Buzz](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/yahoobuzz.png)
![Yigg Yigg](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/yiggit.png)
![豆瓣 豆瓣](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/douban.png)
![豆瓣九点 豆瓣九点](http://www.mfarhanonline.com/wp-content/plugins/sociable/images/douban9.png)
0 comments :
Post a Comment