CODEWITHSUNDEEP
phpmysqlsqlmysqli
jskidd3
jskidd3

Reputation: 4783

PHP binding 'bigint' datatype (MySQLi prepared statement)

$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

Upvotes: 4

Views: 4138

Answers (1)

sectus
sectus

Reputation: 15464

Use $studentId = '57004542323382'; // quotes added and string param for binding.

Upvotes: 8

Related Questions