title: PHP binding 'bigint' datatype (MySQLi prepared statement)
body: <pre><code>$studentId = 57004542323382
  $companyOfferId = 7
  
  $sql = 'INSERT INTO studentPlacement (companyOfferId, studentId) VALUES (?, ?)';
  
  if ($stmt = $db-&gt;prepare($sql)) {
      $stmt-&gt;bind_param("ii", $offerId, $studentId);
      $stmt-&gt;execute();
      $insertId = $stmt-&gt;insert_id;
      $stmt-&gt;close();
  }
  </code></pre>
  
  <p>My problem lies with the studentId variable. Its value is too long to be stored as a standard integer so it must be stored as a bigint. When binding the parameter as an integer it simply enters '1' as the studentId value. To my understanding <code>bind_param</code> supports 4 types; integer, string, blob and double. Does anybody have any ideas as to how I could get around this problem so I can properly send the value as a bigint?</p>
  
  <p>Thanks</p>