/    Sign up×
Community /Pin to ProfileBookmark

database design…

Copy linkTweet thisAlerts:
Jan 06.2004

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.

to post a comment
PHP

5 Comments(s) ↴

Copy linkTweet thisAlerts:
@pyroJan 06.2004 — 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?
Copy linkTweet thisAlerts:
@SulauthorJan 06.2004 — 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...
Copy linkTweet thisAlerts:
@pyroJan 06.2004 — 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?
Copy linkTweet thisAlerts:
@SulauthorJan 06.2004 — 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.
Copy linkTweet thisAlerts:
@pyroJan 06.2004 — I've only used databases minimally with my sites. On my [URL=http://www.infinitypages.com/]business site[/URL], I only use one database to keep track of my sales for [URL=http://www.infinitypages.com/products/xblog.php]xBlog[/URL]. On my [URL=http://www.ryanbrill.com/]personal site[/URL], I do not use them at all, and on the [URL=http://www.webdevfaqs.com/]Web Dev FAQs[/URL] 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 [URL=http://us2.php.net/manual/en/function.include.php]includes[/URL] 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.
×

Success!

Help @Sul spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 5.27,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...