Topic:   MySql/Php   (Read 4798 times)


0 Members and 1 Guest are viewing this topic.

Gan


  • Administrator

  • ^ This guy is amazing.

  • *****


  • Posts: 4411
MySql/Php
« 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

GMG Tim


  • Administrator

  • GMG-er

  • *****


  • Posts: 465
Re: MySql/Php
« Reply #1 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

Gan


  • Administrator

  • ^ This guy is amazing.

  • *****


  • Posts: 4411
Re: MySql/Php
« Reply #2 on: August 10, 2008, 03:56:05 PM »
Thanks Ghost. :)
I'm going to see what I can do with all this.


-Gandolf

Gan


  • Administrator

  • ^ This guy is amazing.

  • *****


  • Posts: 4411
Re: MySql/Php
« Reply #3 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

Silverwind


  • ^ This guy is amazing.

  • ****


  • Posts: 2805

  • For the glory of my maker
Re: MySql/Php
« Reply #4 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.
I survived the spammage of 2007

Swamp7hing


  • GMG-er

  • **


  • Posts: 751

  • I come from the swamps.
Re: MySql/Php
« Reply #5 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!

Gan


  • Administrator

  • ^ This guy is amazing.

  • *****


  • Posts: 4411
Re: MySql/Php
« Reply #6 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

Mystor


  • GMG-er

  • **


  • Posts: 696

  • I am the myst that consumes us all.
Re: MySql/Php
« Reply #7 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)
"I'll lie to him."
"And if that doesn't work?"
"Then I'll tell the truth. We're allowed to do that, in emergencies. We can't plan for everything, you know."
   -Colonel Graff, Ender&

Gan


  • Administrator

  • ^ This guy is amazing.

  • *****


  • Posts: 4411
Re: MySql/Php
« Reply #8 on: August 11, 2008, 12:20:10 PM »
Thanks :)


-Gandolf