使用isset进行修正？

Question

I'm new to PHP,I got error in my web page.It said:

Notice: Undefined index: itemid in /home/tz005/public_html/COMP1687/edit.php on line 103

Can I use isset to fix this problem? If yes, how to do so? Here is my script:

<?php
//include database connection
include 'dbconnect.php';

// if the form was submitted/posted, update the item
if($_POST){

    //write query
    $sql = "UPDATE 
                item_information 
            SET
                itemtitle = ?, 
                itemdescription = ?,
                date = ?,
            WHERE 
                itemid= ?";

    $stmt = $mysqli->prepare($sql);

    $stmt->bind_param(
        'sssi', 
        $_POST['itemtitle'], 
        $_POST['itemdescription'],
        $_POST['date'],
        $_POST['itemid']
    );

    // execute the update statement
    if($stmt->execute()){
        echo "Item was updated.";

        // close the prepared statement
        $stmt->close();
    }else{
        die("Unable to update.");
    }
}

$sql = "SELECT 
            itemid, itemtitle, itemdescription, date
        FROM 
            item_information
        WHERE 
            id = \"" . $mysqli->real_escape_string($_GET['itemid']) . "\"
        LIMIT 
            0,1";

// execute the sql query
$result = $mysqli->query( $sql );

//get the result
if ($result = $mysqli->query( $sql )) {
  if ($row = $result->fetch_assoc()) {

    // $row contains data

  }
}

//disconnect from database
$result->free();
$mysqli->close();
?>

Answer 1

change

$mysqli->real_escape_string($_GET['itemid'])

to

$mysqli->real_escape_string($_POST['itemid'])

or use empty() or isset() to check values exist