
-----------------------------------
Archi
Tue Sep 09, 2003 10:16 am

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?

-----------------------------------
PaddyLong
Tue Sep 09, 2003 11:09 am


-----------------------------------
looking at the php manual would probably be the best place to start  :roll: 

it's free and available at www.php.net

-----------------------------------
octopi
Tue Sep 09, 2003 2:10 pm


-----------------------------------
if you don't have it already get mysql.

www.mysql.com/downloads

-----------------------------------
Amailer
Tue Sep 09, 2003 4:00 pm


-----------------------------------
looking at the php manual would probably be the best place to start  :roll: 

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 :D

-----------------------------------
Archi
Tue Sep 09, 2003 4:01 pm


-----------------------------------
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..

-----------------------------------
Homer_simpson
Tue Sep 09, 2003 4:57 pm


-----------------------------------
the best site ever for starters!!! online video teaching  :shock: 
http://www.vtc.com/php.htm?ppc

-----------------------------------
PaddyLong
Tue Sep 09, 2003 5:00 pm


-----------------------------------
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

-----------------------------------
Amailer
Tue Sep 09, 2003 5:05 pm


-----------------------------------
He already got phpmyadmin -.-

-----------------------------------
Archi
Tue Sep 09, 2003 5:06 pm


-----------------------------------
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

-----------------------------------
octopi
Tue Sep 09, 2003 8:39 pm


-----------------------------------
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

-----------------------------------
Archi
Wed Sep 10, 2003 12:24 am


-----------------------------------
Well what do the fields mean???

-----------------------------------
octopi
Wed Sep 10, 2003 12:28 am


-----------------------------------
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)

-----------------------------------
Amailer
Wed Sep 10, 2003 7:45 am


-----------------------------------
You gatta read some stuff on MySQL and PHP before starting ;S
