我正在尝试从 MySQL 数据库获取数据PDO但不幸的是PDO以字符串数组形式返回结果。我想在结果数组中保留本机 MySQL 数据类型。
我尝试过设置PDO::ATTR_DEFAULT_FETCH_MODE二者皆是PDO::FETCH_ASSOC AND PDO::FETCH_OBJ但它仍在返回INT数据为字符串。
这是转储的结果：
array (size=1)
0 =>
object(stdClass)[27]
public 'id' => string '3' (length=1)
public 'avatar' => string '' (length=0)
public 'fullName' => string 'Mikheil Janiashvili' (length=19)
public 'email' => string '[email protected]' (length=17)
public 'phone' => string '23 3537 20 03544' (length=12)
public 'educationGE' => string '' (length=0)
public 'educationEN' => string '' (length=0)
public 'educationRU' => string '' (length=0)
public 'experienceGE' => string '' (length=0)
public 'experienceEN' => string '' (length=0)
public 'experienceRU' => string '' (length=0)
public 'descriptionGE' => string '' (length=0)
public 'descriptionEN' => string '' (length=0)
public 'descriptionRU' => string '' (length=0)
当你实例化 PDO 对象时，你需要告诉它使用 MySQL 的本机准备好的查询：
$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
假设您使用 PHP >= 5.3，您将使用 mysqlnd 库，它可以从准备好的查询中返回正确的数据类型。
Example:
$ php -a
Interactive shell
php > $db = PDO("mysql:host=localhost;dbname=test", "test", "");
php > $res = $db->query("SELECT 1 as num, PI()");
php > var_dump($res->fetch(PDO::FETCH_ASSOC));
array(2) {
["num"] => string(1) "1"
["PI()"] => string(8) "3.141593"
}
php > $db = PDO("mysql:host=localhost;dbname=test", "test", "", [PDO::ATTR_EMULATE_PREPARES=>false]);
php > $res = $db->query("SELECT 1 as num, PI()");
php > var_dump($res->fetch(PDO::FETCH_ASSOC));
array(2) {
["num"] => int(1)
["PI()"] => float(3.141593)
}
php >
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系:hwhale#tublm.com(使用前将#替换为@)
