PHP 是否有类似于 .NET 的 DataSet 的构造?

2022-01-21 00:00:00 dataset php mysql .net

如何在 PHP 中实现 DataSet,如 .NET?

How can I implement a DataSet in PHP like .NET?

我希望这个类只从数据库中读取一次数据,然后我应该能够使用这些数据而无需再次连接到 MySQL 来运行查询.

I want this class to read data from database only once, then I should be able to use the data without connecting again to MySQL to run queries.

select * from user

当我在 DataSet 上运行此查询时,数据是从内存中获取的.

When I run this query on the DataSet the data is fetched from memory.

如何在 PHP 中实现这种机制?

How can I implement this mechanism in PHP?

推荐答案

你可以像这样将数据推送到数组中:

You could push your data into an array like this:

$result = mysql_query( 'select * from user' );

$results = array();
while ( $row = mysql_fetch_array( $result ) ) {
    array_push( $results, $row );
}

mysql_close();

然后你就可以对数组做任何你想做的操作了……

Then you can do whatever operations you want on the array...

foreach( $results as $record ){
    $foo = $record['col_name'];
    //...
}

相关文章