AD MANAGEMENT

Collapse

BEHOSTED

Collapse

GOOGLE

Collapse

[PHP] MySQL Login System

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [PHP] MySQL Login System

    In this tutorial, I will teach you how to create a login system that takes the username and password from a database. Here is the code, I will break it down at the end.
    First, we will begin by making our table and fields, and insert data into them. Execute this SQL command in a interface such as phpMyAdmin:

    CREATE TABLE `users` (
    `username` VARCHAR(255) NOT NULL,
    `password` VARCHAR(255) NOT NULL
    );

    INSERT INTO `users` ( `username` , `password` )
    VALUES (
    'USERNAME', 'PASSWORD'
    );

    Login.php:


    HTML Code:
    <html>
    <head>
    </head>
    <body>
    <form action="./login.php" method="POST">
    <input type="text" name="username"><br>
    <input type="password" name="password"><br>
    <input type="submit" value="Login!">
    </form>
    
    <?
    
    $connection = @mysql_connect("localhost", "username", "password")
    or die(mysql_error());
    $dbs = @mysql_select_db(database, $connection) or
    die(mysql_error());
    
    
    
    $sql = "SELECT * FROM `users` WHERE username = '$_POST[username]' AND password = '$_POST[password]'";
    $result = @mysql_query($sql,$connection) or die(mysql_error());
    
    
    
    $num = @mysql_num_rows($result);
    
    if ($num != 0) {
    $cookie_name = "auth";
    $cookie_value = "ok";
    $cookie_expire = "0";
    $cookie_domain = "yoursite.com";
    
    
    setcookie($cookie_name, $cookie_value, $cookie_expire, "/" , $cookie_domain, 0);
    
    header("Location: http://YourSite.com/secretpage.php");
    exit;
    }
    
    ?>
    </body>
    </html>
    Basically, the SQL part of it takes the username and password that is in the database and matches it to the username and password you submitted. If it does not match, it will show the login form again. If the username and password DO match, it will set a cookie on your system named auth with the value 'ok'. In secretpage.php, it will verify that that cookie value is okay by using this bit of code:
    secretpage.php:

    HTML Code:
    if ($_COOKIE[auth] == "ok") {
       echo "Welcome Admin!";
    } else {
        header("Location: http://YourSite.com/login.php");
        exit;
    }
    Basically, that code is saying 'If cookie auth = ok, let them in. If it does not, redirect them'. I hope that this has helped someone.

    http://img76.imageshack.us/img76/6450/sc2but4ng.gif | http://img495.imageshack.us/img495/7...gorwtan0je.gif | <a href="http://webtools.sc2.info"><img src="http://img129.imageshack.us/img129/8682/sc2webtan7ju.gif" border="1" width="100" alt="Free Webtools for all" /></a> | <a href="http://www.indexrated.com"><img src="http://img398.imageshack.us/img398/4813/listed1pb.gif" border="1" width="100" alt="Index Rated Directory - Rating Quality Sites" /></a>

    Get all Games,Apps and Wallpapers Nokia, Samsung and Sony Erricson!!


  • #2
    Re: [PHP] MySQL Login System

    Thanks for the codes
    Is there any good site that offers such codes?

    Comment

    Unconfigured Ad Widget

    Collapse

    Announcement

    Collapse
    1 of 2 < >

    FreeHostForum Rules and Guidelines

    Webmaster forum - Web Hosting Forum,Domain Name Forum, Web Design Forum, Travel Forum,World Forum, VPS Forum, Reseller Hosting Forum, Free Hosting Forum

    Signature

    Board-wide Policies:

    Do not post links (ads) in posts or threads in non advertising forums.

    Forum Rules
    Posts are to be made in the relevant forum. Users are asked to read the forum descriptions before posting.

    Members should post in a way that is respectful of other users. Flaming or abusing users in any way will not be tolerated and will lead to a warning or will be banned.

    Members are asked to respect the copyright of other users, sites, media, etc.

    Spam is not tolerated here in most circumstances. Users posting spam will be banned. The words and links will be censored.

    The moderating, support and other teams reserve the right to edit or remove any post at any time. The determination of what is construed as indecent, vulgar, spam, etc. as noted in these points is up to Team Members and not users.

    Any text links or images contain popups will be removed or changed.

    Signatures
    Signatures may contain up to four lines

    Text in signatures is subject to the same conditions as posts with respect decency, warez, emoticons, etc.

    Font sizes above 3 are not allowed

    Links are permitted in signatures. Such links may be made to non-Freehostforum material, commercial ventures, etc. Links are included within the text and image limits above. Links to offensive sites may be subject to removal.

    You are allowed ONLY ONE picture(banner) upto 120 pixels in width and 60 pixels in height with a maximum 30kB filesize.

    In combination with a banner/picture you can have ONLY ONE LINE text link.


    Advertising
    Webmaster related advertising is allowed in Webmaster Marketplace section only. Free of charge.

    Shopping related (tangible goods) advertising is allowed in Buy Sell Trade section only. Free of charge.

    No advertising allowed except paid stickies in other sections.

    Please make sure that your post is relevant.


    More to come soon....
    2 of 2 < >

    Advertise at FreeHostForum

    We offer competitive rates and a many kinds of advertising opportunities for both small and large scale campaigns.More and more webmasters find advertising at FreeHostForum.com is a useful way to promote their sites and services. That is why we now have many long-term advertisers.

    At here, we also want to thank you all for your support.

    For more details:
    http://www.freehostforum.com/threads...eHostForum-com

    More ad spots:
    http://www.freehostforum.com/forums/...-FreeHostForum
    See more
    See less
    Working...
    X