CODEWITHSUNDEEP
phpmysql
caglaror
caglaror

Reputation: 458

How to get an array from a class in PHP?

i am very newbie, please forgive for my inexperienced knowledges. I have a class in PHP. It makes some database job. But i couldn't get results as array. 

public function __construct($sunucu, $kullaniciAdi, $kullaniciSifre, $veritabaniAdi){
$this->_baglanti= mysql_connect($sunucu, $kullaniciAdi,$kullaniciSifre);
mysql_select_db($veritabaniAdi,$this->_baglanti);
}

public function baglantiyiKopar(){
mysql_close($this->_baglanti);
}

public function sorgula($sorgu){
$this->_donenSonuclar = mysql_query($sorgu, $this->_baglanti);
$this->_satirSayisi = mysql_num_rows($this->_donenSonuclar) ;
}

public function satirSayisi(){
return $this->_satirSayisi;
}

public function satirlar(){
$satirlar = array();
for($st=0;$st< $this->_satirSayisi;$st++){
$satirlar = mysql_fetch_assoc($this->_donenSonuclar);
}
return $satirlar;
}
}
?>

Upvotes: 0

Views: 59

Answers (2)

Hardik
Hardik

Reputation: 1411

public function satirlar(){
  $satirlar = array();
  for($st=0;$st< $this->_satirSayisi;$st++){
    $satirlar[$st] = mysql_fetch_assoc($this->_donenSonuclar);
  }
  return $satirlar;
}

Upvotes: 1

jeroen
jeroen

Reputation: 91744

Assuming that you mean this function, you need to change it a little bit:

public function satirlar(){
  $satirlar = array();
  for($st=0;$st< $this->_satirSayisi;$st++){
    $satirlar[] = mysql_fetch_assoc($this->_donenSonuclar);
             ^^ add a new entry to the array instead of overwriting the existing one
  }
  return $satirlar;
}

Also note that the mysql_* functions are deprecated and it is recommended to switch to PDO (or mysqli) with prepared statements and bound variables.

Upvotes: 2

Related Questions