未定义索引：不在c：/ wamp / www / Hotel 18 \确认booking.php在第3行[重复]

Question

This question already has an answer here:

• “Notice: Undefined variable”, “Notice: Undefined index”, and “Notice: Undefined offset” using PHP 28 answers

error : undefine index:no in c:/wamp/www/Hotel 18\confirm_booking.php on line 3.

    $roomno=$_GET['no'];
    include('connection.php');
    if(isset($_Request['btnconfirm']))
    {

    $cust=$_POST['custname'];
    $room=$_POST['custroom'];
    $ar=$_POST['arrv'];
    $dep=$_POST['depr'];
    $total=$_POST['total'];
    echo mysql_query("inserted into checkout(customer_name,room_no,arrival_time,departure_time,total,status) values('$cust','$room','$ar','$dep','$total','PAID')");
    mysql_query("update room_booking set status='Clear' where name='$cust' and roomNo='$room'");
 }
 ?>

note: i have taken 'no' as a reference from a page, and it is working quit well, but on submitting the form, still an error occurred related to the $_GET['no'] what mistake i did ?**

</div>

Answer 1

This line:

if(isset($_Request['btnconfirm']))

$_Request is a superglobal which must be in uppercase $_REQUEST

change it to:

if(isset($_REQUEST['btnconfirm']))

I suggest that you switch to using mysqli_* with prepared statements or PDO. mysql_* functions are deprecated and will be deleted from future PHP releases.

As it stands now, you are open to SQL injection.

• Read this article on how to prevent SQL injection.