Docs For Class DatabaseConnection - ManiaLib 1.0b1 API Reference

Description

Database connection

Usage example:

<?php
require_once(APP_FRAMEWORK_LIBRARIES_PATH.'Database.php');
try
{
$database = DatabaseConnection::getInstance();
$result = $database->execute('SELECT * FROM mytable WHERE id < 10');
while($array = $result->fetchAssoc())
{
print_r($array);
}
$myvar = 'Some \'text with quotes\' and "double quotes"';
$myvarQuoted = $database->quote($myvar);
$database->execute( 'INSERT INTO mytable (MyText) VALUES ('.$myvarQuoted.')' );
echo $database->insertID.' is a newly inserted ID';
}
catch(Exception $e)
{
// Error handling...
}
?>

Located in /libraries/Database.php (line 42)

Method Summary

static DatabaseConnection getInstance ()

int affectedRows ()

DatabaseRecordSet execute (string $query)

string getDatabase ()

int insertID ()

bool isConnected ()

void quote ( $string)

void select ( $database)

void setCharset ( $charset)

Methods

static getInstance (line 72)

Get an instance on the database connection object, and connects to the mysql server if needed

To configure your connection, override these constants in your config:

APP_DATABASE_HOST
APP_DATABASE_USER
APP_DATABASE_PASSWORD
APP_DATABASE_NAME
APP_DATABASE_CHARSET

access: public

DatabaseConnection getInstance ()

affectedRows (line 159)

Get number of affected rows in previous operation

int affectedRows ()

execute (line 145)

Executes a query

DatabaseRecordSet execute (string $query)

string $query: The query

getDatabase (line 185)

Currently selected database

string getDatabase ()

insertID (line 168)

Get the ID generated in the last query

int insertID ()

isConnected (line 176)

bool isConnected ()

quote (line 135)

Escape and quote variables so you can insert them safely

void quote ( $string)

$string

select (line 120)

Selects a database

void select ( $database)

$database

setCharset (line 105)

Sets the charset for the database connection

void setCharset ( $charset)

$charset