PHP make_csv_line Examples

Example #1

File: example-10-15.php Project: KimiyukiYamauchi/php.2015

<?php

require 'MDB2.php';
require 'example-10-12.php';
$db = MDB2::connect('mysql://*****:*****@localhost/restaurant');
if (MDB2::isError($db)) {
    die("connection error: " . $db->getMessage());
}
// この後のデータベースエラーに関してはメッセージを出力して抜け出す
$db->setErrorHandling(PEAR_ERROR_DIE);
// Tell the web client that a CSV file called "dishes.csv" is coming
header('Content-Type: text/csv');
header('Content-Disposition: attachment; filename="dishes.csv"');
// Retrieve the info from the database table and print it
$dishes = $db->query('SELECT dish_name, price, is_spicy FROM dishes');
while ($row = $dishes->fetchRow()) {
    print make_csv_line($row);
}

Example #2

File: example-10-13.php Project: KimiyukiYamauchi/php.2015

<?php

require 'MDB2.php';
require 'example-10-12.php';
$db = MDB2::connect('mysql://*****:*****@localhost/restaurant');
if (MDB2::isError($db)) {
    die("connection error: " . $db->getMessage());
}
// この後のデータベースエラーに関してはメッセージを出力して抜け出す
$db->setErrorHandling(PEAR_ERROR_DIE);
// Open the CSV file for writing
$fh = fopen('dishes2.csv', 'wb');
$dishes = $db->query('SELECT dish_name, price, is_spicy FROM dishes');
while ($row = $dishes->fetchRow()) {
    // Turn the array from fetchRow() into a CSV-formatted string
    $line = make_csv_line($row);
    // Write the string to the file. No need to add a newline on
    // the end since make_csv_line() does that already
    fwrite($fh, $line);
}
fclose($fh);
echo 'OK';