Download the PHP package aldisaglobal/mysql-db without Composer
On this page you can find all versions of the php package aldisaglobal/mysql-db. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download aldisaglobal/mysql-db
More information about aldisaglobal/mysql-db
Files in aldisaglobal/mysql-db
Package mysql-db
Short Description A Simple Iterateable MySQL DB Query Object
License MIT
Informations about the package mysql-db
Library Package
Vendor: aldisaglobal
Package: mysql-db
Author: Abid
Version: 0.2
Connection Parameters
Make available the following Connection parameters:
MYSQL_HOST
the URI for the MySQL serverMYSQL_USER
the usernameMYSQL_PASS
the passwordMYSQL_DB
the database
Option 1: As Environment Variables
Place connection params in $_ENV superglobal Optional: You can use the \vlucas\dotenv package with a .env file to populate $_ENV variables
Option 2: As Constants
You can define
these constants in a settings file
Option 3: As an Array
You can create and pass a parameters array to the create method
$params = array('MYSQL_HOST'=>"hostname", ...)
Instantiate a Database Object
Use the static create
method to get the DB object:
Execute queries on the Database Object
$db->query("...mysql statement...");
Iterate SELECT Queries
The full Object API
\AldisaGlobal\MySQL\DB::create([$params])
- returns object with connection
$db->init()
- closes any open result
$db->escape($str)
- returns escaped string
$db->getResponse()
- returns last server response
$db->getError()
- returns error string from last query
$db->getErrno()
- returns errno from last query
$db->hasError()
- true if last query had an error
$db->query($sql [, $buffered=true])
- executes query, pass false as second arg for unbuffered query
$db->hasResult()
- whether query returned a result
$db->getInsertID()
- returns InsertID of last insert query
$db->getRow()
- returns the current row
$db->getNextRow([$mode = "object"])
- returns next row of result as object [pass "array" to get back an assoc array]
$db->getFirstRow([$mode = "object"])
- returns first row of result as object
$db->getRowNum($num [, $mode = "object"])
- returns row at \$num index
$db->getNumFields()
- returns number of columns in result row
$db->getFields()
- returns array of column names
$db->getNumRows()
- returns total number of rows in result [not accurate for unbuffered queries]
All versions of mysql-db with dependencies
ext-mysqli Version *