Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.


Welcome to AstaHost - Dear Guest , Please Register here to get Your own website. - Ask a Question / Express Opinion / Reply w/o Sign-Up!

Replying to Password protect your site!

Post Options

Enable emoticons?

Enter Your Name

Security Check *

[quote name="mastercomputers" post="3891" timestamp="1096382963"] Let's do this but using HTML, PHP and MySQL. The improvements that you could make is that you create pages to help you manage your database which means you would have a registration page, a forgotten password page and a login page and whatever else you think you would require, concept behind it is a full feature membership login procedure. But for this I will only show you the basics and may provide the complete package in the HOWTO and TUTORIAL section. So lets begin with setting up our database, hopefully you have a database already created, our one will be named [b]MyDB[/b] for this example. Next we will pass some MySQL query inside phpmyadmin to create the table and entries we require. Since it's only for a simple login, what would we require? We need the username and password. We should have some security features behind this, but for this simple login, we won't be needing that. [code=auto:0]CREATE TABLE users ( userid int(25) NOT NULL auto_increment, username varchar(30) NOT NULL default '', passwd varchar(255) NOT NULL default '', PRIMARY KEY (userid), UNIQUE KEY (username)) TYPE = MyISAM COMMENT = 'MyDB Users';[/code] That create our table we will use to store our username/password, We then create our first user, using [b]phpmyadmin[/b] once again to execute this query. [code=auto:0]INSERT INTO `users` (`userid`, `username`, `passwd`)VALUES ( '', 'myUserName', PASSWORD('myPassWord'));[/code] What this does is add a user named [b]myUserName[/b] and a password that is [b]myPassWord[/b] as well as doing the auto_increment used for userid, which should get set to 1. Next we write our connection to database file, this is the user that has permissions on the database to be able to access the required information we need, this file we will include in our login script to connect to our database and perform the required tasks. We will call this [b]dbcon.inc.php[/b] [code=auto:0]<?php$dbhost = 'localhost';$dbusername = 'MyDB_username';$dbpassword = 'MyDB_password';$database = 'MyDB';$connection = mysql_connect("$dbhost", "$dbusername", "$dbpassword") or die('Error: Connection to Server failed');$db = mysql_select_db("$database", $connection) or die('Error: Database selection failed');?>[/code] We then create our simple [b]login.html[/b] form, not set up nicely, but I'll leave that up to you. [html]<?xml version="1.0" encoding="iso-8859-1"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict //EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-NZ" lang="en-NZ"> <head> <title> Login Page </title> </head> <body> <form action="/php-bin/login.php" method="post" id="loginform"> <table summary="login information"> <tr> <td>Username</td> <td><input id="username" type="text" name="username" /></td> </tr> <tr> <td>Password</td> <td><input id="password" type="password" name="password" /></td> </tr> <tr> <td> </td> <td><input type="submit" id="submit" value="Submit" name="submit" /></td> </tr> </table> </form> </body> </html>[/html] Now all we need to do is create our [b]login.php[/b] script [code=auto:0]<?phpinclude '../includes/db.inc.php';$username = $_POST['username'];$password = $_POST['password'];if((!$username) || (!$password)) exit();$sql = mysql_query("SELECT * FROM users WHERE userid = '1' AND username = '$username' AND passwd = PASSWORD('$password')");$login_check = mysql_num_rows($sql);if($login_check > 0){ echo '<' . '?xml version=1.0" encoding="iso-8859-1"?' . '>';?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict //EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"><html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-NZ" lang="en-NZ"> <head> <title> Secret Page </title> </head> <body> <p>blah blah blah blah blah SECRET PAGE blah blah blah</p> </body></html><?php}else echo "Your login was invalid, Either username or password were incorrect<br />";?>[/code] And that's it, You just have to make sure that you have a folder called includes (new folder created) for all your included files to go and that the path is correct, that the login.php exists in your php-bin (new folder created). There have been issues with using the word password in MySQL as I believe it's a reserved word, so you might want to change from using password to passwd as I have done in MySQL. To login you would use myUserName and myPassWord. [b]This has been tested and verified that it works.[/b] Cheers, MC[/quote] [quote name="mastercomputers" post="3891" timestamp="1096382963"] Let's do this but using HTML, PHP and MySQL. The improvements that you could make is that you create pages to help you manage your database which means you would have a registration page, a forgotten password page and a login page and whatever else you think you would require, concept behind it is a full feature membership login procedure. But for this I will only show you the basics and may provide the complete package in the HOWTO and TUTORIAL section. So lets begin with setting up our database, hopefully you have a database already created, our one will be named [b]MyDB[/b] for this example. Next we will pass some MySQL query inside phpmyadmin to create the table and entries we require. Since it's only for a simple login, what would we require? We need the username and password. We should have some security features behind this, but for this simple login, we won't be needing that. [code=auto:0]CREATE TABLE users ( userid int(25) NOT NULL auto_increment, username varchar(30) NOT NULL default '', passwd varchar(255) NOT NULL default '', PRIMARY KEY (userid), UNIQUE KEY (username) ) TYPE = MyISAM COMMENT = 'MyDB Users';[/code] That create our table we will use to store our username/password, We then create our first user, using [b]phpmyadmin[/b] once again to execute this query. [code=auto:0]INSERT INTO `users` (`userid`, `username`, `passwd`) VALUES ( '', 'myUserName', PASSWORD('myPassWord') );[/code] What this does is add a user named [b]myUserName[/b] and a password that is [b]myPassWord[/b] as well as doing the auto_increment used for userid, which should get set to 1. Next we write our connection to database file, this is the user that has permissions on the database to be able to access the required information we need, this file we will include in our login script to connect to our database and perform the required tasks. We will call this [b]dbcon.inc.php[/b] [code=auto:0]<?php $dbhost = 'localhost'; $dbusername = 'MyDB_username'; $dbpassword = 'MyDB_password'; $database = 'MyDB'; $connection = mysql_connect("$dbhost", "$dbusername", "$dbpassword") or die('Error: Connection to Server failed'); $db = mysql_select_db("$database", $connection) or die('Error: Database selection failed'); ?>[/code] We then create our simple [b]login.html[/b] form, not set up nicely, but I'll leave that up to you. [html]<?xml version="1.0" encoding="iso-8859-1"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict //EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-NZ" lang="en-NZ"> <head> <title> Login Page </title> </head> <body> <form action="/php-bin/login.php" method="post" id="loginform"> <table summary="login information"> <tr> <td>Username</td> <td><input id="username" type="text" name="username" /></td> </tr> <tr> <td>Password</td> <td><input id="password" type="password" name="password" /></td> </tr> <tr> <td> </td> <td><input type="submit" id="submit" value="Submit" name="submit" /></td> </tr> </table> </form> </body> </html>[/html] Now all we need to do is create our [b]login.php[/b] script [code=auto:0]<?php include '../includes/db.inc.php'; $username = $_POST['username']; $password = $_POST['password']; if((!$username) || (!$password)) exit(); $sql = mysql_query("SELECT * FROM users WHERE userid = '1' AND username = '$username' AND passwd = PASSWORD('$password')"); $login_check = mysql_num_rows($sql); if($login_check > 0) { echo '<' . '?xml version=1.0" encoding="iso-8859-1"?' . '>'; ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict //EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-NZ" lang="en-NZ"> <head> <title> Secret Page </title> </head> <body> <p>blah blah blah blah blah SECRET PAGE blah blah blah</p> </body> </html> <?php } else echo "Your login was invalid, Either username or password were incorrect<br />"; ?>[/code] And that's it, You just have to make sure that you have a folder called includes (new folder created) for all your included files to go and that the path is correct, that the login.php exists in your php-bin (new folder created). There have been issues with using the word password in MySQL as I believe it's a reserved word, so you might want to change from using password to passwd as I have done in MySQL. To login you would use myUserName and myPassWord. [b]This has been tested and verified that it works.[/b] Cheers, MC[/quote]

or Cancel

Topic Summary

yordan

Posted 14 December 2011 - 08:52 AM

ok i meant "waiting" and let me rephrase that. " id did it! im waiting for a mod to aprove it. can you? "
still it needs to be moderated. but to show you i will reply or "quote" with it