PHP error Undefined index in

Question

Error:

Image of the error

Code:

<?php
  if($_POST['submit']) {
    $ename = $_REQUEST['ename'];
    $civstatus = $_REQUEST['civstatus'];
    $deptno = $_REQUEST['deptno'];
    $hiredate = $_REQUEST['hiredate'];
    $sal = $_REQUEST['sal'];
    $comm = $_REQUEST['comm'];

    include("conn.php");
    $sql = "insert into emp
            (ename,civstatus,
             deptno,hiredate,
             sal,comm) values(
             '$ename','$civstatus',
             '$deptno','$hiredate',
             '$sal','$comm')";
    $res = $conn->query($sql);  
    $conn->close();
  }
?>

Welcome to StackOverflow. Please consider: pasting the same thing over and over doesn't encourage people to help you because it's annoying, like typing in ALL CAPS — BeetleJuice, Aug 09 '16 at 04:18
If you are using post then i suggest you to user $_POST instead of $_REQUEST. — PHP Geek, Aug 09 '16 at 04:18
Sorry because i cant it says it needs to add some more context, im new here at stackoverflow. Im sorry — stackoverlow, Aug 09 '16 at 04:21
BTW, can you help me to post the code right? because stackoverflow is not a userfriendly forum — stackoverlow, Aug 09 '16 at 04:29
@stackoverflow when you post credentials, make sure to shadow your password; for instance, $user: mysql*** $pass: !sed*** and hide any urls, especially directing to your webserver or your home network. — unixmiah, Aug 09 '16 at 05:03

score 0 · Answer 1 · answered Aug 09 '16 at 04:20

first in your form please check your submit button have name="submit" and in your php code please use isset. try this-

<?php
  if(isset($_POST['submit'])) {
    $ename = $_REQUEST['ename'];
    $civstatus = $_REQUEST['civstatus'];
    $deptno = $_REQUEST['deptno'];
    $hiredate = $_REQUEST['hiredate'];
    $sal = $_REQUEST['sal'];
    $comm = $_REQUEST['comm'];

    include("conn.php");
    $sql = "insert into emp
            (ename,civstatus,
             deptno,hiredate,
             sal,comm) values(
             '$ename','$civstatus',
             '$deptno','$hiredate',
             '$sal','$comm')";
    $res = $conn->query($sql);  
    $conn->close();
  }
?>

score 0 · Answer 2 · answered Aug 09 '16 at 04:34

You need to check name of input elements of all the form fields are same as you are using in php file.

You need to improve your code by checking the values availability like-

<?php
  if(isset($_POST['submit']) {
    $ename = isset($_REQUEST['ename']) ? $_REQUEST['ename'] : '';
    $civstatus = isset($_REQUEST['civstatus']) ? $_REQUEST['civstatus'] : '';
    $deptno = isset($_REQUEST['deptno']) ? $_REQUEST['deptno'] : 0;
    $hiredate = isset($_REQUEST['hiredate']) ? $_REQUEST['hiredate'] : '';
    $sal = isset($_REQUEST['sal']) ? $_REQUEST['sal'] : 0;
    $comm = isset($_REQUEST['comm']) ? $_REQUEST['comm'] : ''; 

    include("conn.php");

    $sql = "insert into emp
            (ename,civstatus,
             deptno,hiredate,
             sal,comm) values(
             $ename,$civstatus,
             $deptno,$hiredate,
             $sal,$comm)";

    $res = $conn->query($sql);  
    $conn->close();
  }
?>

You also need to check conn.php file for any undefined index .

PHP error Undefined index in

2 Answers2