| Server IP : 61.19.30.66 / Your IP : 216.73.216.80 Web Server : Apache/2.2.22 (Ubuntu) System : Linux klw 3.11.0-15-generic #25~precise1-Ubuntu SMP Thu Jan 30 17:39:31 UTC 2014 x86_64 User : www-data ( 33) PHP Version : 5.3.10-1ubuntu3.48 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : ON | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /var/www/cooperative/ |
Upload File : |
<?
header('Content-type: application/csv');
header('Content-Disposition: attachment; filename="sell.csv"');
require_once "config/connectdb.php";
$tb="klw";
echo "ลบ,แถว,1ถึง3,ก่อนนำเข้า,ข้อมูล\n";
echo "รหัสสินค้า,บาร์โค้ด,จำนวนเงินซื้อ,จำนวนหน่วย,ผู้ขาย,เลขที่สมาชิก,วันที่ขาย,ปีที่ขาย,เวลา,ชนิดขาย,เลขที่บิล,สถานะ\n";
$sql = "select * from sell where yearssell = '$_GET[id]' order by idsell";
$dbquery = mysql_query($sql);
$num_rows = mysql_num_rows($dbquery);
$i=0;
while ($i < $num_rows)
{
$result= mysql_fetch_array($dbquery);
$sellusername=$result[Username];
$crsql="SELECT sum(pricsell ) FROM `sell` where userbysell='$sellusername'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$selltotalstu=$dcrd[0];
echo "$result[idcodesell],$result[bacodesell],$result[pricsell], $result[unitsell],$result[usersell],$result[userbysell],$result[datesell],$result[yearssell],$result[nosell],$result[tpysell],$result[billnumber],$result[statussell],\n";
$i++;
}
?>