Choose Category
<?php // get the values from the <FORM> $user_name = $_POST['user_name']; $pass_word = $_POST['passwd_user']; ob_start(); // Initialize database connection $connect = mysqli_connect('127.0.0.1','root','your_password'); if($connect) echo "MySql Connection Established "; else die("Error :" . mysql_error()); //striplashes : Un-quotes a quoted string $username = stripslashes($user_name); $password = stripslashes($pass_word); // mysqli_real_escape_string - Escapes special characters in a string for use in an SQL statement $username = mysqli_real_escape_string($connect, $username); $password = mysqli_real_escape_string($connect, $password); $login = "SELECT * FROM table_name WHERE username='$username' AND password='$password'"; // Mysql_num_row is Counting table row $result = mysqli_query($connect, $login); // if it matches it counts to be one 1 $count = mysqli_num_rows($result); if($count==1) { session_register("admin"); session_register("password"); $_SESSION['username'] = $username; // On Success header("location:home.php"); } else { // On Failure header("location:loginpage.php"); } ob_end_flush(); ?>