Ciao,
con ogni singola riga del mio database?
<?php
$host="xxx.xxx.xxx.xxx";
$user="my_user";
$pass="my_psw";
$db_name="my_db";
$table="tblprojects";
$conn = mysqli_connect($host,$user,$pass,$db_name) or die("Errore connessione");
$query = "SELECT status, deadline, name, description FROM $table";
$result = mysqli_query($conn,$query) or die("Errore della query");
//delete file old
unlink('./export/file.csv');
//Open a file in write-mode (he creates it, if it not exists)
$fp = fopen('./export/file.csv', 'w');
// output the column headings
fputcsv($fp, array('status','deadline','name','description'));
function utf8($value) {
return str_replace("<br />", " - ", utf8_encode($value));
}
// loop over the rows, outputting them
while ($row = mysqli_fetch_assoc($result)) {
fputcsv($fp, array_map(utf8, $row));
}
//close the handler
fclose($fp);
?><?php
$host = "localhost";
$user = "root";
$pass = "password";
$db_name = "database";
$conn = mysqli_connect($host, $user, $pass, $db_name) or die("Errore connessione");
$query = "SELECT status,deadline,name,description,value FROM tblprojects T1 "
. "LEFT JOIN tblcustomfieldsvalues T2 ON T1.id = T2.relid && fieldid = 23 "
. "ORDER BY T1.id DESC";
$result = mysqli_query($conn, $query) or die("Errore della query");
//delete file old
if (file_exists("file.csv")) {
unlink('file.csv');
}
//Open a file in write-mode (he creates it, if it not exists)
$fp = fopen('file.csv', 'w');
// output the column headings
fputcsv($fp, array('status', 'deadline', 'name', 'description', 'venditore'));
function utf8($value) {
return str_replace("<br />", " - ", utf8_encode($value));
}
$venditori = array("", "pinco", "pallo", "tizio");
// loop over the rows, outputting them
while ($row = mysqli_fetch_assoc($result)) {
$row['value'] = array_search($row['value'], $venditori);
fputcsv($fp, array_map("utf8", $row));
}
//close the handler
fclose($fp);$row['campodata'] = implode("/", array_reverse(explode("-", $row['campodata'])));<?php
$host="my_host";
$user="my_user";
$pass="my_pass";
$db_name="my_dbname";
$conn = mysqli_connect($host, $user, $pass, $db_name) or die("Errore connessione");
$query = "SELECT status,deadline,name,description,value FROM tblprojects T1 "
. "LEFT JOIN tblcustomfieldsvalues T2 ON T1.id = T2.relid && fieldid = 23 "
. "ORDER BY T1.id DESC";
$result = mysqli_query($conn, $query) or die("Errore della query");
$row['campodata'] = implode("/", array_reverse(explode("-", $row['campodata'])));
//delete file old
if (file_exists("./files/export.csv")) {
unlink('./files/export.csv');
}
//Open a file in write-mode (he creates it, if it not exists)
$fp = fopen('./files/export.csv', 'w');
// output the column headings
fputcsv($fp, array('status', 'deadline', 'name', 'description', 'partners'));
function utf8($value) {
$value = str_replace("\"", "", $value);
return str_replace("<br />", " - ", utf8_encode($value));
}
$venditori = array("", "pinco", "pallo", "caio", "sempronio");
// loop over the rows, outputting them
while ($row = mysqli_fetch_assoc($result)) {
$row['value'] = array_search($row['value'], $venditori);
fputcsv($fp, array_map("utf8", $row));
}
//close the handler
fclose($fp);function utf8($value) {
$value = str_replace("\"", "", $value);
$value = str_replace("<br />", " - ", utf8_encode($value));
echo $value . "<br/>";
return $value;
}
