Forum Moderators: coopster

Message Too Old, No Replies

Avoiding query_strings when using DB

         

I Will Make It

4:26 pm on Mar 4, 2006 (gmt 0)

10+ Year Member



Hello, my site will consist of somewhere around 500-600 pages, with short relevant articles.
The site will be devided in three:
Main category -> Sub1 category -> Sub2 category

Layout like this:
Main category - Layout 1
Sub1 category - Layout 2
Sub2 category - Layout 3
The pages within each category will have the exact same layout.

I want to avoid using query_strings, and since my knowledge on DB's is kind of embarrassing, I've concentrated on doing the site with very little and very easy DB scripting. The result has been an "Admin-page" for each category, where I easily includes the right one of the three different templates(layouts)

So whenever I want to change something in the layout for let's say "Sub2 category" I will only have to change the Adminpage for this particular category, and all of the pages within "Sub2" will be affected.

Now, because I've done it this way, I'll be sitting with approximately 500 pages on the server. And they will be reachable from different menus, which is DB driven..

And finally, HERE's my question:
Will the site be very slow when I do it like this,
and how much better of would I be using a DB to run the whole site, where the existing .php-pages would be set to a minimum? At least less than 500 pages.php...

Oh, and also:
When using a DB to run the whole site, is there any way to avoid using query_strings in the URL?

I don't know if any of understood this one ;) I'm not sure I understood it myself, but if someone really did get what I was trying to say, I would be more than grateful for some answers.

Thanks.

omoutop

12:52 pm on Mar 7, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



[block]
And finally, HERE's my question:
Will the site be very slow when I do it like this,
and how much better of would I be using a DB to run the whole site, where the existing .php-pages would be set to a minimum? At least less than 500 pages.php...
[/block]

Well for 3 different categories you would need 3 php pages - no comparisson between those and 500

[block]
When using a DB to run the whole site, is there any way to avoid using query_strings in the URL?
[/block]
Yes there is... you may want to use htaccess (if you run the site on apache. In this way u can transofrm something like example.php?variable1=foo to something like example/foo.htm

If you dont wanna use htaccees, u may want to use cookies, sessions and even forms to avoid passing data on url