Annoying problem passing variable as parameter

[farban6]

I am experimenting around with PDO, I have a DB handle class and instancing it in a function. The problem is when I want to bind elements in a query, for example I bind a parameter but I can only do it using a varible outside of the object.

 

<?php

$database = new Database("localhost", "fry", "root", ""); 

$database->set_table("usertest");
$database->set_query("SELECT * FROM usertest WHERE user_name = :user_name");
$value = "matt";
$database->prepare_query();
$database->bind("parameter", ":user_name", $value ,PDO::PARAM_STR, 5);
$database->execute();

while($result = $database->fetch())
        {
        echo $result['user_name'].'<br />';
        }
?>

 

 

Is this bad OOP practice? I wanted to put $value = "matt"; into the Database class somehow

 

here is the Database class

 

<?php

class Database{

public $hostname;
public $database;
public $username;
public $password;
public $connection;
public $prepare;
public $query;
public $table;
public $fetch;
public $bind_var;
public $bind_val;


	 function  __construct($hostname, $database, $username, $password)	{

		 $this->hostname = $hostname;
             $this->database = $database;
             $this->username = $username;
             $this->password = $password;

		 $this->Database_connection();


	}

	  public function  Database_connection()	{

		try {

		$this->connection = new PDO('mysql:host='.$this->hostname.';dbname='.$this->database, $this->username, $this->password);


		}
		catch (PDOException $e) {

   					 echo 'Connection failed: ' . $e->getMessage();
			}

	}
	  
	   public function set_query($query)	{
	   	

		$this->query = $query;

	}
	   
	   public function get_query()	{
	   	

		return $this->query;

	}
	  public function set_table($table)	{
	   	

		$this->table = $table;

	}
	   
	   public function get_table()	{
	   	

		return $this->table;

	}
	   
	 public function set_bind_var($var)	{
	   	
		 $bind_var = $var;

	}
		public function set_bind_val($val)	{
	   	
		 $bind_val = $val;

	}

		public function get_bind_var()	{
	   	
		return $this->bind_var;

	}
		public function get_bind_val()	{
	   	
		return $this->bind_val;

	}

	    public function bind($bindtype, $val, $var, $pdo, $num)	{
	    	
	   	

		if ($bindtype == "parameter")	{

		 $result = $this->prepare->bindParam($val,$var,$pdo);


		}


		return $result;
	}


	   
	   public function prepare_query()	{
	   	

		$this->prepare = $this->connection->prepare($this->get_query());



	}
	   
	   public function execute()	{
	   	

		$this->prepare->execute();


	}
	   
	  
		public function fetch()	{
	   	

		 return $this->prepare->fetch();



}




}

?>

 

Yet agian sorry for the sloppy code, this is mainly an experiment, would be very appriciated if someone could help me out with this problem.