sql连接查询

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

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

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

try {
    $db = new PDO("mysql:host=localhost;dbname=$dbname", $user, $pass);  //连接数据库
	echo "数据库连接成功";
} catch (PDOException $e) {
	echo "数据库连接失败";
}

$sql = "select * from user as a inner join user_identity as b on a.id = b.id"; //内连接user和user_identity表，as 起别名：user代表a，user_identity代表b

//$sql = "select * from user inner join user_identity on user.id = user_identity.id"; // 效果同上

//$sql = "select a.id,a.name,b.identity_number from user as a inner join user_identity as b on a.id = b.id";  //select 和 from 之间的意思是 - 输出a表的id字段，输出a表的name字段，输出b表的identity_number;

$data = $db->query($sql)->fetchAll(PDO::FETCH_ASSOC);

print_r ($data);

Array
(
    [0] => Array
        (
            [id] => 1
            [name] => fan
            [sex] => 0
            [age] => 18
            [identity_number] => 111
        )

    [1] => Array
        (
            [id] => 2
            [name] => jack
            [sex] => 0
            [age] => 25
            [identity_number] => 222
        )

    [2] => Array
        (
            [id] => 3
            [name] => xiaoming
            [sex] => 0
            [age] => 33
            [identity_number] => 333
        )

    [3] => Array
        (
            [id] => 4
            [name] => laowang
            [sex] => 1
            [age] => 50
            [identity_number] => 444
        )

    [4] => Array
        (
            [id] => 5
            [name] => julia
            [sex] => 0
            [age] => 22
            [identity_number] => 555
        )

    [5] => Array
        (
            [id] => 6
            [name] => pangda
            [sex] => 1
            [age] => 53
            [identity_number] => 666
        )

)