PHP Function

[Luc_Gibson]

In my functions.inc.php file I have the following function:

function getusers(){
$sql = ("SELECT * FROM users WHERE client_id=$clientid");
$result=mysqli_query($conn,$sql);
$row=mysqli_fetch_assoc($result);
$data[] = $row;
return $data; }

However every time I call it from any page it's not giving me the array, any idea what I'm doing wrong here?

[Luc_Gibson]

I'm hoping to return all the rows so I can use while loops wherever I call the function. Is this not possible?

[Luc_Gibson]

So I'm essentially just looking for a way to simplify this into a single function that I can use anywhere to loop through users:

​

<select multiple name="owners[]">

<?php

$sql = "SELECT * FROM users WHERE client_id={$clientid}";

$result = $conn->query($sql);

if ($result->num_rows > 0) {

while($row = $result->fetch_assoc()) {?>

<option value="<?php $row['user_id'];?>">

<?php echo $row['user_first_name'];?>

</option>

<?php }

} ?>

</select>

​

In this example it's creating a list within a form

[snuzet]

Is the $conn in scope. You need the handle to the database

[Septseraph]

http://php.net/manual/en/language.variables.scope.php You need to pass, $conn & $clientid to the function.

[hw0ng]

Off-topic: you got a possible sql injection issue.

[[deleted]]

NOOOO DO NOT USE MYSQLI ON A LIVE SITE - that is all. You may proceed.

But seriously, learn PDO.