Jump to content

PHP-HTML Integration


vigiw

Recommended Posts

Hi everyone, and Happy Thanksgiving! ;D

I am currently improving a system I successfully installed on my website, thanks largely in part to phpfreaks for the help!  But now I am adding more to it and I will try to "spice it up" a bit.

I have an HTML page of what I want it to look like--at least, that was the plan before PHP--but I want to keep it as similar as possible.

Example page code (quite a bit, but quite simply an HTML page with colors, fonts, tables with cell colors, etc.):
[code]<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Vigilant Weather - Alert Mode Analysis</title>
</head>

<body>

<p align="center"><b><font face="Verdana" size="4" color="#0000FF">Vigilant
Weather - Alert Mode Analysis</font></b></p>
<p align="center"><font face="Verdana" size="2">Vigilant Weather Alert Mode
Analysis will show you the live breakdown of storms that we may consider for
Alert Mode.&nbsp; To find out if a particular storm has caused Alert Mode to be
issued, please refer to the Severe Weather Forum at
<a href="http://www.vigilantweather.com">www.vigilantweather.com</a></font></p>
<p align="center"><b><font face="Verdana" size="4">Potential Upcoming Storms:</font></b></p>
<table border="1" width="100%" id="table3">
  <tr>
    <td align="center">
    <p align="center"><font face="Verdana">Storm ID</font></td>
    <td align="center"><font face="Verdana">Status<sup><font size="1">§</font></sup></font></td>
    <td align="center"><font face="Verdana">Updated</font></td>
    <td align="center"><font face="Verdana">Valid On</font></td>
    <td align="center" width="223"><font face="Verdana">Conditions</font></td>
    <td align="center" width="245"><font face="Verdana">Location</font></td>
    <td align="center" width="184"><font face="Verdana">Likelihood*</font></td>
    <td align="center"><font face="Arial">Risk**</font></td>
    <td align="center"><font face="Arial">Alert Mode Consideration<sup><font size="1">±</font></sup></font></td>
  </tr>
  <tr>
    <td align="center" bgcolor="#FF0000"><font face="Arial" color="#FFFFFF">1</font></td>
    <td align="center" bgcolor="#FF0000"><font face="Arial" color="#FFFFFF">
    ACTIVE</font></td>
    <td align="center" bgcolor="#FF0000"><font face="Arial" color="#FFFFFF">7-27-06</font></td>
    <td align="center" bgcolor="#FF0000"><font face="Arial" color="#FFFFFF">7-28-06</font></td>
    <td align="center" bgcolor="#FF0000" width="223">
    <font face="Arial" color="#FFFFFF">SCATTERED SEVERE THUNDERSTORMS</font></td>
    <td align="center" bgcolor="#FF0000" width="245">
    <font face="Arial" color="#FFFFFF">SOUTHERN NEW ENGLAND</font></td>
    <td align="center" bgcolor="#FF0000" width="184">
    <font face="Arial" color="#FFFFFF">LIKELY</font></td>
    <td align="center" bgcolor="#FF0000"><font face="Arial" color="#FFFFFF">
    MODERATE</font></td>
    <td align="center" bgcolor="#FF0000"><font face="Arial" color="#FFFFFF">IN
    CONSIDERATION</font></td>
  </tr>
  <tr>
    <td align="center"><font face="Arial">2</font></td>
    <td align="center"><font face="Arial">INACTIVE</font></td>
    <td align="center">&nbsp;</td>
    <td align="center">&nbsp;</td>
    <td align="center" width="223">
    &nbsp;</td>
    <td align="center" width="245">
    &nbsp;</td>
    <td align="center" width="184">
    &nbsp;</td>
    <td align="center">&nbsp;</td>
    <td align="center">&nbsp;</td>
  </tr>
  <tr>
    <td align="center"><font face="Arial">3</font></td>
    <td align="center"><font face="Arial">INACTIVE</font></td>
    <td align="center">&nbsp;</td>
    <td align="center">&nbsp;</td>
    <td align="center" width="223">
    &nbsp;</td>
    <td align="center" width="245">
    &nbsp;</td>
    <td align="center" width="184">
    &nbsp;</td>
    <td align="center">&nbsp;</td>
    <td align="center">&nbsp;</td>
  </tr>
  <tr>
    <td align="center"><font face="Arial">4</font></td>
    <td align="center"><font face="Arial">INACTIVE</font></td>
    <td align="center">&nbsp;</td>
    <td align="center">&nbsp;</td>
    <td align="center" width="223">&nbsp;</td>
    <td align="center" width="245">&nbsp;</td>
    <td align="center" width="184">&nbsp;</td>
    <td align="center">&nbsp;</td>
    <td align="center">&nbsp;</td>
  </tr>
</table>
<p><font face="Verdana"><sup><font size="1">§</font></sup>Status is represented
by &quot;Inactive&quot; when the storm is no longer being watched, &quot;Active&quot; when the storm
is currently being watched, and &quot;Watching&quot; the storm will be watched in the
future (for storms coming within days, not hours, etc.)&nbsp; &quot;Active&quot; is
represented by red, &quot;Inactive&quot; by white, and &quot;Watching&quot; by light blue.&nbsp;
When in &quot;Inactive&quot; mode, there may be obsolete tables for Storm IDs that are
inactive on the bottom of this page, please ignore them and use the active one(s).</font></p>
<p><font face="Verdana">*Likelihood has 4 possible forecasts, ranging from least
severe to most severe: &quot;Threat&quot;, &quot;Possible&quot;, &quot;Likely&quot;, and &quot;Very Likely&quot;.&nbsp;
At times we may mix multiple forecasts that are 'in between', for example:
&quot;Possible-Likely&quot;.&nbsp; Likelihood shows the probability of a particular storm
striking a particular area.</font></p>
<p><font face="Verdana">**Risk has 4 possible forecasts, ranging from least
severe to most severe: &quot;Low&quot;, &quot;Moderate&quot;, &quot;High&quot;, and &quot;Extreme&quot;.&nbsp; At times
we may mix multiple forecasts that are 'in between', for example:
&quot;Low-Moderate&quot;.&nbsp; Risk shows how dangerous a particular storm can
be; considering the storm will hit, we will show you the potential risk the
storm will have.</font></p>
<p><font face="Verdana"><sup><font size="1">±</font></sup>Alert Mode
Consideration has 5 possible outputs explaining the likelihood of Vigilant
Weather issuing Alert Mode for a particular storm.&nbsp; Ranging from least
likely to most likely, the 5 possible outputs are: &quot;Unlikely&quot;, &quot;Possible&quot;, &quot;In
Consideration&quot;, &quot;Likely&quot;, and &quot;Very Likely&quot;.&nbsp; Note that &quot;In Consideration&quot;
means we are considering a particular storm for Alert Mode, but it is between
&quot;Possible&quot; and &quot;Likely&quot;.</font></p>
<hr>
<p align="center"><b><font face="Verdana">The Breakdown:</font></b></p>
<p align="left"><i><font face="Verdana">Note: Active forecasts, such as &quot;Threat&quot;
are highlighted in yellow.&nbsp;&nbsp; At times, if we feel forecasts are 'in
between', for example, a forecast may be in between &quot;Likely&quot; and &quot;Very Likely&quot;,
so we will highlight both under the specific forecast, such as &quot;Tornadoes&quot;.&nbsp;
(Note that N/A designates to little a chance of happening.) Once again, likelihood is the chance of something occurring a particular storm,
such as hail; risk is how dangerous we feel something, such as wind damage, will
be in a particular storm.</font></i></p>
<p>&nbsp;</p>
<table border="2" width="100%" id="table2" bordercolor="#FF00FF">
  <tr>
    <td bgcolor="#00FFFF">
    <p align="center"><b><font face="Verdana" size="4">VALID: Storm ID #1 -
    Likelihood</font></b></td>
  </tr>
</table>
<table border="2" width="100%" id="table1" bordercolor="#FF00FF">
  <tr>
    <td align="center" height="23"><b><font face="Verdana">Tornadoes</font></b></td>
    <td align="center" height="23"><b><font face="Verdana">Hail</font></b></td>
    <td align="center" height="23"><b><font face="Verdana">Wind Damage</font></b></td>
    <td align="center" height="23"><b><font face="Verdana">Heavy Rainfall</font></b></td>
  </tr>
  <tr>
    <td align="center"><font face="Verdana">Very Likely</font></td>
    <td align="center"><font face="Verdana">Very Likely</font></td>
    <td align="center"><font face="Verdana">Very Likely</font></td>
    <td align="center"><font face="Verdana">Very Likely</font></td>
  </tr>
  <tr>
    <td align="center"><font face="Verdana">Likely</font></td>
    <td align="center"><font face="Verdana">Likely</font></td>
    <td align="center"><font face="Verdana">Likely</font></td>
    <td align="center"><font face="Verdana">Likely</font></td>
  </tr>
  <tr>
    <td align="center"><font face="Verdana">Possible</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Possible</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Possible</font></td>
    <td align="center"><font face="Verdana">Possible</font></td>
  </tr>
  <tr>
    <td align="center"><font face="Verdana">Threat</font></td>
    <td align="center"><font face="Verdana">Threat</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Threat</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Threat</font></td>
  </tr>
  <tr>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">N/A</font></td>
    <td align="center"><font face="Verdana">N/A</font></td>
    <td align="center"><font face="Verdana">N/A</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">N/A</font></td>
  </tr>
</table>
<table border="2" width="100%" id="table6" bordercolor="#FF0000">
  <tr>
    <td bgcolor="#00FFFF">
    <p align="center"><b><font face="Verdana" size="4">VALID: Storm ID #1 - Risk</font></b></td>
  </tr>
</table>
<table border="2" width="100%" id="table7" bordercolor="#FF0000">
  <tr>
    <td align="center" height="23"><b><font face="Verdana">Tornadoes</font></b></td>
    <td align="center" height="23"><b><font face="Verdana">Hail</font></b></td>
    <td align="center" height="23"><b><font face="Verdana">Wind Damage</font></b></td>
    <td align="center" height="23"><b><font face="Verdana">Rainfall</font></b></td>
  </tr>
  <tr>
    <td align="center"><font face="Verdana">Very High</font></td>
    <td align="center"><font face="Verdana">Very High</font></td>
    <td align="center"><font face="Verdana">Very High</font></td>
    <td align="center"><font face="Verdana">Very High</font></td>
  </tr>
  <tr>
    <td align="center"><font face="Verdana">High</font></td>
    <td align="center"><font face="Verdana">High</font></td>
    <td align="center"><font face="Verdana">High</font></td>
    <td align="center"><font face="Verdana">High</font></td>
  </tr>
  <tr>
    <td align="center"><font face="Verdana">Moderate</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Moderate</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Moderate</font></td>
    <td align="center"><font face="Verdana">Moderate</font></td>
  </tr>
  <tr>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Low</font></td>
    <td align="center" bgcolor="#FFFFFF"><font face="Verdana">Low</font></td>
    <td align="center" bgcolor="#FFFFFF"><font face="Verdana">Low</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Low</font></td>
  </tr>
  <tr>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">N/A</font></td>
    <td align="center"><font face="Verdana">N/A</font></td>
    <td align="center"><font face="Verdana">N/A</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">N/A</font></td>
  </tr>
</table>
<hr>
<table border="2" width="100%" id="table12" bordercolor="#FF00FF">
  <tr>
    <td bgcolor="#00FFFF">
    <p align="center"><b><font face="Verdana" size="4">VALID: Storm ID #2 -
    Likelihood</font></b></td>
  </tr>
</table>
<table border="2" width="100%" id="table13" bordercolor="#FF00FF">
  <tr>
    <td align="center" height="23"><b><font face="Verdana">Tornadoes</font></b></td>
    <td align="center" height="23"><b><font face="Verdana">Hail</font></b></td>
    <td align="center" height="23"><b><font face="Verdana">Wind Damage</font></b></td>
    <td align="center" height="23"><b><font face="Verdana">Heavy Rainfall</font></b></td>
  </tr>
  <tr>
    <td align="center"><font face="Verdana">Very Likely</font></td>
    <td align="center"><font face="Verdana">Very Likely</font></td>
    <td align="center"><font face="Verdana">Very Likely</font></td>
    <td align="center"><font face="Verdana">Very Likely</font></td>
  </tr>
  <tr>
    <td align="center"><font face="Verdana">Likely</font></td>
    <td align="center"><font face="Verdana">Likely</font></td>
    <td align="center" bgcolor="#FFFFFF"><font face="Verdana">Likely</font></td>
    <td align="center"><font face="Verdana">Likely</font></td>
  </tr>
  <tr>
    <td align="center"><font face="Verdana">Possible</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Possible</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Possible</font></td>
    <td align="center"><font face="Verdana">Possible</font></td>
  </tr>
  <tr>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Threat</font></td>
    <td align="center"><font face="Verdana">Threat</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Threat</font></td>
    <td align="center"><font face="Verdana">Threat</font></td>
  </tr>
  <tr>
    <td align="center"><font face="Verdana">N/A</font></td>
    <td align="center"><font face="Verdana">N/A</font></td>
    <td align="center"><font face="Verdana">N/A</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">N/A</font></td>
  </tr>
</table>
<table border="2" width="100%" id="table14" bordercolor="#FF0000">
  <tr>
    <td bgcolor="#00FFFF">
    <p align="center"><b><font face="Verdana" size="4">VALID: Storm ID #2 - Risk</font></b></td>
  </tr>
</table>
<table border="2" width="100%" id="table15" bordercolor="#FF0000">
  <tr>
    <td align="center" height="23"><b><font face="Verdana">Tornadoes</font></b></td>
    <td align="center" height="23"><b><font face="Verdana">Hail</font></b></td>
    <td align="center" height="23"><b><font face="Verdana">Wind Damage</font></b></td>
    <td align="center" height="23"><b><font face="Verdana">Rainfall</font></b></td>
  </tr>
  <tr>
    <td align="center"><font face="Verdana">Very High</font></td>
    <td align="center"><font face="Verdana">Very High</font></td>
    <td align="center"><font face="Verdana">Very High</font></td>
    <td align="center"><font face="Verdana">Very High</font></td>
  </tr>
  <tr>
    <td align="center"><font face="Verdana">High</font></td>
    <td align="center"><font face="Verdana">High</font></td>
    <td align="center"><font face="Verdana">High</font></td>
    <td align="center"><font face="Verdana">High</font></td>
  </tr>
  <tr>
    <td align="center"><font face="Verdana">Moderate</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Moderate</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Moderate</font></td>
    <td align="center"><font face="Verdana">Moderate</font></td>
  </tr>
  <tr>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Low</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Low</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Low</font></td>
    <td align="center"><font face="Verdana">Low</font></td>
  </tr>
  <tr>
    <td align="center"><font face="Verdana">N/A</font></td>
    <td align="center"><font face="Verdana">N/A</font></td>
    <td align="center"><font face="Verdana">N/A</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">N/A</font></td>
  </tr>
</table>
<hr>
<table border="2" width="100%" id="table20" bordercolor="#FF00FF">
  <tr>
    <td bgcolor="#00FFFF">
    <p align="center"><b><font face="Verdana" size="4">VALID: Storm ID #3 -
    Likelihood</font></b></td>
  </tr>
</table>
<table border="2" width="100%" id="table21" bordercolor="#FF00FF">
  <tr>
    <td align="center" height="23"><b><font face="Verdana">Tornadoes</font></b></td>
    <td align="center" height="23"><b><font face="Verdana">Hail</font></b></td>
    <td align="center" height="23"><b><font face="Verdana">Wind Damage</font></b></td>
    <td align="center" height="23"><b><font face="Verdana">Heavy Rainfall</font></b></td>
  </tr>
  <tr>
    <td align="center"><font face="Verdana">Very Likely</font></td>
    <td align="center"><font face="Verdana">Very Likely</font></td>
    <td align="center"><font face="Verdana">Very Likely</font></td>
    <td align="center"><font face="Verdana">Very Likely</font></td>
  </tr>
  <tr>
    <td align="center"><font face="Verdana">Likely</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Likely</font></td>
    <td align="center" bgcolor="#FFFFFF"><font face="Verdana">Likely</font></td>
    <td align="center"><font face="Verdana">Likely</font></td>
  </tr>
  <tr>
    <td align="center"><font face="Verdana">Possible</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Possible</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Possible</font></td>
    <td align="center"><font face="Verdana">Possible</font></td>
  </tr>
  <tr>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Threat</font></td>
    <td align="center"><font face="Verdana">Threat</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Threat</font></td>
    <td align="center"><font face="Verdana">Threat</font></td>
  </tr>
  <tr>
    <td align="center"><font face="Verdana">N/A</font></td>
    <td align="center"><font face="Verdana">N/A</font></td>
    <td align="center"><font face="Verdana">N/A</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">N/A</font></td>
  </tr>
</table>
<table border="2" width="100%" id="table22" bordercolor="#FF0000">
  <tr>
    <td bgcolor="#00FFFF">
    <p align="center"><b><font face="Verdana" size="4">VALID: Storm ID #3 - Risk</font></b></td>
  </tr>
</table>
<table border="2" width="100%" id="table23" bordercolor="#FF0000">
  <tr>
    <td align="center" height="23"><b><font face="Verdana">Tornadoes</font></b></td>
    <td align="center" height="23"><b><font face="Verdana">Hail</font></b></td>
    <td align="center" height="23"><b><font face="Verdana">Wind Damage</font></b></td>
    <td align="center" height="23"><b><font face="Verdana">Rainfall</font></b></td>
  </tr>
  <tr>
    <td align="center"><font face="Verdana">Very High</font></td>
    <td align="center"><font face="Verdana">Very High</font></td>
    <td align="center"><font face="Verdana">Very High</font></td>
    <td align="center"><font face="Verdana">Very High</font></td>
  </tr>
  <tr>
    <td align="center"><font face="Verdana">High</font></td>
    <td align="center"><font face="Verdana">High</font></td>
    <td align="center"><font face="Verdana">High</font></td>
    <td align="center"><font face="Verdana">High</font></td>
  </tr>
  <tr>
    <td align="center"><font face="Verdana">Moderate</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Moderate</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Moderate</font></td>
    <td align="center"><font face="Verdana">Moderate</font></td>
  </tr>
  <tr>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Low</font></td>
    <td align="center" bgcolor="#FFFFFF"><font face="Verdana">Low</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">Low</font></td>
    <td align="center"><font face="Verdana">Low</font></td>
  </tr>
  <tr>
    <td align="center"><font face="Verdana">N/A</font></td>
    <td align="center"><font face="Verdana">N/A</font></td>
    <td align="center"><font face="Verdana">N/A</font></td>
    <td align="center" bgcolor="#FFFF00"><font face="Verdana">N/A</font></td>
  </tr>
</table>
<hr>
<p><b><font face="Arial" size="2">NOTICE: All content on this page has been
created by and is maintained &amp; updated by Vigilant Weather -
<a href="http://www.vigilantweather.com">www.vigilantweather.com</a> and may not
be redistributed, reproduced, rewritten, or republished in anyway without
written permission by Eddie stating otherwise.&nbsp; All content on this page is
<u>not</u> to be used as a serious decision to save life/lives or property.&nbsp;
Any damages or losses potentially or completely caused by any or all of the
content on this page does not put any Vigilant Weather staff member at fault.&nbsp;
This page is to be used a simple reference or guidance, and only this.</font></b></p>
</body>

</html>
[/code]


And I want to somehow incorporate a PHP query page (which is working with my database already--this one is just an example), which will look similar to this, but with different queries and echo text and whatnot:

[code]<?
include("bos_header.php");
include("bos_db3.php");
$q = mysql_query("SELECT * from `" . $table_name . "`");
while($row = mysql_fetch_assoc($q)) {
echo "Zone 3 - In MA: Essex, Suffolk, Middlesex counties, In NH: Rockingham, Hillsborough counties<br><br>Last Updated: " . $row['time'] . " PST<br><br>Day 1:<br><br>" . $row['heaviness1'] . " " . $row['precip1'] . " , with " . $row['conditions_1'] . " " . $row['conditions2_1'] . " conditions.  High " . $row['high1'] . ", Low <br>" . $row['low1'] . ".  Winds "  . $row['winddir1'] . " at " . $row['wind1'] . " mph.  Probability of Precipitation: "  . $row['pop1'] .

"<br><br>Day 2:<br><br>" . $row['heaviness2'] . " " . $row['precip2'] . " , with " . $row['conditions_2'] . " " . $row['conditions2_2'] . " conditions.  High " . $row['high2'] . ", Low <br>" . $row['low2'] . ".  Winds "  . $row['winddir2'] . " at " . $row['wind2'] . " mph.  Probability of Precipitation: "  . $row['pop2'] .

"<br><br>Day 3:<br><br>" . $row['heaviness3'] . " " . $row['precip3'] . " , with " . $row['conditions_3'] . " " . $row['conditions2_3'] . " conditions.  High " . $row['high3'] . ", Low <br>" . $row['low3'] . ".  Winds "  . $row['winddir3'] . " at " . $row['wind3'] . " mph.  Probability of Precipitation: "  . $row['pop3'] .

"<br><br>Day 4:<br><br>" . $row['heaviness4'] . " " . $row['precip4'] . " , with " . $row['conditions_4'] . " " . $row['conditions2_4'] . " conditions.  High " . $row['high4'] . ", Low <br>" . $row['low4'] . ".  Winds "  . $row['winddir4'] . " at " . $row['wind4'] . " mph.  Probability of Precipitation: "  . $row['pop4'] .

"<br><br>Day 5:<br><br>" . $row['heaviness5'] . " " . $row['precip5'] . " , with " . $row['conditions_5'] . " " . $row['conditions2_5'] . " conditions.  High " . $row['high5'] . ", Low <br>" . $row['low5'] . ".  Winds "  . $row['winddir5'] . " at " . $row['wind5'] . " mph.  Probability of Precipitation: "  . $row['pop5'] . "<br>______________________________________________<br>";


}
if(mysql_num_rows($q) < 1) { echo "There are no forecasts updated by BOS at this time."; }

mysql_close(); //closes the link to mysql
?>[/code]

If you are confused, here is the system in a nutshell:

It is a weather alert & forecast system, the forecaster submits both alerts and forecasts via a working form to a working database (this part is done).. I would like to use the same frameworks to produce a new forecaster form (no problem to make), but here's my question:

How do I make it so the data sent to the database (similar to PHP code page--2nd code) will be able to show up on the different tables (different data corresponds with different tables) in the correct cells, with the correct alert colors, etc. (Ex: An active storm will be red..)

I may have to do away with this PHP code I realize, but how do I do this successfully?

Feel free to ask questions if you need further information.

Please help, I am in quite a predicament!

Thanks, and happy holidays! :)
Link to comment
https://forums.phpfreaks.com/topic/28158-php-html-integration/
Share on other sites

my best guess would be just to do things in if and elses..
like for a complete warning system..
[code]
if ($stormwarning == 'red')
{
echo "<td bgcolor=red>Very High</td>";
}
elseif ($stormwarning == 'orange')
{
echo "<td bgcolor=orange>High</td>";
}
elseif ($stormwarning == 'yellow')
{
echo "<td bgcolor=yellow>Low</td>";
}
else ($stormwarning == 'white')
{
echo "<td bgcolor=white>Low</td>";
}

[/code]

of course your gonna need to do a '<table><tr>' thing at the beginning and close them at the end and such..
and, your gonna need to add all of them in one..



that is how I would do it...
hope i helped =/
Link to comment
https://forums.phpfreaks.com/topic/28158-php-html-integration/#findComment-128866
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.