Hi,
for ($i=1; $i <= 3; $i++) {
echo $i . ": " . $lines4[$i] . "\n";
list($words, $file) = explode(" ", $lines4[$i]);
$carriage= array("\r\n", "\r", "\n");
str_replace($carriage, "", $lines4[$i]);
echo "File: $file has $words words\n\n";
$query3="INSERT INTO youtoo(Description,Filename,Words) VALUES ('$lines4[0]','$file', '$words')";
$result1= mssql_query($query3) or die ("Couldn't Create New Entry into Database $myDB");
}
Is this the change you told me to change? Or, am I having some other issues here in this revised code?
I have just checked my database, and it is still giving me the same square. Could there be something else that I have missed?
Thanks for your help.
Alice
======================================================
Alice Wei
MIS 2009
School of Library and Information Science
Indiana University Bloomington
ajwei@xxxxxxxxxxx
________________________________________
From: Zephaniah ha Levi [zleviticus@xxxxxxxxxxxxxx]
Sent: Monday, June 30, 2008 1:41 PM
To: Wei, Alice J.; php-windows@xxxxxxxxxxxxx
Subject: RE: Remove End of Line Characters
My guess is that the squares are line feed or carriage returns. Do a
str_replace on \r and \n
-----Original Message-----
From: Wei, Alice J. [mailto:ajwei@xxxxxxxxxxx]
Sent: Monday, June 30, 2008 1:25 PM
To: php-windows@xxxxxxxxxxxxx
Subject: Remove End of Line Characters
Hi,
I have a simple file as follows:
There are in the total of 513 words in sinus.txt, lung.txt and stomach.txt.
151 sinus.txt
105 lung.txt
257 stomach.txt
What I want to do is to print the first line in the Description column, and
have each of the following lines be entered into the database by assigning
the number as $words, and the filename into the Filename column.
The script in the following performs exactly the way I wanted, except for
the fact that in my database, each of the entries looks something like this:
sinus.txt followed by a square for each of the variables that contains text.
I don't have this problem for my numbers at all.
for ($i=1; $i <= 3; $i++) {
echo $i . ": " . $lines4[$i] . "\n";
list($words, $file) = explode(" ", $lines4[$i]);
echo "File: $file has $words words\n\n";
substr($file, 0, -3);
//substr($lines4['0'],0,-1);
$query3="INSERT INTO youtoo(Description,Filename,Words) VALUES
('$lines4[0]','$file', '$words')";
$result1= mssql_query($query3) or die ("Couldn't Create New Entry into
Database $myDB");
}
I tried using rtrim(), chop() using the $line4 as I have declared and there
is no use. Finally, I used substr(), but this does not seem to get what I
wanted either, and the square is still in the way. I checked my text file in
the text editor, and I see nothing that could have produced the square
during the database entering process.
Does anyone know what I have done wrong here? Anything is appreciated.
Alice
======================================================
Alice Wei
MIS 2009
School of Library and Information Science
Indiana University Bloomington
ajwei@xxxxxxxxxxx
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
