Computer Science Canada

Setting Up A Database and Forms

Author:  Archi [ Tue Sep 09, 2003 10:16 am ]
Post subject:  Setting Up A Database and Forms

I'm using IBServer which seems to be alright...I've been able to make a few *.php files and see what they look like. THe only question I have now, is how can I set-up and store information into my database? And also at the same time make a way so people can sign up for my game?.

Also, how can I make forms where the data then is placed into the necessary spots in the database?

Author:  PaddyLong [ Tue Sep 09, 2003 11:09 am ]
Post subject: 

looking at the php manual would probably be the best place to start Rolling Eyes

it's free and available at www.php.net

Author:  octopi [ Tue Sep 09, 2003 2:10 pm ]
Post subject: 

if you don't have it already get mysql.

www.mysql.com/downloads

Author:  Amailer [ Tue Sep 09, 2003 4:00 pm ]
Post subject: 

PaddyLong wrote:
looking at the php manual would probably be the best place to start Rolling Eyes

it's free and available at www.php.net

As paddy said, php.net is da best place to get your php info -.-
And...there is also...google.com Very Happy

Author:  Archi [ Tue Sep 09, 2003 4:01 pm ]
Post subject: 

I already have mysql but now I need to figure out how to create a database. I'll attach a photo of the mysql screen..

Author:  Homer_simpson [ Tue Sep 09, 2003 4:57 pm ]
Post subject: 

the best site ever for starters!!! online video teaching Shocked
http://www.vtc.com/php.htm?ppc

Author:  PaddyLong [ Tue Sep 09, 2003 5:00 pm ]
Post subject: 

hmm, probably the easiest way to set up/manage your databases would be to get phpmyadmin ... www.phpmyadmin.net ... just unzip that into a subdir in your htdocs directory and then go to it with your browser

Author:  Amailer [ Tue Sep 09, 2003 5:05 pm ]
Post subject: 

He already got phpmyadmin -.-

Author:  Archi [ Tue Sep 09, 2003 5:06 pm ]
Post subject: 

I have myphp or w/e it is..Thats what the second image is showing u...Or thats a db i created using that i guess:S

Author:  octopi [ Tue Sep 09, 2003 8:39 pm ]
Post subject: 

You have created a database, and now you need to create a table.

Such as 'users', or whatever you want to store.

Enter the name for the table, and the number of feilds in the table.

Follow the directions on phpmyadmin, or on google

Author:  Archi [ Wed Sep 10, 2003 12:24 am ]
Post subject: 

Well what do the fields mean???

Author:  octopi [ Wed Sep 10, 2003 12:28 am ]
Post subject: 

Well.....its up to you...


If you were to make a table named users. You would need the following.

ID
Username
Password

Id I usually make INT(11), username varchar(255), password varchar(255)

Author:  Amailer [ Wed Sep 10, 2003 7:45 am ]
Post subject: 

You gatta read some stuff on MySQL and PHP before starting ;S


: