php对mysql结果集处理

<?php
for ($i=0; $i<3; $i++) {
    $res = connetDB($i);
    print_r('<pre>');
    print_r($res);
}
function connetDB($type){
		$source_server_name='127.0.0.1';
		$source_username='';
		$source_password='';
		$source_database='test';
		$source_conn=@mysql_connect($source_server_name,$source_username,$source_password) or die("error connecting") ; //连接数据库
		@mysql_query("set names 'utf8'"); 
		@mysql_select_db($source_database); //打开数据库
		$sql = 'SELECT * FROM note ';
		$res = @mysql_query($sql, $source_conn);
		$data = [];
        $ar = [];
        $mark = $type == 0 ? 'mysql_fetch_row' : ($type == 1 ? 'mysql_fetch_assoc' : 'mysql_fetch_array');
		while ($row = $mark($res)){ //每次只取一行，指针下移一行，最后没有数据返回false
			$data[$mark] = $row;
		}
		return $data;
}

输出：

Array
(
    [mysql_fetch_row] => Array
        (
            [0] => 1
            [1] => mysql
            [2] => handle result
        )

)
Array
(
    [mysql_fetch_assoc] => Array
        (
            [id] => 1
            [title] => mysql
            [desc] => handle result
        )

)
Array
(
    [mysql_fetch_array] => Array
        (
            [0] => 1
            [id] => 1
            [1] => mysql
            [title] => mysql
            [2] => handle result
            [desc] => handle result
        )

)

mysqli版本

function connetDB($sql, $type){
    $source_server_name='127.0.0.1';
    $source_username='';
    $source_password='';
    $source_database='cpmart';
    $source_conn=mysqli_connect($source_server_name,$source_username,$source_password) or die("error connecting") ; //连接数据库
    mysqli_select_db($source_conn, $source_database); //打开数据库
    $res = mysqli_query($source_conn, $sql);
    $data = [];
    $ar = [];
    $mark = $type == 0 ? 'mysqli_fetch_row' : ($type == 1 ? 'mysqli_fetch_assoc' : 'mysqli_fetch_array');
    while ($row = $mark($res)){ //每次只取一行，指针下移一行，最后没有数据返回false
        $data[$mark] = $row;
    }
    return $data;
}