mysql的结果集返回php数组

$pdo = new PDO('mysql:host=localhostdbname=','root','')

$data = $pdo->query('SELECT * FROM `user`')

foreach($data as $v){

echo $v['id']

}

正常情况下你还应该处理异常

try{

$pdo = new PDO('mysql:host=localhostdbname=','root','')

$data = $pdo->query('SELECT * FROM `user`')

foreach($data as $v){

print_r($v)

}

}catch(PDOException $e){

}

将数组序列化存储,例如

$stooges

=

array('Moe','Larry','Curly')

$new

=

serialize($stooges)

print_r($new)echo

"<br

/>"

print_r(unserialize($new))

结果：a:3:{i:0s:3:"Moe"i:1s:5:"Larry"i:2s:5:"Curly"}

Array

(

[0]

=>

Moe

[1]

=>

Larry

[2]

=>

Curly

)

把$new写进数据库就行啦

---