blocks|key|1492167|text|首先回答您的最后一个问题：“是”。不幸的是，以字符串形式接收数字是很正常的。正如Pascal引用的手册所说，mysqlnd+(PHP5.3)将从预准备语句返回本机数据类型，前提是您从PDO关闭了预准备语句模拟。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1492168|new+PDO($dsn,+$user,+$pass,+array(
++++PDO::ATTR_EMULATE_PREPARES+=>+false
))|code-block|syntax|javascript|1492169|PDO::ATTR_STRINGIFY_FETCHES与MySQL无关。|1492170|如果从好的方面来看，不管怎样，使用准备好的语句是一个很好的实践，所以...;)|1492171|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

To answer your last question first, "yes," unfortunately it's normal to receive numbers as strings. As the manual quoted by Pascal says, mysqlnd (PHP 5.3) will return native data types from prepared statements, provided you turn off the prepared statement emulation from PDO.

<pre><code>new PDO($dsn, $user, $pass, array(
 PDO::ATTR_EMULATE_PREPARES =&gt; false
))
</code></pre>

PDO::ATTR_STRINGIFY_FETCHES is unrelated to MySQL.

If you look at the bright side, it's good practice to use prepared statements anyway, so... ;)

blocks|key|1492266|text|Pascal's+answer是正确的。我遇到了一些麻烦，使它所有的工作。这是你需要做的。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1492267|首先，确保您已经安装并激活了mysqlnd。看看php+--info吧。在pdo_mysql部分中，它应该如下所示：|style|CODE|1492268|pdo_mysql

PDO+Driver+for+MySQL+=>+enabled
Client+API+version+=>+mysqlnd+5.0.8-dev+-+20102224+-+$Revision:+321|code-block|syntax|javascript|1492269|如果您看到的不是Client+API版本中的mysqlnd，而是下面这样的行...|1492270|Client+API+version+=>+5.5.29|1492271|...then你还没有安装mysqlnd。先处理好这件事。|1492272|其次，PDO使用模拟的预准备语句by+default+for+all+MySQL连接。很可笑，但事实就是如此。而且，只有在使用真正的预准备语句(在链接的博客文章中称为“服务器端预准备语句”，现在是here)时，您才能获得原生数据类型。因此，必须将PDO::ATTR_EMULATE_PREPARES设置为false，如下所示：|1492273|$pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES,+false);|1492274|最后，确保您没有将PDO::ATTR_STRINGIFY_FETCHES设置为true。|1492275|$pdo->setAttribute(PDO::ATTR_STRINGIFY_FETCHES,+false);|1492276|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/1197041/441684|1|https://stackoverflow.com/a/10617155/441684|2|http://blog.ulf-wendel.de/2008/pdo_mysqlnd-the-new-features-of-pdo_mysql/^0|0|F|0|0|O|A|0|0|M|7|0|0|0|G|O|1|2Q|4|2|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1C|8|@]|9|@$A|1D|B|1E|1|1F]]|C|$]]|$1|D|3|E|5|6|7|1G|8|@$A|1H|B|1I|F|G]]|9|@]|C|$]]|$1|H|3|I|5|J|7|1J|8|@]|9|@]|C|$K|L]]|$1|M|3|N|5|6|7|1K|8|@$A|1L|B|1M|F|G]]|9|@]|C|$]]|$1|O|3|P|5|J|7|1N|8|@]|9|@]|C|$K|L]]|$1|Q|3|R|5|6|7|1O|8|@]|9|@]|C|$]]|$1|S|3|T|5|6|7|1P|8|@]|9|@$A|1Q|B|1R|1|1S]|$A|1T|B|1U|1|1V]]|C|$]]|$1|U|3|V|5|J|7|1W|8|@]|9|@]|C|$K|L]]|$1|W|3|X|5|6|7|1X|8|@]|9|@]|C|$]]|$1|Y|3|Z|5|J|7|1Y|8|@]|9|@]|C|$K|L]]|$1|10|3|-4|5|6|7|1Z|8|@]|9|@]|C|$]]]|11|$12|$5|13|14|15|C|$16|17]]|18|$5|13|14|15|C|$16|19]]|1A|$5|13|14|15|C|$16|1B]]]]

<a href="https://stackoverflow.com/a/1197041/441684">Pascal's answer</a> is correct. I had some trouble it making it all work. Here is what you need to do.

First, make sure you have mysqlnd installed and activated. Look at <code>php --info</code>. In the pdo_mysql section, it should look like:

<pre><code>pdo_mysql

