PHP mySQL Htaccess pretty links

Question

There is a rewrite rule ensuring that all URL's head to index.php and maintain a 'pretty format'.

I still need to get information from them to work out what page to send the user.

Say there is a Url

http://localhost/telephones/nokia

I need to find out the SQL table ('telephone') and the make ('nokia')

How do I do that.

UPDATE

RewriteEngine on
RewriteRule ^/([^/]+)/([^/]+) /index.php?table=$1&make=$2 [NC]

(in .htaccess)

$table = $_GET['table']; $make = $_GET['make'];
$CONsiteurl = mysql_query("SELECT * FROM $table WHERE name = $make");

So we can bring up the page now by typing in http://localhost/?make=nokia&table=telephones but cannot get to it by typing in http://localhost/telephones/nokia

Why

The rewrite rule sends everything to index.php from which I've tried an explode on the slashes and foreach on the results. Not very good or flexible. — Walrus
– Walrus, Commented Jun 15, 2012 at 22:58
Are you sure your .htaccess file is actually being used? To make sure, just add a Deny from all clause to it and see if you get a 403. — RandomSeed
– RandomSeed, Commented Jun 16, 2012 at 1:27

barsju · Accepted Answer · 2012-06-15 22:58:08Z

1

Assuming you have mod_rewrite setup you can put something like this in you .htaccess:

RewriteEngine on
RewriteRule ^/([^/]+)/([^/]+) /index.php?table=$1&make=$2 [NC]

Then you can access the values from php using $_GET('table') etc.

answered Jun 15, 2012 at 22:58

barsju

4,4561 gold badge23 silver badges24 bronze badges

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

3 Comments

Walrus Over a year ago

This just says page not found. I have tried it but I do not understand how it is supposed to work. I have made a page called localhost/pages/sample-page. I can get to it by typing in localhost?table=pages&make=sample-page but not by typing in the 'pretty url'

barsju Over a year ago

corz.org/serv/tricks/htaccess2.php or some other tutorial you can find at at a search engine near you.

Walrus Over a year ago

Shown you my entire process in question. Exactly as in documentation but not working. Please help

Collectives™ on Stack Overflow

PHP mySQL Htaccess pretty links

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related