|
|
| Name: |
SQL Statement |
| Base name: |
sqlstatement |
| Description: |
Compose database queries without writing SQL |
| Version: |
0.8 |
| PHP version: |
5.0 |
| License: |
GNU Lesser General Public License (LGPL) |
| All time users: |
701 users |
| All time rank: |
3834 |
| Week users: |
0 users |
| Week rank: |
2329 |
| |
|
This package can be used to compose SQL database query statements without writing SQL manually.
It can compose the SELECT, INSERT, UPDATE and DELETE queries from a list of table field names and the respective values.
The main class can also associate conditions, order and grouping clauses to the queries. A separate class can be used to associate join condition clauses.
The main class returns SQL strings that can be executed separately.
| Ratings | Utility |
Consistency |
Documentation |
Examples |
Tests |
Videos |
Overall |
Rank |
| All time: |
Good (81.2%) |
Good (93.8%) |
- |
- |
- |
- |
Not sure (50.0%) |
1492 |
| Month: |
Not yet rated by the users |
| |
Packages needed by this class |
|
|
| Class |
Dependency |
Why it is needed |
| Error Class |
Required |
When errors are generated by creation of new SQL strings they can now automatically notify an administrator. |
| |
Applications that use this class |
|
|
No application links were specified for this class.

If you know an application of this package, send a message to the
author to add a link here.
| |
Files |
|
|
| File |
Role |
Description |
class.SQLJoins.php |
Class |
This class is utilized by the SQLStatement class to create the different type of SQL join statements that exist. |
class.SQLStatement.php |
Class |
This is the base class file. Declare new objects using this file. |