Mamaging a long array of numbers in a text file! Sort of

[M. Johansson]

Hello everyone!

I have a bit of a problem. This is a .txt file that I have:

122323123
238212381
327832981
322873322
232232332
235454455
455353534
...and so forth into oblivion

What I would like to do is to smack all these into a MySQL database in some nifty manner. These are over 1000 numbers, and I will get new txt files all the time, so doing this manually is just not an option. (no, it's not CC numbers)

/Mattias

[freddydoesphp]

I would do this

$data = file("yourtextfile");
foreach($data as $key => $val) {
$result = mysql_query("INSERT into table set field = '$val'");
unset($result);
} 

[M. Johansson]

And freddy saves the day!



Thanks!

[freakysid]

freddy, the last statement in the code you provide is:

unset($result); 

What is the reason for this code. $result should be an int should it not? Is it that important to free up a couple of bytes of memory at this point in the script, or am I missing something?

[M. Johansson]

Oh, darn - I was a bit too quick there. I have two problems.

1. For some reason, it refuses to add more than exactely 127 rows. Very strange.

2. If a row begins with a zero, it ignores the zero - can't have that!

[M. Johansson]

Oh disregard my last post - It was I who accidentally put the ID table as tinyint - I made it mediumint, and it worked fine.

[freakysid]

Originally posted by truelight
2. If a row begins with a zero, it ignores the zero - can't have that!

If a field begins with a zero then it is not a number (to my way of thinking - it is an numeric code not a number) and I would be tempted to store it in a varchar field (but that's my C way of thinking coming through). That said, if you use a int type field, then defining the field with the ZEROFILL option may help?!?

[M. Johansson]

Oh, ah - how stupid of me!

/me changes field to varchar.

[freakysid]

BTW, more for general info (because you have probably already imported the data by now); in mysql you can use a LOAD DATA query to suck the contents of a text file into a table http://www.mysql.com/doc/L/O/LOAD_DATA.html

[M. Johansson]

Nice function, but I will probably not need it. Freddys method imported the file with 1000 rows in about 2 seconds.