silly function question

[Jakebert]

This is a silly question about functions. Why does this code:

 

<?php

//connect to the database
$host = "localhost";
$DBuser = "root";
$DBpassword = "";
$database = "ksu";

$connection = new mysqli($host, $DBuser, $DBpassword, $database);

if ($connection->connect_error) {
die('Connection Error (' . $connection->connect_errno . ') ' 
	. $mysqli->connect_error);
}

function getUserGroups($id) {

$query = $connection->query("SELECT group_id FROM group_membership WHERE user_id = " . $id); // this is line 20, where the error gets thrown
$results = mysqli_fetch_assoc($query);
return $results;
}


?>

 

Throw this error:

Notice: Undefined variable: connection in C:\wamp\www\KSU\connect.php on line 20

 

There must be a really obvious answer I'm missing.

[KevinM1]

You need to pass $connection into the getUserGroups() function, like you did with $id.

[Drummin]

Maybe I'm wrong but shouldn't the query be

$query = $connection->query("SELECT group_id FROM group_membership WHERE user_id =$id");

[Jakebert]

You are correct! Thanks for finding that for me!