public function getGroup($id = NULL)
{
if ($id) {
$stmt = $this->pdo->PDOInstance->prepare("SELECT * FROM group_product WHERE id= :id");
$stmt->bindParam(':id', $id);
} else {
$stmt = $this->pdo->PDOInstance->prepare("SELECT * FROM group_product");
}
try {
$stmt->execute();
} catch (Exception $e) {
echo "Problem at " . $e->getLine() . " from model Extraction :" . $e->getMessage();
}
$stmt = $stmt->fetchAll(PDO::FETCH_ASSOC);
$result = array();
foreach ($stmt as $group) {
$group_ = new group_products();
$group_->setId($group["id"]);
$group_->setName($group["name"]);
$group_->setType($group["type"]);
array_push($result, $group_);
}
return $result;
}
<?php
require_once '../model/group_products.php';
$group_products = new group_products();
if ($_GET["name"] != "") {
$group_products->setName($_GET["name"]);
$group_products->setType($_GET["type"]);
$group_products->addToDatabase();
}
header('location:' . $_GET["next"]);
<?php
require_once '../model/group_products.php';
$groupProduct = new group_products($_GET['id']);
foreach ($_GET as $key => $value) {
if ($key != "next" && $value != "") {
echo $key . ' -> ' . $value . '<br/>';
$nkey = "set" . ucfirst($key);
echo $nkey . '<br/>';
try {
$groupProduct->{$nkey}($value);
} catch (Exception $e) {
echo 'shit';
}
}
}
$groupProduct->setToDatabase();
header('location:' . $_GET['next']);
<?php
require_once '../model/group_products.php';
try {
$id = $_GET["id"];
} catch (Exception $e) {
header('location:viewGroupProducts.php');
exit;
}
$group_products = new group_products($id);
$group_products->eraseOfDatabase();
header('location:viewGroupProducts.php');
exit;
