Notice: Undefined index: enroll in G:\xampp\htdocs\tg\1stSubmit.php on line 10

Question

when i insert data in mysql, this error are generated.

Notice: Undefined index: enroll in G:\xampp\htdocs\tg\1stSubmit.php on line 10

enroll is a defined in <input type="text" name="enroll"> and on submit page declare :

$a =  $POST['enroll'];
$sql="INSERT INTO student (e_no,f_name) VALUES ('$a','$b')";

*sidenote:* your code is subjected to SQL Injection attack, as you directly allow POST values to be inserted in your query. — Raptor, Mar 27 '14 at 06:37

score 1 · Answer 1 · edited May 25 '19 at 13:56

I guess it's a typo,

$a =  $_POST['enroll']; //you missed "_" should be _POST

And always check if post variable really exists or not,

$a =  isset($_POST['enroll']) ? $_POST['enroll'] : "";

Warning: Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO, or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial.

score 1 · Accepted Answer · answered Mar 27 '14 at 06:38

1

use

$a = $_POST['enroll'];

instead of

$a = $POST['enroll'];

answered Mar 27 '14 at 06:38

Deepu Sasidharan

2 Answers2