PHP Classes

LMSQL: Connect and perform MySQL database queries

Recommend this page to a friend!
  Info   View files Documentation   View files View files (7)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2020-04-30 (Less than 1 hour ago) RSS 2.0 feedNot yet rated by the usersTotal: 141 This week: 10All time: 8,912 This week: 31Up
Version License PHP version Categories
lmsql 1.2MIT/X Consortium ...5PHP 5, Databases
Description Author

This class can connect and perform MySQL database queries.

It can connect to a MySQL database using the PDO extension.

The class can also perform common queries taking some parameters like:

- Get data from a table with a condition clause, limit, order and custom sorting by field
- Get one row from a table
- Insert data into a table
- Update table rows
- Delete table rows
- Get the total number of table rows
- Get the last inserted table identifier
- Search in all fields
- Search in specific fields
- Show tables of current database
- Show columns of a table
- Execute a custom SQL query

  Performance   Level  
Name: Arash Soleimani <contact>
Classes: 4 packages by
Country: Iran Iran
Innovation award
Innovation award
Nominee: 2x

 

  Files folder image Files  
File Role Description
Files folder image.github (1 directory)
Files folder imagedemo (2 files)
Accessible without login Plain text file LICENSE Lic. License text
Plain text file mysql.class.php Class Class source
Accessible without login Plain text file README.md Doc. Documentation

  Files folder image Files  /  .github  
File Role Description
Files folder imageISSUE_TEMPLATE (2 files)

  Files folder image Files  /  .github  /  ISSUE_TEMPLATE  
File Role Description
  Accessible without login Plain text file bug_report.md Data Auxiliary data
  Accessible without login Plain text file feature_request.md Data Auxiliary data

  Files folder image Files  /  demo  
File Role Description
  Accessible without login Plain text file insert.php Example insert example
  Accessible without login Plain text file update.php Example update example

 Version Control Unique User Downloads Download Rankings  
 100%
Total:141
This week:10
All time:8,912
This week:31Up

For more information send a message to info at phpclasses dot org.