How to solve PHP undefined index error?

Question

I am not familiar with PHP,but I need to use PHP as backend for insert data into database from my android app using xamp local host.I got a PHP code but it shows the error "undefined index in line 4 (username)".I cant find the ERROR, so please help me, thanks.

here is my code

   <?php
    mysql_connect("localhost","root","");
    mysql_select_db("taskmanager");
    $name=null;
    $name=$_POST['username'];
    $ins="insert into userlog (username)values('$name')";
    mysql_query($ins);
    mysql_close();
   ?>

Check if you are really passing the `username` as a parameter from your android app. — Shankar Narayana Damodaran, Feb 05 '14 at 07:38
try to pass $name as a static data ones, if that makes your query run then try with handling the post — sourabh kasliwal, Feb 05 '14 at 07:40
Side note: You shouldn't use `mysql_*()` for new code - it's deprecated. Use `mysqli_*()` or `PDO`. You're also open to SQL Injection - make sure you escape your user input properly, or use prepared statements. — , Feb 05 '14 at 07:42
am using array list,to store my details..so any prblm with calling username ??? — prince, Feb 05 '14 at 07:42
If PHP says $_POST does not include username, it doesn't. The error is most likely in the android app. — Joni, Feb 05 '14 at 07:44
You are posting a few lines of code and they are FULL of catastrophical errors. Dude, start over and learn PHP from scratch! **You are doing it wrong.** — Sliq, Feb 05 '14 at 07:48
Use this: print_r($_POST); if username is not included in it then it is android app problem — Adam Radomski, Feb 05 '14 at 07:49

score 2 · Accepted Answer · answered Feb 05 '14 at 07:57

2

Here is updated code

mysql_connect("localhost","root","");
mysql_select_db("taskmanager");    
$name= (isset($_POST['username'])) ? $_POST['username'] : '';
$ins="insert into userlog (username)values('$name')";
mysql_query($ins);
mysql_close();

answered Feb 05 '14 at 07:57

Jignesh Patel

1,053
6
10

ghost · Answer 2 · 2014-02-05T07:51:12.857

1

Try this

if(isset($_POST['username']))
    {
        mysql_connect("localhost","root","");
        mysql_select_db("taskmanager");
        $name=$_POST['username'];
        $ins="insert into userlog (username)values('$name')";
        mysql_query($ins);
        mysql_close();
    }
else
{
 echo 'No POST request';
}

edited Feb 05 '14 at 07:51

answered Feb 05 '14 at 07:42

ghost

467
2
6
18

Missing `$name` assignment. – vee Feb 05 '14 at 07:43
1

This might avoid the error, but doesn't address the reason for it in the first place. – Feb 05 '14 at 07:45
@ Mike W but he said he is passing username. to check if he is passing username he can use this i guess.. – ghost Feb 05 '14 at 07:50
@Sharad, You may not even know .. what if the OP is sending the params via `GET` ;) ? – Shankar Narayana Damodaran Feb 05 '14 at 07:56
@Shankar Damodaran ooh OP is Sending GET and he is using POST ??? – ghost Feb 05 '14 at 08:02
@Sharad, No idea about that. He hasn't posted his android code yet ! – Shankar Narayana Damodaran Feb 05 '14 at 08:03

How to solve PHP undefined index error?

2 Answers2