Game Maker's Garage Forum

Game Maker's Garage => Trash Talk => Topic started by: Gan on August 09, 2008, 09:04:59 PM

Title: MySql/Php
Post by: Gan on August 09, 2008, 09:04:59 PM

Instead of waiting, I think I'm going to learn php and build what I need. I've signed up for a Gmg domain, and will test all my php scripts there.

Though I don't have the slightest idea of what to do first.
So, just a few questions:

(1) What are the uses of a MySQL database?
(2) How do you use it with php to hold data?
(3) Know any good php tutorials?
(4) Is it true I can use TextEdit as a php page maker?
(5) If you had a pink pomeranian what would you name him/her?
(6) What is the approximate difficulty level of making the Lw database?
(7) Any tips you would like to share?


Thanks guys, this might just work.
-Gandolf

Title: Re: MySql/Php
Post by: GMG Tim on August 10, 2008, 03:46:28 PM

Quote

Instead of waiting, I think I'm going to learn php and build what I need. I've signed up for a Gmg domain, and will test all my php scripts there.

Though I don't have the slightest idea of what to do first.
So, just a few questions:

(1) What are the uses of a MySQL database?
(2) How do you use it with php to hold data?
(3) Know any good php tutorials?
(4) Is it true I can use TextEdit as a php page maker?
(5) If you had a pink pomeranian what would you name him/her?
(6) What is the approximate difficulty level of making the Lw database?
(7) Any tips you would like to share?


Thanks guys, this might just work.
-Gandolf

1. A MySQL database provides a fast way to access stored data. You access the data using MySQL queries in PHP, which look something like "SELECT * FROM users WHERE name='Ghost'".
2. You would execute a MySQL query in PHP that would say something like "INSERT INTO users (name,age) VALUES (Ghost,20)"
3. http://www.tizag.com/phpT/syntax.php
4. http://www.barebones.com/products/textwrangler/ is free.
5. Fluffy
6. You can set it up using PHPMyAdmin. You need to think about what kinds of fields you need. It might be helpful to read a MySQL tutorial first.

Ghost

Title: Re: MySql/Php
Post by: Gan on August 10, 2008, 03:56:05 PM

Thanks Ghost. :)
I'm going to see what I can do with all this.


-Gandolf

Title: Re: MySql/Php
Post by: Gan on August 10, 2008, 04:59:34 PM

This is really amazing. Now in the MySql page thing, is does 1 table = 1 variable or can 1 table hold many variables?


-Gandolf

Title: Re: MySql/Php
Post by: Silverwind on August 10, 2008, 05:04:55 PM

I don't know anything about PHP, but I think Mist used to say that a table held multiple values. I'm not even sure if Mist was using the same language mind you, or whether table properties vary depending on the language.

Title: Re: MySql/Php
Post by: Swamp7hing on August 10, 2008, 06:13:59 PM

Quote

This is really amazing. Now in the MySql page thing, is does 1 table = 1 variable or can 1 table hold many variables?


-Gandolf

Wow, looks like there is some progress going on! Great!

Title: Re: MySql/Php
Post by: Gan on August 10, 2008, 07:59:24 PM

I'm now creating a "LostWinds Var" table in Mysql.

So, is each little field in the table 1 variable? Because, I made 1000 fields thinking that 1 field=1 var. Just hope I didn't screw up, also I'm going to look at accessing mysql database through php scripts and changing or reading one of those fields.


-Gandolf

Title: Re: MySql/Php
Post by: Mystor on August 11, 2008, 11:59:04 AM

I use PHP

If you need any help just PM me.

Mist (Actually, Email me at support[at]redrasor[dot]com)

Title: Re: MySql/Php
Post by: Gan on August 11, 2008, 12:20:10 PM

Thanks :)


-Gandolf