/** * @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; }
$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")