Mysqli not returning a value when i use functions

Question

I have used a lot of function in my website projects. I had used mysql. now I want to convert it into mysqli but the problem I am facing is with mysql_result my fuction should return 1 valve only

// $mysqli is my database connection


function test($id){

$query = "SELECT name FROM members where id= '$id'"; 
 $result = mysqli_query($mysqli, $query);

$row = mysqli_fetch_array($result,  MYSQLI_ASSOC);


return $row;
}

$name = test(4);

echo $name;

when I do not use functions, just echo $row it gives correct result when I put $id =4;

Please mark the answer as accepted if your question was addressed. Thanks. — Peter Bowers
– Peter Bowers, Commented Mar 15, 2015 at 7:49

Peter Bowers · Accepted Answer · 2015-03-16 15:50:53Z

1

If your function definition of test() is complete above then you do not have the value of $mysqli. You get that value when you connect to the database and you either need to make it global or pass it in:

function test ($id) {
    global $mysqli;

or

function test ($mysqli, $id) {

edited Mar 16, 2015 at 15:50

answered Mar 15, 2015 at 5:39

Peter Bowers

3,1031 gold badge13 silver badges20 bronze badges

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

4 Comments

AHSAN KHAN Over a year ago

Thankx Sir Peter u solved my problem but i cant vote due to reputation less

AHSAN KHAN Over a year ago

sorry 1 more problem #peter that i use 100 functions 3 or 4 time each there in project so i have to pass $mysqli every time is there any other way efficient and easy fast

Peter Bowers Over a year ago

I'm not aware of another way to handle this more efficiently or easily. You have to somehow get access to the variable within the function and the 2 ways to do that are by passing in a parameter or by using a global...

AHSAN KHAN Over a year ago

oh did now ok peter sir i thankx i will use any of 2 ways thanks

Collectives™ on Stack Overflow

Mysqli not returning a value when i use functions

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related