Can mysqli binding unsigned int?

Question

when i do mysqli update using prepare and then bind param like:

$stmt->bind_param("ii", $svr_id, $group_id)

here comes the problem: In my database, svr_id was defined as unsigned int, but when binding, it is specified by int. when

$svr_id>0x1000 0000 0000 0000 0000 0000 0000 0000

, it seems that it was considered to be a negative num, and the update command failed. but i can't find a param to make it unsigned int in function bind_param(); Is anyone can help to solve this?

Why not to post *complete reproduceable* code, so everyone could run and confirm that it is indeed the case, not some typo in your own code? — Your Common Sense, Nov 16 '13 at 09:27
This may be helpful: http://stackoverflow.com/a/872484/789186 — user4035, Nov 16 '13 at 09:30
Bug #35518 mysqli bind_param() incorrectly handles unsigned int https://bugs.php.net/bug.php?id=35518 — Damodaran, Nov 16 '13 at 09:38

score 0 · Answer 1 · answered Nov 22 '13 at 00:12

0

Your number greater that MAX_INT. When you trying to bind php converts it to integer.

Solution: bind values as strings.

answered Nov 22 '13 at 00:12

sectus

15,605
5
55
97

Can mysqli binding unsigned int?

1 Answers1