hard code content or fetch from database for a lot of restaurants !!!!

[sherynust]

I am going to build a website which is about to have a lot of restaurant, say 200 restaurants. i am going show the menu for every restaurant. and further items in menu.

1st Question: Should I hard code the menus and item details or should i use the database??

2nd Question: I want my website pattern something like that, if i click on restaurant "Pisa Pizza"
my URL should be like this www.myrestaurant.com/pisa_pizza/
and content of page will be all the details of "Pisa Pizza".
Further if i click on the menu button
my URL should be like this www.myrestaurant.com/pisa_pizza/menu
and content of page will be all the details of "Menu".

I am just confused, this way i may have to make a lot of sub directories, what should i do here. Because there are too much restaurants i can't make a separate for all of them.

And i am building my website in CODE CHARGE using PHP.

I will be thankful if any one give me idea and right direction .

Thanx

[NogDog]

If you set things up right, you can make use of URL re-writing in the web server to keep your "friendly" URLs while storing all the user data in the DB. Pretty much any PHP framework you might use would have this ability "out of the box". Then you don't actually have separate directories and files for each restaurant, but one single entry point that receives the URI parts as get/post variables*, which you then use to select the desired info from the DB and output via the applicable template (view).
____________
* or as arguments to controller methods