PDO Driver for MySQL =&gt; enabled
Client API version =&gt; mysqlnd 5.0.8-dev - 20102224 - $Revision: 321
</code></pre>

If instead of seeing <code>mysqlnd</code> in the Client API version, you see a line like...

<pre><code>Client API version =&gt; 5.5.29
</code></pre>

...then you don't have mysqlnd installed and going. Take care of that first.

Second, PDO uses emulated prepared statements <a href="https://stackoverflow.com/a/10617155/441684">by default for all MySQL</a> connections. Ridiculous, but there it is. And you will get native data types only if you use real prepared statements (called "server-side prepared statements" in the linked blog post, which is now <a href="http://blog.ulf-wendel.de/2008/pdo_mysqlnd-the-new-features-of-pdo_mysql/" rel="noreferrer">here</a>). So you must set PDO::ATTR_EMULATE_PREPARES to false, like so:

<pre><code>$pdo-&gt;setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
</code></pre>

Lastly, make sure that you have not set PDO::ATTR_STRINGIFY_FETCHES to true.

<pre><code>$pdo-&gt;setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
</code></pre>

blocks|key|1277583|text|你可能已经安装了mysqlnd，但这并不意味着它可以被常规的PDO扩展(pdo_mysql)使用，这在共享主机上更常见，所以请确保启用nd_pdo_mysql扩展，并禁用其他扩展pdo_mysql，因为它可能会产生冲突。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1277584|@截图|1277585|​|1277586|📷|atomic|1277587|1277588|我发现了这个(复制的)+question，决定在这里发表我的想法，希望它是好的;)|1277589|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/ccccbde5af6793f13251be5440085757.jpeg|imageAlt|1|LINK|MUTABLE|url|https://stackoverflow.com/q/38107214/1244597^0|8|7|U|3|Z|B|1V|C|2H|9|0|0|0|0|1|0|0|0|C|8|1|0^^$0|@$1|2|3|4|5|6|7|13|8|@$9|14|A|15|B|C]|$9|16|A|17|B|C]|$9|18|A|19|B|C]|$9|1A|A|1B|B|C]|$9|1C|A|1D|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1E|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|1F|8|@]|D|@]|E|$]]|$1|J|3|K|5|L|7|1G|8|@]|D|@$9|1H|A|1I|1|1J]]|E|$]]|$1|M|3|I|5|6|7|1K|8|@]|D|@]|E|$]]|$1|N|3|O|5|6|7|1L|8|@]|D|@$9|1M|A|1N|1|1O]]|E|$]]|$1|P|3|-4|5|6|7|1P|8|@]|D|@]|E|$]]]|Q|$R|$5|S|T|U|E|$V|W|X|-4]]|Y|$5|Z|T|10|E|$11|12]]]]

You might have <code>mysqlnd</code> installed, but it doesn't mean it is ready for use by the regular <code>PDO</code> extension <code>(pdo_mysql)</code>, this is more often the case on shared hosting, so make sure to enable the <code>nd_pdo_mysql</code> extension, and also to disable other extension <code>pdo_mysql</code> as it might create an conflict.

@screenshot

<a href="https://i.stack.imgur.com/FU2Cn.jpg" rel="noreferrer"><img src="https://i.stack.imgur.com/FU2Cn.jpg" alt="enter image description here"></a>

I found this (duplicate) <a href="https://stackoverflow.com/q/38107214/1244597">question</a>, decided to post my thoughts here, hope its fine ;)

I'm using PDO and MySQL, for some reason when getting values from the database that are int type, the PDOStatement is returning a string representation of the number and not a value of numeric type. How do I prevent this from happening?

I noticed there is a attribute of the PDO class: <code>PDO::ATTR_STRINGIFY_FETCHES</code> that is supposed to take care of this but, when trying to modify it, it throws an error saying the attribute is not valid for MySQL driver.

Is it normal to get strings instead of numbers when consulting a database?

How to get numeric types from MySQL using PDO?

数据库

服务器

MySQL

我使用PDO和MySQL，由于某些原因，当从数据库中获取整型的值时，PDOStatement返回的是数字的字符串表示，而不是数字类型的值。如何防止这种情况发生？我注意到PDO类有一个属性：PDO::ATTR_STRINGIFY_FETCHES，它应该处理这个问题，但是，当试图修改它时，它抛出一个错误，指出该属性对MyS...

问如何使用PDO从MySQL中获取数值类型？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用PDO从MySQL中获取数值类型？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用PDO从MySQL中获取数值类型？
EN