PHP Classes

Array Search: Search and filter array data using MySQL database

Recommend this page to a friend!
     
  Info   Example   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 584 All time: 5,298 This week: 57Up
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: 29
All time rank: 2034293 in United States United States
Week rank: 195 Up19 in United States United States Up

Level 4 StarStarStarStar

 Innovation award
Innovation award
Nominee: 4x

Winner: 1x

Example

<pre>
<?php

require_once('arraySearch.class.php');

// API call (or whatever) for data
$response = json_decode(file_get_contents('arraySearch.example.data.php'),true);

/*********************************************/

// Initialize arraySearch Object
//$mysqli = new mysqli($server, $user, $pass, $db);
$arraySearch = new arraySearch($mysqli);

// Assign object an array
$arraySearch->todoList = $response['todos'];
// Note: this array can be ($incrementer => $field) or ($field => $incrementer)
// the result will be returned in the same format it was supplied in.

/*********************************************/

// Now we can start reading out, this will print all the data we just put in
echo '<br/> Example 1: Printing all the data<br/>';
print_r($arraySearch->todoList->data());

/*********************************************/

// Or we could run the data through a filter
echo '<br/> Example 2.0: Using filters on the data<br/>';
print_r($arraySearch->todoList->filterBy(['Priority' => '10'])->data());

// We can also use WildCards and Inclusive Arrays in these filters
echo '<br/> Example 2.1: Using wildcards in the filters<br/>';
print_r($arraySearch->todoList->filterBy(['Description' => '%important%', 'Priority' => ['8','9','10']])->data());

/*********************************************/

// We also have the ability to modify the data in the object, before or after the filter
echo '<br/> Example 3: Modifying data after the filter<br/>';
print_r($arraySearch->todoList->filterBy(['Priority' => ['1','2','3','4']])->modify(['Priority' => '5'])->data());

/*********************************************/

?>
</pre>

  Files folder image Files (3)  
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

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
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:584
This week:0
All time:5,298
This week:57Up

  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.