[SOLVED] WORD Avery Label?

[tqla]

Hi. I am using a script that prints my database to an Avery 5160 formatted PDF file.

I need to make one that prints to a Microsoft Word document.

Does this sound like something that is even possible?

[Fadion]

U can just use fopen

 

$file = fopen('file.doc', 'w+');
$text = 'Some text here';
fwrite($file, $text);
fclose($file);

[tqla]

Thanks GuiltyGear.

 

Is it possible to put a script within the text part. I tried this but got an "parse error, unexpected T_STRING".

 

$file = fopen('file.doc', 'w+');
$text = '

// echo out the results to the screen
while ($Fields = mysql_fetch_array($result)) {

echo "{$Fields['MCity']} <br>";

} // end while 


     ';
fwrite($file, $text);
fclose($file);

[Fadion]

It cant work like that as it interprets all those lines as a string and also u got " inside '. But this may do it:

 

$file = fopen('file.doc', 'w+');
$text = "";
while ($Fields = mysql_fetch_array($result)) {
  $text .= $Fields['MCity'] . '<br />';
}
fwrite($file, $text);
fclose($file);

 

It appends the new lines to the $text variable without touching the existing data. Hope it helps.

[Fadion]

Probably word docs dont understand br and it may print as plaing text. Try using \n or \n\r instead.

 

$text .= $Fields['MCity'] . "\n\r";

[tqla]

Yay! That works. Thanks for teaching me this GuiltyGear. I appreciate it.

[Fadion]

Glad it worked