Pass argument via variable

Question

this is my code... docrow('&ddname') is not passing.if I am using docrow('Jhon') then my code is all right.it give 3 number of row in returns.but what's wrong with docrow('&ddname')? it give me 0 row in returns.though there have 3 rows!

<?php 
$ddname="Jhon"; 
include 'config.php';
//my database connection
function docrow($name){
    global $conn;
    $sqlquery=mysqli_query($conn,"SELECT id,name,docname,discount,docget from income where docname='$name'");
    $countrow=mysqli_num_rows($sqlquery);
    return $countrow;
}
echo docrow('$ddname');
?>

inside the single quotes everything consider as string so .no need that single quotes echo docrow($ddname); — JYoThI, May 13 '17 at 11:03
$ddname is a variable don't include quotes `echo docrow($ddname);` — Prakhar Thakur, May 13 '17 at 11:05
i checked your code i is working fine . don not include single quotes on variables you can directly put variables . Example insisted of this `echo docrow('$ddname');` do this `echo docrow($ddname);`. you will result — Pavan Baddi, May 13 '17 at 11:13
@MustaqueAhmed please think of [accepting an answer](http://stackoverflow.com/help/accepted-answer) — Junius L., May 13 '17 at 23:52

score 5 · Accepted Answer · edited May 23 '17 at 12:18

5

Pass the connection as a parameter to your function, and don't use quotes around your arguments when you pass them to a function.

<?php
$ddname = "Jhon";
include 'config.php';
//my database connection
function docrow($name, $conn)
{
    $sqlquery = mysqli_query($conn, "SELECT id,name,docname,discount,docget from income where docname='$name'");
    return mysqli_num_rows($sqlquery);
}

echo docrow($ddname, $conn);
?>

Please read more about the difference between single and double quotes and global variables

edited May 23 '17 at 12:18

Community

1
1

answered May 13 '17 at 11:12

Junius L.

14,324
4
33
63

he accessed by gloabl did you notice that global $conn; – JYoThI May 13 '17 at 11:19
Yes I did, I think it's better to stay away from global variables. – Junius L. May 13 '17 at 11:21
is there any issue using global variable ? – JYoThI May 13 '17 at 11:22
I think a function should not depend/rely on the global scope code – Junius L. May 13 '17 at 11:30

score 2 · Answer 2 · answered May 13 '17 at 11:07

Try it:

<?php
$ddname="Jhon"; 
include 'config.php';
//my database connection
function docrow($name){
    global $conn;
    $sqlquery=mysqli_query($conn,"SELECT id,name,docname,discount,docget from income where docname='$name'");
    $countrow=mysqli_num_rows($sqlquery);
    return $countrow;
}
echo docrow($ddname);
?>

Pass argument via variable

2 Answers2