PHP Parsing URL

Question

Ok, i'm trying to get data from a database to be pulled according to the url.

I have a database that is holding data for some announcements for individual customer websites. The websites are in individual directories on my website. (i.e., www.domain.com/website1/index.html, www.domain.com/website2/index.html, www.domain.com/website3/index.html, etc..) In the database i have a column that has each customers "filing name" (aka directory name - website1, website2, website3, etc..). I want to try and display only rows in the database where filingName = website1 for the domain "www.domain.com/website1/index.html". Hope this makes sense. I'm basically trying to figure out how to connect the dots between a single page and only pulling a specific customers records. Any thoughts??

Thanks!

what database? Question is tagged database

user195488
– user195488

2010-08-28 13:42:26 +00:00
Commented Aug 28, 2010 at 13:42 — user195488
– user195488, Commented Aug 28, 2010 at 13:42

Marc B · Accepted Answer · 2010-08-28 03:50:01Z

1

Depending on how big your data set is, it might be "cheaper" to preprocess the URLs and store the individual components you need to match on. e.g. create extra fields for host/dir/querystring and store those individually, instead of a monolithic absolute URL. This would be safer than trying to do substring matches, especially if the substring you're matching could be part of multiple different urls ('abc' being part of 'abc.com' and 'abctv.com').

answered Aug 28, 2010 at 3:50

Marc B

362k44 gold badges433 silver badges508 bronze badges

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

Comments

Cody Snider · Accepted Answer · 2010-08-28 03:16:17Z

0

Use a like statement in your query:

SELECT * FROM `sites` WHERE `url` LIKE "%/website1/%";

answered Aug 28, 2010 at 3:16

Cody Snider

3683 silver badges5 bronze badges

2 Comments

Cody Snider Over a year ago

Alternately, you could use REGEXP, but I believe that would be a more expensive query for something like this.

Vladislav Rastrusny Over a year ago

Such queries require full table scan almost always so... That's not for using in middle-to-large projects.

Isaac Dozier · Accepted Answer · 2015-02-25 05:36:44Z

0

Your best bet is going to be to store these identifiers on their own in the database (ex 1= website1, 2 = website 2) and name the directories accordingly. Then in your .htaccess file, manipulate the URL to look like your $_GET variable is the directory name, replace it with the matching name in your database. Do this with RewriteRule rule. This is the most absolute way to achieve this while keeping the same URL structure.

edit: whoops, didn't realize how old this thread was.

answered Feb 25, 2015 at 5:36

Isaac Dozier

861 silver badge3 bronze badges

Collectives™ on Stack Overflow

PHP Parsing URL

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related