codehaven - php snippets - coding help
Generic filters
Exact matches only
    • octopus energy discount code

    Create Csv from Mysql and Variables, email csv

    26th November 2013

    Php - Csv

    php codehaven

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
     
    <?php
    header("Content-type: application/csv");
    header("Content-Disposition: attachment; filename=file.csv");
    header("Pragma: no-cache");
    header("Expires: 0");
     
    mysql_connect("localhost", "root", "") or die(mysql_error());
    mysql_select_db("mydatabase") or die(mysql_error());
     
    $query = "SELECT * FROM mypanels ORDER BY id";
    $select_c = mysql_query($query) or die(mysql_error());
     
    while ($row = mysql_fetch_array($select_c, MYSQL_ASSOC))
    {
    //echo  "Name,age,gender,cost";
    // echo "\n";
        $result.="{$row['name']},";
        $result.="{$row['age']},";
        $result.="{$row['gender']},";
        $result.="{$row['cost']},";
        $result.="\n";//next line
        echo $result;
    }
    ?>
     

    RSS Latest Snippets
    LINKS
    A Repository of Code Snippets in many Programming Languages:-

    PHP – JQUERY
    CSS – MYSQL
    WORDPRESS – JAVASCRIPT
    WOOCOMMERCE – HTML

    © 2022 CODEHAVEN