thanks ya,
setelah dipindah keatas dialog box untuk save nya keluar (di ie), tapi ada
masalah lagi , klo kita downloadnya pake download manager berhasil , tapi klo
tidak pake apa apa ( maksudnya standarnya ie ) , waktu kita pilih save keluar
error :
"internet explorer cannot download tes_excel.php from www.dayadimensi.net.
internet explorer was not able to open this internet site. The requested site
is either unavailable or cannot be found.please try later "
ternyata bagian pragma nya dikosongin aja, ngga usah pake no cache.
header("Pragma: ");
Sekali lagi makasih ya :)
Lingling <[EMAIL PROTECTED]> wrote:
bagian ini dipindah ke paling atas dari file php kamu :
*header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=extraction.xls");
header("Pragma: no-cache");
header("Expires: 0");*
dicoba deh.. saya sendiri udah coba dan berhasil kok..
On 7/11/06, tito surya wardhana <[EMAIL PROTECTED]> wrote:
>
> halo semua,
>
> saya coba script seperti dibawah ini untuk export mysql ke excel,
> tapi masalahnya klo buka pake mozilla, dialog untuk download file keluar,
> tapi klo buka pake ie ngga keluar tuh, malah langsung ke print di layar,
> gimana ya caranya,
> saya sudah coba ganti content typenya jadi vnd.ms-excel , download,
> x-msdownload,x-excel, tetep ngga bisa.
>
> saya pake webserver apache dan webnya jalan di https.
>
> <?
> mysql_connect("localhost","root","");
> mysql_select_db("library");
>
> $select = "SELECT * FROM library";
> $export = mysql_query($select);
> $fields = mysql_num_fields($export);
> for ($i = 0; $i < $fields; $i++) {
> $header .= mysql_field_name($export, $i) . "\t";
> }
> while($row = mysql_fetch_row($export)) {
> $line = '';
> foreach($row as $value) {
> if ((!isset($value)) OR ($value == "")) {
> $value = "\t";
> } else {
> $value = str_replace('"', '""', $value);
> $value = '"' . $value . '"' . "\t";
> }
> $line .= $value;
> }
>
> $data .= trim($line)."\n";
> }
> $data = str_replace("\r","",$data);
> header("Content-type: application/x-msdownload");
> header("Content-Disposition: attachment; filename=extraction.xls");
> header("Pragma: no-cache");
> header("Expires: 0");
> print "$header\n$data";
>
> ?>
>
>
> ---------------------------------
> Do you Yahoo!?
> Everyone is raving about the all-new Yahoo! Mail Beta.
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> --
> www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
> Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
> :: Hapus bagian yang tidak perlu (footer, dst) saat reply! ::
> ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##
> $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$
>
> [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
[Non-text portions of this message have been removed]
---------------------------------
Do you Yahoo!?
Get on board. You're invited to try the new Yahoo! Mail Beta.
[Non-text portions of this message have been removed]
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
:: Hapus bagian yang tidak perlu (footer, dst) saat reply! ::
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##
$$ Iklan/promosi : www.itcenter.or.id/sponsorship $$
[@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
