Smarty

[satya61229]

Suppose you have to write a script for reading insert data from a very large file (8-9 Mb).
Then What you would do?
Generally Script for this read all data in variable and then read one line a time and insert.
But in this case reading 8MB data in memory itself jam the PHP.

So i have written a script after not getting in google.

I read a chunk of data from file.
Then i read each line.
Check the data in line. Suppose you data is in CSV form and all quoted with double quote. then you can count the (") in line.
You can also extract the line and check that you have right no. of column in that line.
If data in line is not correct then it will be you last line in you read chunk.
So go back the bytes you read. and start with new chunk including this bad data in bytes you read.
You have to make account of data you already read, data to read, chunk size..
I did it for reading MaxMain data, Which is in CSV form.

And make sure, you will run insert query at the last of every chunk read.
and only this way- Insert into tablename (col1, col2..) values (val1,val2), (val1,val2), (val1,val2) ,,,.

satyaprakasha1@yahoo.co.in
http://satya-prakash.blogspot.com/

[shannera]

So what it is you want us to tell about nice smarty tips and tricks?

[satya61229]

[Hielke Hoeve]

All forums are for questions/answers have to be related to Smarty.
_________________
Debug XHTML Compliance
SmartyPaginate
Smarty License Questions
---
(About Unix) The learning curve is full of aha! moments, such as that glorious day that the full beauty of grep and, later, find is revealed in all its majesty. --- Robert Uhl <ruhl@4dv.net>

[boots]

...and now moved to the General forum, though still off-topic