fetching article from mysql db with slug url

Question

Im developing my own PHP Mysql site.

I used to fetch data by id like this : mysite.com/articles.php?id=12

now i want to change the url with slug:

mysite.com/articles/google-search

or

mysite.com/articles.php?article=google-search

I dont want to use id and numbers.

My table:

+----+---------------+---------+------------------------------------+
| id | title         | article |   urlslug                          |
+----+---------------+---------+------------------------------------+
| 12 | google search | xxxxxxx |   google-search                    |
| 13 | bing yahoo    | xxxxxxx |   bing-yahoo                       |
| 14 | friendly seo  | xxxxxxx |   friendly-seo                     |
+-------------------------------------------------------------------+

I used the below code to get data by id:

$id = $_GET['id'];
$id = mysqli_real_escape_string($conn,$id);
$query = "SELECT * FROM `table` WHERE `id`='" . $id . "'";
$result = mysqli_query($conn,$query);

while($row = mysqli_fetch_array($result)) {
echo ($row['title']);
echo ($row['article']);    }

I tried the above code by substituting urlslug it says Invalid ID specified. I googled and even searched in stack questions i didnt get any help. Please assist me. Thanks in advance.

can you echo echo $_GET['id'];

uno
– uno

2015-12-02 09:13:51 +00:00
Commented Dec 2, 2015 at 9:13 — uno
– uno, Commented Dec 2, 2015 at 9:13

Tintu C Raju · Accepted Answer · 2015-12-02 09:16:50Z

1

If url is like this mysite.com/articles.php?article=google-search then instead of id get the article from url and change the condition to urlslug instead of id.

$slug = $_GET['article'];
$slug = mysqli_real_escape_string($conn,$slug);
$query = "SELECT * FROM `table` WHERE `urlslug`='" . $slug. "'";
$result = mysqli_query($conn,$query);

 //Since  slug is unique you will get only 1 result so no need to loop

 $row = mysqli_fetch_array($result);
 echo $row['title'];
 echo $row['article'];

edited Dec 2, 2015 at 9:16

answered Dec 2, 2015 at 9:05

Tintu C Raju

2,7002 gold badges23 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Tintu C Raju Over a year ago

slug must be unique. so you don't need to bother about number of articles.

dan Over a year ago

bro in christ, im totally new to this. i tried in the way u suggested but it says invalid id specified

Tintu C Raju Over a year ago

@dan Which means you have check the id some where in your application. php doesn't provide such a message invalid id specified so find that in your code.. which was not mentioned in your question. I think its a very small problem.

Tintu C Raju Over a year ago

invalid id specified have you given such a message in any part of your code...??? please check.

Tintu C Raju Over a year ago

Let us continue this discussion in chat.

Amit Verma · Accepted Answer · 2015-12-02 09:38:55Z

0

You can use the following rule in Root/.htaccess

RewriteEngine On


RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^articles/([^/]+)/?$ /articles.php?id=$1 [NC,L]

This will rewrite

example.com/articles/123

to

example.com/articles.php?id=123

edited Dec 2, 2015 at 9:38

answered Dec 2, 2015 at 9:31

Amit Verma

41.3k21 gold badges97 silver badges117 bronze badges

Collectives™ on Stack Overflow

fetching article from mysql db with slug url

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related