对于PDO返回的数组重复值(values are repeated for array returned by PDO)
我使用PDO连接到MySQL数据库并获取所有数据。 当我打印出数组时,重复这些值。 怎么解决? 谢谢
连接到DB:
$db = new PDO("mysql:host=localhost:3306;dbname=$dbName", $user, $pass, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);获取数据并打印出结果:
$result = $db->query("select UserBirthday, UserAddress, UserZipCode, UserPhone, UserFirstName, UserLastName, UserPassword, UserSecurityQuestion from USER_PROFILE where UserID=$userID;")->fetchAll(); print_r($result);打印出来的内容:
Array ( [UserBirthday] => 1999-01-01 [0] => 1999-01-01 [UserAddress] => 1 Infinite Loop Seattle [1] => 1 Infinite Loop Seattle [UserZipCode] => 98125 [2] => 98125 [UserPhone] => 2068874596 [3] => 2068874596 [UserFirstName] => abc [4] => abc [UserLastName] => cdf [5] => cdf [UserPassword] => 5271593ca406362d7a2701e331408ab77d5b5b88 [6] => 5271593ca406362d7a2701e331408ab77d5b5b88 [UserSecurityQuestion] => null [7] => null)I connect to MySQL database using PDO and fetch all the data. When I print out the array, the values are repeated. How to fix it? Thank you
connect to DB:
$db = new PDO("mysql:host=localhost:3306;dbname=$dbName", $user, $pass, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);fetch data and print out the result:
$result = $db->query("select UserBirthday, UserAddress, UserZipCode, UserPhone, UserFirstName, UserLastName, UserPassword, UserSecurityQuestion from USER_PROFILE where UserID=$userID;")->fetchAll(); print_r($result);What it prints out:
Array ( [UserBirthday] => 1999-01-01 [0] => 1999-01-01 [UserAddress] => 1 Infinite Loop Seattle [1] => 1 Infinite Loop Seattle [UserZipCode] => 98125 [2] => 98125 [UserPhone] => 2068874596 [3] => 2068874596 [UserFirstName] => abc [4] => abc [UserLastName] => cdf [5] => cdf [UserPassword] => 5271593ca406362d7a2701e331408ab77d5b5b88 [6] => 5271593ca406362d7a2701e331408ab77d5b5b88 [UserSecurityQuestion] => null [7] => null)最满意答案
默认情况下,PDO将按名称和索引获取列。
使用PDO::FETCH_ASSOC获取模式只按名称获取:
$result = $db->query("select UserBirthday, UserAddress, UserZipCode, UserPhone, UserFirstName, UserLastName, UserPassword, UserSecurityQuestion from USER_PROFILE where UserID=$userID;")->fetchAll(PDO::FETCH_ASSOC);另请参阅替代提取模式 。
By default PDO will fetch columns by name AND index.
Use the PDO::FETCH_ASSOC fetch mode to just fetch by name:
$result = $db->query("select UserBirthday, UserAddress, UserZipCode, UserPhone, UserFirstName, UserLastName, UserPassword, UserSecurityQuestion from USER_PROFILE where UserID=$userID;")->fetchAll(PDO::FETCH_ASSOC);Also check out alternative fetch modes.
更多推荐
发布评论