DB class for MYSQL, POSTGRES, SQLITE, PHPLIB, ODBC
If you believe that database abstraction is a good think, but you don't want to
join the religous fights about the best one out there, then we have a common
interest.
This abstract wrapper class provides easy and simple class methods to access the
most important db function. It implements the functionality for databases like
MYSQL, POSTGRESQL or SQLITE. It provides a wrapper for PEAR, PHPLIB, ADOdb and
METABASE and enables you to switch between these db abstraction layers with only
changing a single line of code. You gain the possibility to develop similar code
for more than 15 different databases.
Detailed documentation for all the complete interface exists.
A ligtweight interface supports the most common tasks in an easy and efficent
way, such as sending queries and fetching result sets or single variables.
Additional classes provide tools for accessing database data, dumping
information in html tables, exporting db content to CSV-files or as SQL
statements or presenting database content pagewise (e.g. for search results).
/////////////////////////////////////////////////////////////
// Interface of version 1.0:
function Constructor($libraryPath, $dbType, $preferredResType = ASSOCIATIVE_ARRAY)
function connect($host, $db, $user, $password)
function disconnect()
function query($query)
function getNext($resultType = PREDEFINED_VALUE)
function getAll($resultType = PREDEFINED_VALUE)
function getValue()
function getColumn($resultType = PREDEFINED_VALUE)
function execute($query, $resultType = PREDEFINED_VALUE)
function free()
function numRows()
function affectedRows()
function getIdentifier()
function getTables()
function escapeStr()
This class can retrieve messages from a mailbox and insert them into a MySQL database.
The class retrieves and parses messages from a mailbox using the PHP IMAP extension.
The parsed messages can be stored in a MySQL database table. Message attachments are stored in server files.
The class can also perform some basic spam checking on the retrieved messages by verifying the sender address against a blacklist, and verify the existence of banned words in the message subject or body. The sender blacklist and banned words are also stored in the database tables.
The message processing activity is logged in a separate database table.
The class can also retrieve the messages and logged actions from the database.
A class for handling templates. This class is 100% compatible with PHPLib but with a few caracteristics added such as file inclusion from the same template, optional blocks and more. English documentation will be available soon.
Una clase para el manejo de plantillas. Esta clase es 100% compatible con la de PHPLib pero con unas cuantas características nuevas, como la inclusión de ficheros desde la misma plantilla, bloques opcionales y más. Documentación en español.
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Good (87.5%)
Good (91.7%)
Sufficient (70.0%)
-
-
-
Not sure (59.9%)
820
Month:
There are not enough user ratings to display for this class.
Image gallery generation class based on templates.
Template based Image gallery generation class.
Example shows how it:- Creates the thumbnails into a folder, and then generates HTML file listing all the thumbnails and links to the original images.
Each class can be used seperately!
This class provides functionalities for dealing with MySQL DB tables hiding some complexities related with the use of SQL commands. It is based upon the PHPLIB MySQL class.
It abstracts record sets so you can easily select, insert, delete and modify rows into the table on a per row basis.
Data conversion support and some basic formatting are provided.
Since the class is Web-oriented, it also provide methods for HTML output generation.