Variables not working in PHP PDO

Question

This is my PHP PDO code:

<?php
$number = 1;
function result($conn) {
    $sql = 'SELECT name FROM customerdata';
    foreach ($conn->query($sql) as $row) {
        print " ". $number ."       ". $row['name'] . " <br> "; // this is line 6 

    }
}
result($conn);
?>

This is the error, I am getting:

Notice: Undefined variable: number in C:\xampp\htdocs\website\a.php on line 6

Possible duplicate of [PHP: variable not working inside of function?](https://stackoverflow.com/questions/3041171/php-variable-not-working-inside-of-function) — Mohammad Hamedani, Jun 03 '17 at 05:46

score 0 · Answer 1 · answered Jun 03 '17 at 05:47

0

Pass the number variable as a parameter in the function. The number variable does not exist in that function. As said, either pass as a parameter or declare the number variable as a global variable in the function

answered Jun 03 '17 at 05:47

Rotimi

4,783
4
18
27

score 0 · Answer 2 · answered Jun 03 '17 at 05:49

0

$number

is a variable. You should do this

function result($conn) {
    insert line   global $number;
    $sql = 'SELECT name FROM customerdata';
    foreach ($conn->query($sql) as $row) {
        print " ". $number ."       ". $row['name'] . " <br> "; // this is line 6 

    }
}

answered Jun 03 '17 at 05:49

Alexios Tsiaparas

880
10
17

Worked. Your answer and Arun's answer do the same thing in all conditions? – Shilpa Choudhary Jun 03 '17 at 05:54

score 0 · Answer 3 · answered Jun 03 '17 at 05:50

0

You need pass the number as a arugument to the function

 function result($conn,$number) {
     $sql = 'SELECT name FROM customerdata';
        foreach ($conn->query($sql) as $row) {
            print " ". $number ."       ". $row['name'] . " <br> "; 

        }

    }

answered Jun 03 '17 at 05:50

Arun Kumaresh

6,211
6
32
50

Worked. Your answer and Alexios answer do the same thing in all conditions? – Shilpa Choudhary Jun 03 '17 at 05:54
usage global in php is considered to be bad practice check it here https://stackoverflow.com/questions/1557787/are-global-variables-in-php-considered-bad-practice-if-so-why.Instead of that pass the variable as parameter to the function – Arun Kumaresh Jun 03 '17 at 05:58

score 0 · Answer 4 · answered Jun 03 '17 at 05:52

0

You can use two options here either pass $number as argument or declare it at global

Sol 1:

<?php
$number = 1;
function result($conn,$number) {
    $sql = 'SELECT name FROM customerdata';
    foreach ($conn->query($sql) as $row) {
        print " ". $number ."       ". $row['name'] . " <br> "; // this is line 6 

    }
}
result($conn,$number);
?>

Sol 2:

<?php
$number = 1;
function result($conn) {
    global $number;
    $sql = 'SELECT name FROM customerdata';
    foreach ($conn->query($sql) as $row) {
        print " ". $number ."       ". $row['name'] . " <br> "; // this is line 6 

    }
}
result($conn);
?>

answered Jun 03 '17 at 05:52

B. Desai

16,414
5
26
47

Both do the same thing under all conditions? – Shilpa Choudhary Jun 03 '17 at 05:56
I recommended to use sol1 to pass variable as argument. As global declaration is not good practice. https://stackoverflow.com/questions/2216340/the-advantage-disadvantage-between-global-variables-and-function-parameters-in – B. Desai Jun 03 '17 at 06:03

Variables not working in PHP PDO

4 Answers4