classes db.php

<?php
	class DB{
		private $_pdo;
		private $count = 0;

		public function __construct(){

			try{
				$this->_pdo = new PDO('mysql:host=localhost;dbname=wakamegroup', 'root' , '');	

				//echo 'good';
			}
			catch (PDOException $e){

			}
		}

		public function insert($table, $data){
			$sql = "INSERT INTO " . $table . " (" . implode(",",array_keys($data)) . ') VALUES (' . "'" . implode("','",array_values($data)) . "')";
			
			$stmt = $this->_pdo->prepare($sql);
			$stmt->execute();
		}

		public function getName($name, $table, $field, $operator, $str){
			$sql = "SELECT " . $name . " FROM " . $table . " WHERE " . $field . $operator . $str;

			$stmt = $this->_pdo->query($sql);
			
			return $stmt->fetchAll();

		}



	}
?>

oferta.php

<?php
	require_once 'classes/db.php';

	$getProd = new DB;

	echo $getProd->getName('name', 'products', 'id', '>', '0');

	
//zwraca mi SELECT name FROM products WHERE id>0



?>