|
|
Posted by gerg on 01/30/06 21:34
J.O. Aho wrote:
> gerg wrote:
>
>
>>This is a wealth of info. Thanks so much for your response. If I may
>>ponder a few more ideas:
>>
>>so, i'll upload the file ( I can write a scipt or find one to use )
>>
>>Open said file with fopen() ( Where does fgets() come into play. Seems
>>to only return a lenght? I wasn't getting much from php.net. )
>
>
> When using fopen(), it don't read the file itself, you need to loop through
> the whole file in a similar way as when fetching rows from the database (see
> my previous post) and you will read one line at the time.
>
> You can choose to process the rows at the same time you fget() it or store
> into an array. IMHO it's better to process one line at the time, as if the
> uploaded file is a big one, then you will use more RAM if you store it in an
> arrya.
>
>
>
>>so I will need to somehow transfer the text of the .txt file into a
>>variable. Is this what the explode() is used for? Once I get the array
>>I think i'll be good. I was under the understanding that explode will
>>create an array out of every new line. Would that look something like
>>this:
>
>
>>$myarray = explode("/n",$my_text_from_uploaded_file);
>
>
> This would be the case if you had loaded the whole file into one variable,
> remember that this will consume twice as much ram as the file is big, one in
> $my_text_from_uploaded_file and one in $myarray
>
> $fp = @fopen("/path/to/uploaded/file/inputfile.txt", "r");
> /*We check that we can open the file*/
> if ($fp) {
> /* we can read the file, let loop one row/line at the time */
> while (!feof($fp)) {
> $text_line = fgets($fp, 4096);
> /*Do something with the $text_line which contains one line of the text*/
> mysql_query("INSER INTO table VALUE('$text_line')");
> }
> /* we are at the end of the file, we close it */
> fclose($fp);
> echo "File has been stored in the database!<br>\n";
> } else {
> /* Error message as we couldn't open the file */
> echo "We couldn't open the file!!!<br>\n";
> }
>
>
>
>
>>When I run the query into the database I just want the text to be input
>>in the database just like it is on the text document. Do I even need an
>>array for this? Or is there a simpler function that will just copy the
>>text to a variable that I can dump in the database?
>
>
> No, you don't need an array, see the example above, it shows how you read one
> line and inserts the date directly into the database. The examples this far
> hasn't included much of error handling, I do suggest you do check at each step
> that everything went okey, some problems you may be able to fix in the code,
> others may not and you could make the script to mail you all errors, this way
> you can manually insert those error lines.
>
>
>
>>Let me know where you live and I'll talk you to dinner and drinks for
>>helping me wiht this! :)
>
>
> Looking at your posts header it seems that could be quite expensive for you,
> I'm living on east shores of the Lake Atlantic.
>
>
>
> //Aho
Hey Buddy, Thanks for the helpful advice. Seriously it is much appreciated.
Greg
Navigation:
[Reply to this message]
|