PHP-HTML Integration

vigiw · November 22, 2006

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>

Vigilant
Weather - Alert Mode Analysis
Vigilant Weather Alert Mode
Analysis will show you the live breakdown of storms that we may consider for
Alert Mode.  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>
Potential Upcoming Storms:
<table border="1" width="100%" id="table3">
<tr>
<td align="center">
Storm ID</td>
<td align="center">Status§</td>
<td align="center">Updated</td>
<td align="center">Valid On</td>
<td align="center" width="223">Conditions</td>
<td align="center" width="245">Location</td>
<td align="center" width="184">Likelihood*</td>
<td align="center">Risk**</td>
<td align="center">Alert Mode Consideration±</td>
</tr>
<tr>
<td align="center" bgcolor="#FF0000">1</td>
<td align="center" bgcolor="#FF0000">
ACTIVE</td>
<td align="center" bgcolor="#FF0000">7-27-06</td>
<td align="center" bgcolor="#FF0000">7-28-06</td>
<td align="center" bgcolor="#FF0000" width="223">
SCATTERED SEVERE THUNDERSTORMS</td>
<td align="center" bgcolor="#FF0000" width="245">
SOUTHERN NEW ENGLAND</td>
<td align="center" bgcolor="#FF0000" width="184">
LIKELY</td>
<td align="center" bgcolor="#FF0000">
MODERATE</td>
<td align="center" bgcolor="#FF0000">IN
CONSIDERATION</td>
</tr>
<tr>
<td align="center">2</td>
<td align="center">INACTIVE</td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center" width="223">
 </td>
<td align="center" width="245">
 </td>
<td align="center" width="184">
 </td>
<td align="center"> </td>
<td align="center"> </td>
</tr>
<tr>
<td align="center">3</td>
<td align="center">INACTIVE</td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center" width="223">
 </td>
<td align="center" width="245">
 </td>
<td align="center" width="184">
 </td>
