PHP CSV::exportMysqlToCsv Beispiele

Beispiel #1

Datei: index.php Projekt: laiello/mixexperiments

<?php

include_once 'dbconnect.php';
include_once 'dbtocsv.php';
$csv = new CSV();
$sql = "SELECT products_book_id, book_name, publisher_name, isbn_13, products_book.image\r\nFROM products_book\r\nLEFT JOIN publisher_master ON publisher_master.publisher_master_id = products_book.publisher_master_id\r\nWHERE products_book.image = ''\r\nOR products_book.image NOT LIKE '%.jpg'";
$csv->exportMysqlToCsv($sql);