初始mysqli查询阻止下一个运行

Question

I am running a query using a global mysqli object and then passing the mysqli object to a function called getProgramInfo to be used when running a second query. If I don't run the initial query, everything works well, but if I run the initial query, the second query does not work and fails on the $mysqli->prepare(). The SQL is valid on the second query, there seems to just be an issue with the mysqli object.

echo getProgramInfo($mysqli); //This works if I call this function here.

$sql = "SELECT programName FROM programs WHERE programID = ?";

if ($stmt = $mysqli->prepare($sql)) //This query always works
{
  $stmt->bind_param('i', $_GET['id']);

  $stmt->execute();

  $stmt->bind_result($programNameText);

  if ($stmt->fetch()) 
  { 
    //Do stuff;
  }
  else
  {
     echo "Error";
  }

  $mysqli->close();
}

echo getProgramInfo($mysqli); //This fails if I call the function here

Answer 1

"You were correct on the closing the $mysql, I stared at it for so long but kept reading it as $stmt->close(). I have failed at reading comprehension of my own code. – Columbus"

As stated in my first comment; you closed the connection too soon in your code.

Therefore, either remove $mysqli->close(); since MySQL will close it automatically, or place it after your last function call.

echo getProgramInfo($mysqli); //This fails if I call the function here
$mysqli->close();