thipages/quicksql

Quick sql builder

v0.1.3 2023-01-27 15:03 UTC

Requires (Dev)

• thipages/quicktests: *

MIT

• Thierry PAGES

• php
• sql
• update
• insert
• select
• delete

README

Quick sql builder

Installation

composer require thipages\quicksql OR use the single php file quicksql.php

Usage of QSql class

Through the following static methods (more to come)

    insert  ($tableName, $keyValues)
    insert  ($tableName, $keyValues, $values)
    update  ($tableName, $keyValues, $where)
    delete  ($tableName, $where)

Examples

 $sql=QSql::insert(
    "aTable",
    [
      'field1'=>1
      'field2'=>2
   ]
 );
 /* INSERT INTO aTable ( field1,field2 ) VALUES ( '1', '2' ); */

$sql=QSql::insert(
   "aTable",
   ['field1','field2'],
   [
      [1,2],
      [3,4]
   ]
);
/* INSERT INTO aTable ( field1,field2 ) VALUES ( '1','2' ),( '3','4' ); */

$sql=QSql::update(
   "aTable",
   [
      'field1'=>1,
      'field2'=>2
   ],
   "id=1"
);
 /* UPDATE aTable SET field1='1',field2='2' WHERE id=1; */

 $sql=QSql::delete("aTable","id=1");
 /* DELETE FROM aTable WHERE id=1; */