On 11/6/06, Ross Clutterbuck <[EMAIL PROTECTED]> wrote:
Previously, I have an Access database storing the login information which is accessed through ASP. This database is stored in a folder outside of the domain hosting area so you can't physically access it through the website's URL. The ASP script accesses the file through the server's file system using Server.MapPath. My problem now is twofold: firstly, I don't have this sort of access to the server and second it's likely that I have to use PHP and MySQL. I've started playing with MySQL recently for a Flash-fronted CMS project and I'm fairly comfortable with it for the basic uses I have in mind, but I have difficulty getting my head around creating a database - it's a bit odd not having a tangible, MDB-esque file I can just drop into a directory. So in a nutshell, what's the best way of doing a user/password login using PHP/MySQL? TIA MOU
The ISP should provide some form of mysql admin tool (myphpadmin is a popular one) which you can use to manage the db. Building the db using myphpadmin is easy. You can look at the entire db as well, just like you did for access. Easy to do and manage with a good tool. Learn the syntax, or borrow heavily from good examples. If you use asp a lot you'll find the syntax of php as annoying at times as php users find asp. But it will be managabke. Start with a good example, as Tris suggested, and just be sure to practice reasonable security: use post, check user input, use secure connection. You know the drill. There are or were some very good php and sql people here who can keep you from sweating over the details. It'll be a lot less of a trial than you fear. drew ____ The WDVL Discussion List from WDVL.COM ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: [email protected] To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
