tyrola/sdc

A very simple mysqli database lib

SDC - SimpleDatabaseConnector

Simple PHP Database Connector, _(*1)

• works with mysqli
• very simple ;)

query() Example:, _(*2)

``` php <?php, <sub>(*3)</sub>

$db = new mysqli("localhost", "dbUser", "dbPassword", "dbName"); $sdc = new DatabaseConnector($db);, <sub>(*4)</sub>

$name = "Franz";, <sub>(*5)</sub>

$sql = "UPDATE table SET col = '1' WHERE name = ".$sdc->quote($name").";";, <sub>(*6)</sub>

$sdc->query($sql);, <sub>(*7)</sub>

getAll() Example: 

``` php
<?php

$db = new mysqli("localhost", "dbUser", "dbPassword", "dbName");
$sdc = new DatabaseConnector($db);

$sql = "SELECT
            `name`
        FROM
            `table`
        LIMIT
            `10`";

$entries = $sdc->getAll($sql);

foreach ($entries as $entry) {
    echo $entry["name"];
}

getFirst() Example:, <sub>(*8)</sub>

``` php <?php, <sub>(*9)</sub>

$db = new mysqli("localhost", "dbUser", "dbPassword", "dbName"); $sdc = new DatabaseConnector($db);, <sub>(*10)</sub>

$sql = "SELECT name FROM table LIMIT 10";, <sub>(*11)</sub>

$entry = $sdc->getFirst($sql);, <sub>(*12)</sub>

echo $entry["name"];, <sub>(*13)</sub>

getOne() Example:

``` php
<?php

$db = new mysqli("localhost", "dbUser", "dbPassword", "dbName");
$sdc = new DatabaseConnector($db);

$sql = "SELECT
            `name`
        FROM
            `table`
        WHERE
            `id` = '1'";

$name = $sdc->getOne($sql);

echo $name;