title: question about mysqli prepared statements
body: <p>I have basic question about mysqli prepared statements. For example, I want to execute a SELECT query, Should I do it like:</p>
  
  <pre><code>&lt;?
  $city = "Amersfoort";
  
  if ($stmt = $mysqli-&gt;prepare("SELECT District FROM City WHERE Name=?")) {
      $stmt-&gt;bind_param("s", $city);
      $stmt-&gt;execute();
      $stmt-&gt;bind_result($district);
      $stmt-&gt;close();
  }
  $mysqli-&gt;close();
  ?&gt;
  </code></pre>
  
  <p>In the above code, is bind_result also required? What exactly it does?</p>
  
  <p>Also, do I need need to close mysqli connection after each query?
  Thanks.</p>