Esempio n. 1
0
 /**
  * @param user
  * @return $this
  */
 public function delete($user)
 {
     $queryBuilder = new queryBuilder();
     $query = $queryBuilder->delete('user')->where('id = ', $user->getId());
     $this->connection->execute($query);
     return $this;
 }
Esempio n. 2
0
            $stmt->execute($this->bindParameters);
            $rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
            print_r($rows);
        } catch (PDOException $e) {
            trigger_error('Wrong SQL: ' . $this->prepare . ' Error: ' . $e->getMessage(), E_USER_ERROR);
        }
    }
}
$make = "suzuki";
$model = "kizashi";
$newcolor = "green";
$color = "red";
$id = '12';
$i = '2';
$j = '3';
$ob = new queryBuilder();
//$ob->select("*")->from("cars")->where("make", "=", "$make")->execute();
//------------------------------------------------------------------
//$ob->select("id", "make", "model", "color")
//$ob->select("*")
$ob->select(count($column))->from("customers")->groupBy("age")->havingCount("age", ">=", "2")->execute();
//---------------------------------------------------------------
//$ob->insertTo("cars")
//        ->columns("make", "model", "color")
//        ->values("$make", "$model", "$color")
//        ->execute();
//-----------------------------------------------------------------
//$ob->update("cars")
//        ->set("model", "$model")
//        ->set("make", "$make")
//        ->set("color", "$newcolor")