In this tutorial I will show you how to make seo friendly or clean url in PHP programming language using apache .htaccess file. Semantic Url is one of the required things for Content Marketing. With the help of pretty url our website content will be Indexed on different search engine very fast. Clean Url is one part of Search Engine Optimization. SEO Friendly Url will increase our ranking on different search engine. With the help of this clean slug our presence on search engine will increase. So, How to gain this feature for our ecommerce website, these all things are learn in this video. I think you will learn this things from this video.
Table Structure
CREATE TABLE IF NOT EXISTS `tbl_post` (
`post_id` int(11) NOT NULL AUTO_INCREMENT,
`post_title` text NOT NULL,
`post_text` text NOT NULL,
`post_url` text NOT NULL,
PRIMARY KEY (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
index.php
<?php
$connect = mysqli_connect("localhost", "root", "", "test_db");
if(isset($_POST["submit_btn"]))
{
$post_title = mysqli_real_escape_string($connect, $_POST["post_title"]);
$post_text = mysqli_real_escape_string($connect, $_POST["post_text"]);
$post_title = htmlentities($post_title);
$post_text = htmlentities($post_text);
$sql = "INSERT INTO tbl_post (post_title, post_text, post_url) VALUES ('".$post_title."', '".$post_text."', '".php_slug($post_title)."')";
if(mysqli_query($connect, $sql))
{
header("location:post/".php_slug($post_title)."");
}
}
function php_slug($string)
{
$slug = preg_replace('/[^a-z0-9-]+/', '-', trim(strtolower($string)));
return $slug;
}
?>
<html>
<head>
<title>Make SEO Friendly / Clean Url in PHP using .htaccess</title>
<style>
.container
{
width:700px;
margin:0 auto;
border:1px solid #ccc;
padding:16px;
}
.form_text
{
width:100%;
padding:6px;
}
</style>
</head>
<body>
<div class="container">
<h3 align="center">Make SEO Friendly / Clean Url in PHP using .htaccess</h3>
<form name="submit_form" method="post">
<p>Post Title
<input type="text" name="post_title" class="form_text" maxlength="200" />
</p>
<p>Post Text
<textarea name="post_text" class="form_text" rows="10"></textarea>
</p>
<p><input type="submit" name="submit_btn" value="Submit" />
</form>
</div>
</body>
</html>
post.php
<?php
$connect = mysqli_connect("localhost", "root", "", "test_db");
$post_url = $_GET["post_url"];
$sql = "SELECT * FROM tbl_post WHERE post_url = '".$post_url."'";
$result = mysqli_query($connect, $sql);
?>
<html>
<head>
<title>Make SEO Friendly / Clean Url in PHP using .htaccess</title>
<style>
.container
{
width:700px;
margin:0 auto;
border:1px solid #ccc;
padding:16px;
}
.form_text
{
width:100%;
padding:6px;
}
</style>
</head>
<body>
<div class="container">
<h3 align="center">Make SEO Friendly / Clean Url in PHP using .htaccess</h3>
<?php
if(mysqli_num_rows($result) > 0)
{
while($row = mysqli_fetch_array($result))
{
echo '<h3>'.$row["post_title"].'</h3>';
echo '<p>'.$row["post_text"].'</p>';
}
}
else
{
echo '404 Page';
}
?>
</div>
</body>
</html>
.htaccess File
RewriteEngine On
RewriteRule ^post/([a-zA-Z0-9-/]+)$ post.php?post_url=$1
RewriteRule ^post/([a-zA-Z-0-9-]+)/ post.php?post_url=$1
Hello webslesson
ReplyDeleteI am try this code. data not show in my webpage.
i split this code in three step.
1. New update
2. View all post
3. show details
http://www.searchanzsco.com/news-update.php
http://www.searchanzsco.com/australia-immigration.php then click on Title
data not show on page.
how to place keyword in php
ReplyDeletelove this post thaanks
ReplyDeleteis only single url but cant work if use multi id
ReplyDeleteblog?id=1&pic?id=1
When i am using .htaccess the css file is not loading... What to do?
ReplyDeleteif two posts have same name then.....
ReplyDelete---------------------------
for example
post 1 name is: Hello-Word
post 2 name is: Hello-Word
--------------------------
Then what we do....?
Tell me plz....
plz...... reply my comment
ReplyDeleteHello friends in this post we are going to learn how to use Datatables jQuery plugin with php mysql and how can we use this plugin with Bootstrap… Read More
ReplyDeletethank u!
ReplyDeletePlease we lesson, I have really enjoyed your coding style. Pls I want you to make a tutorial on how to use mpdf to create PDF document in php. Please help us
ReplyDeleteyou guys are doing a great job but try to respond to question from your viewer in the comment section of you youtube page and here too
ReplyDeletemy question is, if i have a page with products displayed in a table with links for delete, edit, viewproduct like(example: viewproduct.php?id=$7), how will i set the url to be seo friendly.
ReplyDeletebecause i don't want people to see the server side id values on clicking the viewproduct or edit product link?.
thanks waiting for your kind reply
It's not working in case
ReplyDeleteHow to use the same thing for another url
ReplyDeletefor example: post.php and post2.php
how to define in .htaccess
Best tutorial ever for web developer
ReplyDeleteIf I try that I get an unidentified index for the post_url in the $_GET variable
ReplyDelete