Cruthaich faidhle CSV airson neach-cleachdaidh ann am PHP

SSL earbsach bho dìreach $3.44
sanasan
Clò-bhuail array gu faidhle
Seall àireamh gu dà ionad deicheach ann am PHP

aithris duilgheadas

Ma tha dàta agad ann an stòr-dàta MySQL. Tha thu a’ cur URL chun neach-cleachdaidh gus an dàta aca fhaighinn a-mach mar fhaidhle CSV.

Ciamar as urrainn dhut, nuair a phutas iad air a’ cheangal, pop-up a bhith agad gus CVS a luchdachadh sìos leis a’ chlàr bho MySQL?

Fuasgladh 1

header("Content-Type: text/csv");
header("Content-Disposition: attachment; filename=file.csv");

function outputCSV($data) {
  $output = fopen("php://output", "wb");
  foreach ($data as $row)
    fputcsv($output, $row); // here you can change delimiter/enclosure
  fclose($output);
}

outputCSV(array(
  array("name 1", "age 1", "city 1"),
  array("name 2", "age 2", "city 2"),
  array("name 3", "age 3", "city 3")
));

Fuasgladh 2

Seo dreach leasaichte den ghnìomh bho php.net. Cuimhnich air exit() às deidh dhut seo a ghairm ma tha thu deiseil leis an duilleag.

function download_csv_results($results, $name = NULL)
{
    if( ! $name)
    {
        $name = md5(uniqid() . microtime(TRUE) . mt_rand()). '.csv';
    }

    header('Content-Type: text/csv');
    header('Content-Disposition: attachment; filename='. $name);
    header('Pragma: no-cache');
    header("Expires: 0");

    $outstream = fopen("php://output", "wb");

    foreach($results as $result)
    {
        fputcsv($outstream, $result);
    }

    fclose($outstream);
}

Tha e gu math furasta a chleachdadh agus bidh e ag obair gu math le seataichean toraidh MySQL(i) / PDO.

SSL earbsach bho dìreach $3.44
sanasan
download_csv_results($results, 'your_name_here.csv');
Clò-bhuail array gu faidhle
Seall àireamh gu dà ionad deicheach ann am PHP
dùin

Cùm suas ris an fhiosrachadh as ùire mu PHP!

Cha bhith sinn a’ spamadh!

SSL earbsach bho dìreach $3.44
sanasan

en English
X
Rach gu mhullaich