phpBB.sk

AHojte.

Prosím o pomoc. Sanžím sa spraviť import z txt (z xls) do mysql.
Prosím mrknite na to či je to ok, alebo máte po ruke aj niečo jednoduchšie.

1. explode neviem dostať do int len char (musel som všetko nechať v char )
2. neviem ako mám zapísať do DB diakritiku. už ked to zpbrazím cez echo $import tak ju tam nevidím (db mam nastavenu na ute8 sk)

dik za kažné info. som len začiatočník.

<?php


function CsvToSql($file, $delimiter, $host, $dbname, $username, $password, $table)
{

if(!file_exists($file))
{
echo 'The file name '.$file.' does not exist';
}
else
{$data = fopen($file, "r");

$conn = mysql_connect($host, $username, $password) or die();
if (!$conn)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db($dbname, $conn);

$size = count(file($file));

for($i = 1 ; $i < $size; $i++)
{

$contents = file($file, FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES);
$line = trim($contents[$i], $delimiter);
$split = explode($delimiter, $line);
$import = "INSERT INTO ". $table . " (him ,item ,bid ,picture ,remark ,type ,pc_ram ,pc_mhz ,pc_proc_type ,pc_hdd ,pc_mon_size ,region_restrict ,umiestnenie) VALUES ( '".$split[0]."','".$split[1]."','".$split[2]."','".$split[3]."','".$split[4]."','".$split[5]."','".$split[6]."', '".$split[7]."','".$split[8]."','".$split[9]."','".$split[10]."','".$split[11]."','".$split[12]."')";

echo $import."</BR>";


if(!mysql_query($import,$conn))
{
die('Error: ' . mysql_error());
}
echo "record added";

}
}

fclose($file);
mysql_close($conn);
}


?>

nabudúce php kódy vkladaj do tohto tagu

Kód: Vybrať všetko

<?php echo="[code=php]...[/code]"; ?> 

Neviete prečo mi dáva do exportu html kod (v tomto prípade tie aaaaaa a sssssss) do xls ?
ako to odstraniť pls?

Kód: Vybrať všetko

aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
sssssssssssssssssssssssssssssssssssss
<?php

require 'cfg.php';
date_default_timezone_set ('Europe/Belgrade');

$dbhost = $db_cfg['conf']['dbhost'];
$db = $db_cfg['conf']['db'] ;
$dbuser = $db_cfg['conf']['dbuser']  ;
$dbpasswd = $db_cfg['conf']['dbpasswd'];
$dbtable = $db_cfg['conf']['dbtable'] ;

$link = mysql_connect("$dbhost","$dbuser","$dbpasswd");
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db($db, $link);

//****************************************************

$table = 'tonery';
$file = 'tonery';
$csv_output = "";

$result = mysql_query("SHOW COLUMNS FROM ".$table."");
$i = 0;
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
$csv_output .= $row['Field']."; ";
$i++;
}
}
$csv_output .= "\n";

$values = mysql_query("SELECT * FROM ".$table."");
while ($rowr = mysql_fetch_row($values)) {
for ($j=0;$j<$i;$j++) {
$csv_output .= iconv( 'UTF-8', 'Windows-1250' ,$rowr[$j])."; ";
}
$csv_output .= "\n";
}

$filename = $file."_".date("Y-m-d_H-i",time());
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: csv" . date("Y-m-d") . ".csv");
header( "Content-disposition: filename=".$filename.".csv");
print $csv_output;



?>


kodovanie daj utf8 bez BOM asi tam máš nejaké znaky predtým