title: How to prepare statement for update query?
body: <p>I have a mysqli query with the following code: </p>
  
  <pre><code>$db_usag-&gt;query("UPDATE Applicant SET phone_number ='$phone_number', 
  street_name='$street_name', city='$city', county='$county', zip_code='$zip_code', day_date='$day_date', month_date='$month_date',
   year_date='$year_date' WHERE account_id='$account_id'");
  </code></pre>
  
  <p>However all the data is extracted from HTML documents so to avoid errors I would like to use a prepared statement. I found <a href="http://www.php.net/manual/en/mysqli-stmt.bind-param.php" rel="noreferrer">PHP documentation on <code>bind_param()</code></a> but there is no UPDATE example.</p>