We hope you enjoy your visit.

You're currently viewing our forum as a guest. This means you are limited to certain areas of the board and there are some features you can't use. If you join our community, you'll be able to access member-only sections, and use many member-only features such as customizing your profile, sending personal messages, and voting in polls. Registration is simple, fast, and completely free.


Join our community!


If you're already a member please log in to your account to access all of our features:

Username:   Password:
Add Reply
  • Pages:
  • 1
  • 2
Modding PHP Files
Topic Started: May 2 2005, 01:28 AM (632 Views)
Das
Member Avatar
Smells of rich mahogany
[ *  *  *  *  *  *  * ]
The Balrog
May 2, 2005 04:36 PM
SQL is a database, not a language. So no, it cannot.

You can, however, pull a row out of the database, and assign it to a PHP variable, if that's what you mean.

:blink: :unsure: :blink:
Um... lets put this in a short buleted list
-I need a login script
-I want to do it myself
-I am not too arogant to ask for help
-I have a good $40.49 SQL book the size of a @#$%ing dictionary
-I want to get this project done relitivly fast
-I want to know if it would be easier/could be done with Sql
Offline Profile Quote Post Goto Top
 
Dennis
Member Avatar
Member
[ *  *  *  *  *  *  * ]
MySQL is a storage system, not a language. It has certain syntax for querying it, like the SELECT, UPDATE, INSERT, commands.

You should use MySQL to store the user information, such as Passwords, names, IPs, etc. It will be much faster if you find yourself with a lot of members.

While you can use MySQL to store the information, you need to use PHP to access and make use of it.

Unfortunately, I still haven't been able to write a functional login script. >_<, but Zend has a good tutorial. You can see it here. It's pretty long, but it's helpful as it descibes several, different methods.
Offline Profile Quote Post Goto Top
 
Seth
Member Avatar
I has a pony
[ *  *  *  *  *  *  *  *  * ]
Peek at IdioQuote for a login example? :unsure:
Offline Profile Quote Post Goto Top
 
Dennis
Member Avatar
Member
[ *  *  *  *  *  *  * ]
But that doesn't use cookies or sessions, does it?

The login itself works, but when I try setting a cookie then accessing it, it gets messed up.
Offline Profile Quote Post Goto Top
 
Seth
Member Avatar
I has a pony
[ *  *  *  *  *  *  *  *  * ]
Zend's tut doesn't use cookies or sessions. Mine uses sessions.
Offline Profile Quote Post Goto Top
 
1 user reading this topic (1 Guest and 0 Anonymous)
« Previous Topic · Technology Chat · Next Topic »
Add Reply
  • Pages:
  • 1
  • 2