PHP Classes

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    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 577 All time: 5,320 This week: 135Up
Version License PHP version Categories
array-search 1.1Public Domain5PHP 5, Databases, Searching, Data types
Description 

Author

Matthew Knowlton

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
Picture of Matthew Knowlton
  Performance   Level  
Name: Matthew Knowlton is available for providing paid consulting. Contact Matthew Knowlton .
Classes: 6 packages by
Country: United States United States
Age: 27
All time rank: 2043290 in United States United States
Week rank: 578 Up70 in United States United States Up

Level 4 StarStarStarStar

 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

Downloadarray-search-2015-08-12.zip 2KB
Downloadarray-search-2015-08-12.tar.gz 2KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:577
This week:0
All time:5,320
This week:135Up

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.