|
Iv02sn
|
 |
« on: May 27, 2011, 03:55:19 PM » |
|
I'd like to establish a login page for a website I'm building, but I don't have a clue where to start. Should I use Javascript or some other technology? Should I use mySQL to house the database of users, or how else would users' login information be kept? Any guidance or links to tutorials would be greatly appreciated.
|
|
|
|
|
Logged
|
|
|
|
|
darkwolf
Guest
|
|
« Reply #1 on: May 27, 2011, 09:46:47 PM » |
|
This really depends on what exactly you want to do with your site, and if the next pages on the site need to be able to confirm that a user is logged in. There are many different ways of doing login pages, and twice as many websites online saying how to create them  I generally recommend the php/mysql database approach. You may want to review http://www.adesdesign.net/php/tutorials/dreamweaver/secure_login.php |
|
|
|
|
Logged
|
|
|
|
|
Iv02sn
|
|
« Reply #2 on: May 27, 2011, 10:10:26 PM » |
|
Thanks for the reply. Yeah, I found that exact tutorial online but hit a roadblock right away. I'm on a Mac and the tutorial suggested downloading dev5beta3.exe. I may be able to access a PC and install the reference software, but I was still confused by Step 1: "Create a table." Is that something I'd be able to do by launching phpMyAdmin? Although I'm well versed in XHTML and CSS, this is speaking Latin to me.  |
|
|
|
|
Logged
|
|
|
|
|
|
|
Iv02sn
|
|
« Reply #4 on: May 27, 2011, 10:43:58 PM » |
|
Thanks, hopefully I'll be able to install it on a PC, or at least a Mac emulating a PC.
One of the tutorials I read (on Dreamweaver and creating registration pages) needed me to specify where my database was on the server. I went through a Lunarpages tutorial on creating a database, I just don't know the path to the database I created. Can you shed any light on that?
|
|
|
|
|
Logged
|
|
|
|
|
darkwolf
Guest
|
|
« Reply #5 on: May 27, 2011, 11:02:19 PM » |
|
This can depend if you are on cpanel, plesk, or lpcp Also, the path will vary on if you are using a script on the webpage, or trying to connect to the database using remote software such as dreamweaver or other database management tool doing a "remote connection" You will need to contact support at support@lunarpages.com or via support.lunarpages.com , tell them you need the path to use in scripts, and the path for remote connections. |
|
|
|
|
Logged
|
|
|
|
|
Iv02sn
|
|
« Reply #6 on: May 27, 2011, 11:09:28 PM » |
|
Thank you for your help, Troy. Have a great holiday weekend!
|
|
|
|
|
Logged
|
|
|
|
|
Iv02sn
|
|
« Reply #7 on: June 03, 2011, 03:43:44 PM » |
|
Hey Troy, After looking into this issue, there just seems to be a large knowledge gap for me with this stuff. But before I abandon all hope... Regarding the Creating Login Page tutorial ( http://www.adesdesign.net/php/tutorials/dreamweaver/secure_login.php), I'm just plain stuck on Step 1. The rest of the tutorial seems manageable, but... Might I imposed upon you to provide a move-by-move of Step 1? I've downloaded dev5beta3.exe and run the installation. In the resulting control panel, I have a green indicator next to "mysql" so I'm hoping that's ready to go. The first instruction says to create a table, and that "phpMyAdmin is preferred." I assumed phpMyAdmin would be part of the dev5beta3.exe package, but a search of my computer doesn't find it anywhere. I do see phpdev within the dev5beta3 control panel, but not phpMyAdmin. Where would I find phpMyAdmin? If I do eventually find phpMyAdmin and fire it up, is it self-explanatory where to input the provided code? (CREATE TABLE users ( etc.)? Thanks for your time and patience. |
|
|
|
|
Logged
|
|
|
|
|
darkwolf
Guest
|
|
« Reply #8 on: June 03, 2011, 07:40:32 PM » |
|
You actually didnt need to install dev5beta3.exe , unless your attempting to setup mysql, phpmyadmin, and such on your local computer, what you needed to do was just use the directions below that.
First, you need to create a blank database on your site, database user/pass, then link the database to the db user.
You create the database username/password, a new database, and link them together via your control panel.
Exact directions depend on if you are on a cpanel, plesk, or lpcp account, which one are you using?
Also if you plan on connecting to the database from dreamweaver, you will need to setup for remote connections.
Then, you would use phpmyadmin, available in your lunarpages control panel to do step 1.
|
|
|
|
|
Logged
|
|
|
|
|
Iv02sn
|
|
« Reply #9 on: June 08, 2011, 11:14:07 AM » |
|
Wow Troy, you've managed to get me much farther than I ever thought I'd get. If I can impose upon you for a bit more help...
Using phpMyAdmin, I was able to create a new table which matched the aforementioned tutorial perfectly except for one thing--the "default" field. Can you shed some light on where to specify the default value so that it matches the tutorial's script?
Also, I noticed what looks like a warning that "No index defined!" I'm guessing that I should select something in the Index dropdowns, but Im'not sure whether it should be Primary, Unique, Index, or Fulltext. Any suggestions?
One final question... once I've created this new table, I don't see where I'd populate it with an entry. Can you shed some light on that as well? Bye the way, I'm using cPanel for all of this. Thanks for your help!
|
|
|
|
|
Logged
|
|
|
|
|
masonbarge
|
|
« Reply #10 on: August 30, 2011, 09:38:42 AM » |
|
I'd like to establish a login page for a website I'm building, but I don't have a clue where to start. Should I use Javascript or some other technology? Should I use mySQL to house the database of users, or how else would users' login information be kept? Any guidance or links to tutorials would be greatly appreciated.
I'm thinking that what you are looking for in a "login page" is a registration API, so that your page can have registered members who can login and thereby have access to increased functionality. I have done a lot of these and the only good way I know to do it is by learning and using a server-side scripting language. PHP is by far the most popular for an individual webmaster just getting started, although there are a fair number of others. You simply cannot use javascript, which is run on the user's computer rather than on the server. PHP is relatively easy to learn, has an excellent interface with databases (particularly MySQL), is installed on all Lunarpages servers, and can provide for a high degree of security. I would use MySQL, both because the PHP interface is so well-documented and because the graphic API, PHPMyAdmin, makes MySQL really simple to use. |
|
|
|
|
Logged
|
"If this is coffee, please bring me some tea. If this is tea, please bring me some coffee."
~ Abraham Lincoln
|
|
|
|
MrPhil
|
|
« Reply #11 on: August 30, 2011, 11:07:33 AM » |
|
You might start by glomming a copy of SMF, osCommerce, or some other free application that includes member registration and sign-on, as well as session handling. That would at least give you an example to work from. If you want to just take some of their code and stick it on your site, you'd have to check their license to see if you need to display their copyright or whatever. It would be, at the least, bad form to simply take the code with no acknowledgment.
|
|
|
|
|
Logged
|
-= From the ashes shall rise a sooty tern =- |
|
|
|
