Crud

.php

?php
	require_once 'C:\xampp\htdocs\Sitealterdochao\classes\DB\DB.php';
	
	abstract class Crud extends DB{

	protected $table;

	abstract public function insert();
	abstract public function update($id);

	public function find($id){
		$sql  = "SELECT * FROM $this->table WHERE id = :id";
		$stmt = DB::prepare($sql);
		$stmt->bindParam(':id', $id, PDO::PARAM_INT);
		$stmt->execute();
		return $stmt->fetch();
	}

	public function findAll(){
		$sql  = "SELECT * FROM $this->table";
		$stmt = DB::prepare($sql);
		$stmt->execute();
		return $stmt->fetchAll();
	}

	public function delete($id){
		$sql  = "DELETE FROM $this->table WHERE id = :id";
		$stmt = DB::prepare($sql);
		$stmt->bindParam(':id', $id, PDO::PARAM_INT);
		return $stmt->execute(); 
	}

}


?>

require_once 'C:\xampp\htdocs\Sitealterdochao\classes\DB\DB.php';

Mano, use namespace por favor!

Veja:

• PSR-0
• PSR-4

Veja um exemplo de camada de persistencia em OOP:

• https://github.com/malukenho/phrases/tree/master/src/Phrases/Persistence