So I have this template that has a login

eclecticpixie · Sep 18, 2007

and I have a pretty good idea what I want to do with it, make some stuff member viewing, etc.

Problem is, I need a login/ signup script that actually works

Does anyone know how/ have any links where I can make this possible?

I need it for this site.

lmfrench · Sep 18, 2007

Search google for it. I did a search and this is what I turned up:

http://www.google.com/search?source=ig&hl=en&q=free php login script

Another option is to turn that template into a CMS (content management system) template for Joomla and let it create a login for you.

eclecticpixie · Sep 20, 2007

lmfrench said: ↑

Search google for it. I did a search and this is what I turned up:

http://www.google.com/search?source=ig&hl=en&q=free php login script

Another option is to turn that template into a CMS (content management system) template for Joomla and let it create a login for you.

Wow, I have no idea how to do that (joomla)

XD!

and everytime I end up on a script from google, it doesnt specify WHAT I'm supposed to name the things. It's just like
"Now for the registration you just insert this code right here!"

How am I supposed to know what to call them?

lmfrench · Sep 20, 2007

I really don't know, it depends on your database. If you set up a database you would name it there, then you would know.

Anders Moen · Oct 2, 2007

Well, first it could be an idea to tell us what your fields in the different tables you have. That'd help us help you make a code

elegos · Oct 4, 2007

If you've got your own database, and you have to do it all by scratch, I'll suggest to follow this guide made by myself right now just for you
1. All the pages will be .PHP, even if they're HTML
2. Your web-hoster have to support PHP pages

3. All the pages will start with this code:
Code:
<?php
    session_start();
?>
4. Execute this SQL script into your database:
Code:
CREATE TABLE `YOUR_DB_NAME_HERE`.`users` (
    `id` INT( 4 ) NOT NULL ,
    `name` VARCHAR( 20 ) NOT NULL ,
    `password` VARCHAR( 50 ) NOT NULL ,
    `level` SMALLINT( 2 ) NOT NULL DEFAULT '0',
    PRIMARY KEY ( `id`, `name` )
) ENGINE = MYISAM
OK, your DB is ok, here is the explanation:
`id`: the unique key that represents the user in the site. There won't be two users with the same account!
`name`: the user's nick name (it is also unique)
`password`: the user's password (maybe encrypted in SHA1?)
`level`: the user's level... I thought about this: -1: banned user | 0: normal user | 1: moderator | 2: site admin

5. Now create your user, executing this other SQL script into your DB:
Code:
INSERT INTO `YOUR_DB_NAME`.`users` (`name`,`password`,`level`) VALUES ('YOUR USERNAME HERE', SHA1('YOUR PASSWORD HERE'));
You will create a unique user with an encrypted SHA1 password (this means you can't recover your password from the database, you will need to update the database with another password)

OK, now it's time to write the PHP part

6. after the session_start(); line, write this before ?>
Code:
$id = (!key_exists('id', $_SESSION)) ? null : strval($_SESSION['id']);
$user = (!key_exists('user', $_SESSION)) ? null : strval($_SESSION['user']);
$pwd = (!key_exists('pwd', $_SESSION)) ? null : strval($_SESSION['pwd']);
$level = (!key_exists('level', $_SESSION)) ? null : strval($_SESSION['level']);

$form_user = (!key_exists('user', $_POST)) ? null : strval($_POST['user']);
$form_pwd = (!key_exists('pwd', $_POST)) ? null : strval($_POST['pwd']);

if($form_user && $form_pwd)
{
    $conn = mysql_connect("YOUR_DB_SERVER","YOUR_DB_USER","YOUR_DB_PASSWORD");
    $query = "SELECT `id`, `level` FROM `YOUR_DB_NAME`.`users` WHERE `user` = '".$form_user."' AND `password` = '".sha1($form_pwd)."' LIMIT 1";
    $result = mysql_query($query);
    if(!$result)
        echo mysql_error();
    else
    {
        $row = mysql_fetch_array($result);
        $_SESSION['user'] = $form_user;
        $_SESSION['pwd'] = sha1($form_pwd);
        $_SESSION['id'] = $row['id'];
        $_SESSION['level'] = $row['level'];

        $user = $_SESSION['user'];
        $id = $_SESSION['id'];
        $pwd = $_SESSION['pwd'];
        $level = $_SESSION['level'];
    }
    mysql_close($conn);
}
This means: if there are no user, password or level informations about the logged user, they will have a null value (i.e. if !$user is true, this means that there is no $user information). If they're null, they will be filled if there is data taken by the POST method of the login form, if the password is right (if the form was filled).

7. ok, now goto your login form, and overwrite it with this code:
Code:
<?php
    if(!$user || !$pwd || !$level || !$id)
        echo "YOUR_HTML_LOGIN_FORM"; // note: quotes (") have to be ALL replaced with ' or \" (all in the same way)
    else
        echo "Welcome ".$user."!";
?>
NOTE: user field must have name='user' and password one name='pwd', and the form's action='?' and method='post'

ok, the login is made

To create a register form... well study PHP and MYSQL, I don't have all the time to explain you, but here you have all the necessary things to create one ^^
P.S.
now the code can be optimized, this is an 'on the fly' login system, but you should understand it's logic ^^

Cheers

Log in or Sign up

So I have this template that has a login

eclecticpixie New Member

lmfrench New Member

eclecticpixie New Member

lmfrench New Member

Anders Moen New Member

elegos New Member

Log in or Sign up

So I have this template that has a login

eclecticpixie New Member

lmfrench New Member

eclecticpixie New Member

lmfrench New Member

Anders Moen New Member

elegos New Member

Useful Searches