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

}


?>

<?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