<?php
$biraylikgiris = $db->prepare("
SELECT in_out,Sum(sip_urun_adedi) as toplam_urun_adet,count(1) as toplam_giris_sayisi, SUM((sip_birim_fiyati*sip_urun_adedi)) as toplam_urun_maliyeti FROM siparis WHERE AND sip_zaman >= NOW() - INTERVAL 1 month
AND stok_id=:id
group by in_out
");
$biraylikgiris->execute(array('id' => guvenlik($_POST['id']) ));
$toplamstok = $biraylikgiris->fetchColumn();
?>

<?php
$biraylikgiris = $db->prepare("
SELECT in_out AS giris_cikis,DATE_FORMAT(sip_zaman, '%Y-%m') giris_cikis_ay, Sum(sip_urun_adedi) as toplam_urun_adet,count(1) as toplam_giris_sayisi, SUM((sip_birim_fiyati*sip_urun_adedi)) as toplam_urun_maliyeti FROM siparis WHERE AND sip_zaman >= NOW() - INTERVAL 12 month
AND stok_id=:id
group by in_out,DATE_FORMAT(sip_zaman, '%Y-%m')
");
$biraylikgiris->execute(array('id' => guvenlik($_POST['id']) ));
$toplamstok = $biraylikgiris->fetchColumn();
?>