Sample Forum mySQL Database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
dug1967
Forum Newbie
Posts: 1
Joined: Thu Jul 24, 2003 10:01 pm

Sample Forum mySQL Database

Post by dug1967 »

Is there such a thing?

With all the use of php and mySQL for forums (including this one) I would think somewhere there would be download-able mySQL databases. Something you could learn from or use as a starting point for you own.

Could anybody point me to such a thing? OR would you be willing to share yours?

I admit I am new mySQL and am not having much luck deciphering it so far. I sample to look at would be most benefical.

Thanks for your time.
kettle_drum
DevNet Resident
Posts: 1150
Joined: Sun Jul 20, 2003 9:25 pm
Location: West Yorkshire, England

...

Post by kettle_drum »

Just download any open source forum that uses mySQL and then look at it.

Another good way to learn is to download phpmyadmin and just have a play about, adding new tables and rows and then reviewing the sql code that it shows you.

If you want to make your own forum and want to know what to store in the database - then just think it over. Think about what details must be stored and then spilt it up into different tables and you have your database. Like you know you will need to store the messages - so make a table called messages which include everything that a message would include (the message, title, id number, thread id, posted by, time posted, if its a sticky etc)

If youve only just started learning sql then check out the mysql manual on their site, and then search good for sql tutorials and read away.

http://www.w3schools.com has a good tutorial on sql.
pistolfire99
Forum Commoner
Posts: 58
Joined: Thu May 23, 2002 3:18 pm

Post by pistolfire99 »

dug1967:- I have created a forum from scratch of my own. Its very simple, only 6 pages *.php pages with three tables in my MySQL database. Here is the link.
http://www.i2l2.com/kpsnatest/xxxforum.php

If you want something like this then its very simple. I am planning/designing to add more features. I am creating an Online Directory Management for my community and they need a simple message board, so I am working on the same.
Let me know your thoughts about my forum and if there are any improvements that I can make thanks.
Post Reply