Mata mage site eken members login wenna puluwan widiyata hada ganna one !

SAN_APIIT

Well-known member
  • Mar 8, 2007
    4,611
    196
    63
    In a Chip !!!
    This is a sample code i wrote for a Mysql Database using PHP. make sure to protect ur self against SQL injection before sending the data to this code. Hope u find this useful.

    <?php
    $user = $_POST['user']; //user name from login page
    $pass = $_POST['pass']; //password from login page

    $conn = mysql_connect("Server IP", "user name", "password"); //server IP | Login User Name | Password
    mysql_select_db("database name", $conn); //Database Name

    $query = "SELECT * FROM Table_name WHERE user_column='$user' AND pass_column='$pass'";
    $res = mysql_query($query);

    if (mysql_num_rows($res)==1) {
    session_start();
    header( "Location: pagename.php" );
    } else {
    header( "Location: errorpage.php" );
    }
    ?>