PHP function returns wrong values

Question

I have this function

function getNick($uid)
{
    $sqli = "SELECT nick FROM users WHERE userid='".$uid."'";
    mysqli_real_escape_string($con,$sqli);
    $resulti = mysqli_query($con,$sqli);
    $rowi = mysqli_fetch_assoc($resulti);   
    if($resulti->num_rows > 0) return $rowi["nick"];
    else return "(none)";
}

Basically it should return me nick based on user's id. Problem is that I only keep getting '(none)'. What is interesting I printed actual $sqli and copied it into phpMyAdmin and it worked as expected. I even tried to just print nick without IFs but I ended up with empty string. What might be the issue? Am I overlooking something? Thanks

It didn't work and problem has to be somewhere else as I had echo under mysqli_fetch_assoc and it was empty string. — Martin
– Martin, Commented Oct 2, 2016 at 9:15

asissuthar · Accepted Answer · 2016-10-02 09:30:26Z

1

<?php

$con = mysqli_connect("localhost","root","","test");

function getNick($uid,$con)
{

    $sqli = "SELECT nick FROM users WHERE userid='".$uid."'";
    mysqli_real_escape_string($con,$sqli);
    $resulti = mysqli_query($con,$sqli);
    $rowi = mysqli_fetch_assoc($resulti);   
    if($resulti->num_rows > 0) return $rowi["nick"];
    else return "(none)";
}

echo getNick(1,$con);
?>

it works

variable scope problem

use above method to pass connection in method or

use $GLOBALS['con'] to access connection in method getNick

edited Oct 2, 2016 at 9:30

answered Oct 2, 2016 at 9:24

asissuthar

2,2561 gold badge18 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP function returns wrong values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related