PHP code example of thipages / quicksql

1. Go to this page and download the library: Download thipages/quicksql library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php.

    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

thipages / quicksql example snippets


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



 $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; */