PHP Search All Database
With this code, you can search entire database, by narrowing down the tables & column to search in. Giving the flexibility to developer and efficiency to execute faster searches by lowering down the traversing nodes.
Usage
How to use:
Assign keyword to search to varible $search_keyword
$search_keyword = "keyword"; // search KeywordEnter table names & their repective column names in an associative array $table_ass_array to search the given keyword.
$table_ass_array = array(
'TABLE NAME 1' => array( // TABLENAME 1 to search in
'COLUMNNAME_A', // Column Name A to search in
'COLUMNNAME_B' // Column Name B to search in
),
'TABLE NAME 2' => array( // TABLENAME 2 to search in
'COLUMNNAME_A', // Column Name A to search in
'COLUMNNAME_B' // Column Name B to search in
)
);Call this awesome function php_search_all_database("Keyword to search", "Table name array") as below
php_search_all_database($search_keyword, $table_ass_array); // call this Awesomme function