Query on PHP arrays

Question

Consider following scenario: You have a small MogoDB collection or a small MySQL table (contains 1000 record for example, it may be read-only too ) that is used extensively and repeatedly in your app.

You decide to fetch all of its content to a PHP array and use the array instead of sending a lot of query to DB.

In above scenario how can we retrieve some array items in a manner similar to retrieving records of a DB table in an efficient way? A PDO adapter for array or any other similar facility ...

http://stackoverflow.com/questions/5792388/is-there-something-in-php-equivalent-to-linq-in-c — Handsome Nerd, Nov 13 '13 at 09:41

score 2 · Accepted Answer · edited May 30 '17 at 21:02

2

There is port of famous C# LINQ library for php.

It gives you flexible oo interface to querying data sources.

http://phplinq.codeplex.com/wikipage?title=Examples&referringTitle=Home

Simple example

// Create data source
$names = array("John", "Peter", "Joe", "Patrick", "Donald", "Eric"); 

$result = from('$name')->in($names)
            ->where('$name => strlen($name) < 5')
            ->select('$name');

edited May 30 '17 at 21:02

marc_s

732,580
175
1,330
1,459

answered Jan 13 '13 at 10:31

Fivell

11,829
3
61
99

http://habrastorage.org/storage2/b3c/95c/3f4/b3c95c3f427b11617bfe086504bc893b.png – Handsome Nerd Nov 13 '13 at 09:40

score 1 · Answer 2 · answered Jan 13 '13 at 10:23

While you could use a combination of array_filter and the function niehztog proposed at php.net ( http://pl1.php.net/manual/en/function.array-filter.php#87912 ), I believe even with small amounts of data you will still find querying the db faster than trying to achieve the same with array processing.

Remember that MySQL caches query results - so you just hit memory with repeated queries and not the disk.

Query on PHP arrays

2 Answers2