Login   Register  
PHP Classes
elePHPant
Icontem

LINQ In PHP

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

  Author  
Picture of Tufan Baris YILDIRIM
Name: Tufan Baris YILDIRIM is available for providing paid consulting. Contact Tufan Baris YILDIRIM .
Packages: 11 Browse all classes by Tufan Baris YILDIRIM Browse all classes by
Country: Turkey Turkey - PHP jobs in Turkey
Age: 23
All time rank: 2294 in Turkey Turkey
Week rank: 49 Up1 in Turkey Turkey Up
Innovation award
Innovation award
Nominee: 5x

Winner: 4x


  Detailed description   Download .zip .tar.gz  
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 .zip .tar.gz  >  Support forum Support forum (15)  >  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: 3095 users
All time rank: 1024
Week users: 11 users
Week rank: 168 Up
 
  Groups   Screenshots Screenshots   Rate classes User ratings   Dependencies  
  Trackback   Applications   Related links   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  
Linq Self Debugger
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  
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Good (98.7%)
Good (96.1%)
Good (98.1%)
Good (96.1%)
-
-
Sufficient (78.4%)
17
Month:
There are not enough user ratings to display for this class.

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

  Trackback links  
Link Description
PHP ve LINQ .NET meraklilari ya da takipçilerinin bir çogu LINQ (Language Integrated Query) i de ayni ilgi ile takip eder...

  Applications that use this class  
Link Description
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 links  
Link Description
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  /  Files folder image 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  /  Files folder image 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(...

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.