library easydb

ibrahimozturkme/easydb

Short MySQL & PDO Proccess.

, _(*1)

Installing via Composer

`$ composer require "ibrahimozturkme/easydb":"dev-master", _(*2)

Constructor

• $database : String.
• $host : String.
• $username : String.
• $password : String.
• $charset : String.

Server Mode, _(*3)

 $db = new \EasyDB\Connection('database_name', 'localhost', 'ibrahimozturk', '12341234', 'utf8');

Localhost mode, _(*4)

 $db = new \EasyDB\Connection('database_name');

SQL

• $proccess : String.

• $table : String., _(*5)

  $db->sql('select', 'articles');, _(*6)

From

• $fields : String., _(*7)

  $db->sql('select', 'articles')->from('id, title, article');, _(*8)

Serialize

• $array : Array. Form data, _(*9)

  $db->sql('insert', 'articles')->serialize($_POST)->result();, _(*10)

Additional

• $type : String.

• $array : Array. Form data, _(*11)

  $db->sql('update', 'articles')->serialize($array)->additional('WHERE id = :id', ['id' => 2])->result();, _(*12)

Result

Query result., _(*13)

 $db->sql('select', 'articles')->result();

Examples

SELECT - Single, _(*14)

 $query    = $db->sql('select', 'articles')->additional('WHERE id = :id', ['id' => 2])->result();
 echo $query->count;
 echo $query->result->title;

SELECT - Multiple, _(*15)

 $query    = $db->sql('select', 'articles')->result();
 echo $query->count;

 foreach($query->result as $row){
      echo $row->title.'<br>';
 }

SELECT - From, _(*16)

 $query    = $db->sql('select', 'articles')->from('id, title, article')->result();
 echo $query->count;

 foreach($query->result as $row){
      echo $row->title.'<br>';
 }

INSERT, _(*17)

 $insert   = $db->sql('insert', 'articles')->serialize($array)->result();
 echo $insert->last_id;
 echo ($insert->result) ? 'Has been added.' : 'Could not be added.';

UPDATE, _(*18)

 $update   = $db->sql('update', 'articles')->serialize($array)->additional('WHERE id = :id', ['id' => 2])->result();
 echo ($update->result) ? 'Have been updated.' : 'Update failed.';

DELETE, _(*19)

 $delete   = $db->sql('delete', 'articles')->additional('WHERE id = :id', ['id' => 2])->result();
 echo ($update->result) ? 'Has been deleted.' : 'Could not be deleted.';