I'm creating a new website, and I'm using PHP & mySQL for the first time to create a database website. I'm not too sure of how to start off. I've read a PHP - MySQL book, so I'm familiar with PHP and mysql syntax, etc. But the problem is that I'm not sure of what a typical database for a website looks like. If someone can give me an example to start from or point me to one. Thanks.
It depends entirely on what kind of information will be stored in that database. Since you've read a book on PHP & MySQL, I assume you know the basics of database design?
Erm... what specifically do you need help with? As stated above, how you design the database depends on what information it will contain. Also, what aspect of it are you looking for help with?
I've only used databases minimally with my sites. On my business site, I only use one database to keep track of my sales for xBlog. On my personal site, I do not use them at all, and on the Web Dev FAQs site, I should have used one, but did not. One of these days I'll have to go back and make a CMS for it. I have, however, used databases extensively on some of my clients sites, and for xBlogPro, which is coming soon.
However, I do use PHP includes on nearly every site that I make (all three listed above) as it makes it incredibly easy to keep navigation current across the entire site.
Reply With Quote
One of these days I'll have to go back and make a CMS for it. I have, however, used databases extensively on some of my clients sites, and for xBlogPro, which is coming soon. 
Bookmarks