$pDate = date('m.Y');
$query = $connectsite->query("SELECT * FROM `payment`  WHERE `date` LIKE '%$pDate'")->fetch_row();


if($query) {
    $amount = 0;
    foreach ($query as $item) {
        $amount += $query[2];
    }
}
var_dump($amount);