PHP Classes
elePHPant
Icontem

Array Search: Search and filter array data using MySQL database

Recommend this page to a friend!
  Info   View files Example   View files View files (3)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2015-08-12 (3 years ago) RSS 2.0 feedNot enough user ratingsTotal: 552 This week: 2All time: 5,368 This week: 190Up
Version License PHP version Categories
array-search 1.1Public Domain5PHP 5, Databases, Searching, Data types
Description Author

This class can search and filter array data using MySQL database.

It can take an array of associative array records and inserts them in a MySQL database.

The class then uses SQL queries to search, filter and sort records using SQL query clauses. This allows the user to use SQL's wildcard and inclusive array search features.

Innovation Award
PHP Programming Innovation award winner
August 2015
Winner


Prize: PhpStorm IDE personal permanent license
PHP provides basic support for searching values in arrays. It would be better if it provided means to search data as SQL databases.

This class provides a solution that leverages the power of SQL databases to provide more flexible array filtering and sorting capabilities.

Despite for small arrays it may much slower than searching arrays in memory, for large arrays it may be a more feasible solution, as it will not require to load the whole arrays in memory to search for their values.

Manuel Lemos
  Performance   Level  
Name: Matthew Knowlton is available for providing paid consulting. Contact Matthew Knowlton .
Classes: 6 packages by
Country: United States United States
Age: 23
All time rank: 2054262 in United States United States
Week rank: 129 Up11 in United States United States Up
Innovation award
Innovation award
Nominee: 4x

Winner: 1x

  Files folder image Files  
File Role Description
Plain text file arraySearch.class.php Class Class Source
Accessible without login Plain text file arraySearch.example.php Example Example File
Accessible without login Plain text file arraySearch.example.data.php Data data for search example

 Version Control Unique User Downloads Download Rankings  
 0%
Total:552
This week:2
All time:5,368
This week:190Up