vigiw Posted November 22, 2006 Share Posted November 22, 2006 Hi everyone, and Happy Thanksgiving! ;DI 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. 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"> </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"><font face="Arial">3</font></td> <td align="center"><font face="Arial">INACTIVE</font></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"><font face="Arial">4</font></td> <td align="center"><font face="Arial">INACTIVE</font></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><p><font face="Verdana"><sup><font size="1">§</font></sup>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).</font></p><p><font face="Verdana">*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.</font></p><p><font face="Verdana">**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.</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. 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".</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 "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.</font></i></p><p> </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 & 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<u>not</u> 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.</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 More sharing options...
vigiw Posted November 22, 2006 Author Share Posted November 22, 2006 [Bump] For help.. please help out, I am stuck.. thanks in advance! Link to comment https://forums.phpfreaks.com/topic/28158-php-html-integration/#findComment-128810 Share on other sites More sharing options...
ataria Posted November 22, 2006 Share Posted 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 =/ Link to comment https://forums.phpfreaks.com/topic/28158-php-html-integration/#findComment-128866 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.