[wdvltalk] Web login system - best approach
Greetings and salutations I have a few web projects in the pipeline that will require some form of user log-in to access restricted content. I've done a few projects before that have been successful but I'm unsure if my approach is the the best way of doing things, or if I will be able to actually implement it. 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. This has worked pretty well so far but any projects using this has been deployed on a server that I have physical access to and administration control over, so it's easy for me to upload and maintain files directly through Windows Explorer. 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 Send instant messages to your online friends http://uk.messenger.yahoo.com 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: wdvltalk@lists.wdvl.com 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: archive@jab.org 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.
Re: [wdvltalk] Web login system - best approach
Try this:
http://www.freewebmasterhelp.com/tutorials/phpmysql
A quick google will rpovide literally 100's of other tutorials...
I leant from books myself, but the info is the same...
Good luck, and once you get going and have specific questions... we're
here for you...!!!
Tris...
On 06/11/06, Ross Clutterbuck [EMAIL PROTECTED] wrote:
Greetings and salutations
I have a few web projects in the pipeline that will require some form of
user log-in to access restricted content. I've done a few projects before
that have been successful but I'm unsure if my approach is the the best way
of doing things, or if I will be able to actually implement it.
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.
This has worked pretty well so far but any projects using this has been
deployed on a server that I have physical access to and administration
control over, so it's easy for me to upload and maintain files directly
through Windows Explorer.
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
Send instant messages to your online friends http://uk.messenger.yahoo.com
• 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: wdvltalk@lists.wdvl.com
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.
� 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: wdvltalk@lists.wdvl.com
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 $subst('List.Name') as:
$subst('Recip.EmailAddr')
To unsubscribe send a blank email to $subst('Email.UnSub')
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.
Re: [wdvltalk] Web login system - best approach
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: wdvltalk@lists.wdvl.com 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: archive@jab.org 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.
Re: [wdvltalk] Web login system - best approach
Thanks Drew and Tris I've googled a number of different approaches prior to posting here - given that there were so many varied approaches I thought I'd shout here too for some advice on real-world applications. I'll go read some of the better-looking Google results and get back to you! MOU Send instant messages to your online friends http://uk.messenger.yahoo.com 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: wdvltalk@lists.wdvl.com 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: archive@jab.org 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.
Re: [wdvltalk] Web login system - best approach
Where are you based..?
I've got a few books here, that I learnt from...
One in perticular is VERY basic, but it sent me on the fast track to
understanding what's what..
I'm in London and will happily sned it to you...?
On 06/11/06, Ross Clutterbuck [EMAIL PROTECTED] wrote:
Thanks Drew and Tris
I've googled a number of different approaches prior to posting here - given
that there were so many varied approaches I thought I'd shout here too for
some advice on real-world applications.
I'll go read some of the better-looking Google results and get back to you!
MOU
Send instant messages to your online friends http://uk.messenger.yahoo.com
• 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: wdvltalk@lists.wdvl.com
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.
� 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: wdvltalk@lists.wdvl.com
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 $subst('List.Name') as:
$subst('Recip.EmailAddr')
To unsubscribe send a blank email to $subst('Email.UnSub')
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.
Re: [wdvltalk] Web login system - best approach
Hi Tris I'm in Stoke-on-Trent and would be very happy to accept your gracious offer! I would say grab my details from the website but I'm in the middle of a big network upgrade so our server's offline so drop me a line offlist and I'll give the postal address. TY! MOU Send instant messages to your online friends http://uk.messenger.yahoo.com � 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: wdvltalk@lists.wdvl.com 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: archive@jab.org 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.
[wdvltalk] Microsoft Exchange DNS
Hi guys, I have a client who uses Microsoft Exchange for their company's email services. We are in the process of developing a new website for them - at the moment they do not have a website at all. My concern is that if we change the DNS settings to point their domain to a new host for their website that this will disrupt their email services. I have no idea about Exchange or how it works. They have some network guys they contract to support their systems and they advised that changing the DNS will have no affect on their internal email. Can anyone confirm that this is the case? I am just concerned that if we make such a critical change that it will indeed bring down their email systems. Does someone have some knowledge of Exchange and DNS that can advise? Thanks in advance 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: wdvltalk@lists.wdvl.com 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: archive@jab.org 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.
RE: [wdvltalk] Microsoft Exchange DNS
Well, maybe I'm missing something. If you are just changing the A record of the domain name to point to the IP of the new website - and that's it - then everything should be fine. However, if you are going to make a critical change, such as changing the name servers, then you need to make sure you are prepared. Todd -Original Message- From: wwwpages [mailto:[EMAIL PROTECTED] Sent: Monday, November 06, 2006 7:11 PM To: wdvltalk@lists.wdvl.com Subject: [wdvltalk] Microsoft Exchange DNS Hi guys, I have a client who uses Microsoft Exchange for their company's email services. We are in the process of developing a new website for them - at the moment they do not have a website at all. My concern is that if we change the DNS settings to point their domain to a new host for their website that this will disrupt their email services. I have no idea about Exchange or how it works. They have some network guys they contract to support their systems and they advised that changing the DNS will have no affect on their internal email. Can anyone confirm that this is the case? I am just concerned that if we make such a critical change that it will indeed bring down their email systems. Does someone have some knowledge of Exchange and DNS that can advise? Thanks in advance 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: wdvltalk@lists.wdvl.com 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. 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: wdvltalk@lists.wdvl.com 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: unknown lmsubst tag argument: '' 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.
