download: tại đây
**** Import:
download:tại đây
linkwebsite: nhancuoi
EXPORT CSV-------------------------------------------------------------------
$conn = mysqli_connect("localhost","username","password", "database");
$query = "SELECT * FROM toy";
$result = mysqli_query($conn, $query);
$num_column = mysqli_num_fields($result);
$csv_header = '';
for($i=0;$i<$num_column;$i++) {
$csv_header .= '"' . mysqli_fetch_field_direct($result,$i)->name . '",';
}
$csv_header .= "\n";
$csv_row ='';
while($row = mysqli_fetch_row($result)) {
for($i=0;$i<$num_column;$i++) {
$csv_row .= '"' . $row[$i] . '",';
}
$csv_row .= "\n";
}
/* Download as CSV File */
header('Content-type: application/csv');
header('Content-Disposition: attachment; filename=toy_csv.csv');
echo $csv_header . $csv_row;
exit;
UPLOADFILE-------------------------------------------------------------------
function uploadfile($path){
global $max_size, $width;
$application = array("application/vnd.ms-excel","text/xls");
if((!empty($_FILES["userfile"])) && ($_FILES['userfile']['error'] == 0)){
@unlink("".INCLUDE_PATH."$path/$filename");
$ext = substr($filename, strrpos($filename, '.') + 1);
if (($ext == "xls") && (in_array($_FILES["userfile"]["type"],$application)) && ($_FILES["userfile"]["size"] <= ($max_size*100))) {
//&& ($_FILES["userfile"]["size"] < 2000000)
$newname = INCLUDE_PATH."$path/".$filename;
if (!file_exists($newname)) {
if ((@move_uploaded_file($_FILES['userfile']['tmp_name'],$newname))){
$f = $filename;
} else {
info_exit("<br><br>Error: A problem occurred during file upload!<br>");
}
} else {
info_exit("Error: File ".$_FILES["userfile"]["name"]." already exists");
}
} else {
$maxsize = $max_size*100;
info_exit("Error: Only .XLS files under($maxsize) are accepted for upload");
}
} else {
return "Error: No file uploaded";
}
return $f;
}
