$studentId = 57004542323382
$companyOfferId = 7
$sql = 'INSERT INTO studentPlacement (companyOfferId, studentId) VALUES (?, ?)';
if ($stmt = $db->prepare($sql)) {
$stmt->bind_param("ii", $offerId, $studentId);
$stmt->execute();
$insertId = $stmt->insert_id;
$stmt->close();
}
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 bind_param
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?
Thanks
Use $studentId = '57004542323382'; // quotes added
and string param for binding.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With