MySQL DB Class and Data Manipulation Class
| Recommend this page to a friend! |  Stumble It! |
 Bookmark in del.icio.us |
| Author | ||
 |
|
|||||||||||||||||||
This package is a MySQL database access wrapper with data manipulation functions.
There is one base class that can establish MySQL database connections, sanitize values to use in SQL queries, execute SQL queries, retrieve SELECT query results into arrays, execute SQL INSERT queries and retrieve the last inserted identifier.
There is also a sub-class that can retrieve the list of fields of a table, compose and execute an SQL SELECT, INSERT, UPDATE and DELETE queries from a list of parameters.
There is one base class that can establish MySQL database connections, sanitize values to use in SQL queries, execute SQL queries, retrieve SELECT query results into arrays, execute SQL INSERT queries and retrieve the last inserted identifier.
There is also a sub-class that can retrieve the list of fields of a table, compose and execute an SQL SELECT, INSERT, UPDATE and DELETE queries from a list of parameters.
| Classes of Mitchelle Pascual | > | MySQL DB Class and Data Manipulation Class | > | Download .zip .tar.gz | > |  Support forum (1) |
> |  Blog |
> |   Latest changes |
||
|
|||||||||||||||||||||||
| Groups |  User ratings |
Applications | Related links |  Files |
||||||
| Groups | ||
 |
PHP 5 | Classes using PHP 5 specific features | View top rated classes |
|
Databases | Database management, accessing and searching | View top rated classes |
| User ratings | ||
| Ratings | ||||||||
|---|---|---|---|---|---|---|---|---|
| All time: | ||||||||
| Month: | ||||||||
| 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.| Related links | ||
| Link | Description |
|---|---|
| Data Manipulation DEMO | Data Manipulation DEMO |
| Files |
||
| File | Role | Description | ||
|---|---|---|---|---|
| conf (1 file) |
||||
| includes (1 file, 2 directories) |
||||
 init.php |
Example | Load/Initialize class | ||
| localhost.sql |
Data | db sample | ||
| README.txt |
Doc. | How to use | ||
| sample_data.php |
Example | sample script | ||
| Files | / | includes |
||
| File | Role | Description | ||
|---|---|---|---|---|
| dbclasses (2 files) |
||||
| js (2 files) |
||||
| DBOpen.php |
Example | Initialize DB connection | ||
| Files | / | includes | / | dbclasses |
||
| File | Role | Description |
|---|---|---|
| Data.class.php |
Class | Data Manipulation Class |
| MySQLDB.php |
Class | MySQL DB Abstraction Class |
| Files | / | includes | / | js |
||
| File | Role | Description |
|---|---|---|
| confirm.js |
Data | Prompt confirmation |
| validation.js |
Data | Render Form Validation in JS |
| Download all files: mysqldbclass.tar.gz mysqldbclass.zip |
For more information send a message to info at phpclasses dot org.
Copyright (c) Icontem 1999-2013