<?php
include "../yonet/baglan.php";

$kullaniciID=1;

$sepetSorgu = $db->prepare('SELECT urun.urun_id,urun_barkod, urun_adi, urun_fiyat, urun_stok_id, stok_renk, stok_beden, sepet.adet FROM sepet
    INNER JOIN urun ON sepet.urun_id=urun.urun=id
    INNER JOIN urun_stok ON sepet.urun_stok_id=urun_stok.stok
    WHERE kullanici_id=?');

$sepetSorgu->execute(array(1));

$siparis=$db->prepare('INSERT INTO siparis SET
kullanici_id=:kullanici_id,
fatura_unvan="fatura_unvan",
fatura_adres="fatura_adres",
fatura_vergino="vergino",
fatura_vergidairesi="fatura_vergidairesi",
fatura_no="fatura_no"');
$siparis->execute(array('kullanici_id' => $kullaniciID));

$siparisID = $db->lastInsertId();

echo "siparisID:" . $siparisID;

while($satir=$sepetSorgu->fetch(PDO::FETCH_ASSOC))
{
    $siparisKalem = $db->prepare('INSERT INTO siparis_kalem SET
        siparis_id=:siparis_id,
        urun_id=:urun_id,
        urun_barkod=:urun_barkod,
        urun_adi=:urun_adi,
        urun_fiyat=:urun_fiyat,
        urun_stok_id=:urun_stok_id,
        stok_renk=:stok_renk,
        stok_beden=:stok_beden,
        miktar=:miktar');
        
    $siparisKalem->execute(array(
        'siparis_id'=>$satir['siparis_id'],
        'urun_id'=>$satir['urun_id'],
        'urun_barkod'=>$satir['urun_barkod'],
        'urun_adi'=>$satir['urun_adi'],
        'urun_fiyat'=>$satir['urun_fiyat'],
        'urun_stok_id'=>$satir['urun_stok_id'],
        'stok_renk'=>$satir['stok_renk'],
        'stok_beden'=>$satir['stok_beden'],
        'miktar'=>$satir['miktar']
    ));
}