PHP class to perform SQL queries easily
- PHP >= 5.3
- PHP extension mysqli
Install directly via Composer:
$ composer require phyrexia/sql
<?php
require 'vendor/autoload.php';
use Phyrexia\SQL\SimpleSQL;
//First call: generate instance (next calls won't need parameters, Singleton <3)
$SQL = SimpleSQL::getInstance(DATABASE, HOST, PORT, USER, PASS);
//Do some SQL query
$SQL->doQuery('SELECT * FROM table');
//Count returned rows
$count = $SQL->numRows();
//Fetch results (associative array)
$rows = $SQL->fetchAllResults();
//Do another SQL query
$SQL->doQuery('SELECT * FROM table2 LIMIT 1');
//Fetch a single result
$row = $SQL->fetchResult();