Odak modu

PHP Temel

MIN, MAX, COUNT ve GROUP BY HAVING Kullanımı

PDO SUM MIN MAX COUNT GROUP HAVING

SUM
 $sql = 'SELECT SUM(id) FROM test';

    $query = $db->query($sql);
    if ( $query->rowCount() ){
        print_r($query->fetch(PDO::FETCH_ASSOC));
    }
MIN
 $sql = 'SELECT MIN(id) FROM test';

    $query = $db->query($sql);
    if ( $query->rowCount() ){
        print_r($query->fetch(PDO::FETCH_ASSOC));
    }```
##### MAX

$sql = 'SELECT MAX(id) FROM test';

$query = $db->query($sql);
if ( $query->rowCount() ){
    print_r($query->fetch(PDO::FETCH_ASSOC));
}```
COUNT
  $sql = 'SELECT COUNT(id) FROM test';

    $query = $db->query($sql);
    if ( $query->rowCount() ){
        print_r($query->fetch(PDO::FETCH_ASSOC));
    }
HAVING
$sql = "SELECT COUNT(id) toplam, soyisim FROM test GROUP BY soyisim HAVING toplam > 2";

$query = $db->query($sql);
if ($query->rowCount()) {
    print_r($query->fetch(PDO::FETCH_ASSOC));
}

Yorumlar

Yorum yapabilmek için derse kayıt olmalısın!