phyrexia/sql

PHP class to perform SQL queries easily

simple-sql

PHP class to perform SQL queries easily, _(*1)

, _(*2)

Requirements

• PHP >= 5.3
• PHP extension mysqli

Installation

Install directly via Composer:, _(*3)

$ composer require phyrexia/sql

Basic Usage

<?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();