[RESOLVED] Need help with reading/parsing a txt file

MadRhino

I ran into a bit of a bump. A IDX vendor has updated their photo txt files.
Before, the photo file only contained the name of the image file (1 column).

Here is my old code:

$images=$config['connection']['working_directory'];
		$images=explode("\n", file_get_contents("{$images}/active_photos.txt"));
		unset($images[0]);
		foreach ($images as $key => $value) 
			{ 
			list($value)=explode("\t", $value);

		$images[trim($value)]=trim($value); 
		unset($images[$key]); 

		list($listing_id)=explode('_', $value);
		$listing_id=trim($listing_id);

		@mysql_query("insert into mls_listing_photos set listing_id='".a($listing_id)."',  filename='".a($value)."'");
		}

As you can see from my code above, all I am doing is reading the file name, and creating 2 values, one for the listing id (mls number) and keeping the original filename.

Now on the new photo txt, the file is tab delimited with an added column. That is where I'm stuck... sorry, my php are limited at this point! Any help or advice would be great!

Gregg

bpat1434

Take a looksie at [man]str_getcsv/man which will take a string, and parse it into an array.

And you can set the delimiter and enclosure that the file uses in case it's not a comma and a double-quote respectively.

MadRhino

Hey bpat1434,

Thanks for the reply. After studying "list" for a bit last night, I figured it out. Actually it was pretty simple.

Here is a snippet of the previous code :

list($value)=explode("\t", $value);

All I needed to do was assign a variable to the new column in the txt file like so:

list($value, $newvalue)=explode("\t", $value);

So, I take it that you can assign more variables as well. If I am wrong, someone please let me know.

Works great!

Again, thanks for your reply, I really appreciate it!

Gregg

bpat1434

Yes, you could just keep adding variables to list for as many columns as there will be; however, that requires that there actually is a value for each column. Something str_getcsv() might take into account for (e.g. empty columns).

MadRhino

I see.. so when I update my entire I engine, I really need study str_getcsv(). I have used str_getcsv() before on a smaller project, but after I wrote this IDX script.

Again, thanks. It's been very helpful!