Forum PHP.pl

[PHP] pobierz, plaintext 
<?
class QueryIterator implements Iterator
{
   private $result;
   private $connection;
   private $data;
   private $key=0;
   private $valid;
 
   function __construct($host, $user, $password, $dbname)
   {
      $this->connection = mysql_connect($host, $user, $password);
	  mysql_select_db($dbname);
   }
   //wykonujemy zapytanie o imiona i email
   public function exceute($query)
   {
      $this->result = mysql_query($query);
      if (mysql_num_rows($this->result)>0)
      $this->next();
   }
   public function rewind() {}
   public function current()
   {
      return $this->data;
   }
   public function key()
   {
      return $this->key;
   }
   //dane zapisywane są w $data, $valid=true, $key++
   public function next()
   {
      if ($this->data = mysql_fetch_assoc($this->result))
      {
         $this->valid = true;
         $this->key+=1;
      }
      else
         $this->valid = false;
   }
   public function valid()
   {
      return $this->valid;
   }
}
 
	$qi = new QueryIterator("localhost", "user", "pass", "test");
	$qi->exceute("SELECT name, email FROM users");
	while($qi->valid())
	{
		print_r($qi->current());
		$qi->next();
	}
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$this->data = mysql_fetch_assoc($this->result)
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
while($qi->valid())
{
print_r($qi->current());
$qi->next();
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
foreach($qi as $value)
{
  echo $value;
}
[PHP] pobierz, plaintext