Click to See Complete Forum and Search --> : database design...
Hi
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?
I know more than the basics on database design, the title of this thread is somewhat inaccurate...I apologise.
I'm not too sure of how to start off. I'll try to figure this out myself, but feel free to help...
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?
Sorry, hmm... okay, I checked your website, and I'm assuming you used a database, tell me how you used your database with the website.
I've only used databases minimally with my sites. On my business site (http://www.infinitypages.com/), I only use one database to keep track of my sales for xBlog (http://www.infinitypages.com/products/xblog.php). On my personal site (http://www.ryanbrill.com/), I do not use them at all, and on the Web Dev FAQs (http://www.webdevfaqs.com/) site, I should have used one, but did not. :p 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 (http://us2.php.net/manual/en/function.include.php) 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.