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();