PHP - Ms Word Cleanup

Hello...
I know, a lot of times, I hack some code together.  It's not necessarily the most efficient or cleanest way to do it, but it works.
I thought it might be useful to have a place where people (maybe just myself) could post a chunk of code that others could analyze and recommend a better way of doing it.

This looks to see if a file for a particular date is available and, if it is, creates a link to it.
This is a prime example of what looks like it is way too much code for the task at hand.
You'll note that nothing is indented.  This isn't how I normally code, but when putty pastes vim tabs, it turns into spaces (which is annoying).  I left-justified for ease of copy/paste, as I had to do it for multiple days (not just Friday).
Just so it's clear, the code is looking for 110211Audio.mp3 (as of this week).
JJ
Code: [Select]
<?php
if (date("l")=="Friday") {
if(file_exists("services/2011/".date("ymd"))."Audio.mp3") {
echo "<a href='services/2011/".date("ymd")."Audio.mp3'>Listen To Friday Sermon</a>";
}
}
elseif (date("l")=="Saturday") {
if(file_exists("services/2011/".date("ymd", strtotime("-1 day"))."Audio.mp3")) {
echo "<a href='services/2011/".date("ymd", strtotime("-1 day"))."Audio.mp3'>Listen To Friday Sermon</a>";
}
}
elseif (date("l")=="Sunday") {
if(file_exists("services/2011/".date("ymd", strtotime("-2 day"))."Audio.mp3")) {
echo "<a href='services/2011/".date("ymd", strtotime("-2 day"))."Audio.mp3'>Listen To Friday Sermon</a>";
}
}
elseif (date("l")=="Monday") {
if(file_exists("services/2011/".date("ymd", strtotime("-3 day"))."Audio.mp3")) {
echo "<a href='services/2011/".date("ymd", strtotime("-3 day"))."Audio.mp3'>Listen To Friday Sermon</a>";
}
}
elseif (date("l")=="Tuesday") {
if(file_exists("services/2011/".date("ymd", strtotime("-4 day"))."Audio.mp3")) {
echo "<a href='services/2011/".date("ymd", strtotime("-4 day"))."Audio.mp3'>Listen To Friday Sermon</a>";
}
}
elseif (date("l")=="Wednesday") {
if(file_exists("services/2011/".date("ymd", strtotime("-5 day"))."Audio.mp3")) {
echo "<a href='services/2011/".date("ymd", strtotime("-5 day"))."Audio.mp3'>Listen To Friday Sermon</a>";
}
}
elseif (date("l")=="Thursday") {
if(file_exists("services/2011/".date("ymd", strtotime("-6 day"))."Audio.mp3")) {
echo "<a href='services/2011/".date("ymd", strtotime("-6 day"))."Audio.mp3'>Listen To Friday Sermon</a>";
}
}
?>

Hi I'm currently experiencing problems with my super global outputs.   I'm using     $_SERVER['HTTP_X_MXIT_NICK'];

I'm going to post the code that I am currently using and then explain what I'm trying to do. I hope I can explain it well enough.

