How can I get the number of records in db via sql statement ?

Question

How can I get the number of records in mySQL DB via PDO?.

My codes: (But something is wrong.It is not working.)

    function AlandakiDegerlerToplami ($tablo,$alan) 

 {  

     $dsn = 'mysql:host='.$host.';dbname='.$veritabaniadi;

    try {
        $this->conn = new PDO($dsn, $kullaniciadi, $sifre);
    } catch (PDOException $e) {
        echo vthatasi .':'. $e->getMessage();
    }

    $veriler = $this->conn->prepare('SELECT sum('.$alan.') as adet from '.$tablo);
    $toplam=$veriler->execute();

    return $toplam['adet'];
 }


      function TablodakiKayitSayisi ($tablo) 

 {  

     $dsn = 'mysql:host='.$host.';dbname='.$veritabaniadi;

    try {
        $this->conn = new PDO($dsn, $kullaniciadi, $sifre);
    } catch (PDOException $e) {
        echo vthatasi .':'. $e->getMessage();
    }

$veriler = $this->conn->prepare('SELECT count(*) as adet from '.$tablo);
        $toplam=$veriler->execute();

    return $toplam['adet'];

 }

}

http://stackoverflow.com/questions/15990857/reference-frequently-asked-questions-about-pdo — Your Common Sense, Apr 14 '14 at 05:11
@MustafaMJalal yes, sure. Most of PHP users do not understand the necessity of using prepared statements and have no idea how raw mysqli inconvenient with them — Your Common Sense, Apr 14 '14 at 05:31

score 0 · Accepted Answer · answered Apr 15 '14 at 09:10

Finally I solved my problem.

Codes:

            function AlandakiDegerlerToplamiWHERE ($tablo,$alan,$where) 

         {  

$kullaniciadi='bla';
$sifre='1234';
$veritabaniadi='deneme'; 

 $dsn = 'mysql:host='.$host.';dbname='.$veritabaniadi;

    try {
        $baglan = new PDO($dsn, $kullaniciadi, $sifre);
    } catch (PDOException $e) {
        echo vthatasi .':'. $e->getMessage();
    }
            $veriler = $baglan->query('SELECT sum('.$alan.') as adet from '.$tablo.' WHERE '.$where);

            foreach($veriler as $row) {
            return $row['adet'];      }
         }








            function TablodakiKayitSayisi ($tablo) 

         {


    $kullaniciadi='bla';
$sifre='1234';
$veritabaniadi='deneme'; 
 $dsn = 'mysql:host='.$host.';dbname='.$veritabaniadi;

    try {
        $baglan = new PDO($dsn, $kullaniciadi, $sifre);
    } catch (PDOException $e) {
        echo vthatasi .':'. $e->getMessage();
    }

              $veriler = $baglan->query('SELECT count(*) as adet from '.$tablo);
              foreach($veriler as $row) {
              return $row['adet'];      }

         }

How can I get the number of records in db via sql statement ?

1 Answers1