/** * @param $url * @param int $cacheTime * * @return string */ public function getData($url, $cacheTime = 3600) { // Md5 the url $md5 = md5($url); // Get results if they are available in the cache already $result = $cacheTime > 0 ? $this->cache->get($md5) : null; // If there was no result, get the data if (!$result) { // Init curl $curl = curl_init(); // Setup curl curl_setopt_array($curl, array(CURLOPT_USERAGENT => $this->app->baseConfig->getConfig('userAgent', 'site', 'DataGetter from Mira (karbowiak@gmail.com)'), CURLOPT_TIMEOUT => 30, CURLOPT_POST => false, CURLOPT_FORBID_REUSE => false, CURLOPT_ENCODING => '', CURLOPT_URL => $url, CURLOPT_HTTPHEADER => array('Connection: keep-alive', 'Keep-Alive: timeout=10, max=1000'), CURLOPT_RETURNTRANSFER => true, CURLOPT_FAILONERROR => true)); // Get the data $result = curl_exec($curl); // Cache the data if ($cacheTime > 0) { $this->cache->set($md5, $result, $cacheTime); } } // Return the data return $result; }
/** * @param string $query * @param array $parameters * @param int $cacheTime * * @return array|bool * * @throws Exception */ public function query($query, $parameters = array(), $cacheTime = 30) { // Sanity check if (strpos($query, ';') !== false) { throw new Exception('Semicolons are not allowed in queries. Use parameters instead.'); } // Cache time of 0 seconds means skip all caches. and just do the query $key = $this->getKey($query, $parameters); // If cache time is above 0 seconds, lets try and get it from that. if ($cacheTime > 0) { // Try the cache system $result = !empty($this->cache->get($key)) ? unserialize($this->cache->get($key)) : null; if (!empty($result)) { return $result; } } try { // Start the timer $timer = $this->timer; // Increment the queryCounter $this->queryCount++; // Prepare the query $stmt = $this->pdo->prepare($query); // Execute the query, with the parameters $stmt->execute($parameters); // Check for errors if ($stmt->errorCode() != 0) { return false; } // Fetch an associative array $result = $stmt->fetchAll(PDO::FETCH_ASSOC); // Close the cursor $stmt->closeCursor(); // Stop the timer $duration = $timer->stop(); // If cache time is above 0 seconds, lets store it in the cache. if ($cacheTime > 0) { $this->cache->set($key, serialize($result), min(3600, $cacheTime)); } // Store it in the cache system // Log the query $this->logQuery($query, $parameters, $duration); // now to return the result return $result; } catch (Exception $e) { // There was some sort of nasty nasty nasty error.. throw $e; } }