Oh, thank you so much for writing!
Well, I have now collected some code (with support of others :D), that looks like this one:
<?php
$fh=fopen('uploads/datei.txt');
while(!feof($fh)){
$string = fgets($fh);
$array[1].=substr($string,2,9);
$array[2].=substr($string,19,9);
$array[3].=substr($string,28,9);
$array[4].=substr($string,37,8);
$array[5].=substr($string,45,9);
$array[6].=substr($string,99,5);
$array[7].=substr($string,104,2);
$array[8].=substr($string,108,18);
$array[9].=substr($string,300,18);
}
$new_variable = implode(';',$array);
echo $new_variable;
?>
What I have to do now, is to write these code slices into my data base (because currently it is only working for ONE line of 480 charakters), that has the following structure:
mysql_query(“CREATE TABLE datenimport (
id
int(255) NOT NULL auto_increment,
kennung
varchar(1) NOT NULL default ‘0’,
zusatzkennung
varchar(1) NOT NULL default ‘0’,
buchungsdatum
varchar(100) NOT NULL,
beleg
varchar(8) NOT NULL,
buchungstext
varchar(60) NOT NULL,
sollkonto
varchar(100) NOT NULL,
habenkonto
varchar(100) NOT NULL,
buchungsbetrag
varchar(100) NOT NULL,
steuerbetrag
varchar(100) NOT NULL,
steuersatz
varchar(100) NOT NULL,
fwcode
varchar(100) NOT NULL default ‘0’,
fwbuchungsbetrag
varchar(100) NOT NULL,
fwsteuerbetrag
varchar(100) NOT NULL,
nettozahlungsziel
varchar(100) NOT NULL,
skontotage1
varchar(100) NOT NULL,
skonto1
varchar(100) NOT NULL,
skontotage2
varchar(100) NOT NULL,
skonto2
varchar(100) NOT NULL,
zessionsbank
varchar(100) NOT NULL,
mahnen
varchar(100) NOT NULL,
verzugszinsen
varchar(100) NOT NULL,
bankeinzug
varchar(100) NOT NULL,
valutadatum
varchar(100) NOT NULL,
opnummernkostenstelle
varchar(100) NOT NULL,
skontobetrag
varchar(100) NOT NULL,
fwskontobetrag
varchar(100) NOT NULL,
kore
varchar(1) NOT NULL default ‘0’,
PRIMARY KEY (id) );”);
mysql_close();
So, there are only 9 slices, that are relevant for the output to the DB table.
The current output looks like:
000066202;000000000;000000012;01201310;00008060 ;00000;00;0000000000010540+0;OHN/01 L
But how?
;D
