Need a quick PHP job

[johnn]

Hi guys,

I need a simple PHP program to read the input text file and write to output text file.

inputfile.txt
name1
name2
name3

outputfile.txt
UPDATE `name1`.`admin` SET `googlecode1` = '<script

type="text/javascript"><!--
google_ad_client = "pub-xxxxxxxxxxxxxxxxxxxxxxx";
/* 728x90, created 3/29/08 */
google_ad_width = 728;
google_ad_height = 90;
google_ad_channel ="5340647399";
google_color_border = "ffffff";
google_color_bg = "ffffff";
google_color_link = "CC0000";
google_color_url = "336699";
google_color_text = "000000";
//-->
</script>
<script type="text/javascript"

src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>' WHERE `admin`.`id` =1 LIMIT 1 ;

UPDATE `Red"]name1[/COLOR][/B]`.`admin` SET `googlecode2` = '<script

type="text/javascript"><!--
google_ad_client = "pub-xxxxxxxxxxxxxxxxxxxxxxx";
/* 468x60, created 3/29/08 */
google_ad_width = 468;
google_ad_height = 60;
google_ad_channel ="5340647399";
google_color_border = "ffffff";
google_color_bg = "ffffff";
google_color_link = "CC0000";
google_color_url = "336699";
google_color_text = "000000";
//-->
</script>
<script type="text/javascript"

src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>' WHERE `admin`.`id` =1 LIMIT 1 ;


UPDATE `name1`.`admin` SET `googlecode3` = '<script

type="text/javascript"><!--
google_ad_client = "pub-xxxxxxxxxxxxxxxxxxxxxxx";
/* 160x600, created 3/29/08 */
google_ad_width = 160;
google_ad_height = 600;
google_ad_channel ="5340647399";
google_color_border = "ffffff";
google_color_bg = "ffffff";
google_color_link = "CC0000";
google_color_url = "336699";
google_color_text = "000000"; /
/-->
</script>
<script type="text/javascript"

src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>' WHERE `admin`.`id` =1 LIMIT 1 ;


UPDATE `name1`.`admin` SET `adminpass` = 'admin2000' WHERE

`admin`.`id` =1 LIMIT 1 ;

 

[Michael]

http://idevlabs.com/php/johnn.phps

 

[johnn]

Thanks a lot Michael.

John