Im inserting data with php code but its not working and give( un defined index:name)at submit page

Question

I am getting this error:

undefined index:name why its not responding.

<?php
$url="localhost";
$user="root";
$password="";
$db="sms";
$connection=new mysqli($url,$user,$password,$db);
$username=$_POST["name"];
$query="INSERT INTO student(name)VALUES('".$username."')";
$connection->query($query);   
?>

What does your `student` table look like? The error message indicates the `name` column doesnt exist — madsroskar, Feb 19 '17 at 12:07

score 0 · Answer 1 · answered Feb 19 '17 at 12:55

When you get Username $username = $_POST["name"]; Value for $username variable come from global $_POST variable. If you start your script without POST, you cant read key 'name' from $_POST array. This key didn't exist and you get this error. SOLUTION for this problem. Just check for $_POST value with isset() and if() statments.

if (isset($_POST["name"])) {
    $username=$_POST["name"];
    $query="INSERT INTO student(name)VALUES('".$username."')";
    $connection->query($query);   
}

score 0 · Answer 2 · answered Feb 19 '17 at 13:15

0

Make sure that the <input type="blablabla" name="name" ...>

Also make sure to wrap the PHP code in:

if(!empty($_POST["name"])){
    // the code you posted ...
}

answered Feb 19 '17 at 13:15

Hossam

1,126
8
19

– Muhammad Younas Feb 19 '17 at 13:25
this is html code – Muhammad Younas Feb 19 '17 at 13:25
Muhammad, ok. Then make sure to wrap your code in the if condition – Hossam Feb 19 '17 at 13:26

Im inserting data with php code but its not working and give( un defined index:name)at submit page

2 Answers2