note 89544 added to mysqli-stmt.bind-param
| From: | KaiSellgren at osu1 dot php dot net | Date: | Thu, 12 Mar 2009 23:26:58 +0000 |
| Subject: | note 89544 added to mysqli-stmt.bind-param | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-151809@lists.php.net to get a copy of this message | ||
A few notes on this function.
If you specify type "i" (integer), the maximum value it allows you to have is 2^32-1 or
2147483647. So, if you are using UNSIGNED INTEGER or BIGINT in your database, then you are better
off using "s" (string) for this.
Here's a quick summary:
(UN)SIGNED TINYINT: I
(UN)SIGNED SMALLINT: I
(UN)SIGNED MEDIUMINT: I
SIGNED INT: I
UNSIGNED INT: S
(UN)SIGNED BIGINT: S
(VAR)CHAR, (TINY/SMALL/MEDIUM/BIG)TEXT/BLOB should all have S.
FLOAT/REAL/DOUBLE (PRECISION) should all be D.
That advice was for MySQL. I have not looked into other database software.
----
Server IP: 62.237.7.3
Probable Submitter: 81.175.154.102
----
Manual Page -- http://www.php.net/manual/en/mysqli-stmt.bind-param.php
Edit -- https://master.php.net/note/edit/89544
Del: integrated -- https://master.php.net/note/delete/89544/integrated
Del: useless -- https://master.php.net/note/delete/89544/useless
Del: bad code -- https://master.php.net/note/delete/89544/bad+code
Del: spam -- https://master.php.net/note/delete/89544/spam
Del: non-english -- https://master.php.net/note/delete/89544/non-english
Del: in docs -- https://master.php.net/note/delete/89544/in+docs
Del: other reasons-- https://master.php.net/note/delete/89544
Reject -- https://master.php.net/note/reject/89544
Search -- https://master.php.net/manage/user-notes.php