-
It really would be worth buying a book as Marv suggested or reading up on MySQL using google. You're not likely to learn too much about MySQL if you post every question here. As you're new to it all at the moment you don't know where to start. While we can tell you step by step what you need to do, it isn't the best way to learn.
Anyway, think of tables like spread sheets (this is a very basic way to describe them). They contain the data you'll want to retrieve.
Once you've installed MySQL you'll want to create a database first and then tables within the database. for example if you were making a online game you may want to have a table for account data; usernames, passwords (encrypted), email address, account number. Then a table for character data that links to the account number.
You'll need to work out how you want to store your data in the database.
-
Dan is exactly right. Think of it as a data TABLE, like you may have done in a science class. A table is a set of information stored on two axes. The X is groups (account name, password, email, phone number, etc). The Y is the number of the data set (1,2,4,20,etc). In reality it's not really a XY plane but it's a simple way of thinking of it ;)
You can enter information manually or by PHP. Manually is easy, you just click on the space to edit a value. But automatically by PHP is very confusing for beginners. You have to connect first and then submit data. It's hard to explain.
-
I did already have the book, but it made things more confusing...
Also, the PHPs do everything, they're the pages, the login, everything!
I just need a way to host them. I found a great site http://zymic.com/free-web-hosting/, I'm going to use it to host my PHPs as soon as I figure out how... It has those tables, so I presume that those are used in some communication with the PHPs?
-
Yes, well SQL wont be communicating with PHP. It'll be PHP communicating with SQL. Your php pages will pass the queries to the sql db to check authentication.
check php.net for the mysql commands. You'll need to have a basic understanding on how to select data from a table in mysql also. Or take a look at the tutorial links Hydra provided.
You should also consider password encryption. No passwords should ever be stored in plain text and not even YOU should be able to reverse the encryption. The easiest way would be to store the password as a md5 hash salted with a unique number/string.
-
OK, I figured out a way around having to use PHP and MySQL, and such!
But there's a problem:
I put in some HTML code to display an image, like a logo, instead of plain text, but the server application displays it as normal text anyway.
Please help!
-
Good job! Are there tags around your code? I'm not familiar with the WEB server of lacewing. Would you be able to delete the quick hash object so I can take a look? I don't have developer so I cannot view the file :(
-
Sure, I'll get to it after school this afternoon!
-
Thanks! I hope it doesn't disable me from helping you!
-
1 Attachment(s)
For the example, I put in a template page, that should work the same way as the actual one.
Also, quickhash has been removed.
Take a look!
-
How do I run this? Sorry LOL. Part of this is me learning too! Is that one file all I need to test it? How do I access it on my browser? Thanks!