<?php
    if (!isset($_POST['submit'])) {
    echo'<leftmargin="0" topmargin="0" rightmargin="0" bottommargin="0">
    <center><form name="fairlistlist" method="POST" action="'.$_SERVER['PHP_SELF'].'">
      <TABLE width="450" height="119" border=0 cellPadding=3 cellSpacing=2 bgcolor="#fff568">
        <TBODY>
          <TR>
            <TD class=mainText width="100"><b>Event Name</b></TD>
            <TD width="305" class=frmInput> <INPUT class=mainFormBox style="WIDTH: 320px" type="text" name=" fairname"></TD>
          </TR>
          <TR>
            <TD class=mainText width="100"><B>Event Address</B></TD>
            <TD class=frmInput> <INPUT name="fairadd" type="text" class=mainFormBox id="fairadd" style="WIDTH: 320px"></TD>
          </TR>
          <TR>
            <TD class=mainText width="100"><b>Event City</b></TD>
            <TD class=frmInput> <INPUT name="faircity" type="text" class=mainFormBox id="faircity" style="WIDTH: 320px"></TD>
          </TR>
                <TR>
            <TD class=mainText width="100"><b>Event County</b></TD>
            <TD class=frmInput> <INPUT name="faircty" type="text" class=mainFormBox id="faircty" style="WIDTH: 320px"></TD>
          </TR>
  <TR>
            <TD class=mainText width="100"><b>Event State</b></TD>
            <TD class=frmInput> <INPUT name="fairstate" type="text" class=mainFormBox id="fairstate" style="WIDTH: 320px"></TD>
          </TR>
  <TR>
            <TD class=mainText width="100"><b>Event Country</b></TD>
            <TD class=frmInput> <INPUT name="fairctry" type="text" class=mainFormBox id="fairctry" style="WIDTH: 320px"></TD>
          </TR>
     <TR>
            <TD class=mainText width="100"><b>Event Opening Date</b></TD>
            <TD class=frmInput> <INPUT name="fairopen" type="text" class=mainFormBox id="fairopen" style="WIDTH: 320px"></TD>
          </TR>
     <TR>
            <TD class=mainText width="100"><b>Event Closing Date</b></TD>
            <TD class=frmInput> <INPUT name="fairclose" type="text" class=mainFormBox id="fairlose" style="WIDTH: 320px"></TD>
          </TR>
     <TR>
            <TD class=mainText width="100"><b>Event Contact Email</b></TD>
            <TD class=frmInput> <INPUT name="fairmail" type="text" class=mainFormBox id="fairmail" style="WIDTH: 320px"></TD>
          </TR>
     <TR>
            <TD class=mainText width="100"><b>Event Website</b></TD>
            <TD class=frmInput> <INPUT name="fairweb" type="text" class=mainFormBox id="fairweb" style="WIDTH: 320px"></TD>
          </TR>
          <TR>
            <TD class=frmDescription width="56">&nbsp;</TD>
            <TD class=frmInput> <div align="right">
            <input type="submit" name="submit" value="Add my Event" />
              </div></TD>
          </TR>
        </TBODY>
      </TABLE>
    </form></center>
      </body>';
    //note that I added a new field called submit and it's hidden ..

    } else {

    /*I added addslashes() so it escape any special char in the form ..
    if you want to show your inserted record , you need to use stripslashes() to remove any slashes from the record ..
    this is only to avoid some security problems in the query ..*/

    $fairname=trim(addslashes($_POST['fairname']));
    $fairadd=trim(addslashes($_POST['fairadd']));
    $faircity=trim(addslashes($_POST['faircity']));
    $faircty=trim(addslashes($_POST['faircty']));
    $fairstate=trim(addslashes($_POST['fairstate']));
    $fairctry=trim(addslashes($_POST['fairctry']));
    $fairopen=trim(addslashes($_POST['fairopen']));
    $fairclose=trim(addslashes($_POST['fairclose']));
    $fairmail=trim(addslashes($_POST['fairmail']));
    $fairweb=trim(addslashes($_POST['fairweb']));
include("Connections/local.php");
    $link = mysql_connect($hostname_local,$username_local, $password_local)
        or die("Could not connect");
    mysql_select_db('fair123')
        or die("Could not select database");

    $insert=mysql_query("INSERT INTO events (fairidnum, fairname, fairadd, faircity, faircty, fairstate, fairctry, fairopen, fairclose, fairmail, fairweb)
    VALUES('NULL', '$fairname', '$fairadd', '$faircity', '$faircty','$fairstate', '$fairctry','$fairopen', '$fairclose', '$fairmail', '$fairweb')")or
    die('couldn\'t Insert record into database :'.mysql_error());

   header( 'Location: event_added.php' ) ;
    }
    ?>

Especially look at the code part here
    $insert=mysql_query("INSERT INTO events (fairidnum, fairname, fairadd, faircity, faircty, fairstate, fairctry, fairopen, fairclose, fairmail, fairweb)
    VALUES('NULL', '$fairname', '$fairadd', '$faircity', '$faircty','$fairstate', '$fairctry','$fairopen', '$fairclose', '$fairmail', '$fairweb')")or
    die('couldn\'t Insert record into database :'.mysql_error());

   header( 'Location: event_added.php' ) ;
    }
    ?>
this is where I am having problems it was reading
echo your record has been successfully added to the database

What I want is for it to open up a new page with my menu and my css and all that good crap to a page where it will read the following
Your information has been added to our database
We have added

Event name = "whatever the event's name was"
Event address = "address:"

so on and so on for all the fields in my form that was submitted to the database.

with just using the echo command it always opened to just a blank page no formatting and no css as well as no all important links

Can you please tell me what I'm doing wrong or where I can find a good guideline that Is easy to understand on how to do this?

Thanks in advance

Oh also I don't care if that page get's indexed by google or yahoo or not actually prefer it don't get indexed to be honest

Hi guys,

I'm trying to export records from php to ms word which appends text + image.

i have got this code from http://www.thaicreate.com/php/php-word.application-addpicture.html
Code: [Select]
<html>
<head>
<title>ThaiCreate.Com PHP Word.Application Tutorial</title>
</head>
<body>
<?
$wdColorDarkRed = "&H80";

$wdAlignParagraphCenter = "1";
$wdAlignParagraphLeft = "0";
$wdParagraph = "4";
$wdHorizontalPositionMargin = "0";
$wdTableLeft = "-999998";
$wdCollapseEnd = "0";

$Wrd = new COM("Word.Application");

$DocName = "MyDoc/MyWord.doc";

//$strPath = realpath(basename(getenv($_SERVER["SCRIPT_NAME"]))); // C:/AppServ/www/myphp

$Wrd->Application->Visible = False;

$WrdDoc = $Wrd->Documents->Add();

$MyRange1 = $WrdDoc->Paragraphs->Add->Range;
$MyRange1->ParagraphFormat->Alignment = $wdAlignParagraphCenter;
$MyRange1->Font->Name = "Verdana";
$MyRange1->Font->Size = "30";
$MyRange1->Font->Bold = True;
$MyRange1->InsertBefore(chr(13).chr(13)."www.ThaiCreate.Com".chr(13)."Version 2009");

$MyRange1->InlineShapes->AddPicture(realpath("thaicreate-2009.gif"));
//$WrdDoc->InlineShapes->AddPicture(realpath("thaicreate-2009.gif"));
//$WrdDoc->Shapes->AddPicture(realpath("thaicreate-2009.gif"),0,0,MyRange1);
//$WrdDoc->Shapes->AddPicture(realpath("thaicreate-2009.gif"),0,0,Wrd->Selection->Range);

$MyRange2 = $WrdDoc->Paragraphs->Add->Range;
$MyRange2->ParagraphFormat->Alignment = $wdAlignParagraphCenter;
$MyRange2->Font->Name = "Verdana";
$MyRange2->Font->Size = "15";
$MyRange2->Font->Bold = True;
$MyRange2->InsertBefore(chr(13).chr(13)."PHP,ASP and ASP.NET Tutorial");

$MyRange2->InlineShapes->AddPicture(realpath("doc.gif"));

$MyRange3 = $WrdDoc->Paragraphs->Add->Range;
$MyRange3->ParagraphFormat->Alignment = $wdAlignParagraphCenter;
$MyRange3->Font->Name = "Verdana";
$MyRange3->Font->Size = "10";
$MyRange3->Font->Bold = True;
$MyRange3->Font->Color = $wdColorDarkRed;
$MyRange3->Underline = True;
$MyRange3->InsertBefore(chr(13).chr(13).chr(13).chr(13)."All Rights Reserved");

//$WrdDoc->SaveAs($strPath."/".$DocName);
$WrdDoc->SaveAs(realpath($DocName));
$Wrd->Application->Quit;
$Wrd = null;
?>
Word Created <a href="<?=$DocName?>">Click here</a> to Download.
</body>
</html>

This is the best code i've found so far that guides on how to format the text in ms word via PHP. All set to go but one thing that I am trying to accomplish : to have a clickable email address (hyperlink) in the same ms word file.

i have got this code somewhere from the net:
Code: [Select]
$MyRange3->Hyperlinks->Add({range}, 'http://www.google.com', '','',' hyperlink text to display');
// where {range} refers to as anchor
according to that website this methods could be found in ms word visual basic editor (Alt+F11) then object browser (F2)

when i replace the {range} above with let say variable $MyRange3.
Code: [Select]
$MyRange3->Hyperlinks->Add($MyRange3, 'http://www.google.com', '','',' hyperlink text to display');
The output will be produced but overwriting everything in $MyRange3 and displays only the hyperlink.
I would like the email address (hyperlink) to appear at the end of $MyRange3 text.

example output
Code: [Select]
All right reserved [u]hyperlink text to display[/u]
anyone can shed some light on this.

Hey guys i found this script that works great for what i need ..

se i have this script that i did for my body (loan application)

now i would like to export the info in a word doc


<?php
$ExcelFileName="test.doc";
header("Content-type: application/x-ms-download");
header("Content-Disposition: attachment; filename=$ExcelFileName");
header('Cache-Control: public');

$content=<<<EOD

echo 'php';
whatever you want to write here
including a php script
it will be included in a string and then
go in the output for a doc file

EOD;

echo $content;
?>



so im trying to eco all the content in the database..

i tryed
all the DB connection is there..

ao i place this after the (echo 'php'

while($info = mysql_fetch_array($fileLIST)){;
echo $info['PERS_F_NAME'];
};


i get this?
Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/autosspe/public_html/admin/loan/word.php on line 21