nytrix/simplesql

A php library that makes SQL simple

SimpleSQL

A php library that makes SQL simpel. Build your applications much faster with simple and fast communication to your database., _(*1)

Why?

SimpleSQL is a very lightweight library that will speed up your proccess of creating, selecting, updating and all your other SQL queries. It's a very easy syntax and has also multiple ways of doing your queries, there is a basic set of SQL functions that will work with the documented parameters, but then you can also build your own query through our building structure., _(*2)

Installation

We recommend using composor to install our library. Look at how to install composor here, _(*3)

composer require nytrix/simplesql

You can also download the library and install it manually. Download button will be added when the first official release is there., _(*4)

Features

• Common SQL queries in easy functions with understandable paramters.
• SQL query builder, so you can make any query with just PHP functions
• Database backup that you can pass it on in other connections
• Multi-driver possibilities
• Mutliple connections available, and easy to communicate between those.

Usage

Examples of SQL queries, simply in PHP., _(*5)

Create instance
Create your SimpleSQL instance, this will be used in the examples below., _(*6)

<?php
    use lib\SimpleSQL;
    $sql = new SimpleSQL; 
?>

Functions

Select, _(*7)

$sql->select("table","column",array("where" => "equals"));

Update, _(*8)

$sql->update("table","column",array("where" => "equals"),"to");

Insert, _(*9)

$sql->insert("table",array("value1","value2","value3"));

Create, _(*10)

$sql->create("table",array("id int auto_increment",name varchar(255)),"id");

Exists, _(*11)

$sql->exists("table",array("where" => "equals"));

Full documentation you can find here, _(*12)

License

SimpelSQL is under the MIT license, read it here, _(*13)