MySql in Login Tutorial

programming
1

I have been working in flash for a while now and want something new to learn, so I am checking out all this Sql and PHP, Stuff… So, just a Quick Question… For some reason, when I get to the third step of the tutorial, The Mysql, I get lost as to what am I suppose to do with the script that is provided in the tutorial… Right now I have downloaded the files as is, and uploaded them to my server. So, I have not changed any of the script… Is there Something in the script that I need to change… If someone could help me, that would be great. thanks…

cheers

norm1252003

2

How about a link to the tutorial you are using? That would help me help you.

3

http://www.kirupa.com/developer/actionscript/authentication.htm

Here is the tutorial that I am using…

4

Step three deals with creating the table in your mySQL database where your data (in this case login and password) is stored.

There are actually several different ways to do this. You can use the script provided, or my server comes with a utility called phpMyAdmin which is graphical approach to dealing with mySQL databases, tables, and data. You might want to look around and see you have this utitlity. It is much easier to use.

5

I do not know if my server has that, so let’s assume I don’t, how and where do i make this databade that you are talking about.

6

Are you sure that your server has mySQL? I guess that is the first question.

If you do have mySQL, there should be someplace that you can change settings, add databases, add tables, ect.

7

OKay, so i look into my account and i do have a MySql Database manager… So, What do I do with this, now that i know i have it…

8

There is a place where you can enter scripts. Enter the script that the tutorial provides.

CREATE TABLE auth (
userid
int(4)
unsigned
zerofill
DEFAULT '0000’
NOT NULL
auto_increment,
username varchar(20),
userpassword varchar(20),
PRIMARY KEY (userid)
);

Change the name of the table “auth” to whatever your table is.

9

I created a table in the mysql database with the script u provided. When I use the usercheck.php.

I get an errorat the bottom:

http://www.bradparish.com/v2/login/usercheck.php

what does that mean?

10

I didn’t see an error?

11

YEAH, I FINAL GOT IT TO WORK LATE LAST NIGHT. THANKS FOR ALL YOUR HELP MAN… THIS SQL STUFF IS PRETTY COOL… MANY MORE HOURS OF FUN AHEAD…

CHEERS

NORM125

12

It is some cool stuff. Wait until you start using pulling from mySQL, and then turning it into XML with PHP. That’s when the fun begins.

13

ANY TUTORIALS TO START ME IN THAT DIRECTION?

14

Well here is a whole list of them:
http://www.kirupa.com/web/index.htm

I would start here:
http://www.kirupa.com/web/mysql_xml_php.htm