 |
|
Code (PHP)
<body>
<?
$filName = "rebuydrug.csv";
$objWrite = fopen("rebuydrug.csv", "w");
$objDB = mysql_select_db("$db_clinic");
$strSQL= " select did,tname,unit,sprice,total,sqty from tb_druge where status = 'IN' and sqty > total ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
fwrite($objWrite, "\"id\",\"name\",\"unit\",\"total\",\"sqty\" \n");
while($objResult = mysql_fetch_array($objQuery))
{
fwrite($objWrite, "\"$objResult[did]\",\"$objResult[tname]\",\"$objResult[unit]\",\"$objResult[total]\",\"$objResult[sqty]\" \n");
// fwrite($objWrite, "\"$objResult[did]\",\"$objResult[tname]\",\"$objResult[unit]\",");
// fwrite($objWrite, "\"$objResult[sprice]\",\"$objResult[total]\",\"$objResult[sqty]\" \n");
}
fclose($objWrite);
echo "<center><br>ดาวน์โหลดยาถึงจุดสั่งซื้อเป็น Excel<br><a href=$filName>Download</a></center>";
//onclick='window.close();'
?>
</table>
</body>
|
ประวัติการแก้ไข
2015-01-23 15:48:57
 |
 |
 |
 |
| Date :
2015-01-23 15:47:50 |
By :
para_dize |
|
 |
 |
 |
 |
|
|
 |
Load balance : Server 00
