2017 © Pedro PelĂĄez
 

library sql

PHP class to perform SQL queries easily

image

phyrexia/sql

PHP class to perform SQL queries easily

  • Thursday, June 1, 2017
  • by Jejem
  • Repository
  • 2 Watchers
  • 2 Stars
  • 622 Installations
  • PHP
  • 1 Dependents
  • 0 Suggesters
  • 1 Forks
  • 0 Open issues
  • 13 Versions
  • 2 % Grown

The README.md

simple-sql

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

Latest Stable Version License, (*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();

The Versions

01/06 2017

dev-master

9999999-dev

PHP class to perform SQL queries easily

  Sources   Download

MIT

The Requires

  • ext-mysqli *
  • php >=5.3

 

by Frédéric Le Barzic

sql query

01/06 2017

1.8.0

1.8.0.0

PHP class to perform SQL queries easily

  Sources   Download

MIT

The Requires

  • php >=5.3
  • ext-mysqli *

 

by Frédéric Le Barzic

sql query

30/01 2017

1.7.0

1.7.0.0

PHP class to perform SQL queries easily

  Sources   Download

MIT

The Requires

  • php >=5.3
  • ext-mysqli *

 

by Frédéric Le Barzic

sql query

11/03 2016

1.6.2

1.6.2.0

PHP class to perform SQL queries easily

  Sources   Download

MIT

The Requires

  • php >=5.3
  • ext-mysqli *

 

by Frédéric Le Barzic

sql query

10/02 2016

1.6.1

1.6.1.0

PHP class to perform SQL queries easily

  Sources   Download

MIT

The Requires

  • php >=5.3
  • ext-mysqli *

 

by Frédéric Le Barzic

sql query

05/02 2016

1.6.0

1.6.0.0

PHP class to perform SQL queries easily

  Sources   Download

MIT

The Requires

  • php >=5.3
  • ext-mysqli *

 

by Frédéric Le Barzic

sql query

22/01 2016

1.5.0

1.5.0.0

PHP class to perform SQL queries easily

  Sources   Download

MIT

The Requires

  • php >=5.3
  • ext-mysqli *

 

by Frédéric Le Barzic

sql query

08/11 2015

1.4.1

1.4.1.0

PHP class to perform SQL queries easily

  Sources   Download

MIT

The Requires

  • php >=5.3
  • ext-mysqli *

 

by Frédéric Le Barzic

sql query

07/11 2015

1.4.0

1.4.0.0

PHP class to perform SQL queries easily

  Sources   Download

MIT

The Requires

  • php >=5.3
  • ext-mysqli *

 

by Frédéric Le Barzic

sql query

03/10 2015

1.3.0

1.3.0.0

PHP class to perform SQL queries easily

  Sources   Download

MIT

The Requires

  • php >=5
  • ext-mysqli *

 

by Frédéric Le Barzic

sql query

27/09 2015

1.2.0

1.2.0.0

PHP class to perform SQL queries easily

  Sources   Download

MIT

The Requires

  • php >=5
  • ext-mysqli *

 

by Frédéric Le Barzic

sql query

25/09 2015

1.1.0

1.1.0.0

PHP class to perform SQL queries easily

  Sources   Download

MIT

The Requires

  • php >=5
  • ext-mysqli *

 

sql query

21/09 2015

1.0.0

1.0.0.0

PHP class to perform SQL queries easily

  Sources   Download

MIT

The Requires

  • php >=5
  • ext-mysqli *

 

sql query