[請益] 從Mysql 抓取資料 轉存成TXT
想請教一下
如果我從mysql 中抓取欄位資料
然後再從網頁將顯示出來的資料轉存成TXT
想請問一下 我在save 時候 變數該怎麼寫?
<?php
require_once('123.php');
require_once('456.php');
$query_Recordset1 = "SELECT abc,def,ghi,jkl,mno,pqr from AAA join BBB LIMIT
0,50";
$Recordset1 = $mmm->SelectLimit($query_Recordset1) or die($mmm->ErrorMsg());
$totalRows_Recordset1 = $Recordset1->RecordCount();
//撈取資料庫欄位
while(!$Recordset1->EOF){
?>
<div align="center">
<table width="900" border="0">
<tr>
<td width="150" align="left" ><?php echo
$Recordset1->Fields('abc');?></td>
<td width="150" align="left" ><?php echo
$Recordset1->Fields('def');?></td>
<td width="150" align="left" ><?php echo
$Recordset1->Fields('ghi');?></td>
<td width="150" align="left" ><?php echo
$Recordset1->Fields('jkl');?></td>
<td width="150" align="left" ><?php echo
$Recordset1->Fields('mno');?></td>
<td width="150" align="left" ><?php echo
$Recordset1->Fields('pqr');?></td>
</tr>
</table>
<?php
$Recordset1->MoveNext();
}
//存檔內容以及位置 想請問以下段落我該怎麼修改 才能正確運行 自動轉存成TXT呢
//看書上寫的很多都是要把要寫入的資料直接寫進去 但我該怎麼寫呢?
$savedata = "文件內容文件內容";
$savedata = iconv("UTF-8","big5",$savedata);
$getfilename = 'prt.txt';
touch($getfilename);
if(@$fp = fopen($getfilename, 'w+'))
{
fwrite($fp, $savedata);
fclose($fp);
}
?>
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 124.11.67.218
推
12/27 15:01, , 1F
12/27 15:01, 1F
→
12/27 15:09, , 2F
12/27 15:09, 2F
推
12/27 17:57, , 3F
12/27 17:57, 3F
→
12/27 18:03, , 4F
12/27 18:03, 4F
推
12/27 18:26, , 5F
12/27 18:26, 5F