Top rated packages with tag search mysql

Recommend this page to a friend!

			All class groups	>	Search tags: search mysql

	1. Basic MySQL Search Engine Class		search mysql

Supplied by: padik <e-mail contact>

Search for text in a MySQL database table

This class can be used to search for data in MySQL database table text fields.

It executes one or more SQL SELECT queries to search for given keywords in different text fields of the same MySQL database table.

The class returns an array with the values of primary keys of the table records returned by the queries. Duplicate record entries are eliminated.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (93.8%)`	`Good (93.8%)`	`Sufficient (68.8%)`	`Good (81.2%)`	`-`	`-`	`Sufficient (71.2%)`	153
Month:	Not yet rated by the users

	2. PHP Search		search mysql

Supplied by: Vick <e-mail contact>

Search for data MySQL tables and show the results

This class can perform basic searches in MySQL tables.

It can take parameters that define the tables and fields to be searched and retrieved and the fields that define the results sorting order.

The class returns the search results in the form of an HTML table or a text displaying a message when the search query did not return any results.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (86.4%)`	`Good (86.4%)`	`Sufficient (72.7%)`	`Sufficient (79.5%)`	`-`	`-`	`Sufficient (67.0%)`	334
Month:	Not yet rated by the users

	3. Database Search		search mysql

Supplied by: Tomasz Wilk <e-mail contact>

Search for words and phrases in a a MySQL table

This class can be used to search for words and phrases in text fields of a MySQL database table.

It can generate a Web search form with an input field to enter the search text, a submit button and radio buttons to let the user tell whether the search should find records with all the words or at least one of them. The form text and presentation style is configurable with CSS.

The class can perform the search for the specified text with prior cleanup to avoid security exploits. The searched text is stored in a session variable so the user can be reminded of the last search.

The search can treat words separately or as phrases when the user encloses the words in double quotes.

The search results are returned in an array that contains a list of distinct records that matched the searched text.

The table name and the table fields to be searched and the fields to be returned as result of the search are configurable.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (80.4%)`	`Good (82.1%)`	`Good (83.9%)`	`Good (85.7%)`	`-`	`-`	`Sufficient (65.4%)`	423
Month:	Not yet rated by the users

	4. better_field_search		search mysql

Supplied by: Craig Heydenburg <e-mail contact>

Generalized, flexible class to search a mysql DB

Adapted from Sujith's search_fields class. A generalized, flexible class to search a MySQL DB. You can specify fields to search or display in results. Allows multiple search terms. Has a sample form to implement the class. Easy to implement. Recently added ability to format results independant of class, modify and/or or search, and search multiple tables (via joins). See class file for documentation. Please let me know if you use and like the class.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (81.2%)`	`Sufficient (68.8%)`	`-`	`Not sure (50.0%)`	`-`	`-`	`Not sure (52.5%)`	1322
Month:	Not yet rated by the users

	5. Search Query Generator for MySQL Database		search mysql

Supplied by: Shoeb <e-mail contact>

Generate an SQL query for searching values

This is a very simple class that can be used to build a SQL WHERE clause for performing a query that search for given field values.

It takes as parameter an associative array with the field names as indexes and the field search parameter values as array entry values.

It generates an SQL SELECT query to retrieve all table fields of the records that match a condition defined by the combination of all fields and values defined by the parameter associative array.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Not sure (41.7%)`	`Not sure (41.7%)`	`-`	`Not sure (58.3%)`	`-`	`-`	`Insufficient (30.8%)`	2161
Month:	Not yet rated by the users

Copyright (c) Icontem 1999-2012	PHP Classes	- PHP Class Scripts
	PHP Book Reviews	- Reviews of books and other products