首页 > php教程 > PHP源码 > 正文

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

php中文网
发布: 2016-06-08 17:31:59
原创
1249人浏览过
<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

立即学习PHP免费学习笔记(深入)”;

// Create data source<br />$names = array("John", "Peter", "Joe", "Patrick", "Donald", "Eric"); <br /> <br />$result = from(''$name'')->in($names)<br />            ->where(''$name => strlen($name) < 5'')<br />            ->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-&gt;Name     = $name;<br>        $this-&gt;Email     = $email;<br>        $this-&gt;Age        = $age;<br>
登录后复制
PHP速学教程(入门到精通)
PHP速学教程(入门到精通)

PHP怎么学习?PHP怎么入门?PHP在哪学?PHP怎么学才快?不用担心,这里为大家提供了PHP速学教程(入门到精通),有需要的小伙伴保存下载就能学习啦!

下载
来源:php中文网
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn
最新问题
开源免费商场系统广告
热门教程
更多>
最新下载
更多>
网站特效
网站源码
网站素材
前端模板
关于我们 免责申明 意见反馈 讲师合作 广告合作 最新更新
php中文网:公益在线php培训,帮助PHP学习者快速成长!
关注服务号 技术交流群
PHP中文网订阅号
每天精选资源文章推送
PHP中文网APP
随时随地碎片化学习
PHP中文网抖音号
发现有趣的

Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号