blocks|key|1000278|text|在MySQLi中使用bind_result：它设置正确的类型并处理NULL。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1000279|entityMap|0|LINK|mutability|MUTABLE|url|http://www.php.net/manual/en/mysqli-stmt.bind-result.php^0|A|B|X|4|A|B|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]|$9|Q|A|R|B|C]]|D|@$9|S|A|T|1|U]]|E|$]]|$1|F|3|-4|5|6|7|V|8|@]|D|@]|E|$]]]|G|$H|$5|I|J|K|E|$L|M]]]]

In MySQLi use <a href="http://www.php.net/manual/en/mysqli-stmt.bind-result.php" rel="noreferrer"><code>bind_result</code></a>: it sets the correct type and handles <code>NULL</code>.

blocks|key|786186|text|如果您运行的是Ubuntu：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|786187|sudo++apt-get+remove+php5-mysql
sudo++apt-get+install+php5-mysqlnd
sudo+service+apache2+restart|code-block|syntax|javascript|786188|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If you are running Ubuntu:

<pre><code>sudo apt-get remove php5-mysql
sudo apt-get install php5-mysqlnd
sudo service apache2 restart
</code></pre>

blocks|key|785995|text|从MySQL数据库中提取数据后，可以使用类型转换|type|unstyled|depth|inlineStyleRanges|entityRanges|data|785996|$row['field']+=+(int)$row['field'];|code-block|syntax|javascript|785997|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You could use type casting once you've pulled the data from your MySQL database

<pre><code>$row['field'] = (int)$row['field'];
</code></pre>

blocks|key|785874|text|由于PHP不是一种强类型语言，这在某种程度上是没有意义的，但您当然可以在使用之前通过settype等简单地将有问题的字段转换为一个整数。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|785875|不管怎样，(据我所知)没有办法自动维护这种“类型”信息。|785876|entityMap|0|LINK|mutability|MUTABLE|url|http://www.php.net/manual/en/function.settype.php^0|16|7|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

As PHP isn't a strongly typed language, this is somewhat meaningless, but you could of course simply cast the field in question to an int via <a href="http://www.php.net/manual/en/function.settype.php" rel="nofollow">settype</a>, etc. prior to usage.

Irrespective, there's no way (that I know of) to maintain this "type" information automatically.

blocks|key|1000151|text|PHP的MySQL默认库没有任何这样的选项。使用类型转换，如(int)或intval，(float)等|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1000152|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

PHP's default library for MySQL doesn't have any options of this kind. Use type casting
like (int) or intval, (float) etc

blocks|key|1000209|text|在php中，你可以使用(类型)来确保$something是整型的，这有助于sql注入，如果你知道它的话。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1000210|例如：|1000211|(int)+$something;|code-block|syntax|javascript|1000212|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

in php, you can use ([type]) to make sure $something was integer , this help sql injection if you khow about it.

ex:

<pre><code>(int) $something;
</code></pre>

blocks|key|1000371|text|我不知道你是在什么情况下问这个问题的。因为php变量的数据类型依赖于表中列的数据类型。如果列在mysql中的数据类型是"int“，那么在php中会得到一个整数(而不是字符串)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1000372|但无论如何，您都可以使用is_numeric()、is_int()或gettype()+php函数来了解Mysql返回值的数据类型。is_numeric()的问题是，即使变量包含数字字符串，例如"2“，它也会返回true。但是在前面提到的例子中，gettype()将返回"string“，而is_int()将始终返回false，即"2”。|1000373|一旦知道了返回值的数据类型，就可以绑定php变量来通过类型转换来维护该类型，如下所示：|1000374|//+Suppose+this+is+the+returned+value+from+mysql+and
//+you+do+not+know+its+data+type.
$foo+=+"2";

if+(gettype($foo)+==+"string"){
++++$foo+=+(string)+$foo;
}|code-block|syntax|javascript|1000375|您可以对变量的数据类型进行多次检查，然后进行相应的强制转换。|1000376|我希望这份答复会有所帮助。祝你好运！:)|1000377|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|S|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|T|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

I don't know in what context you asked this question. Because the data type of a php variable is dependent on what data type a column in your table has. If the column has data type "int" in mysql, you get an integer in php (not a string).

But anyways, you can use either is_numeric(), is_int() or gettype() php functions to know the data type of a returned value from Mysql. The problem with is_numeric() is that it returns true even if a variable contains a numeric string e.g. "2". 
But gettype() will return "string" and is_int() will always return false in the example mentioned i.e. "2".

Once you know the data type of a returned value you can bind the php variable to maintain that type by type casting like this:

<pre><code>// Suppose this is the returned value from mysql and
// you do not know its data type.
$foo = "2";

if (gettype($foo) == "string"){
 $foo = (string) $foo;
}
</code></pre>

You can make several checks for what data type the variable has and then cast it accordingly.

I hope this reply would be helpful. Good luck! :)

When data is returned from MySQL, it is automatically returned as strings, regardless of the MySQL data type.

Is there any way to tell MySQL/PHP to maintain the data types (e.g. int), so if you query an int column, you get an integer in PHP instead of a string?

How to get an integer from MySQL as integer in PHP?

SQL数据库

数据库

Ubuntu

MySQL

无论MySQL数据类型如何，从MySQL返回数据时，数据都会自动作为字符串返回。有没有办法告诉MySQL/PHP保持数据类型(例如int)，这样当你查询一个int列时，你会得到一个整数而不是一个字符串？

问如何在PHP中从MySQL中获取一个整数？
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在PHP中从MySQL中获取一个整数？EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在PHP中从MySQL中获取一个整数？
EN