What languages do I need to use in order to make this scenario a reality:
Individual clients go to www.delasoul.com, there they can type in a username and password that loads personal information. Sounds easy eh?
Easy as it sounds though? I was thinking that I could use javascript to validate the username and password, mysql to store the personal info pages and php to retrieve those pages.
Am I close? Any insights are greatly appreciated as usual.
Madcat
Search for "user authentication" at
-www.devshed.com
-www.zend.com
-www.phpbuilder.com
One (but I think all) of those have some good articles that will give you a complete step-by-step.
Also, you can download some open source packages that will have it coded in and you can see how they do it. I'm most familiar with osCommerce, but I'm sure a variety of bulletin boards and so on will have the same stuff.
Why build it when you can steal if from someone who knows a lot more than either of us?
Tom
Good article on user authentication...
[devshed.com ]
I've loaded Apache/MySQL/PHP, what interface would you suggest for MySQL?
Madcat
I recently set this up, using a cookie to store a unique id that corresponds to all of the users personal data and preferences.
It was surprisingly simple....
Nick
I've loaded Apache/MySQL/PHP, what interface would you suggest for MySQL?
That depends on what you're doing. Here's what I do:
1. Big tasks like entering a lot of data. I use a text file (perhaps generated by a script or perhaps by hand editing) and upload it to my DB using the standard client that comes with MySQL. I also use the standard client for optimizing with EXPLAIN and a few other tasks.
2. For entering piecemeal data for a web site (i.e. adding a single new item), I build a custom form. This is the only good way to make sure the data gets entered correctly.
3. Site maintenance, testing and such. On my local machine, I use Mysql-Front by Ansgar Becker. This is still free, though now he asks for a donation. I think the program is so good, I donated twice for my one copy. Saves a lot of time. Please donate if you like it.
4. Lots of people like PhpMyAdmin but I'm not one of them. If working locally, I use Mysql-Front, if working over a network for anything more than one tiny change, the standard client through SSH is so much faster than PhpMyAdmin that it isn't even funny.
Tom