✏️ Edit: importtbl.php
Path:
/home/thiqat5/admincrud.thiqatech.com/sql/modules/importtbl.php
Size: 3 KB · Modified: 2023-08-20 10:31:19 · Perm: 0644 · Writable
← Back to directory
👁 View
⬇ Download
<?php /** * This file is a part of MyWebSQL package * * @file: modules/importtbl.php * @author Samnan ur Rehman * @copyright (c) 2008-2014 Samnan ur Rehman * @web http://mywebsql.net * @license http://mywebsql.net/license */ function processRequest(&$db) { $importDone = FALSE; $message = ''; $refresh = '0'; $max_upload_size = min(bytes_value(ini_get('post_max_size')), bytes_value(ini_get('upload_max_filesize'))) / 1024; $max_upload_size_text = ($max_upload_size < 1024) ? $max_upload_size.'KB' : ($max_upload_size/1024).' MB'; if (isset($_FILES['impfile'])) { if (v($_FILES['impfile']['tmp_name']) != '' && file_exists($_FILES['impfile']['tmp_name'])) { //$module_id = create_module_id( 'import' ); include(BASE_PATH . "/lib/import/import.php"); $type = 'csv'; $imptype = v($_REQUEST['$imptype']); if(in_array($imptype, DataImport::types())) $type = $imptype; $importer = DataImport::factory($db, $type); $options = extract_vars($_REQUEST, $importer->options()); $result = $importer->importTable($_FILES['impfile']['tmp_name'], $options); $failed = $importer->getFailedQueries(); $affected = $importer->getRowsAffected(); if (!$result || $affected > 0 || $failed > 0) { $message .= '<div class="message ui-state-default">[ ' . str_replace('{{NUM}}', $affected, __('{{NUM}} record(s) were affected')) . '. ]</div>'; if ($failed > 0) { $message_tmp = ($failed > 1) ? str_replace('{{NUM}}', $failed, __('{{NUM}} queries failed to execute')) : __('Error occurred while executing the query'); $message .= '<div class="message ui-state-error">'.$message_tmp.'</div>'; if ($failed == 1) { $message .= '<div class="message ui-state-error">' . htmlspecialchars($importer->getError()) . '</div>'; $message .= '<div class="sql-text ui-state-error">' . htmlspecialchars($importer->getLastQuery()) . '</div>'; } } } else $message .= '<div class="message ui-state-default">'.__('No queries were executed during import').'.</div>'; } else $message .= '<div class="message ui-state-error">'.__('File upload failed. Please try again').'.</div>'; $importDone = TRUE; } if (!$importDone) { $message = '<div class="message ui-state-default">'.str_replace('{{SIZE}}', $max_upload_size_text, __('Maximum upload filesize is {{SIZE}}')); $message .= '<br/>' . str_replace('{{LIST}}', valid_import_files(), __('Supported filetypes / extensions are: ({{LIST}})')) . '</div>'; } else { $refresh = '1'; } include(BASE_PATH . '/lib/html.php'); $tables = html::arrayToOptions($db->getTables(), '', true, ''); $replace = array( 'MESSAGE' => $message, 'MAX_SIZE' => $max_upload_size, 'REFRESH' => $refresh, 'TABLE_LIST' => $tables ); echo view('importtbl', $replace); } function valid_import_files() { $files = '*.csv, *.txt'; /*if (function_exists('bzopen')) $files .= ', *.bz, *.bzip, *.bz2'; if (function_exists('gzopen')) $files .= ', *.gz, *.gzip';*/ return $files; } ?>
💾 Save
Cancel
Save as UTF-8, newlines normalized to LF