php - undefined index

Question

Is there any wrong with this statement?

Error return:

Notice: Undefined index: inputBlock

Notice: Undefined index: inputHouseUnit

code:

if($conn){
    $insertData = "INSERT INTO ESTATEUNIT (BLOCK, UNIT) VALUES ('$_POST[inputBlock]', '$_POST[inputHouseUnit]')";
}

Answer 1

PHP array indices are either numbers or strings.

If inputBlock and inputHouseUnit are the identifiers of string variables, you must precede them with $ (e.g., $_POST[$inputBlock]).

If they are literal strings, wrap them in ' (single-quotes) or " (double-quotes) (e.g., $_POST["inputBlock"]).

Obviously, you will have to be careful of escaping single and double quotes. Also, you should validate your user input before attempting to put it into the database.