Subscribe: PHPLinq Wiki & Documentation Rss Feed
http://phplinq.codeplex.com/project/feeds/rss?ProjectRSSFeed=codeplex://wiki/phplinq
Preview: PHPLinq Wiki & Documentation Rss Feed

PHPLinq Wiki & Documentation Rss Feed



PHPLinq Wiki Rss Description



 



New Comment on "Examples"

Wed, 15 Jan 2014 07:51:50 GMT

That is a very graceful way of coding. It looks like 'linq to object' in .NET framework platform.



New Comment on "Examples"

Thu, 12 Dec 2013 22:47:43 GMT

I'm not sure about this syntax. Defining code as strings is kind of rough. I guess that php isn't really very mature when it comes to passing anonymous functions around?



Updated Wiki: Home

Fri, 08 Apr 2011 06:03:19 GMT

Home Features Requirements Examples FAQ Contribute Credits Contact

 

PHP LINQ classes

A set of PHP classes mimicing C#3.0's LINQ (Language Integrated Query) extension methods.
Checkout the Examples and Features this class set provides!

Want to bookmark this page? Please use http://www.phplinq.net as the URL.

We are aware of other PHP LINQ implementations (http://plinq.codeplex.com/ and http://linqforphp.codeplex.com/). We received numerous comments about the fact that PHPLinq is not using closures. The reason for this is simple: closures would be our preferred way of doing things, however closures would make it impossible to do things described in this blog post: one query that you write in PHP can be translated into SQL statements. If someone knows of a good way of parsing and tokenizing closures at runtime, we can proceed in the good direction...

Want to contribute?

Please refer the Contribute page.

Downloads

Current release: PHPLinq 0.4.0
Snapshot: http://www.codeplex.com/PHPLinq/SourceControl/ListDownloadableCommits.aspx

News

2009-01-29 Blog post on PHPLinq 0.4.0

Check my blog at http://blog.maartenballiauw.be/post/2009/01/29/PHPLinq-040-released-on-CodePlex!.aspx for a post on PHPLinq.

2009-01-27 Version 0.4.0 released!

Check the release page for PHPLinq 0.4.0.

2008-06-23 Version 0.3.0 released!

Check the release page for PHPLinq 0.3.0.

2008-01-18 Version 0.2.0 released!

Check the release page for PHPLinq 0.2.0.

2008-01-18 Project started on CodePlex

Check the initial release PHPLinq 0.1.0.

Team members

Check the Credits for a complete list of team members.




Updated Wiki: Home

Fri, 08 Apr 2011 06:03:02 GMT

Home Features Requirements Examples FAQ Contribute Credits Contact

 

PHP LINQ classes

A set of PHP classes mimicing C#3.0's LINQ (Language Integrated Query) extension methods.
Checkout the Examples and Features this class set provides!

Want to bookmark this page? Please use http://www.phplinq.net as the URL.

We are axware of other PHP LINQ implementations (http://plinq.codeplex.com/ and http://linqforphp.codeplex.com/). We received numerous comments about the fact that PHPLinq is not using closures. The reason for this is simple: closures would be our prefered way of doing things, however closures would make it impossible to do things described in this blog post: one query that you write in PHP can be translated into SQL statements. If someone knows of a good way of parsing and tokenizing closures at runtime, we can proceed in the good direction...

Want to contribute?

Please refer the Contribute page.

Downloads

Current release: PHPLinq 0.4.0
Snapshot: http://www.codeplex.com/PHPLinq/SourceControl/ListDownloadableCommits.aspx

News

2009-01-29 Blog post on PHPLinq 0.4.0

Check my blog at http://blog.maartenballiauw.be/post/2009/01/29/PHPLinq-040-released-on-CodePlex!.aspx for a post on PHPLinq.

2009-01-27 Version 0.4.0 released!

Check the release page for PHPLinq 0.4.0.

2008-06-23 Version 0.3.0 released!

Check the release page for PHPLinq 0.3.0.

2008-01-18 Version 0.2.0 released!

Check the release page for PHPLinq 0.2.0.

2008-01-18 Project started on CodePlex

Check the initial release PHPLinq 0.1.0.

Team members

Check the Credits for a complete list of team members.




Updated Wiki: Home

Fri, 08 Apr 2011 06:02:19 GMT

Home Features Requirements Examples FAQ Contribute Credits Contact

 

PHP LINQ classes

A set of PHP classes mimicing C#3.0's LINQ (Language Integrated Query) extension methods.
Checkout the Examples and Features this class set provides!

Want to bookmark this page? Please use http://www.phplinq.net as the URL.

We are axware of other PHP LINQ implementations (http://plinq.codeplex.com/ and http://linqforphp.codeplex.com/). We received numerous comments about the fact that PHPLinq is not using closures. The reason for this is simple: closures would be our prefered way of doing things, however closures would make it impossible to do things described in this blog post: one query that you write in PHP can be translated into SQL statements. If someone knows of a good way of parsing and tokenizing closures at runtime, we can proceed in the good direction...

 

Want to contribute?

Please refer the Contribute page.

Downloads

Current release: PHPLinq 0.4.0
Snapshot: http://www.codeplex.com/PHPLinq/SourceControl/ListDownloadableCommits.aspx

News

2009-01-29 Blog post on PHPLinq 0.4.0

Check my blog at http://blog.maartenballiauw.be/post/2009/01/29/PHPLinq-040-released-on-CodePlex!.aspx for a post on PHPLinq.

2009-01-27 Version 0.4.0 released!

Check the release page for PHPLinq 0.4.0.

2008-06-23 Version 0.3.0 released!

Check the release page for PHPLinq 0.3.0.

2008-01-18 Version 0.2.0 released!

Check the release page for PHPLinq 0.2.0.

2008-01-18 Project started on CodePlex

Check the initial release PHPLinq 0.1.0.

Team members

Check the Credits for a complete list of team members.




New Comment on "Contribute"

Wed, 08 Dec 2010 15:38:07 GMT

Very good project... Just one detail... I've changed all of your "require_once 'file.php'" by "require_once dirname(__FILE__).'/file.php'" because of integration problems of your code in my system.



New Comment on "Examples"

Fri, 16 Jul 2010 07:30:38 GMT

how about the performance?



New Comment on "Examples"

Tue, 22 Jun 2010 08:27:13 GMT

ok thank you i Know now



New Comment on "Examples"

Tue, 22 Jun 2010 08:10:44 GMT

this code where i use it . i mean any Environment programming i must use. are this php code . write it like any code in my editor. . Maybe



New Comment on "Examples"

Tue, 03 Nov 2009 19:43:40 GMT

Have not benchmarked...



New Comment on "Examples"

Tue, 03 Nov 2009 16:45:40 GMT

I wonder how much overhead is involved when using PHPLinq. Don't get me wrong, it's great to see, but I'm the curious type when it comes to how preformance (memory/speed/disk/etc) is affected.



New Comment on "Examples"

Tue, 03 Nov 2009 16:45:04 GMT

I wonder how much overhead is involved when using PHPLinq. Don't get me wrong, it's great to see, but I'm the curious type when it comes to how preformance (memory/speed/disk/etc) is effected.



Updated Wiki: Home

Thu, 29 Jan 2009 11:30:41 GMT

Home Features Requirements Examples FAQ Contribute Credits Contact

PHP LINQ classes

A set of PHP classes mimicing C#3.0's LINQ (Language Integrated Query) extension methods.
Checkout the Examples and Features this class set provides!

Want to bookmark this page? Please use http://www.phplinq.net as the URL.

Want to contribute?

Please refer the Contribute page.

Downloads

Current release: PHPLinq 0.4.0
Snapshot: http://www.codeplex.com/PHPLinq/SourceControl/ListDownloadableCommits.aspx

News

2009-01-29 Blog post on PHPLinq 0.4.0

Check my blog at http://blog.maartenballiauw.be/post/2009/01/29/PHPLinq-040-released-on-CodePlex!.aspx for a post on PHPLinq.

2009-01-27 Version 0.4.0 released!

Check the release page for PHPLinq 0.4.0.

2008-06-23 Version 0.3.0 released!

Check the release page for PHPLinq 0.3.0.

2008-01-18 Version 0.2.0 released!

Check the release page for PHPLinq 0.2.0.

2008-01-18 Project started on CodePlex

Check the initial release PHPLinq 0.1.0.


Team members

Check the Credits for a complete list of team members.



Updated Wiki: Home

Thu, 29 Jan 2009 11:27:01 GMT

Home Features Requirements Examples FAQ Contribute Credits Contact

PHP LINQ classes

A set of PHP classes mimicing C#3.0's LINQ (Language Integrated Query) extension methods.
Checkout the Examples and Features this class set provides!

Want to bookmark this page? Please use http://www.phplinq.net as the URL.

Want to contribute?

Please refer the Contribute page.

Downloads

Current release: PHPLinq 0.4.0
Snapshot: http://www.codeplex.com/PHPLinq/SourceControl/ListDownloadableCommits.aspx

News

2009-01-29 Blog post on PHPLinq 0.4.0

Check my blog at http://blog.maartenballiauw.be/post/2009/01/29/PHPLinq-040-released-on-CodePlex!.aspx for a post on PHPLinq.

2009-01-27 Version 0.4.0 released!

Check the release page for PHPLinq 0.4.0.

2008-06-23 Version 0.3.0 released!

Check the release page for PHPLinq 0.3.0.

2008-01-18 Version 0.2.0 released!

Check the release page for PHPLinq 0.2.0.

2008-01-18 Project started on CodePlex

Check the initial release PHPLinq 0.1.0.


Team members

Check the Credits for a complete list of team members.



Updated Wiki: Home

Tue, 27 Jan 2009 08:11:22 GMT

Home Features Requirements Examples FAQ Contribute Credits Contact

PHP LINQ classes

A set of PHP classes mimicing C#3.0's LINQ (Language Integrated Query) extension methods.
Checkout the Examples and Features this class set provides!

Want to bookmark this page? Please use http://www.phplinq.net as the URL.

Want to contribute?

Please refer the Contribute page.

Downloads

Current release: PHPLinq 0.4.0
Snapshot: http://www.codeplex.com/PHPLinq/SourceControl/ListDownloadableCommits.aspx

News

2009-01-27 Version 0.4.0 released!

Check the release page for PHPLinq 0.4.0.

2008-06-23 Version 0.3.0 released!

Check the release page for PHPLinq 0.3.0.

2008-01-18 Version 0.2.0 released!

Check the release page for PHPLinq 0.2.0.

2008-01-18 Project started on CodePlex

Check the initial release PHPLinq 0.1.0.


Team members

Check the Credits for a complete list of team members.



Updated Wiki: Home

Tue, 27 Jan 2009 08:09:54 GMT

Home Features Requirements Examples FAQ Contribute Credits Contact

PHP LINQ classes

A set of PHP classes mimicing C#3.0's LINQ (Language Integrated Query) extension methods.
Checkout the Examples and Features this class set provides!

Want to bookmark this page? Please use http://www.phplinq.net as the URL.

Want to contribute?

Please refer the Contribute page.

Downloads

Current release: PHPLinq 0.3.0
Snapshot: http://www.codeplex.com/PHPLinq/SourceControl/ListDownloadableCommits.aspx

News

2009-01-27 Version 0.7.0 released!

Check the release page for PHPLinq 0.4.0.

2008-06-23 Version 0.3.0 released!

Check the release page for PHPLinq 0.3.0.

2008-01-18 Version 0.2.0 released!

Check the release page for PHPLinq 0.2.0.

2008-01-18 Project started on CodePlex

Check the initial release PHPLinq 0.1.0.


Team members

Check the Credits for a complete list of team members.



Updated Wiki: Home

Mon, 23 Jun 2008 12:32:34 GMT

Home Features Requirements Examples FAQ Contribute Credits Contact

PHP LINQ classes

A set of PHP classes mimicing C#3.0's LINQ (Language Integrated Query) extension methods.
Checkout the Examples and Features this class set provides!

Want to bookmark this page? Please use http://www.phplinq.net as the URL.

Want to contribute?

Please refer the Contribute page.

Downloads

Current release: PHPLinq 0.3.0
Snapshot: http://www.codeplex.com/PHPLinq/SourceControl/ListDownloadableCommits.aspx

News

2008-06-23 Version 0.3.0 released!

Check the release page for PHPLinq 0.3.0.

2008-01-18 Version 0.2.0 released!

Check the release page for PHPLinq 0.2.0.

2008-01-18 Project started on CodePlex

Check the initial release PHPLinq 0.1.0.


Team members

Check the Credits for a complete list of team members.



UPDATED WIKI: Home

Fri, 29 Feb 2008 10:30:55 GMT

Home Features Requirements Examples FAQ Contribute Credits Contact

PHP LINQ classes

A set of PHP classes mimicing C#3.0's LINQ (Language Integrated Query) extension methods.
Checkout the Examples and Features this class set provides!

Want to bookmark this page? Please use http://www.phplinq.net as the URL.

Want to contribute?

Please refer the Contribute page.

Downloads

Current release: PHPLinq 0.2.0
Snapshot: http://www.codeplex.com/PHPLinq/SourceControl/ListDownloadableCommits.aspx

News

2008-01-18 Version 0.2.0 released!

Check the release page for PHPLinq 0.2.0.

2008-01-18 Project started on CodePlex

Check the initial release PHPLinq 0.1.0.


Team members

Check the Credits for a complete list of team members.



UPDATED WIKI: Examples

Tue, 22 Jan 2008 13:55:28 GMT

Home Features Requirements Examples FAQ Contribute Credits Contact 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 < 5. The PHPLinq way of achieving this would be the following: // Create data source $names = array("John", "Peter", "Joe", "Patrick", "Donald", "Eric"); $result = from('$name')->in($names) ->where('$name => strlen($name) < 5') ->select('$name'); 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) < 5 doing? This piece of code is compiled to an anonymous function or Lambda expression under the covers. This function accepts a parameter $name, and returns a boolean value based on the expression strlen($name) < 5. 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 { public $Name; public $Email; public $Age; public function __construct($name, $email, $age) { $this->Name = $name; $this->Email = $email; $this->Age = $age; } } $employees = array( new Employee('Maarten', 'maarten@example.com', 24), new Employee('Paul', 'paul@example.com', 30), new Employee('Bill', 'bill.a@example.com', 29), new Employee('Bill', 'bill.g@example.com', 28), new Employee('Xavier', 'xavier@example.com', 40) ); Now for the PHPLinq query: $result = from('$employee')->in($employees) ->where('$employee => strlen($employee->Name) == 4') ->orderBy('$employee => $employee->Name') ->thenByDescending('$employee => $employee->Age') ->select('new { "EmailAddress" => $employee->Email, "Domain" => substr($employee->Email, strpos($employee->Email, "@") + 1) }'); Again, you may have noticed something strange... What's this new { } thing doing? Actually, this is converted to an anonymous type under the covers. new { "name" => "test" } is evaluated to an object containing the property "name" with a value of "test". [...]



UPDATED WIKI: Examples

Tue, 22 Jan 2008 13:54:41 GMT

Home Features Requirements Examples FAQ Contribute Credits Contact 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 < 5. The PHPLinq way of achieving this would be the following: // Create data source $names = array("John", "Peter", "Joe", "Patrick", "Donald", "Eric"); $result = from('$name')->in($names) ->where('$name => strlen($name) < 5') ->select('$name'); 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) < 5 doing? This piece of code is compiled to an anonymous function or Lambda expression under the covers. This function accepts a parameter $name, and returns a boolean value based on the expression strlen($name) < 5. 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 { public $Name; public $Email; public $Age; public function __construct($name, $email, $age) { $this->Name = $name; $this->Email = $email; $this->Age = $age; } } $employees = array( new Employee('Maarten', 'maarten@example.com', 24), new Employee('Paul', 'paul@example.com', 30), new Employee('Bill', 'bill.a@example.com', 29), new Employee('Bill', 'bill.g@example.com', 28), new Employee('Xavier', 'xavier@example.com', 40) ); Now for the PHPLinq query: $result = from('$employee')->in($employees) ->where('$employee => strlen($employee->Name) == 4') ->orderBy('$employee => $employee->Name') ->thenByDescending('$employee => $employee->Age') ->select('new { "EmailAddress" => $employee->Email, "Domain" => substr($employee->Email, strpos($employee->Email, "@") + 1) }'); Again, you may have noticed something strange... What's this new { } thing doing? Actually, this is converted to an anonymous type under the covers. new { "name" => "test" } is evaluated to an object containing the property "name" with a value of "test". [...]