kalo sebaliknya gimana mas - mas expert.... kalo mo masukin data dari file
exel ke mysql pake php ????
ada yang mau bagi - bagi ilmunya ????
On 7/13/06, tito surya wardhana <[EMAIL PROTECTED]> wrote:
>
> 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] <aprida%40gmail.com>> 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] <tito_sw1%40yahoo.com>>
> 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]<itcenter-help%40yahoogroups.com>
> > :: 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]
>
>
>
[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/
