ajbassett539 / simple-database
Simple mysqli database wrapper to retrieve stdClass objects.
README
Simple mysqli Database Wrapper to Retrieve stdClass Objects.
Installation
composer require ajbassett539/simple-database
Instantiation
include 'vendor/autoload.php';
$db = new \Database\DB();
Credentials
## .htaccess
SetEnv DATABASE_HOST localhost
SetEnv DATABASE_USER usernaem
SetEnv DATABASE_PASS passwerd
SetEnv DATABASE_NAME fancy_db
SetEnv LOG_SQL_QUERIES 1
Methods
query
public function query($sql = "", $multirow = false, $raw = false)
Takes an SQL string and attempts to execute. You are responsible for sanitization and syntax.
If you anticipate multiple rows, $multirow = true
.
If you'd rather have the mysqli result object, $raw = true
.
Returns stdClass PHP object(s) for the result or false.
execute
public static function execute($sql = "", $multirow = false, $raw = false)
Does the same exact thing, just called statically.
Creates a new connection for each call, so it's not advisable to use this in a loop.
escape
public function escape($string)
Returns the escaped string.
real_escape
public static function real_escape($string)
Does the same thing, just called statically.
getLastError
public function getLastError()
Returns the last error as string.
affected_rows
public function affected_rows()
Returns the affected rows of the last query.
insert_id
public function insert_id()
Return the insert id of the last query.