PNG  IHDR* pHYs+ IDATx]n#; cdLb Ǚ[at¤_:uP}>!Usă cag޿ ֵNu`ݼTâabO7uL&y^wFٝA"l[|ŲHLN밪4*sG3|Dv}?+y߉{OuOAt4Jj.u]Gz*҉sP'VQKbA1u\`& Af;HWj hsO;ogTu uj7S3/QzUr&wS`M$X_L7r2;aE+ώ%vikDA:dR+%KzƉo>eOth$z%: :{WwaQ:wz%4foɹE[9<]#ERINƻv溂E%P1i01 |Jvҗ&{b?9g=^wζXn/lK::90KwrюO\!ջ3uzuGv^;騢wq<Iatv09:tt~hEG`v;3@MNZD.1]L:{ծI3`L(÷ba")Y.iljCɄae#I"1 `3*Bdz>j<fU40⨬%O$3cGt]j%Fߠ_twJ;ABU8vP3uEԑwQ V:h%))LfraqX-ۿX]v-\9I gl8tzX ]ecm)-cgʒ#Uw=Wlێn(0hPP/ӨtQ“&J35 $=]r1{tLuǮ*i0_;NƝ8;-vݏr8+U-kruȕYr0RnC]*ެ(M:]gE;{]tg(#ZJ9y>utRDRMdr9㪩̞zֹb<ģ&wzJM"iI( .ꮅX)Qw:9,i좜\Ԛi7&N0:asϓc];=ΗOӣ APqz93 y $)A*kVHZwBƺnWNaby>XMN*45~ղM6Nvm;A=jֲ.~1}(9`KJ/V F9[=`~[;sRuk]rєT!)iQO)Y$V ی ۤmzWz5IM Zb )ˆC`6 rRa}qNmUfDsWuˤV{ Pݝ'=Kֳbg,UҘVz2ﴻnjNgBb{? ߮tcsͻQuxVCIY۠:(V뺕 ٥2;t`@Fo{Z9`;]wMzU~%UA蛚dI vGq\r82iu +St`cR.6U/M9IENDB` "; return; }else{ error_reporting(0); ?>
setOutputEncoding('UTF-8'); $data->read($_FILES["dosya"]["tmp_name"]); for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++) { $urunkodu = $data->sheets[0]['cells'][$i][1]; $urunadi = $data->sheets[0]['cells'][$i][2]; $marka = $data->sheets[0]['cells'][$i][3]; $gurup = $data->sheets[0]['cells'][$i][4]; $hedef = $data->sheets[0]['cells'][$i][5]; $birimmaliyet = $data->sheets[0]['cells'][$i][6]; $satisfiyat = $data->sheets[0]['cells'][$i][7]; $aciklama = $data->sheets[0]['cells'][$i][7]; date_default_timezone_set("Europe/Istanbul"); $bugun =date("d.m.Y"); $coz = mb_detect_encoding($urunadi, "ASCII,UTF-8,ISO-8859-1,UTF-16,ISO-8859-9"); $hucre_textimiz = iconv($coz, 'UTF-8', $urunadi); $kontrolet = mysql_num_rows(mysql_query("select * from stokkartlari where urunkodu='".$urunkodu."' ")); if($kontrolet=="0"){ mysql_query("INSERT INTO stokkartlari Set urunkodu='$urunkodu', urunadi='$hucre_textimiz', birim='1', birimmaliyet='$birimmaliyet', birimsatis='$satisfiyat', aciklama='$aciklama', gurup='$gurup', marka='$marka', hedef_tanim='$hedef'"); }else{} } echo ""; } ?>

EXCELDEN STOK KARTI EKLE

zgnm. Bu sayfay grme yetkiniz bulunmuyor.