}
public function Delete()
{
$id = 1;
$stmt = $this->conn->prepare('DELETE FROM main_category WHERE main_category_id = :id');
$stmt->bindParam(':id', $id);
$stmt->execute();
echo $stmt->rowCount();
}
public function GetMainCategoryById()
{
$id = 5;
try {
$stmt = $this->conn->prepare('SELECT * FROM main_category WHERE id = :id');
$stmt->execute(array('id' => $id));
$result = $stmt->fetchAll();
if (count($result)) {
foreach ($result as $row) {
print_r($row);
}
} else {
echo "No rows returned.";
}
} catch (PDOException $e) {
echo 'ERROR: ' . $e->getMessage();
}
}
}
$obj = new Config();
$obj->SetMainCategory();
