Get data from mysql db by slug url not id

Question

Im facing problem in getting data from mysql db by slug url. When i get data from id it works fine. I substituted urlslug also but no use.

Im trying to change my site article url(s)

mysite.com/public.php?id=12    to    mysite.com/public/google-search

My table:

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

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']);    }

Please help. Thanks.

You are going to need to parse the url to get 'google-search' and set that in the variable for your db call. Php has a bunch of built in functions to handle that. — VIDesignz
– VIDesignz, Commented Nov 26, 2015 at 19:44
I want to remove .php?id= and want to change to this mysite.com/public/google-search I dont know a possible way to get this. Im new to this. — dan
– dan, Commented Nov 26, 2015 at 19:52
if your server is Apache, then google for .htaccess files and URL Rewriting — EhsanT
– EhsanT, Commented Nov 26, 2015 at 22:37

VIDesignz · Accepted Answer · 2015-11-26 20:18:32Z

0

Alright, Here you go

When a user goes here....

mysite.com/public/google-search

This rewrite code will change the server side to this

mysite.com/public.php?id=12

By adding this to your .htaccess file

RewriteRule ^public/google-search mysite.com/public.php?id=12 [NC]

You would need to do this for all files that you want to mask.

edited Nov 26, 2015 at 20:18

answered Nov 26, 2015 at 19:48

VIDesignz

4,8133 gold badges30 silver badges38 bronze badges

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

1 Comment

dan Over a year ago

I want to remove .php?id= and want to change to this mysite.com/public/google-search

Community · Accepted Answer · 2017-05-23 12:23:37Z

0

You should make your route function, this links may help you: http://blogs.shephertz.com/2014/05/21/how-to-implement-url-routing-in-php/

PHP Application URL Routing

edited May 23, 2017 at 12:23

CommunityBot

11 silver badge

answered Nov 26, 2015 at 20:33

Gouda Elalfy

7,0833 gold badges28 silver badges38 bronze badges

1 Comment

mickmackusa Over a year ago

This smells a lot like a "link-only answer" and risks being removed (or converted to a comment).

Collectives™ on Stack Overflow

Get data from mysql db by slug url not id

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related