Sammen skal vi lage: Gjestebok

[Epower]

La til prepare i editEntry

 

<?php

class Guestbook {
private $numEntriesPerPage = 10;
private $connection;
private $entries;
private $memcacheConnection;
private $mcConnected;

public function __construct(PDO $connection, $memcacheConnection) {
	if ($memcacheConnection instanceof Memcache) {
		$this->memcacheConnection = $memcacheConnection;
		$this->mcConnected = true;
	}
	$this->connection = $connection;
}

public function addEntry(GuestbookEntry $entry) {
	$this->entries[] = $entry;
	if ( $this->mcConnected ) {
		$this->memcacheConnection->delete('gb-entries');
	}
}

public function deleteEntry( $id ) {
	if ( is_int( $id ) && $id > 0 ) {
		$sql = "UPDATE guestbook SET deleted = NOW() WHERE id=?";
		$stmt = $this->connection->prepare($sql);
		$stmt->execute(array($id));

		if ( $this->mcConnected ) {
			$this->memcacheConnection->delete( 'gb-entries' );
		}
	}
}

public function editEntry($id) {
	if(is_int($id) && $id > 0) {
		$sql = "UPDATE guestbook SET message=? WHERE id=?";
		$stmt = $this->connection->prepare($sql);
		if ( $this->mcConnected ) {
			$this->memcacheConnection->delete( 'gb-entries' );
		}
	}
}

public function fetchEntries(array $options = array()) {
	if ( $this->mcConnected ) {
		$entries = $this->memcacheConnection->get( 'gb-entries' );
		if ( $entries !== false ) {
			return unserialize( $entries );
		}
	}
	$sql = "SELECT /*SQL_CACHE*/ id, author, email, website, message, created FROM guestbook WHERE !deleted ORDER BY created DESC;";
	$stmt = $this->connection->prepare($sql);
	$stmt->execute();
	$this->entries = $stmt->fetchAll(PDO::FETCH_CLASS, 'GuestbookEntry');
	if ( $this->mcConnected ) {
		$this->memcacheConnection->set( 'gb-entries', serialize( $this->entries ) );
	}
}

public function __destruct () {
	for ( $i = 0, $iMax = count ( $this -> entries ); $i < $iMax; $i++ ) {
		if ( empty ( $this -> entries[$i] -> id ) ) {
			$sql = "INSERT INTO guestbook (author, email, website, message, ip) VALUES (?,?,?,?,INET_ATON(?))";
			$stmt = $this->connection->prepare($sql);
			$stmt->execute(array(
			   $this->entries[$i]->author,
			   $this->entries[$i]->email,
			   $this->entries[$i]->website,
			   $this->entries[$i]->message,
			   $_SERVER['REMOTE_ADDR']
			));
		}
	}
}

}

class GuestbookEntry {
public $id;
public $author;
public $email;
public $website;
public $message;
public $date;
public $ip;

public function __set($key, $value) {
	if (isset($this->$key)) {
		$this->$key = $value;
	}
}
}

 

[Wackamole]

ingen som vil fortsette?

[JohndoeMAKT]

Hadde muligens vært mer interesse dersom det ble laget noe du ikke trengte tidsmaskin for å bruke.

[Wackamole]

Kom med forslag

[Zic0]

k

Endret 12. august 2010 av Zic0