Login   Register  
PHP Classes
elePHPant
Icontem

LINQ In PHP: Query arrays with a SQL-like syntax using LINQ

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

  Author Author  
Picture of Tufan Baris YILDIRIM
Name: Tufan Baris YILDIRIM is available for providing paid consulting. Contact Tufan Baris YILDIRIM .
Classes: 11 packages by
Country: Turkey Turkey
Age: 25
All time rank: 1914 in Turkey Turkey
Week rank: 62 Up1 in Turkey Turkey Up
Innovation award
Innovation award
Nominee: 5x

Winner: 4x


  Detailed description   Download Download .zip .tar.gz   Install with Composer Install with Composer  
This class can be used to query arrays,html,xml or json file with a SQL-like syntax using LINQ.

It takes an array as parameter and can perform several types of queries using an SQL-like syntax as if the array was a relational database.

Currently it supports performing SELECT , DELETE, INSERT and UPDATE queries.

Example SELECT Queries:
========================
- SELECT *FROM myArray ORDER BY key DESC,value ASC,
- SELECT key,value FROM myArray WHERE value='100',
- SELECT * FROM json_file(my_json_file.txt),
- SELECT * FROM xml_file(http://tufyta.com/feed/).channel.item WHERE title LIKE '%linq%'
- SELECT *FROM html_file(http://tufyta.com).div WHERE class='post_title'
- SELECT *FROM text_file(data.txt) WHERE in_array('.line.',array(1,2,3,4,5,6,))
-SELECT * FROM dir_files(doc).files WHERE name LIKE '%D3Linq%'
- SELECT *FROM myArray.subitems WHERE name='Tufan'
- SELECT DISTINCT surname FROM personnels ORDER BY surname DESC

Example INSERT Queries:
========================
- INSERT INTO myArray (name,surname) VALUES ('Tufan','YILDIRIM')
- INSERT INTO myArray.subitems ('known_langs') VALUES ('PHP,C#,C++')

Example UPDATE Queries:
========================
- UPDATE myArray SET name='TUFAN' WHERE surname='YILDIRIM',
- UPDATE myarray.subitems SET known_lags='PHP,C#'

Example DELETE Queries:
========================
- DELETE FROM myArray WHERE name='Tufan'
- DELETE FROM myArray.subistems WHERE known_language LIKE '%PHP%'

  Classes of Tufan Baris YILDIRIM  >  LINQ In PHP  >  Download Download .zip .tar.gz  >  Support forum Support forum (17)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: LINQ In PHP
Base name: linq-in-php
Description: Query arrays with a SQL-like syntax using LINQ
Version: 1.6.0
PHP version: 5.3
License: Artistic License
All time users: 3635 users
All time rank: 846
Week users: 10 users
Week rank: 139 Up
 
  Groups   Screenshots Screenshots   Rate classes User ratings   Dependencies  
  Trackback   Applications   Related pages   Files Files  

  Groups  
Group folder image PHP 5 Classes using PHP 5 specific features View top rated classes
Group folder image Databases Database management, accessing and searching View top rated classes
Group folder image Data types Modeling and manipulating data types View top rated classes

  Files folder image Screenshots  
self_debugger.png
File Role Description
Accessible without login Image file self_debugger.png Screen Linq Self Debugger


  Innovation Award  
PHP Programming Innovation award winner
January 2010
Winner


Prize: One copy of the Zend Studio
LINQ is a framework created by Microsoft for querying data sets that may be stored for instance array variables, XML documents or JSON structures. It can use an SQL-like dialect for querying data.

This class provides a pure PHP implementation of the LINQ data querying framework.

Manuel Lemos

  User ratings  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Good (98%) Good (95%) Good (98%) Good (96%) - - Sufficient (78%) 20
Month: Not enough user ratings

  Packages needed by this class  
Class DownloadWhy it is needed Dependency
DB Engine Download .zip .tar.gz db_engine/tools/d3grid.php need for display linq result in a html table. Optional

  Pages that reference this package  
PHP ve LINQ
.NET meraklilari ya da takipšilerinin bir šogu LINQ (Language Integrated Query) i de ayni ilgi ile takip eder...

Latest pages that reference packages Latest pages that reference packages


  Applications that use this package  
Linq Project Page
Main Linq page
Add link image If you know an application of this package, send a message to the author to add a link here.

  Related pages  
PhpLinq History
PHPLinq Blog Page

  Files folder image Files  
File Role Description
Files folder imageExamples (3 files)
Files folder imageFunc_Example (4 files)
Plain text file D3Linq.php Class D3Linq Class File
Accessible without login Plain text file debug_example.php Example Activating Self Debugger on error
Accessible without login HTML file Doc Doc. Change Log
Accessible without login Plain text file linq_test.php Example Speed Test in big array.

  Files folder image Files  /  Examples  
File Role Description
  Accessible without login Plain text file Example.php Example Linq in PHP Example Queries
  Accessible without login Plain text file Insert_Example Example Example Insert Queries
  Accessible without login Plain text file MultiCol_Example Example Linq Example For MultiColumns Arrays

  Files folder image Files  /  Func_Example  
File Role Description
  Accessible without login Plain text file dir_files.php Example Select *from dir_files
  Accessible without login Plain text file json_file_Examle.php Example Select *from json_file(....
  Accessible without login Plain text file my_json_file.txt Data Json Database File
  Accessible without login Plain text file xml_file_Examle.php Example Select *from xml_file(...

Install with Composer Install with Composer - Download Download all files: linq-in-php.tar.gz linq-in-php.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.