Query update Method

public function update($update, $safemode = true, $addslashes = true, $literal = false, $result_comparison_signal = '>'){

This method is responsible for executes a new UPDATE query.

Parameters

• $insert - Fields and values to update.
  • Example: array('name' => 'Samuel Faj','register_date' => date('Y-m-d H:i:s'))
• $safemode - If true it will not execute the query if there aren't where conditions.
• $addslashes - If true it'll quote strings with slashes on $insert values.
• $literal - If false it'll add, IN THE QUERY, quotes before and after the values.
• $result_comparison_signal - Comparison signal to verify if query was successfully executed. - See More

Usage

<?php 
    require_once('class_db.php');

    $sql = new query(array(
    	'host'     => 'localhost' ,
    	'user'     => 'root'      ,  
    	'password' => ''          ,  
    	'database' => 'test'  	  ,  
    	'db_type'  => 'mysqli'    , 
    ));
    $sql->table('users');
    $sql->where('name','Samuel Faj');
    $query = $sql->update(array(
      'name'  => 'Samuel Fajreldines',
      'email' => 'samuelfaj@icloud.com'
    ));

    var_dump('Query result: ' . var_export($query->result,true));
    var_dump($query);

Returns

string(18) "Query result: true"
object(stdClass)#4 (8) {
  ["sql"]=>
  string(103) "UPDATE users SET name = 'Samuel Fajreldines' , email = 'samuelfaj@icloud.com' WHERE name = 'Samuel Faj'"
  ["fetch"]=>
  array(0) {
  }
  ["result"]=>
  bool(true)
  ["object"]=>
  bool(true)
  ["num_rows"]=>
  int(0)
  ["have_rows"]=>
  bool(false)
  ["affected_rows"]=>
  int(2)
  ["elapsed_time"]=>
  int(0)
}