To upload a text file into database!!

Anon

Hello,
I need to upload a text file with seven columns into my database which i have already finished but the problem is my text file has whitespaces between each column for which i have separeted using a tab.Since my text file cannot be changed manually everytime i upload the file, i need to terminate the columns by just specifying the white space between columns while uploading!Can anyone can me in finding the solution for this!
I am even sending my text file with only few columns .
01:33:49:90:02:92 ON 533698 3835311 2277479 3530766 6714043
01:33:49:90:07:40 OFF 778681 93056 742644 612857 10178599
01:41:30:00:05:85 ON 2243539 17600529 15190881 32434234 34223444

Can anyone please help me with a solution1
Well Thanks in advance!
Sandhya

[deleted]

Are there whitespaces or tabs between the columns?

shanx24

sandhya,

can u remove all the tabs and replace them with a single white space? something like this:

$text = ereg_replace("\t", " ", $text);

wonder if this helps,
shanx

[deleted]

Like Sandhya said, he/she can't change the file before uploading it each time.
And most databases don't really care too much about what is seperating the fields, as long as you tell it what's seperating the fields.

shanx24

Hi vincent/sandhya

From what I understand, while the text is being uploaded into the db, each tab needs to be replaced by a space.

I might be very wrong, but I think "uploading the text into the DB" would most likely mean that there is an INSERT statement, which takes the value of the text file (the contents of the text file).

If this is the case, it looks something like this..

$text = <Comes from somewhere, most likely from opened file>
$text = ereg_replace("\t", " ", $text);
$sql = insert into mytable (mycolumn) values ('$text');

Again, I am only suggesting this based on what I think sandhya is looking for..

[deleted]

Uploading usually means that the textfile is imported into the db directly,
like MySQL's LOAD DATA INFILE.

That seems to make sense looking at Sandya's example.

Anon

Hello;
can anybody give a complete example
how to upload file to the database?
i'm new to php and mysql.
i really need your help.
Thank you

[deleted]

Look at the articles section under "storing binary data in a database"

Anon

hello,
i have seen that artical,
my problem is how to get the content
of the text file and put it into separate
field in a table.
i have try several way since last few days,
but i fail to get the result.
so i really hope if somebody can help me out.
my problem is just like Sandya.

Thank you!
lizza

Anon

Hello guys,
i have try this code but i got error in the sql command.
the error is "column doesn't match the value"
can somebody help me.

my text file is:
"1","abcd","defg"
"2","uuuu","yyyy"
"3","pppp","xxxx"

the code:
<?

include "./common_emp.inc";
$link_id = db_connect();
mysql_select_db("resume_db");

$file = file($text_file);

while (list($key,$val) = each($file))
{

$val = ereg_replace('\"', "",$val);
$data = explode(",",$val)

$query = sprintf("INSERT INTO employer VALUES ('%s','%s','%s')", $data[0],$data[1],$data[2]);

$result = mysql_query($query);
if(!$result) error_message(sql_error());
}

please help me out.
lizza

[deleted]

It propbably said "column could does not match value count" because you did not specify the columns that should be filled.