Skip to content

The1462/PHPDbToolKit

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 
 
 

Repository files navigation

PHPDbToolKit

it's just alpha mysql database handler

#Settings

Codeigniter:

Copy "Application/Library" Folder
Set Line 25: $__usageType="CI";
DB settings standart in ci:

Application/config/database.php

Single:

Copy where you want
delete line 7 and 14
Set Line 25: $__usageType="normal";
Set $__MySQL values
include file

#Usage:

Get Single Line:

Calling by ID:
DB::get("table_name", 2);

Calling by Query
DB::get("table_name", "name LIKE '%as%' and city='2'");

if you want get on second db
DB::get("table_name", "id_or_query", "other_db_set");

Finding Lines:

DB::find("table_name", "city='new york'");

finding on other db
DB::find("table_name", "city='new york'", "other_db_set");

Creating Record:

Step 1: Select Your Table
$newRecord  = DB::create("table_name");

Step 2: Set Row Values
$newRecord  -> name     = "John";
$newRecord  -> lastname = "Doe";

Step 3: Save
$save = DB::save($newRecord); //return insert id

Update Record:

Option 1(Loading Your Record):

Step 1: Get Your Record
$record = DB::get("table_name);

Step 2: Edit Row/s
$record -> name = "Jhonny";
$record -> lastname = "Does";

Step 3: Save
DB::save($record);


Option 2(Just Update):

Step 1: Build Query Settings
$record = DB::update("table_name", "id_or_query", "optional_db_set");

Step 2: Set Row/s
$record -> name = "Doctor";

Step 3: Save
DB::save($record);

Multi Save:

Sample 1:
$recordOne  = DB::get("users", "username='The1462' and password='12345'");
$recordOne  -> login_time = time();

$recordTwo  = DB::create("user_logs");
$recordTwo  -> user_id      = $recordOne->id;
$recordTwo  -> loggin_time  = time();


$records  = array($recordOne, $recordTwo);
$save     = DB::save($records);

Sample 2:
$recordOne  = DB::update("users", 2);
$recordOne  -> status = 0;

$recordTwo  = DB::update("users", 3);
$recordTwo  -> status = 0;

$recordThree  = DB::update("users", 28);
$recordThree  -> status = 1;

$records  = array($recordThree, $recordOne, $recordTwo);
$save     = DB::save($records);

About

No description, website, or topics provided.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages