db/sql-packge

Maintainers

Details

github.com/yossef-ashraf/sql-packge

Source

Issues

Installs: 6

Dependents: 0

Suggesters: 0

Security: 0

Stars: 2

Watchers: 1

Forks: 0

Open Issues: 1

v1 2022-03-30 10:57 UTC

MIT 14d3e2d172447f923b23329fe5f78f170270ebd7

  • yossef-ashraf <yossefff2001.woop@gmail.com>

This package is auto-updated.

Last update: 2025-03-29 01:03:36 UTC

README

sql-packge is a small php wrapper for mysql databases.

installation

install once with composer:

composer require db/sql-packge

then add this to your project:

require __DIR__ . '/vendor/autoload.php';
use Db\SqlPackge\sql;
$db = new sql();

usage

/* connect to database */
$db = new sql('127.0.0.1', 'username', 'password', 'database', 3306);

/* exaples */

/* select */
var_dump( $db->select("users","*")->getAll());
var_dump( $db->select("users","*")->where("id","=","9")->getRow());
var_dump( $db->andWhere("id","LIKE","5")->getRow());
var_dump( $db->orWhere("id","BETWEEN","5")->getRow());
var_dump( $db->WhereNot("id","IN","5")->getRow());
var_dump( $db->notWhere("id","<","5")->getRow());



/* insert/update/delete */
var_dump( $db->insert("users",["name"=>"name","email"=>"email","pass"=>"pass"])->set());
var_dump( $db->delete("users","id","7")->set());
var_dump( $db->deleteTable("users")->set());
var_dump( $db->update("users",["name"=>"name","email"=>"email","pass"=>"pass"] , "id = 15")->set());;