mysql 结果集什么意思

什么意思"/>

mysql 结果集什么意思

对于MySQL应该也不是很陌生吧，我常常爱犯的以错误就是执行mysli_qurey()后就使用数据，忘记返回的是结果集了。而对于lSELECT,、SHOW, DESCRIBE 、 EXPLAINmysql_query返回的是mysqli_result object,也就是结果集对象；对于其他的mysql_query返回bool值，我在想为啥一个对象可以遍历呢，查看：

mysqli_result implementsTraversable {/*Properties*/int$current_field;

int$field_count;array $lengths;

int$num_rows;/*Methods*/bool data_seek ( int$offset)mixed fetch_all ([ int $resulttype =MYSQLI_NUM ] )mixed fetch_array ([ int $resulttype =MYSQLI_BOTH ] )arrayfetch_assoc ( void )object fetch_field_direct ( int $fieldnr)objectfetch_field ( void )arrayfetch_fields ( void )object fetch_object ([ string $class_name = "stdClass" [, array $params]] )mixedfetch_row ( void )

bool field_seek ( int$fieldnr)

void free ( void )

}

mysqli_result是实现Traversable接口，手册是这样说的：

Iterator support was added, as mysqli_result now implements Travers