Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- // Database information
- $dbhost=""; // Host name
- $dbusername=""; // Mysql username
- $dbpassword=""; // Mysql password
- $db_name=""; // Database name
- $tbl_name=""; // Table name
- // Connect to server and select databse.
- mysql_connect("$dbhost", "$dbusername", "$dbpassword")or die("cannot connect to DB");
- mysql_select_db("$db_name")or die("cannot select DB");
- // Fetching form-data from index.php
- $user = $_POST['username'];
- $pass = $_POST['password'];
- $user = mysql_real_escape_string(stripslashes($user));
- $pass = mysql_real_escape_string(stripslashes($pass));
- $sql="SELECT * FROM $tbl_name WHERE `username`='$user' AND `password`='$pass'";
- $query=mysql_query($sql) or die(mysql_error());
- if(mysql_num_rows($query) == 1){
- $row = mysql_fetch_assoc($query); // mysql_fetch_assoc gets the value for each field in the row
- //$_SESSION['id'] = $row['id']; //creates the first session var
- $_SESSION['username'] = $row['username']; // second session var
- header("Location: userarea.php")
- }
- else
- {
- $_SESSION["error"] = "It's just bad bro";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement