<?php
$host = "localhost";
$username = "userczve";
$password = "klaokxcv";
$db_name = "db123";
mysql_connect($host, $username, $password) or die (mysql_error());
mysql_select_db($db_name) or die (mysql_error_db());
$myusername = mysql_real_escape_string($_POST['$username']);
$mypassword = mysql_real_escape_string($_POST['$password']);
$sql = "SELECT `username` FROM `members` WHERE `username`='$myusername' and `password`='$mypassword'";
$count = $row[0];
$result=mysql_query($sql) or die('Query Error: ' . mysql_error() . "<br />\n$sql");
if($count>0)  {     session_start();     $_SESSION['logged_in'] =
true;
header("Location: login_success.php");     exit;  }
else {     echo "Wrong Username or Password"; }
?>