<td align="center"> </td>
<td align="center"> </td>
</tr>
<tr>
<td align="center">4</td>
<td align="center">INACTIVE</td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center" width="223"> </td>
<td align="center" width="245"> </td>
<td align="center" width="184"> </td>
<td align="center"> </td>
<td align="center"> </td>
</tr>
</table>
§Status is represented
by "Inactive" when the storm is no longer being watched, "Active" when the storm
is currently being watched, and "Watching" the storm will be watched in the
future (for storms coming within days, not hours, etc.)  "Active" is
represented by red, "Inactive" by white, and "Watching" by light blue. 
When in "Inactive" 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).
*Likelihood has 4 possible forecasts, ranging from least
severe to most severe: "Threat", "Possible", "Likely", and "Very Likely". 
At times we may mix multiple forecasts that are 'in between', for example:
"Possible-Likely".  Likelihood shows the probability of a particular storm
striking a particular area.
**Risk has 4 possible forecasts, ranging from least
severe to most severe: "Low", "Moderate", "High", and "Extreme".  At times
we may mix multiple forecasts that are 'in between', for example:
"Low-Moderate".  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.
±Alert Mode
Consideration has 5 possible outputs explaining the likelihood of Vigilant
Weather issuing Alert Mode for a particular storm.  Ranging from least
likely to most likely, the 5 possible outputs are: "Unlikely", "Possible", "In
Consideration", "Likely", and "Very Likely".  Note that "In Consideration"
means we are considering a particular storm for Alert Mode, but it is between
"Possible" and "Likely".
<hr>
The Breakdown:
Note: Active forecasts, such as "Threat"
are highlighted in yellow.   At times, if we feel forecasts are 'in
between', for example, a forecast may be in between "Likely" and "Very Likely",
so we will highlight both under the specific forecast, such as "Tornadoes". 
(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.
 
<table border="2" width="100%" id="table2" bordercolor="#FF00FF">
<tr>
<td bgcolor="#00FFFF">
VALID: Storm ID #1 -
Likelihood</td>
</tr>
</table>
<table border="2" width="100%" id="table1" bordercolor="#FF00FF">
<tr>
<td align="center" height="23">Tornadoes</td>
<td align="center" height="23">Hail</td>
<td align="center" height="23">Wind Damage</td>
<td align="center" height="23">Heavy Rainfall</td>
</tr>
<tr>
<td align="center">Very Likely</td>
<td align="center">Very Likely</td>
<td align="center">Very Likely</td>
<td align="center">Very Likely</td>
</tr>
<tr>
<td align="center">Likely</td>
<td align="center">Likely</td>
<td align="center">Likely</td>
<td align="center">Likely</td>
</tr>
<tr>
<td align="center">Possible</td>
<td align="center" bgcolor="#FFFF00">Possible</td>
<td align="center" bgcolor="#FFFF00">Possible</td>
<td align="center">Possible</td>
</tr>
<tr>
<td align="center">Threat</td>
<td align="center">Threat</td>
<td align="center" bgcolor="#FFFF00">Threat</td>
<td align="center" bgcolor="#FFFF00">Threat</td>
</tr>
<tr>
<td align="center" bgcolor="#FFFF00">N/A</td>
<td align="center">N/A</td>
<td align="center">N/A</td>
<td align="center" bgcolor="#FFFF00">N/A</td>
</tr>
</table>
<table border="2" width="100%" id="table6" bordercolor="#FF0000">
<tr>
<td bgcolor="#00FFFF">
VALID: Storm ID #1 - Risk</td>
</tr>
</table>
<table border="2" width="100%" id="table7" bordercolor="#FF0000">
<tr>
<td align="center" height="23">Tornadoes</td>
<td align="center" height="23">Hail</td>
<td align="center" height="23">Wind Damage</td>
<td align="center" height="23">Rainfall</td>
</tr>
<tr>
<td align="center">Very High</td>
<td align="center">Very High</td>
<td align="center">Very High</td>
<td align="center">Very High</td>
</tr>
<tr>
<td align="center">High</td>
<td align="center">High</td>
<td align="center">High</td>
<td align="center">High</td>
</tr>
<tr>
<td align="center">Moderate</td>
<td align="center" bgcolor="#FFFF00">Moderate</td>
<td align="center" bgcolor="#FFFF00">Moderate</td>
<td align="center">Moderate</td>
</tr>
<tr>
<td align="center" bgcolor="#FFFF00">Low</td>
<td align="center" bgcolor="#FFFFFF">Low</td>
<td align="center" bgcolor="#FFFFFF">Low</td>
<td align="center" bgcolor="#FFFF00">Low</td>
</tr>
<tr>
<td align="center" bgcolor="#FFFF00">N/A</td>
<td align="center">N/A</td>
<td align="center">N/A</td>
<td align="center" bgcolor="#FFFF00">N/A</td>
</tr>
</table>
<hr>
<table border="2" width="100%" id="table12" bordercolor="#FF00FF">
<tr>
<td bgcolor="#00FFFF">
VALID: Storm ID #2 -
Likelihood</td>
</tr>
</table>
<table border="2" width="100%" id="table13" bordercolor="#FF00FF">
<tr>
<td align="center" height="23">Tornadoes</td>
<td align="center" height="23">Hail</td>
<td align="center" height="23">Wind Damage</td>
<td align="center" height="23">Heavy Rainfall</td>
</tr>
<tr>
<td align="center">Very Likely</td>
<td align="center">Very Likely</td>
<td align="center">Very Likely</td>
<td align="center">Very Likely</td>
</tr>
<tr>
<td align="center">Likely</td>
<td align="center">Likely</td>
<td align="center" bgcolor="#FFFFFF">Likely</td>
<td align="center">Likely</td>
</tr>
<tr>
<td align="center">Possible</td>
<td align="center" bgcolor="#FFFF00">Possible</td>
<td align="center" bgcolor="#FFFF00">Possible</td>
<td align="center">Possible</td>
</tr>
<tr>
<td align="center" bgcolor="#FFFF00">Threat</td>
<td align="center">Threat</td>
<td align="center" bgcolor="#FFFF00">Threat</td>
<td align="center">Threat</td>
</tr>
<tr>
<td align="center">N/A</td>
<td align="center">N/A</td>
<td align="center">N/A</td>
<td align="center" bgcolor="#FFFF00">N/A</td>
</tr>
</table>
<table border="2" width="100%" id="table14" bordercolor="#FF0000">
<tr>
<td bgcolor="#00FFFF">
VALID: Storm ID #2 - Risk</td>
</tr>
</table>
<table border="2" width="100%" id="table15" bordercolor="#FF0000">
<tr>
<td align="center" height="23">Tornadoes</td>
<td align="center" height="23">Hail</td>
<td align="center" height="23">Wind Damage</td>
<td align="center" height="23">Rainfall</td>
</tr>
<tr>
<td align="center">Very High</td>
<td align="center">Very High</td>
<td align="center">Very High</td>
<td align="center">Very High</td>
</tr>
<tr>
<td align="center">High</td>
<td align="center">High</td>
<td align="center">High</td>
<td align="center">High</td>
</tr>
<tr>
<td align="center">Moderate</td>
<td align="center" bgcolor="#FFFF00">Moderate</td>
<td align="center" bgcolor="#FFFF00">Moderate</td>
<td align="center">Moderate</td>
</tr>
<tr>
<td align="center" bgcolor="#FFFF00">Low</td>
<td align="center" bgcolor="#FFFF00">Low</td>
<td align="center" bgcolor="#FFFF00">Low</td>
<td align="center">Low</td>
</tr>
<tr>
<td align="center">N/A</td>
<td align="center">N/A</td>
<td align="center">N/A</td>
<td align="center" bgcolor="#FFFF00">N/A</td>
</tr>
</table>
<hr>
<table border="2" width="100%" id="table20" bordercolor="#FF00FF">
<tr>
<td bgcolor="#00FFFF">
VALID: Storm ID #3 -
Likelihood</td>
</tr>
</table>
<table border="2" width="100%" id="table21" bordercolor="#FF00FF">
<tr>
<td align="center" height="23">Tornadoes</td>
<td align="center" height="23">Hail</td>
<td align="center" height="23">Wind Damage</td>
<td align="center" height="23">Heavy Rainfall</td>
</tr>
<tr>
<td align="center">Very Likely</td>
<td align="center">Very Likely</td>
<td align="center">Very Likely</td>
<td align="center">Very Likely</td>
</tr>
<tr>
<td align="center">Likely</td>
<td align="center" bgcolor="#FFFF00">Likely</td>
<td align="center" bgcolor="#FFFFFF">Likely</td>
<td align="center">Likely</td>
</tr>
<tr>
<td align="center">Possible</td>
<td align="center" bgcolor="#FFFF00">Possible</td>
<td align="center" bgcolor="#FFFF00">Possible</td>
<td align="center">Possible</td>
</tr>
<tr>
<td align="center" bgcolor="#FFFF00">Threat</td>
<td align="center">Threat</td>
<td align="center" bgcolor="#FFFF00">Threat</td>
<td align="center">Threat</td>
</tr>
<tr>
<td align="center">N/A</td>
<td align="center">N/A</td>
<td align="center">N/A</td>
<td align="center" bgcolor="#FFFF00">N/A</td>
</tr>
</table>
<table border="2" width="100%" id="table22" bordercolor="#FF0000">
<tr>
<td bgcolor="#00FFFF">
VALID: Storm ID #3 - Risk</td>
</tr>
</table>
<table border="2" width="100%" id="table23" bordercolor="#FF0000">
<tr>
<td align="center" height="23">Tornadoes</td>
<td align="center" height="23">Hail</td>
<td align="center" height="23">Wind Damage</td>
<td align="center" height="23">Rainfall</td>
</tr>
<tr>
<td align="center">Very High</td>
<td align="center">Very High</td>
<td align="center">Very High</td>
<td align="center">Very High</td>
</tr>
<tr>
<td align="center">High</td>
<td align="center">High</td>
<td align="center">High</td>
<td align="center">High</td>
</tr>
<tr>
<td align="center">Moderate</td>
<td align="center" bgcolor="#FFFF00">Moderate</td>
<td align="center" bgcolor="#FFFF00">Moderate</td>
<td align="center">Moderate</td>
</tr>
<tr>
<td align="center" bgcolor="#FFFF00">Low</td>
<td align="center" bgcolor="#FFFFFF">Low</td>
<td align="center" bgcolor="#FFFF00">Low</td>
<td align="center">Low</td>
</tr>
<tr>
<td align="center">N/A</td>
<td align="center">N/A</td>
<td align="center">N/A</td>
<td align="center" bgcolor="#FFFF00">N/A</td>
</tr>
</table>
<hr>
NOTICE: All content on this page has been
created by and is maintained & 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.  All content on this page is
not to be used as a serious decision to save life/lives or property. 
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. 
This page is to be used a simple reference or guidance, and only this.
</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 Last Updated: " . $row['time'] . " PST Day 1: " . $row['heaviness1'] . " " . $row['precip1'] . " , with " . $row['conditions_1'] . " " . $row['conditions2_1'] . " conditions. High " . $row['high1'] . ", Low " . $row['low1'] . ". Winds " . $row['winddir1'] . " at " . $row['wind1'] . " mph. Probability of Precipitation: " . $row['pop1'] .

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

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

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

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

}
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! :)

vigiw · November 22, 2006

[Bump] For help.. please help out, I am stuck.. thanks in advance!

ataria · November 22, 2006

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 =/

Sign In

PHP-HTML Integration

Recommended Posts

vigiw

Link to comment

Share on other sites

vigiw

Link to comment

Share on other sites

ataria

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information