xeki-tech/db

There is no license information available for the latest version (1.0.3) of this package.

db for xeki framework

1.0.3 2021-07-19 15:53 UTC

Requires

• php: >=7.2.5
• ext-mysqli: *

Unknown License

• Xeki Team
• Luis Patt

• templating

README

SQL for xeki

Todo

Instalation

Xeki install

In console

    composer require xeki-tech/db

Copy config

 temporal 
 

Manual

• Clone
• Add to

How use

Load Module

$sql = \xeki\module_manager::import_module('xeki_db_sql', 'main');

Manual query

$res = $sql->query("SELECT * FROM xeki_table where active='on' order by order_list asc");
foreach($res as $item){
    d($item); // print on xeki
}

Update

$data = array(
    "email" => $user['new_email'],
);
$sql->update("user", $data, "field='{$value}'");

Insert

$data = array(
    "email" => $user['new_email'],
);
$sql->insert("user", $data);

Delete

$data_array=[];
$data_array['title']="":
$sql->update("tableName", $data_array, "sku='cd22'");

$sql->delete($table = null, $conditions = 'FALSE')