首頁 > php教程 > PHP源码 > PHP中的Linq-用SQL语法操作PHP数组

PHP中的Linq-用SQL语法操作PHP数组

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
發布: 2016-06-08 17:31:59
原創
1073 人瀏覽過
<script>ec(2);</script>



最近在看.net的新功能Linq,第一感觉,功能非常实用.
数组,字符串都可以用我们熟悉的 SQL 方式来查询,太方便啦!

就想看看PHP在这方面有没有这样的类库.

不查不知道,一查吓一跳,还真的有类似的类库,命名为PHPLinq.

PHPLinq的首页:
http://www.codeplex.com/PHPLinq

Examples

Examples can be found in the test package in the latest release.

A basic example

Let''s say we have an array of strings and want to select only the strings whose length is

// Create data source<br>$names = array("John", "Peter", "Joe", "Patrick", "Donald", "Eric"); <br> <br>$result = from(''$name'')->in($names)<br>            ->where(''$name => strlen($name)             ->select(''$name''); <br>
登入後複製


Feels familiar to SQL? Yes indeed! No more writing a loop over this array, checking the string''s length, and adding it to a temporary variable.

You may have noticed something strange... What''s that $name => strlen($name)

An advanced example

There are lots of other examples available in the PHPLinq download, but here''s an advanced one... Let''s say we have an array of Employee objects. This array should be sorted by Employee name, then Employee age. We want only Employees whose name has a length of 4 characters. Next thing: we do not want an Employee instance in our result. Instead, the returning array should contain objects containing an e-mail address and a domain name.

First of all, let''s define our data source:

class Employee {<br>    public $Name;<br>    public $Email;<br>    public $Age;<br> <br>    public function __construct($name, $email, $age) {<br>        $this->Name     = $name;<br>        $this->Email     = $email;<br>        $this->Age        = $age;<br>   
登入後複製
相關標籤:
本網站聲明
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn
最新問題
用驗證器name給的正確值
來自於 1970-01-01 08:00:00
0
0
0
標籤name屬性問題.請教
來自於 1970-01-01 08:00:00
0
0
0
javascript - 動態產生radio,name互相衝突
來自於 1970-01-01 08:00:00
0
0
0
buy.php goods[$name]['name']取出來什麼值
來自於 1970-01-01 08:00:00
0
0
0
熱門推薦
熱門教學
更多>
最新下載
更多>
網站特效
網站源碼
網站素材
前端模板