PHP Classes

MySQL Search: Search several fields in MySQL database and create results page

Recommend this page to a friend!
  All requests RSS feed  >  MySQL Search  >  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  

MySQL Search

Edit

Picture of domenic by domenic - 9 years ago (2015-05-06)

Search several fields in MySQL database and create results page

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

+4

It needs to be implemented all in PHP.

Ask clarification

1 Recommendation

Ultimate MySQL: MySQL database access wrapper

This class is the ultimate MySQL database access wrapper

It can:

- Establish MySQL server connections
- Execute SQL queries
- Query a single value or a single row
- Retrieve query results into arrays or resource objects
- Retrieve the last inserted ID
- Manage transactions (transaction processing)
- Retrieve the list tables of a database
- Retrieve the list fields of a table
- Retrieve the length or position of a field
- Measure the time a query takes to execute
- Display query results in an HTML table
- Format SQL parameters (safe against SQL injection hacks)
- Generate SQL
- Handle errors (optional Exception handling)
- Convert records into XML or JSON
- Uses the mysqli extension
This recommendation solves the problem.
This recommendation does not solve the problem.

+1

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

You are in luck with the PHP requirement since this is a site dedicated to PHP classes :)

This package is a mysql wrapper using the msqli extension (you have to avoid ones using the mysql extension since it is deprecated). It will allow you to query the database and send the results to a page. 

Recommend package
: 
: