function exportAsExcel($query, $HederName) { header("Content-Type: application/vnd.ms-excel; charset=utf-8"); header("Content-Disposition: attachment; filename=filename.xls"); header("Pragma: no-cache"); header("Expires: 0"); //$HederName= Array("id","Name"); //$query = "SELECT id,name FROM jos_users" ; $res = FetchSqltoArray($query); foreach ($HederName as $Name) { echo $Name . "\t"; } echo "\n\r"; foreach ($res as $row) { foreach ($row as $clom) { print_r($clom . "\t"); } echo "\n\r"; } }
$qr = "select * from `buyProsses` where `bid`='{$BID}' and `pid`='{$PID}' "; $res = FetchSqltoArray($qr); if ($res) { $bid_server = $res[0]['bid']; $pid_server = $res[0]['pid']; $rnd_server = $res[0]['rnd']; $UNIC = $devID + $rnd_server; $UNIC = $UNIC + $pid_server; $crcDevpayload = md5($UNIC); if (trim($developerPayload) == $crcDevpayload) { // all thing is ok // buy prosses should end // make dl link and send password if (trim($purchaseState) == BILLING_RESPONSE_RESULT_OK) { $qr = "SELECT `path`,`password` FROM `product` where `pid`='{$pid_server}' and `productID`='{$productId}'"; $res = FetchSqltoArray($qr); if ($res) { $qr = "DELETE FROM `buyProsses` WHERE `buyProsses`.`bid` = '{$bid_server}' AND `buyProsses`.`pid` = '{$pid_server}' LIMIT 1"; insert($qr); $qr = "INSERT INTO `buyed` (`bid` ,`pid`,`orderID`)VALUES ('" . $bid_server . "', '" . $pid_server . "', '" . $orderID . "');"; insert($qr); $returnVal = $res[0]['path'] . "aminOmid" . $res[0]['password']; $returnVal = fnEncrypt($returnVal, "1234567890abcdef", $devID); echo $returnVal; } } else { die("PAYMENT NOT ACCEPTED"); } } else { die("PayLoad ID not accepted"); }