Undefined index: username on line 16 Notice:

Question

I keep getting this error: Undefined index: username on line 16 Notice: Undefined index: password on line 17 Table 'john.Users' doesn't exist

$username = mysql_real_escape_string($_POST['username']);
$password = $_POST['password'];
$result = mysql_query("SELECT * FROM Users WHERE UserName LIKE '$username'");

if($result === FALSE) {
    die(mysql_error());  
}

try running `var_dump($_POST)` to see what you are actually submitting. — edmondscommerce, May 07 '14 at 11:26
possible duplicate of [PHP: "Notice: Undefined variable" and "Notice: Undefined index"](http://stackoverflow.com/questions/4261133/php-notice-undefined-variable-and-notice-undefined-index) — Quentin, May 07 '14 at 12:57
You are using [an **obsolete** database API](http://stackoverflow.com/q/12859942/19068) and should use a [modern replacement](http://php.net/manual/en/mysqlinfo.api.choosing.php). — Quentin, May 07 '14 at 12:57

score 0 · Answer 1 · answered May 07 '14 at 11:32

first write var_dump($_POST); and see whether ur username and password is set or not if it is not check ur html form tag method attribute value is POST or not. like this
<form method="post">

other case in sql check database have users table
also check whether is that Users or users ...(mysql case sensetive)

score 0 · Answer 2 · answered May 07 '14 at 11:35

looks like $_POST['username'] is not set or empty so use isset() or empty() to avoid php notices or check values like :-

$username = (!empty($_POST['username']) ? $_POST['username'] : '');
$username = mysql_real_escape_string($username);
$password = (!empty($_POST['password']) ? $_POST['password'] : '');

or use check

if(empty($_POST['username']))
 echo 'username is empty';

score 0 · Answer 3 · answered May 07 '14 at 12:54

Possible problems:

It isn't a POST but a GET request (Check the method attribute of your<form>. Does it say post or get?)

Typo in the name attribute of your <input> element

And as for the other error (Table 'john.Users' doesn't exist): check your mysql database, maybe it's users instead of Users?

Undefined index: username on line 16 Notice:

3 Answers3