PHP Classes

Find a record into table: I need search any item into table

Recommend this page to a friend!
  All requests RSS feed  >  Find a record into table  >  Request new recommendation  >  A request is featured when there is no good recommended package on the site when it is posted. Featured requests  >  No recommendations No recommendations  

Find a record into table

Edit

Picture of Loscar Luyazan by Loscar Luyazan - 9 years ago (2015-05-15)

I need search any item into table

This request is clear and relevant.
This request is not clear or is not relevant.

0

I have a sorting table. I need finder any record into table.

Ask clarification

2 Recommendations

MySQL Database Library: Access MySQL databases and manipulate files

This class can access MySQL databases and execute common queries. Currently it can:

- Connect to a given MySQL host and access a given database
- List all tables in the accessible databases
- Get the columns of a given table
- Compose and execute SELECT queries to a given table getting specific fields by a given sorting order returning the results into a single array
- Search for given table records that match given conditions
- Insert table records with given field values
- Update table records with given field values and conditions
- Delete table records that match a condition
- Create table records for a new user with a password
- Authenticate a given user with a password in the users table
- Change a given user password in the users table
- Update or delete given user records in the users table
- Read the text contents of files in the format CSV, PDF or Microsoft Word
- Write plain text or CSV files
- Rename or delete files
- Get the list of files from a directory
- Etc..
This recommendation solves the problem.
This recommendation does not solve the problem.

0

Picture of Justin Eldracher by Justin Eldracher package author package author Reputation 160 - 9 years ago (2015-06-22) Comment

Alright, I have a search() method in my DB class that works well for me, as well as a select() method for filtering.


PHP Search: 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.
This recommendation solves the problem.
This recommendation does not solve the problem.

0

Picture of Dave Smith by Dave Smith Reputation 7620 - 9 years ago (2015-05-15) Comment

Assuming that you have a mySQL table, this class is designed to search one or more tables. It may eventually need to be migrated to the mysqli extension, as most will.


Recommend package
: 
: