Databases
StackOverflow2013
Postsdbo
POXML to HTML (PHP)
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POXML to HTML (PHP)
    primarykey
    data
    text
    <p>I have an XML output code for Google's weather API and I'd like to know how to output it into HTML. I know that there must be some PHP involved, but I'm very limited in PHP.</p> <p>Here's the code:</p> <pre><code> &lt;forecast_information&gt; &lt;city data="Toronto, ON"/&gt; &lt;postal_code data="Toronto"/&gt; &lt;latitude_e6 data=""/&gt; &lt;longitude_e6 data=""/&gt; &lt;forecast_date data="2011-03-11"/&gt; &lt;current_date_time data="2011-03-11 15:07:00 +0000"/&gt; &lt;unit_system data="US"/&gt; &lt;/forecast_information&gt; &lt;current_conditions&gt; &lt;condition data="Rain and Snow"/&gt; &lt;temp_f data="36"/&gt; &lt;temp_c data="2"/&gt; &lt;humidity data="Humidity: 100%"/&gt; &lt;icon data="/ig/images/weather/rain_snow.gif"/&gt; &lt;wind_condition data="Wind: S at 6 mph"/&gt; &lt;/current_conditions&gt; &lt;forecast_conditions&gt; &lt;day_of_week data="Fri"/&gt; &lt;low data="31"/&gt; &lt;high data="37"/&gt; &lt;icon data="/ig/images/weather/rain_snow.gif"/&gt; &lt;condition data="Rain and Snow"/&gt; &lt;/forecast_conditions&gt; &lt;forecast_conditions&gt; &lt;day_of_week data="Sat"/&gt; &lt;low data="28"/&gt;&lt;high data="38"/&gt; &lt;icon data="/ig/images/weather/rain_snow.gif"/&gt; &lt;condition data="Rain and Snow"/&gt; &lt;/forecast_conditions&gt; &lt;forecast_conditions&gt; &lt;day_of_week data="Sun"/&gt; &lt;low data="18"/&gt; &lt;high data="32"/&gt; &lt;icon data="/ig/images/weather/snow.gif"/&gt; &lt;condition data="Snow Showers"/&gt; &lt;/forecast_conditions&gt; &lt;forecast_conditions&gt; &lt;day_of_week data="Mon"/&gt; &lt;low data="23"/&gt;&lt;high data="32"/&gt; &lt;icon data="/ig/images/weather/partly_cloudy.gif"/&gt; &lt;condition data="Partly Cloudy"/&gt; &lt;/forecast_conditions&gt; </code></pre> <p> </p> <p>A possible html output format could look like this:</p> <pre><code>&lt;div id="forecast_information"&gt; &lt;div id="city_data"&gt;Ex: Toronto &lt;/div&gt; &lt;div id="current_date_time_data"&gt;EX: 2011-03-11&lt;/div&gt; &lt;div id="forecast_date"&gt;EX: 2011-03-11&lt;/div&gt; &lt;div id="unit_system_data"&gt;Ex: US &lt;/div&gt; &lt;/div&gt; &lt;div id="current_conditions"&gt; &lt;div id="condition_data"&gt;Ex: Rain and Snow&lt;/div&gt; &lt;div id="temp_c_data"&gt;Temperature in Celcius&lt;/div&gt; &lt;div id="humidity_data"&gt;Humidity&lt;/div&gt; &lt;div id="wind_condition_data"&gt;ex: SW at 23 km/h&lt;/div&gt; &lt;div id="icon"&gt;ex: rain.gif&lt;/div&gt; &lt;/div&gt; &lt;div id="forecast_conditions"&gt; &lt;div id="day_of_week_data"&gt;Ex: Friday&lt;/div&gt; &lt;div id="low_data"&gt;Temperature in Celcius&lt;/div&gt; &lt;div id="high_data"&gt;Temperature in Celcius&lt;/div&gt; &lt;div id="condition_data"&gt;Ex: Rain&lt;/div&gt; &lt;div id="icon"&gt;ex: rain.gif&lt;/div&gt; &lt;/div&gt; &lt;div id="forecast_conditions"&gt; &lt;div id="day_of_week_data"&gt;Ex: Saturday&lt;/div&gt; &lt;div id="low_data"&gt;Temperature in Celcius&lt;/div&gt; &lt;div id="high_data"&gt;Temperature in Celcius&lt;/div&gt; &lt;div id="condition_data"&gt;Ex: Rain&lt;/div&gt; &lt;div id="icon"&gt;ex: rain.gif&lt;/div&gt; &lt;/div&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USuser546585
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POXML to HTML (PHP)
      1. USShankar Damodaran
      1. VTFavorite
    2. VO
      singulars
      1. POXML to HTML (PHP)
      1. USkuvukala
      1. VTFavorite
    1. COSo what do you want to transform it into?
      singulars
      1. POXML to HTML (PHP)
      1. USlonesomeday
    2. CO**What HTML do you want to output?**
      singulars
      1. POXML to HTML (PHP)
      1. USMatt Ball
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload