code shows up as code on webpage instead of executing...

Hello - super green here again. I am creating a web page for work (also my school project) and the php code is working fine on its own... when I add it to the html code, it shows up on the web page as code instead of building the chart like it does by itself. I have been working on this for days, trying all kinds of different configurations, but nothing has worked so far. A good portion of th code is below. Any insights on how I screwed this up would be great!

Expand|Select|Wrap|Line Numbers

 
<style type="text/css">
 
BODY    {

    background-image: url("picts/background-sidebar.gif");

    background-repeat: repeat-y;

    background-position: 0px left;

    }
 
</style>
 
<link rel="StyleSheet" href="corporatestyle.css" type="text/css">
 
<script language="JavaScript" type="text/javascript" src="javascripts.js"></script>

<script language="JavaScript" type="text/javascript" src="pop-closeup.js"></script>

<script language="JavaScript" type="text/javascript" src="mouseover.js"></script>
 
</head>
 
  <BODY BGCOLOR="#FFFFFF" TEXT="#000000" leftmargin="0" rightmargin="0" topmargin="0" bottommargin="0" marginheight="0" marginwidth="0">
 
<!-- START PAGE TABLE-->
 
  <TABLE cellpadding="0" cellspacing="0" border="0" width="100%" height="100%"><tr><td ALIGN="LEFT" VALIGN="TOP">
 
    <script language="JavaScript" type="text/javascript" src="header.js"></script>
 
<!-- START PICTURE TABLE -->
 
    <TABLE cellpadding="0" cellspacing="0" border="0" width="100%" bgcolor="#FFFFFF" class="printhide">

      <tr>

        <td background="picts/Montage.jpg"><a href="index.html">

        <IMG SRC="picts/spacer.gif" border="0" width="700" height="80"></a><br>

        </td>

      </tr>

    </table>
 
<!-- END PICTURE TABLE -->
 
    <img src="picts/stretchbar.jpg" width="100%" height="28"><br>
 
    <script language="JavaScript" type="text/javascript" src="menu.js"></script>
 
<!-- START CORNER TABLE -->
 
      <TABLE cellpadding="0" cellspacing="0" border="0" width="100%" background="picts/shadow1.gif" class="printhide">

        <tr>

          <td width="227">

          <IMG SRC="picts/corner.gif" height="40" width="227"><br>

          </td>

          <td>

          <IMG SRC="picts/spacer.gif" height="40" width="10" border="0"><br>

          </td>

        </tr>

      </table>
 
<!-- END CORNER TABLE -->
 
<!-- START OUTER TABLE-->
 
        <TABLE cellpadding="0" cellspacing="0" border="0" width="100%">

          <tr>

            <td ALIGN="left" VALIGN="top">
 
<!-- START SPLIT TABLE-->
 
          <TABLE cellpadding="0" cellspacing="0" border="0" width="100%">

            <tr>

              <td ALIGN="LEFT" VALIGN="TOP" width="15">

              <script language="JavaScript" type="text/javascript" src="pageheight.js"></script>

              </td>

              <td ALIGN="LEFT" VALIGN="TOP" width="150">
 
<!-- START SIDEBAR AREA -->
 
              <script language="JavaScript" type="text/javascript" src="sidebar.js"></script>
 
              <br>

              <IMG SRC="picts/spacer.gif" height="5" width="150" border="0"><br>

              </td>

              <td ALIGN="LEFT" VALIGN="TOP" width="30">

              <IMG SRC="picts/spacer.gif" height="400" width="30" border="0"><br>

              </td>

              <td ALIGN="CENTER" VALIGN="TOP">
 
<!-- END SIDEBAR AREA -->
 
<!-- START CONTENT TABLE -->
 
              <TABLE cellpadding="0" cellspacing="0" border="0" width="1000">

                <tr>

                  <td ALIGN="LEFT" VALIGN="TOP">

                <tr>

                  <td><span class="title">Test Data ...</span>

                  <p class="copy">

                  <span class="subhead">Structural and Thermal Test Data</span>

                  <br />

                    Acadia products are tested to the highest quality ratings in the industry for residential and multi-family housing.

                  </p>

                  <br />

                  </td>

                  <TABLE cellpadding="0" cellspacing="0" border="0" width="80%">

                    <tr>

                      <td>

<!-- START CHART -->
 
<?php
 
  $conn = @new mysqli('localhost', 'root', 'bonkers1', 'prodtestdata');
 
  if (mysqli_connect_errno() != 0)

  {

    $errno = mysqli_connect_errno();

    $errmsg = mysqli_connect_error();

    echo "Connect Failed with: ($errno) $errmsg<br/>\n";

    exit;

  }
 
  $conn->query("SET NAMES 'utf8'");
 
  // prepare the query 

  $query_str = "SELECT * FROM products";

  $result = @conn->query($query_str);

  if ($result === FALSE)

  {

    $errno = $conn->errno;

    $errmsg = $conn->error;

    echo "Connect Failed with: ($errno) $errmsg<br/>\n";

    $conn->close();

    exit;

  } 

  else

  {

  echo <<<EOM

  <table border="5" bordercolor="darkblue" bordercolorlight="#b2b2ff" cellspacing="0" cellpadding="4">

  <thead>

  <tr>

    <th>Product Name</td>

    <th>Size</td>

    <th>Structural</td>

    <th>Air</td>

    <th>Water</td>

    <th>U-Factor</td>

    <th>SHGC</td>

    <th>VT</td>

    <th>Structural Report</th>

    <th>Thermal Report</th>

  </tr>

  </thead>

EOM;

    // get the data

    while (($row_data = @$result->fetch_assoc()) !==NULL)

    {

    echo <<<EOM     

    <tr>

      <td>{$row_data['prod_name']}</td>

      <td align="center">{$row_data['prod_size']}</td>

      <td align="center">{$row_data['aama_rate']}</td>

      <td align="center">{$row_data['air_rate']}</td>

      <td align="center">{$row_data['water_rate']}</td>

      <td align="center">{$row_data['u_rate']}</td>

      <td align="center">{$row_data['shgc_rate']}</td>

      <td align="center">{$row_data['vt_rate']}</td>
 
    </tr>

EOM;

    }
 
    echo <<<EOTABLE

  </table>
 
EOTABLE;

    //

    // clean up results

    //

    $result->close();

  }

  //

  // clean up connection

  //

  $conn->close();
 
?>
 
<!-- END CHART -->

                      </td>

                    </tr>

                  </TABLE>
 
<!-- END CONTENT TABLE -->
 
                  </td>

                </tr>

              </table>
 
<!-- END SPLIT TABLE -->
 
              </td>

            </tr>

          </table>
 
<!-- END OUTER TABLE-->

            </td>

          </tr>

        </table> 
 
<!-- END PAGE TABLE-->
 
      </td>

    </tr>

    <tr>

    <td VALIGN="BOTTOM">
 
<script language="JavaScript" type="text/javascript" src="menu.js"></script>
 
<img src="picts/stretchbar.jpg" width="100%" height="28"><br>
 
<!-- START COPYRIGHT -->
 
<TABLE cellpadding="0" cellspacing="0" border="0" width="100%" background="picts/bottom-shade.gif"><tr><td width="10">

<IMG SRC="picts/spacer.gif" height="45" width="10" border="0" alt="image"><br>

</td><td ALIGN="left" VALIGN="middle">

<script language="JavaScript" type="text/javascript" src="copyright.js"></script>

</td><td ALIGN="right" VALIGN="middle">

</TD><td width="10">

<IMG SRC="picts/spacer.gif" height="10" width="10" border="0" alt="image"><br>

</td></tr></table>
 
<!-- END COPYRIGHT -->
 
      </td>

    </tr>

  </table>
 
</BODY>

</HTML>

Thank You,
Ann

Nov 21 '10 #1

Subscribe Post Reply

✓ answered by Dormilich

you have to name the file with the .php extension otherwise the PHP interpreter doesn’t work on it.

2925

Dormilich

8,658

Expert Mod 8TB

you have to name the file with the .php extension otherwise the PHP interpreter doesn’t work on it.

Nov 21 '10 #2

Ann Madden

So instead of putting the code itself into the .html file, I am suppose to load the .php file with the same code instead?

I will try that - thanks...

Nov 21 '10 #3

Ann Madden

okay - tried that - maybe I am not doing it right, but that did not work either. When I open chart.php in localhost - it works fine. When I turn chart.php into an html file, it then just shows the code. I am missing an important step here - I just don't know what it is. I have changed the code a bit which has cleaned up most of the written code displayed on the page, except under each heading of the table it displays the variable instead of the data, and then.. $result->close(); $conn->close(); ?> .. shows up directly under the table.

Expand|Select|Wrap|Line Numbers

 
</head>
 
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" rightmargin="0" topmargin="0" bottommargin="0" marginheight="0" marginwidth="0">
 
<?php
 
  $conn = @new mysqli('localhost', 'root', 'bonkers1', 'prodtestdata');
 
  if (mysqli_connect_errno() != 0)

  {

    $errno = mysqli_connect_errno();

    $errmsg = mysqli_connect_error();

    echo "Connect Failed with: ($errno) $errmsg<br/>\n";

    exit;

  }
 
  // prepare the query 

  $query_str = "SELECT * FROM products";

  $result = mysqli_query($query_str);
 
?>
 
<!-- START PAGE TABLE-->
 
  <table cellpadding="0" cellspacing="0" border="0" width="100%" height="100%">

    <tr>

      <td align="left" valign="top">

      <script language="JavaScript" type="text/javascript" src="header.js"></script>
 
<!-- START PICTURE TABLE -->
 
    <table cellpadding="0" cellspacing="0" border="0" width="100%" bgcolor="#FFFFFF" class="printhide">

      <tr>

        <td background="picts/Montage.jpg"><a href="index.html">

        <img src="picts/spacer.gif" border="0" width="700" height="80"/></a><br>

        </td>

      </tr>

    </table>
 
<!-- END PICTURE TABLE -->
 
    <img src="picts/stretchbar.jpg" width="100%" height="28"/><br>
 
    <script language="JavaScript" type="text/javascript" src="menu.js"></script>
 
<!-- START CORNER TABLE -->
 
      <table cellpadding="0" cellspacing="0" border="0" width="100%" background="picts/shadow1.gif" class="printhide">

        <tr>

          <td width="227">

          <img src="picts/corner.gif" height="40" width="227"/><br>

          </td>

          <td>

          <img src="picts/spacer.gif" height="40" width="10" border="0"/><br>

          </td>

        </tr>

      </table>
 
<!-- END CORNER TABLE -->
 
<!-- START OUTER TABLE-->
 
        <table cellpadding="0" cellspacing="0" border="0" width="100%">

          <tr>

            <td align="left" valign="top">
 
<!-- START SPLIT TABLE-->
 
          <table cellpadding="0" cellspacing="0" border="0" width="100%">

            <tr>

              <td align="left" valign="top" width="15">

              <script language="JavaScript" type="text/javascript" src="pageheight.js"></script>

              </td>

              <td align="left" valign="top" width="150">
 
<!-- START SIDEBAR AREA -->
 
              <script language="JavaScript" type="text/javascript" src="sidebar.js"></script>

              <br>

              <img src="picts/spacer.gif" height="5" width="150" border="0"/><br>

              </td>

              <td align="left" valign="top" width="30">

              <img src="picts/spacer.gif" height="400" width="30" border="0"/><br>

              </td>

              <td align="center" valign="top">
 
<!-- END SIDEBAR AREA -->
 
<!-- START CONTENT TABLE -->
 
              <table cellpadding="0" cellspacing="0" border="0" width="1000">

                <tr align="left" valign="top">

                  <td><span class="title">Test Data ...</span>

                  <p class="copy">

                  <span class="subhead">Structural and Thermal Test Data</span>

                  <br />

                    Acadia products are tested to the highest quality ratings in the industry for residential and multi-family housing.

                  </p>

                  <br />

                  </td>

                </tr>
 
<!-- START CHART -->
 
                  <table border="5" bordercolor="blue" bordercolorlight="#b2b2ff" cellspacing="0" cellpadding="4">

                    <thead>

                      <tr>

                      <th>Product Name</td>

                      <th>Size</td>

                      <th>Structural</td>

                      <th>Air</td>

                      <th>Water</td>

                      <th>U-Factor</td>

                      <th>SHGC</td>

                      <th>VT</td>

                      <th>Structural Report</th>

                      <th>Thermal Report</th>

                      </tr>

                    </thead>

