Notice: Undefined variable: id in PHP

Strange

I am getting an undefined variable error while executing below code:

if ($amount != NULL) {
    $host = 'localhost';
    $user = 'root';
    $pass = '';
    $db = 'deedok';
    $connection = mysqli_connect($host, $user, $pass, $db);
    echo 'connected_deedok';
    if (!$conn){
        die('Database Connection Lost.');
    }
        $query_deedok = "SELECT * FROM products WHERE amount='$amount'";
            $query_deedok_result = mysqli_query($connection, $query_deedok);
    if ($query_deedok_result != NULL) {
        while($query_deedok_result_rows = mysqli_fetch_assoc($query_deedok_result)) {
            $name = $query_deedok_result_rows['name'];
            $id = $query_deedok_result_rows['id'];
            $description = $query_deedok_result_rows['description'];
        }
    }
    echo $name;
    echo $id;
    echo $description;
}

I have already assigned value to $amount and also there is not database connection error.

Marat Badykov

Do this, and it will work:

if ($amount) {
                $host = 'localhost';
                $user = 'root';
                $pass = '';
                $db = 'deedok';
                $connection = mysqli_connect($host, $user, $pass, $db);
                echo 'connected_deedok';
                if (!$conn){
                    die('Database Connection Lost.');
                }
                    $query_deedok = "SELECT * FROM products WHERE amount='" .  $amount . "'";
                        $query_deedok_result = mysqli_query($connection, $query_deedok);
                if ($query_deedok_result != NULL) {
                    while($query_deedok_result_rows = mysqli_fetch_assoc($query_deedok_result)) {
                        $name = $query_deedok_result_rows['name'];
                        $id = $query_deedok_result_rows['id'];
                        $description = $query_deedok_result_rows['description'];
                    }
                        }
        echo $name;
        echo $id;
        echo $description;
            }

Your $amount variable is not parsed and will not be replaced with the assigned value as you have included it in quotes.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

PHP Notice: Undefined variable

PHP Notice: Undefined variable:

"Notice: Undefined variable", "Notice: Undefined index", "Warning: Undefined array key", and "Notice: Undefined offset" using PHP

"Notice: Undefined variable", "Notice: Undefined index", and "Notice: Undefined offset" using PHP

PHP Notice: undefined variable, but they are already defined

PHP MySql - Notice: Undefined variable Error

php warning session variable, Notice: Undefined index:

PHP error undefined variable notice how to fix?

Notice: Undefined variable: grandTotal in PHP 7.1

Not able to fix "PHP Notice: Undefined variable" and "Undefined index" in code

Notice: Undefined variable: table

Notice: Undefined variable: num

Notice: Undefined variable with <?= $property

Notice: Undefined variable in function +=

Notice: Undefined index: variable

Notice: Undefined variable: mysqli

Ngnix - FastCGI sent in stderr: "PHP message: PHP Notice: Undefined variable

PHP Notice: Undefined index

Undefined index notice in php

PHP Notice: Undefined offset

PHP Notice: Undefined index

Notice: Undefined variable: world in abc.php on line

Notice : Undefined variable: result in new_admin.php on line 42

I am facing an Undefined Variable:Notice Error in PHP

PHP Notice: Undefined variable in array_walk_recursive function

A PHP Error was encountered Severity: Notice Message: Undefined variable: result

Notice: Undefined variable - WordPress / Parse Server Plugin - PHP Error

Notice: Undefined variable: x in include()

Notice: Undefined variable: on line 24

TOP Ranking

  1. 1

    Failed to listen on localhost:8000 (reason: Cannot assign requested address)

  2. 2

    Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)

  3. 3

    How to import an asset in swift using Bundle.main.path() in a react-native native module

  4. 4

    pump.io port in URL

  5. 5

    Compiler error CS0246 (type or namespace not found) on using Ninject in ASP.NET vNext

  6. 6

    BigQuery - concatenate ignoring NULL

  7. 7

    ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3

  8. 8

    ggplotly no applicable method for 'plotly_build' applied to an object of class "NULL" if statements

  9. 9

    Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

  10. 10

    How to remove the extra space from right in a webview?

  11. 11

    java.lang.NullPointerException: Cannot read the array length because "<local3>" is null

  12. 12

    Jquery different data trapped from direct mousedown event and simulation via $(this).trigger('mousedown');

  13. 13

    flutter: dropdown item programmatically unselect problem

  14. 14

    How to use merge windows unallocated space into Ubuntu using GParted?

  15. 15

    Change dd-mm-yyyy date format of dataframe date column to yyyy-mm-dd

  16. 16

    Nuget add packages gives access denied errors

  17. 17

    Svchost high CPU from Microsoft.BingWeather app errors

  18. 18

    Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

  19. 19

    12.04.3--- Dconf Editor won't show com>canonical>unity option

  20. 20

    Any way to remove trailing whitespace *FOR EDITED* lines in Eclipse [for Java]?

  21. 21

    maven-jaxb2-plugin cannot generate classes due to two declarations cause a collision in ObjectFactory class

HotTag

Archive