williamheelis/sqldb

SQL connection in PHP

v1.0.2 2025-05-12 15:36 UTC

Requires

• php: >=7.4

MIT

README

MySQL simple PHP client

composer require williamheelis/sqldb

config like this

make a dir in your root .SQLdb/ and in it make a dbconfig.ini file that looks like this

[database]
host = localhost
username = myuser
password = mypass
database = mydb

IMPORTANT: make sure that .sqldb\ is excluded in .gitignore

use like this

get one row

use Restful\SQLdb;

$db = new SQLdb();
$db->put($email,$dob);
$User = $db->queryrow("SELECT * FROM users WHERE email=? AND date_of_birth=? ORDER BY email LIMIT 0,1");
echo $User['lastName'] . "<br />"'

get a loop

use Restful\SQLdb;

$db = new SQLdb();
$db->put($last_name);
$db->query("SELECT * FROM users WHERE lastName=?");
while ($tmp = $db->getnextrow()){
    echo $tmp['email'] . "<br />";
}

get one element

use Restful\SQLdb;

$db = new SQLdb();
$db->put($id);
echo $db->quickquery("SELECT lastName FROM users WHERE id=?") . "<br />";