@Burti;
<?php
$data = array(
"Ali",
"Veli",
"Mehmet",
"Ahmet",
"Niyazi",
"Ogün",
"Oğuz",
"Oğuzhan",
"Mert",
"Emre"
);
# dizi anahtar değeri 0 olduğu için 1'den büyükse ve 10'dan küçükse yapıyoruz.
foreach($data as $key => $value)
if($key > 1 && $key < 10)
printf("Sıra: %s, %s\n", $key, $value); $query = mysql_query("SELECT * FROM orders WHERE status='2' AND cargo='1' AND excel='0' ORDER BY id ASC") or die(mysql_error());
$total = mysql_num_rows($query);
foreach($query as $key => $value) {
if($key > 2 && $key < $total) {
//İçerik
$objPHPExcel->getActiveSheet()->SetCellValue('A'.$key.'', ''.$value['id'].'');
$objPHPExcel->getActiveSheet()->SetCellValue('B'.$key.'', 'GRAM');
$objPHPExcel->getActiveSheet()->SetCellValue('C'.$key.'', 'AD SOYAD');
$objPHPExcel->getActiveSheet()->SetCellValue('D'.$key.'', 'İL');
$objPHPExcel->getActiveSheet()->SetCellValue('E'.$key.'', 'İLÇE');
$objPHPExcel->getActiveSheet()->SetCellValue('F'.$key.'', 'ADRES');
$objPHPExcel->getActiveSheet()->SetCellValue('G'.$key.'', 'TELEFON');
$objPHPExcel->getActiveSheet()->SetCellValue('H'.$key.'', 'ÜRÜN');
}
}( ! ) Warning: Invalid argument supplied for foreach() in C:\wamp\www\**.net\admin\include\excel.php on line 44
44: foreach($query as $key => $value) {