$s = mysql_query($query, $connect);
}
fclose($handle);
}
echo "Imported " . $csv_file . "<br>\n";
}
//get list of csv files that were imported
$csvs = array();
$sql = 'SELECT * FROM csv_files';
$retval = mysql_query($sql, $connect);
while ($row = mysql_fetch_array($retval, MYSQL_ASSOC)) {
array_push($csvs, $row['name']);
}
//import csv files that are not already imported
$csvfile = "";
if ($handle = opendir('csv')) {
while (false !== ($file = readdir($handle))) {
if ($file != "." && $file != ".." && strtolower(substr($file, strrpos($file, '.') + 1)) == 'csv') {
if (!in_array($file, $csvs)) {
import_csv('csv/' . $file, $connect);
$query = "INSERT INTO csv_files(name) VALUES('" . $file . "')";
$s = mysql_query($query, $connect);
}
}
}
closedir($handle);
}
mysql_close($connect);
?>
echo '<pre>';
var_dump($osoba);
echo '</pre>';
echo date("H:i:s")." kontrola<br>\n";
break;
case "jmena":
$res=kontrola_jmena('Řehoř');
echo '<pre>';
var_dump($res);
echo '</pre>';
echo date("H:i:s")." kontrola<br>\n";
break;
case "csv":
$osoby=import_csv(file('gym.csv'));
echo "Nalezeno ".count($osoby)." osob<br>";
if (is_array($osoby))
foreach ($osoby as $osoba)
echo "$osoba[id] $osoba[jmeno] $osoba[prijmeni] $osoba[narozeni] $osoba[pohlavi] $osoba[cizinec] $osoba[email] $osoba[mobil] $osoba[error]<br>\n";
//echo "<pre>\n";
//var_dump($osoby);
//echo "</pre>\n";
echo date("H:i:s")." import CSV<br>\n";
break;
case "cookies":
$x=getallheaders();
echo "<pre>\n";
var_dump($x);
echo "</pre>\n";
$message = null;
if (isset($_FILES['csv'])) {
$csv = init_csv();
if ($csv === NULL) {
$error = \i18n("Selected file empty or bad format", PLUGIN_NAME);
} else {
if (!$csv->isOpen()) {
$err = array();
foreach ($csv->getErrors() as $mess) {
$err[] = \i18n($mess);
}
if (count($err) > 0) {
$error = $err;
}
} else {
$msgs = import_csv($csv);
$message = $msgs[0];
$error = $msgs[1];
}
}
}
?>
<h1><?php
\pi18n("Import products from csv file", PLUGIN_NAME);
?>
</h1>
<?php
\Pasteque\tpl_msg_box($message, $error);
<?php
include $_SERVER['DOCUMENT_ROOT'] . '/includes/db_new.inc.php';
//require_once $_SERVER['DOCUMENT_ROOT'] . '/includes/access.inc.php';
// if(!isUserLoggedIn()) {
// include '../login.html.php';
// exit();
// }
// ACTIONS
// IMPORT FROM CSV
if (isset($_GET['files'])) {
$arr = array('@dummy1', 'lastdeal', '@dummy2', 'openrate', 'maximum', 'minimum', 'closerate', 'dayvol', 'ratedate', '@dummy3', 'quoteid');
$filename = $_GET['files'][0];
$q = import_csv('rates', $arr, $filename);
try {
$link = mysql_connect('localhost', 'stocksuser', 'jd5xugLMrr') or die('Could not connect to server.');
mysql_select_db('stocks_new', $link) or die('Could not select database.');
mysql_query($q, $link) or die(mysql_error());
//echo "File was uploaded successfully";
header('Location: .');
} catch (PDOException $e) {
$error = 'Error loading CSV: ' . $e->getMessage();
include 'error.html.php';
exit;
}
}
// ADD
if (isset($_GET['addrate'])) {
$pageTitle = 'New Rate';
$action = 'addform';
$quoteid = 0;
if (isset($_FILES['csv'])) {
$dateStr = isset($_POST['date']) ? $_POST['date'] : \i18nDate(time());
$dateStr = \i18nRevDate($dateStr);
$date = \Pasteque\stdstrftime($dateStr);
$csv = init_csv();
if ($csv === NULL) {
\Pasteque\tpl_msg_box(NULL, \i18n("Selected file empty or bad format", PLUGIN_NAME));
} else {
if (!$csv->isOpen()) {
$err = array();
foreach ($csv->getErrors() as $mess) {
$err[] = \i18n($mess);
}
\Pasteque\tpl_msg_box(NULL, $err);
} else {
import_csv($csv, $date);
}
}
}
?>
<h1><?php
\pi18n("Import category from csv file", PLUGIN_NAME);
?>
</h1>
<form class="edit" method="post" action="<?php
echo \Pasteque\get_module_url_action(PLUGIN_NAME, 'categoriesManagement');
?>
" enctype="multipart/form-data">
<div class="row">
<label for='csv' >
* under the terms of the GNU Affero General Public License as published by
* the Free Software Foundation, either version 3 of the License, or (at
* your option) any later version.
*
* allocPSA is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
* FITNESS FOR A PARTICULAR PURPOSE. See the GNU Affero General Public
* License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with allocPSA. If not, see <http://www.gnu.org/licenses/>.
*/
require_once "../alloc.php";
if ($_POST['import']) {
$projectID = $_POST["projectID"];
$result = import_csv($_POST["filename"], $_POST["columns"], $_POST["headerRow"]);
$TPL['result'] = $result;
$TPL['main_alloc_title'] = "CSV Import Results";
$TPL['projectID'] = $projectID;
include_template("templates/csvImportResultM.tpl");
exit;
}
//$_GET["filename"] = "/var/local/alloc/tmp/test.csv";
$basepath = ATTACHMENTS_DIR . 'tmp' . DIRECTORY_SEPARATOR;
$rp = realpath($basepath . $_GET['filename']);
if ($rp === FALSE || strpos($rp, $basepath) !== 0) {
alloc_error("Illegal path", true);
}
$fh = fopen($rp, "r");
if ($fh === false) {
alloc_error("File won't open.", true);
<form enctype="multipart/form-data" action="" method="post">
<input type="hidden" name="MAX_FILE_SIZE" value="2000000" />
<input type="file" name="uploadFile" />
<input type="submit" name="upload" value="Импортировать в БД" />
</form>
<?php
require 'temp/converter.php';
if (isset($_POST['upload'])) {
$folder = 'temp/';
$uploadedFile = $folder . basename($_FILES['uploadFile']['name']);
if (is_uploaded_file($_FILES['uploadFile']['tmp_name'])) {
if (move_uploaded_file($_FILES['uploadFile']['tmp_name'], $uploadedFile)) {
convert_file($_FILES['uploadFile']['name']);
if (import_csv()) {
echo "Загружено";
}
} else {
echo 'Во время загрузки файла произошла ошибка';
}
} else {
echo 'Файл не загружен';
}
}
?>
</div>
<!-- далее обработка загруженного файла , отправка его в бд. -->
$input_fields = array('login', 'pass', 'email', 'name_f', 'name_l', 'street', 'city', 'state', 'zip', 'country', 'is_male', 'product_id', 'expire_date', 'begin_date', 'paysys_id', 'receipt_id', 'amount');
foreach ($member_additional_fields as $field) {
if ($field['type'] != 'hidden') {
$input_fields[] = $field['name'];
}
if ($field['sql']) {
$import_member_fields[] = $field['name'];
}
}
$csv_total_records = 0;
$total_added = 0;
$records_count = 0;
$import_product_cache = array();
$import_members_cache = array();
$import_payment_cache = array();
$csv_duplicate_logins = array();
$amember_duplicate_logins = array();
$vars = get_input_vars();
$import_begin_time = time();
switch ($vars['action']) {
case 'upload':
check_demo();
import_upload();
break;
case 'import':
check_demo();
import_csv();
break;
default:
import_upload();
}
$db_name = 'imports';
}
// Define database connection properties.
define('DB_HOST', 'localhost');
define('DB_USER', 'root');
define('DB_PASS', '');
define('DB_NAME', $db_name);
// Fancy footwork with argv.
if ($argv[1][0] == '-') {
$prog_name = $argv[0];
$argv = array_slice($argv, 3);
array_unshift($argv, $prog_name);
}
// Do actual work.
db_connect();
import_csv(realpath($argv[1]));
exit;
function import_csv($file_path)
{
$file_name = basename($file_path);
// Enter main loop.
if (!($fp = fopen($file_path, 'r'))) {
die("Error: File cannot be opened.\n");
}
$header = fgetcsv($fp, 4056);
$rows = array();
if (($pos = array_search('id', $header)) !== false) {
$header[$pos] = 'item_id';
}
while ($row = fgetcsv($fp, 8112)) {
$rows[] = array_combine($header, $row);
