protected function getSettingValue($id)
{
$sql = "SELECT `value` FROM `settings` WHERE `id`= :id;";
$prep = $this->dbh->prepare($sql);
// Interogarea e pregatita si stocata in $prep
$ar_val = array('id' => $id);
if ($prep->execute($ar_val)) {
$row = $prep->fetch();
return $row['value'];
}
}
protected function saveUrl($url)
{
$sql = "INSERT INTO urls (type,value,parameter_counter) VALUES ('2',:url, :parameter);";
$prep = $this->dbh->prepare($sql);
// Interogarea e pregatita si stocata in $prep
$ar_val = array('url' => $url, 'parameter' => $this->parameterCounter);
$prep->execute($ar_val);
}
protected function saveCounter($counter)
{
$sql = "UPDATE settings SET value=:counter WHERE id='1';";
$prep = $this->dbh->prepare($sql);
// Interogarea e pregatita si stocata in $prep
$ar_val = array('counter' => $counter);
$prep->execute($ar_val);
}
}
$urlSaver = new WebArchive();
$urlSaver->checkPage();