<?php
 
    while (($row_data = mysqli_fetch_assoc($result)) !==NULL)
 
    <tr>

      <td>{$row_data['prod_name']}</td>

      <td align="center">{$row_data['prod_size']}</td>

      <td align="center">{$row_data['aama_rate']}</td>

      <td align="center">{$row_data['air_rate']}</td>

      <td align="center">{$row_data['water_rate']}</td>

      <td align="center">{$row_data['u_rate']}</td>

      <td align="center">{$row_data['shgc_rate']}</td>

      <td align="center">{$row_data['vt_rate']}</td>

      <td align="left"><a href="testreports/200singlehung.pdf" target="window">200 Sinlge Hung</a></td>

    </tr>
 
  </table>
 
    $result->close();
 
    $conn->close();
 
?>
 
<!-- END CONTENT TABLE -->
 
              </table>
 
<!-- END SPLIT TABLE -->
 
              </td>

            </tr>

          </table>
 
<!-- END OUTER TABLE-->

            </td>

          </tr>

        </table>

Any thoughts would be greatly appreciated. Thank You

Nov 22 '10 #4

Dormilich

8,658

Expert Mod 8TB

okay - tried that - maybe I am not doing it right, but that did not work either. When I open chart.php in localhost - it works fine. When I turn chart.php into an html file, it then just shows the code.

.html files are not recognised by the PHP interpreter, thus any PHP code in them will show as such.

Nov 22 '10 #5

by: Stupidgirl | last post by:

Hi, i have had no problem displaying the current date and time, on a static webpage. However, when i try to use the various PHP and MySQL snippets, it does'nt seem to work out. My success story...

MySQL Database

Schemaset : schema compiled form code shows no PSVI elements

by: Steve at Pixelda | last post by:

I accidentally put this on another group - this is the more likley home... The first code fragment creates the simplest of XML Schemas is code. After the â€œCompile()â€ method is called on the...

.NET Framework

Fire Code behind code AND Javascript code associated to a Button Click Event

by: Carlo Marchesoni | last post by:

I have a button that opens a new Window (some kind of search-window), which is fired using JavaScript (btnSearch.Attributes=".....";) Now I need to run some code behind code BEFORE this JavaScript...

ASP.NET

executing client side code from code behind.

by: Asha | last post by:

greetings, i want to populate a datagrid with data from the db and this requires a post back and code behind do its job. after the datagrid is being populated, i want the client side to execute...

ASP.NET

how do I make the validator cut off other code on the page from executing?

by: bennett | last post by:

At http://www.brainjammer.com/testing/validator_test.aspx I have a text field where you can enter text, and a button where if you click the button, it sets the value of a label below it, to...

ASP.NET

Why I prefer inline code to code-behind

by: neilmcguigan | last post by:

I just wanted to list some reasons why I prefer inline code to code-behind. 1. you can fix some bugs more quickly. remote desktop into server, change the aspx file, and she's good to go. I'd say...

ASP.NET

How to obtain the html source code of the webpage

by: ujwala | last post by:

I am trying to develop a tool which requires the source(html) code of the web page i open in the browser.so is there any way to get the html source code of the web page as soon as i open it and store...

.NET Framework

Tool to move inline code to code behind?

by: John Dalberg | last post by:

I have tens of aspx files which contain server side code. I need to move the code to code behind files. Is there a tool that can automate this? John Dalberg

ASP.NET

code shows on status bar

by: emekadavid | last post by:

i've searched if this has been answered but can't find an answer only found something on obfuscation. my problem: i have a code that opens a new window, a blank window, but on clicking the x button...

Javascript

Outputting my python code to a webpage

by: mott3510 | last post by:

I wrote a python script and when I run it, it outputs what I want, so I know that it is working. Now I want to be able to put the output of the code on my website and I have no idea how to do this,...

Python

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

code shows up as code on webpage instead of executing...

✓ answered by Dormilich

Similar topics