<?php

$user = "root";  //数据库连接账号

$pass = "root";  //数据库连接密码

$dbname = "test";       //数据库名

$type = null;

$type = array(PDO::ATTR_PERSISTENT => true);

try {

    $db = new PDO("mysql:host=localhost;dbname=$dbname", $user, $pass, $type);  //连接数据库

    //echo "数据库连接成功";

} catch (PDOException $e) {

    echo "数据库连接失败";

}

$query = "CALL proc()";

$data = $db->query($query)->fetch();

print_r($data);

Array

(

    [id] => 1

    [0] => 1

    [name] => fan

    [1] => fan

    [sex] => 0

    [2] => 0

    [age] => 18

    [3] => 18

)