Jump to content

How do I ...eh.. read on!

Secondlaw

By Secondlaw
in PHP Coding Help

 Share

Recommended Posts

Secondlaw Newbie

Secondlaw

Posted
Posted

I have this page which basically acquiring data from an outside webpage (I have permission).  There are some fields on the page which I use to compile the following page.  (this page takes at least 5-10 seconds to load).

 

http://www.njflyfishing.com/vBulletin/nyff.php

 

If you scroll down to "USGS", you will see there is a time, CFS, TEMP headers.

 

Those numbers are being pulled from other pages and compiled for my page.  My problem is that everytime someone

loads this page, it takes too long to load.  So...  Here is where I can use some help.  I'd like to maybe run a cron job

every 2hrs which pulls this information (just like I'm doing in the PHP file) and store it in my mySQL DB.  Then I can

pretty much query the fields whenever and they'll load instantaneously.

 

Can someone help me out with that or am I asking too much?  I just don't know how to get the data into the Database or how to setup the cron job in order to do it.

 

Thanks in advance for your help!

Link to comment
Share on other sites
Secondlaw Newbie

Secondlaw

Posted
  • Author
Posted

make script that create this part of page "USGS" and save it in local file

 

when you need just include local file in your page

Because I would like to included these numbers within threads that are specifically related to the river searched for...

 

So for an example...  If someone did a search for West Branch, I want posted within the thread or thread page, the usgs information.  I want the info in a database so I can use it wherever I want, not just on 1 page.

 

Here is my code:

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><meta name="Keywords" content="fly fishing photography,fly-fishing,fly fishing,fly fishing photographs,fishing photography,fishing images,fly,fishing,creek,delaware,game fishing,fly dressing,saddle hackle,trout fishing,river,stream,fishing flies,trout materials,nine rivers,flyfishing gear,fly fishing rods,flyfishing rods,fly rods,fly fishing tackle,fly rod selection,flyfishing equipment,fly fishing gear,flyfishing school,flyfishing tackle,Fly Tying Materials,photographs,trout,rainbow,brown,fish,fishery,brook,Beverkill,East Branch Delaware,West Branch Delaware,Delaware River,Willowemoc Creek,Neversink River,Esopus Creek,Scoharie Creek,Roundout Creek,Adirondack Fly Fishing,Ausable River Fly Shop,ausable river,fly shop,FLY TIES,Fly Castings,stream orientations,fly casting instructions and clinics. Free BBQ ,New York Fishing,Bass,fly casting techniques,streams,water,ponds,lakes,mountain streams,castings,rods,reels,FISHERMAN,NEW YORK FISHERMAN,ADIRONDACK FISHERMAN,RAINBOW TROUT,BROOK TROUT,SPLAKE,BROWN TROUT,NEW YORK TROUT FISHING,ADIRONDCK TROUT FISHING,FISH FORTROUT,TROUT LAKES,TROUT STREAMS,ADIRONDACK TROUT STREAMS,adirondack fishing,new york fly fishing,SALMON,SALMON FISHING,SALMON TACTICS,FLY FISHING SALMON,hatches,flies,new york,ny,caddies,catch and release,fisheries,Fly fish for Trout,New York fly fishing guides,New York fly fishing trips,New York fly fishing charters,New York fly fishing lodges,New York fly fishing reports,west canada creek,west canada creek new york,fishing west canada creek,fly fishing west canada creek,west canada creek fishing,fly fishing new york state,fly fishing new york,new york state fly fishing,central new york fly fishing,fly fishing west canada,west canada creek  fishing,fly fishing in new york state,west canada creek trout,canada creek,west canada creek  new york,west canada fishing,west canada creek ny fly fishing,west canada creek new york fishing,west canada creek ny,canada fly fishing,west canada river fishing,fly fishing in canada,west canada creek fly hatches,fly fishing central new york,trout fishing new york state,flyfishing west canada creek,west canada new york trout,black river west canada  creek,delaware river fly fishing,fly fishing delaware river,delaware river trout,upper delaware river fishing,delaware river trout fishing,fly fishing the delaware,upper delaware fly fishing,delaware fly fishing,fly fishing upper delaware,fishing the upper delaware,fishing delaware river,upper delaware fishing,fly fishing the upper delaware,fly fishing the deleware,fly fishing guides near upper delaware river system,the delaware river fly fishing,three types fish you can catch in the delaware river,delaware flyfishing,trout delaware river,delaware river fishing,fishing the delaware river,upper delaware trout fishing,fly fishing in new york,fishing the upper delaware river,fly fishing the deleware river,upper delaware flyfishing,shad fishing delaware river new york reports" />
<title>New York Fly Fishing Forums</title>
<style type="text/css">
<!--
.style7 {
font-size: 14px;
font-weight: bold;
}
.style8 {font-size: 11px}
.style9 {font-size: 14px}
.style10 {font-size: 11px; font-weight: bold; }
.style12 {font-size: 11px; font-weight: bold; color: #006600; }
.style14 {font-size: 11px; color: #006633; }
-->
</style>
</head>

<body>
<div align="center">
  <table width="771" border="0" cellpadding="0" cellspacing="0">
    <!--DWLayoutTable-->
    <tr>
      <td colspan="4" valign="top"><div align="center"></div></td>
    </tr>
    <tr>
      <td width="9"> </td>
      <td colspan="3" valign="top"><img src="/vBulletin/images/new-york-rivers-roads-map.jpg" alt="New York Rivers and Roads Map" width="749" height="514" align="middle" /></td>
    </tr>
    <tr>
      <td></td>
      <td width="245" valign="top"><h3 align="left"><br />
        Links of Interest</h3></td>
      <td width="73" rowspan="7" valign="top"><!--DWLayoutEmptyCell--> </td>
      <td width="444" valign="top"><h3 align="left"><br />
      Latest topics from the New York fly fishing forum</h3></td>
    </tr>
    
    <tr>
      <td></td>
      <td rowspan="5" valign="top"><p align="left" class="style7">General Information:</p>
        <div align="left">
          <ul class="style10">
            <li class="style9"><a href="http://www.njflyfishing.com">NEFF HOME PAGE</a></li>
            <li><a href="http://www.njflyfishing.com/vBulletin/view.php?pg=hatchchart" class="style9">Hatch Chart</a></li>
            <li><a href="http://www.njflyfishing.com/delawaremap.pdf" class="style9">Delaware River Map</a></li>
            <li><a href="http://www.cffcm.net/" class="style9">Catskill Fly Fishing Museum</a></li>
            <li><a href="http://www.njflyfishing.com/vBulletin/vbclassified.php" target="_blank" class="style9">CLASSIFIEDS</a></li>
          </ul>
        </div>
        <p align="left" class="style7">USGS:</p>
        <span class="style12">West Branch - Delaware River @ Hale Eddy</span>
        <table cellpadding="2" cellspacing="2" bgcolor="#FFCC66">
<thead>
	<tr>
	  <td width="92" class="style14">Time</td>
	  <td width="60" class="style14">CFS</td>
	  <td width="56" class="style14">Temp</td>
  </tr>
</thead>

<tbody>
<?php
$last_line = -1;
$content=file("http://waterdata.usgs.gov/nwis/uv?cb_00065=on&cb_00010=on&cb_00060=on&format=rdb&period=1&site_no=01426500");

$content = array_reverse($content);
$lines_to_display = 1;

foreach($content as $i => $line)
{
      /* Check that the row of data begins with USGS.  You may need to tweek this for other file formats */
      if( substr($line, 0, 4)=="USGS")
      {
            echo "<tr>";
            $column = explode("\t", $line);      // Explode line based on data fields being seperated by a TAB
            echo "<td>".date("H:i:s" ,strtotime($column[2]))."</td>";      // Make pretty looking time
            echo "<td>".$column[5]."</td>";
            echo "<td>".$column[7]."</td>";
            echo "</tr>";
            $last_line = $i;
         $lines_to_display--;
         if($lines_to_display == 0) {
            break;
         }
      }
}

?>
</tbody>
</table>

        <span class="style8"><br>
</span><span class="style12">Beaverkill @ Cooks Falls        </span>
        <table cellpadding="2" cellspacing="2" bgcolor="#FFCC66">
<thead>
	<tr>
	  <td width="92" class="style14">Time</td>
	  <td width="60" class="style14">CFS</td>
	  <td width="56" class="style14">Temp</td>
  </tr>
</thead>

<tbody>
<?php
$last_line = -1;
$content=file("http://waterdata.usgs.gov/nwis/uv?cb_00065=on&cb_00010=on&cb_00060=on&format=rdb&period=1&site_no=01420500");

$content = array_reverse($content);
$lines_to_display = 1;

foreach($content as $i => $line)
{
      if( substr($line, 0, 4)=="USGS")
      {
            echo "<tr>";
            $column = explode("\t", $line);      
            echo "<td>".date("H:i:s" ,strtotime($column[2]))."</td>";     
            echo "<td>".$column[5]."</td>";
            echo "<td>".$column[7]."</td>";
            echo "</tr>";
            $last_line = $i;
         $lines_to_display--;
         if($lines_to_display == 0) {
            break;
         }
      }
}

?>
</tbody>
</table>
        <span class="style8"><br>
</span><span class="style12">East Branch @ Harvard        </span>
        <table cellpadding="2" cellspacing="2" bgcolor="#FFCC66">
<thead>
	<tr>
	  <td width="92" class="style14">Time</td>
	  <td width="60" class="style14">CFS</td>
	  <td width="56" class="style14">Temp</td>
  </tr>
</thead>

<tbody>
<?php
$last_line = -1;
$content=file("http://waterdata.usgs.gov/nwis/uv?cb_00065=on&cb_00010=on&cb_00060=on&format=rdb&period=1&site_no=01417500");

$content = array_reverse($content);
$lines_to_display = 1;

foreach($content as $i => $line)
{
      /* Check that the row of data begins with USGS.  You may need to tweek this for other file formats */
      if( substr($line, 0, 4)=="USGS")
      {
            echo "<tr>";
            $column = explode("\t", $line);      // Explode line based on data fields being seperated by a TAB
            echo "<td>".date("H:i:s" ,strtotime($column[2]))."</td>";      // Make pretty looking time
            echo "<td>".$column[5]."</td>";
            echo "<td>".$column[7]."</td>";
            echo "</tr>";
            $last_line = $i;
         $lines_to_display--;
         if($lines_to_display == 0) {
            break;
         }
      }
}

?>
</tbody>
</table>
        <span class="style8"><br>
</span><span class="style12">East Branch @ Fish's Eddy        </span>
        <table cellpadding="2" cellspacing="2" bgcolor="#FFCC66">
<thead>
	<tr>
	  <td width="92" class="style14">Time</td>
	  <td width="60" class="style14">CFS</td>
	  <td width="56" class="style14">Temp</td>
  </tr>
</thead>

<tbody>
<?php
$last_line = -1;
$content=file("http://waterdata.usgs.gov/nwis/uv?cb_00065=on&cb_00010=on&cb_00060=on&format=rdb&period=1&site_no=01421000");

$content = array_reverse($content);
$lines_to_display = 1;

foreach($content as $i => $line)
{
      /* Check that the row of data begins with USGS.  You may need to tweek this for other file formats */
      if( substr($line, 0, 4)=="USGS")
      {
            echo "<tr>";
            $column = explode("\t", $line);      // Explode line based on data fields being seperated by a TAB
            echo "<td>".date("H:i:s" ,strtotime($column[2]))."</td>";      // Make pretty looking time
            echo "<td>".$column[5]."</td>";
            echo "<td>".$column[7]."</td>";
            echo "</tr>";
            $last_line = $i;
         $lines_to_display--;
         if($lines_to_display == 0) {
            break;
         }
      }
}

?>
</tbody>
</table>
        <span class="style12"><br>
Delaware River - Mainstem @ Lordville        </span>
        <table cellpadding="2" cellspacing="2" bgcolor="#FFCC66">
<thead>
	<tr>
	  <td width="92" class="style14">Time</td>
	  <td width="60" class="style14">CFS</td>
	  <td width="56" class="style14">Temp</td>
  </tr>
</thead>

<tbody>
<?php
$last_line = -1;
$content=file("http://waterdata.usgs.gov/nwis/uv?cb_00065=on&cb_00010=on&cb_00060=on&format=rdb&period=1&site_no=01427207");

$content = array_reverse($content);
$lines_to_display = 1;

foreach($content as $i => $line)
{
      /* Check that the row of data begins with USGS.  You may need to tweek this for other file formats */
      if( substr($line, 0, 4)=="USGS")
      {
            echo "<tr>";
            $column = explode("\t", $line);      // Explode line based on data fields being seperated by a TAB
            echo "<td>".date("H:i:s" ,strtotime($column[2]))."</td>";      // Make pretty looking time
            echo "<td>".$column[5]."</td>";
            echo "<td>".$column[7]."</td>";
            echo "</tr>";
            $last_line = $i;
         $lines_to_display--;
         if($lines_to_display == 0) {
            break;
         }
      }
}

?>
</tbody>
</table>
        <span class="style12"><br />
        Delaware River - Mainstem @ Calicoon<br />
        </span>
        <table cellpadding="2" cellspacing="2" bgcolor="#FFCC66">
<thead>
	<tr>
	  <td width="92" class="style14">Time</td>
	  <td width="60" class="style14">CFS</td>
	  <td width="56" class="style14">Temp</td>
  </tr>
</thead>

<tbody>
<?php
$last_line = -1;
$content=file("http://waterdata.usgs.gov/nwis/uv?cb_00065=on&cb_00010=on&cb_00060=on&format=rdb&period=1&site_no=01427510");

$content = array_reverse($content);
$lines_to_display = 1;

foreach($content as $i => $line)
{
      /* Check that the row of data begins with USGS.  You may need to tweek this for other file formats */
      if( substr($line, 0, 4)=="USGS")
      {
            echo "<tr>";
            $column = explode("\t", $line);      // Explode line based on data fields being seperated by a TAB
            echo "<td>".date("H:i:s" ,strtotime($column[2]))."</td>";      // Make pretty looking time
            echo "<td>".$column[5]."</td>";
            echo "<td>".$column[7]."</td>";
            echo "</tr>";
            $last_line = $i;
         $lines_to_display--;
         if($lines_to_display == 0) {
            break;
         }
      }
}

?>
</tbody>
</table>
        <span class="style12"><br />
        Neversink River @ Bridgeville<br />
        </span>
        <table cellpadding="2" cellspacing="2" bgcolor="#FFCC66">
<thead>
	<tr>
	  <td width="92" class="style14">Time</td>
	  <td width="60" class="style14">CFS</td>
	  <td width="56" class="style14">Temp</td>
  </tr>
</thead>

<tbody>
<?php
$last_line = -1;
$content=file("http://waterdata.usgs.gov/nwis/uv?cb_00065=on&cb_00010=on&cb_00060=on&format=rdb&period=1&site_no=01436690");

$content = array_reverse($content);
$lines_to_display = 1;

foreach($content as $i => $line)
{
      /* Check that the row of data begins with USGS.  You may need to tweek this for other file formats */
      if( substr($line, 0, 4)=="USGS")
      {
            echo "<tr>";
            $column = explode("\t", $line);      // Explode line based on data fields being seperated by a TAB
            echo "<td>".date("H:i:s" ,strtotime($column[2]))."</td>";      // Make pretty looking time
            echo "<td>".$column[5]."</td>";
            echo "<td>".$column[7]."</td>";
            echo "</tr>";
            $last_line = $i;
         $lines_to_display--;
         if($lines_to_display == 0) {
            break;
         }
      }
}

?>
</tbody>
</table>
        <br />
        <span class="style12">Esopus Creek @ Coldbrook</span><br />
        <table cellpadding="2" cellspacing="2" bgcolor="#FFCC66">
<thead>
	<tr>
	  <td width="92" class="style14">Time</td>
	  <td width="60" class="style14">CFS</td>
	  <td width="56" class="style14">Temp</td>
  </tr>
</thead>

<tbody>
<?php
$last_line = -1;
$content=file("http://waterdata.usgs.gov/nwis/uv?cb_00065=on&cb_00010=on&cb_00060=on&format=rdb&period=1&site_no=01362500");

$content = array_reverse($content);
$lines_to_display = 1;

foreach($content as $i => $line)
{
      /* Check that the row of data begins with USGS.  You may need to tweek this for other file formats */
      if( substr($line, 0, 4)=="USGS")
      {
            echo "<tr>";
            $column = explode("\t", $line);      // Explode line based on data fields being seperated by a TAB
            echo "<td>".date("H:i:s" ,strtotime($column[2]))."</td>";      // Make pretty looking time
            echo "<td>".$column[5]."</td>";
            echo "<td>".$column[7]."</td>";
            echo "</tr>";
            $last_line = $i;
         $lines_to_display--;
         if($lines_to_display == 0) {
            break;
         }
      }
}

?>
</tbody>
</table>        
        <br />
        <span class="style12">Salmon River @ Pineville        </span>
        <table cellpadding="2" cellspacing="2" bgcolor="#FFCC66">
<thead>
	<tr>
	  <td width="92" class="style14">Time</td>
	  <td width="60" class="style14">CFS</td>
	  <td width="56" class="style14">Temp</td>
  </tr>
</thead>

<tbody>
<?php
$last_line = -1;
$content=file("http://waterdata.usgs.gov/nwis/uv?cb_00065=on&cb_00010=on&cb_00060=on&format=rdb&period=1&site_no=04250200");

$content = array_reverse($content);
$lines_to_display = 1;

foreach($content as $i => $line)
{
      /* Check that the row of data begins with USGS.  You may need to tweek this for other file formats */
      if( substr($line, 0, 4)=="USGS")
      {
            echo "<tr>";
            $column = explode("\t", $line);      // Explode line based on data fields being seperated by a TAB
            echo "<td>".date("H:i:s" ,strtotime($column[2]))."</td>";      // Make pretty looking time
            echo "<td>".$column[5]."</td>";
            echo "<td>".$column[7]."</td>";
            echo "</tr>";
            $last_line = $i;
         $lines_to_display--;
         if($lines_to_display == 0) {
            break;
         }
      }
}

?>
</tbody>
</table>
        <div align="left">
          <p><span class="style8"><a href="http://water.usgs.gov/orh/nrwww/odrm/releases.html" target="_blank">USGS Upper Delaware River Release History</a></span><br />
          </p>
          <hr />
          <p><b>Temperature Converter</b>:<br />
        Enter a number in either field, then click outside
        the text box. </p>
        <form>
          <p>Fahrenheit:   
            <INPUT type="text" name="F" value="32"
    onChange="C.value = 100/(212-32) * (this.value - 32 )"></p>
          <p>Celsius:
            <INPUT type="text" name="C" value="0"
    onChange="F.value = (212-32)/100 * this.value + 32 ">
          </p>
                    </form><hr />
        </div>
        <p align="left" class="style7">Trout Conservation Groups / Other</p>
        <div align="left">
          <ul>
            <li><a href="http://www.cffcm.net/" target="_blank" class="style9">NYDEC HOME PAGE</a></li>
            <li><a href="http://www.delawareriverfoundation.org/" target="_blank" class="style9">Delaware River Foundation</a></li>
            <li><a href="http://fudr.org/" target="_blank" class="style9">Friends of the Upper Delaware River</a></li>
            <li><a href="http://www.tu.org/site/pp.asp?c=7dJEKTNuFmG&b=275410" target="_blank" class="style9">Trout Unlimited</a></li>
            <li><a href="http://www.drarp.org/" target="_blank" class="style9">Delaware River Adaptive Release Policy</a></li>
            <li><a href="http://www.tgf.org/">Theodore Gordon Flyfishers</a></li>
            <li><a href="http://www.cffcm.net/">Catskill Fly Fishing Center & Museum</a></li>
          </ul>
        </div>
        <p align="left"><strong>North Eastern Fly Fishing Syndication:</strong></p>        <div align="left">
          <ul>
            <li class="style9"><a href="http://www.njflyfishing.com/vBulletin/external.php?type=XML&forumids=20">XML (NY)</a></li>
            <li class="style9"><a href="http://www.njflyfishing.com/vBulletin/external.php?type=RSS2&forumids=20">RSS (NY)</a></li>
          </ul>
      </div></td>
      <td valign="top"><p align="left">
        <script type="text/javascript" src="http://www.njflyfishing.com/vBulletin/external.php?type=js&forumids=20"></script>
        <script type="text/javascript">
<!--
for (var i = 0; i < threads.length; i++)
{
	document.write('<a href="http://www.njflyfishing.com/vBulletin/showthread.php?t=' + threads[i]['threadid'] + '">' + threads[i]['title'] + '</a> <br />');
}
//-->
          </script>
      </p>
        <p align="left"><span class="style9">Create a <a href="http://www.njflyfishing.com/vBulletin/newthread.php?do=newthread&f=20"><img src="http://www.njflyfishing.com/vBulletin/images/buttons/newthread.gif" alt="Create New Thread" width="110" height="26" align="bottom" /></a> in the New York Fly Fishing forum</span>.<br /><br />

        </p>
      </td>
    </tr>
    <tr>
      <td height="19"></td>
      <td valign="top"><div id="wx_module_4623">
        <div align="left"><a href="http://www.weather.com/weather/local/USNY0621">Hancock Weather Forecast, NY</a>
        </div>
      </div>

        <div align="left">
          <script type="text/javascript">

   /* Locations can be edited manually by updating 'wx_locID' below.  Please also update */
   /* the location name and link in the above div (wx_module) to reflect any changes made. */
   var wx_locID = 'USNY0621';

   /* If you are editing locations manually and are adding multiple modules to one page, each */
   /* module must have a unique div id.  Please append a unique # to the div above, as well */
   /* as the one referenced just below.  If you use the builder to create individual modules  */
   /* you will not need to edit these parameters. */
   var wx_targetDiv = 'wx_module_4623';

   /* Please do not change the configuration value [wx_config] manually - your module */
   /* will no longer function if you do.  If at any time you wish to modify this */
   /* configuration please use the graphical configuration tool found at */
   /* https://registration.weather.com/ursa/wow/step2 */
   var wx_config='SZ=180x150*WX=FHW*LNK=SSNL*UNT=F*BGI=boat*MAP=CSC|null*DN=njflyfishing.com*TIER=0*PID=1043822770*MD5=90d4e215871eae907182787664b93fba';

   document.write('<scr'+'ipt src="'+document.location.protocol+'//wow.weather.com/weather/wow/module/'+wx_locID+'?config='+wx_config+'&proto='+document.location.protocol+'&target='+wx_targetDiv+'"></scr'+'ipt>');  
  </script>
       </div></td>
    </tr>
    <tr>
      <td></td>
      <td valign="top"><h3 align="left">
        <script type="text/javascript"><!--
auctionads_ad_client = "d8ab292c52a30ff7404d";
auctionads_ad_campaign = "";
auctionads_ad_width = "468";
auctionads_ad_height = "60";
auctionads_ad_kw =  "trout, trout flies, trout flys, trout lures, trout tactics, trout vacations, trout trips, trout rod, trout reel, trout line, trout recipe, trout secret, trout river, trout stream, trout tackle";
auctionads_color_border =  "CFF8A3";
auctionads_color_bg =  "FFFFFF";
auctionads_color_heading =  "00A0E2";
auctionads_color_text =  "000000";
auctionads_color_link =  "008000";
--></script>
        <script type="text/javascript" src="http://ads.auctionads.com/pagead/show_ads.js"></script>
        <br />
          Other interesting Fly Fishing discussions<br />
        </h3>
      </td>
    </tr>
    <tr>
      <td></td>
      <td valign="top">        <div align="left">
        <script type="text/javascript" src="http://www.njflyfishing.com/vBulletin/external.php?type=js&forumids=5,8,16,18"></script>
        <script type="text/javascript">
<!--
for (var i = 0; i < threads.length; i++)
{
	document.write('<a href="http://www.njflyfishing.com/vBulletin/showthread.php?t=' + threads[i]['threadid'] + '">' + threads[i]['title'] + '</a> <br />');
}
//-->
          </script>
       </div></td>
    </tr>
    <tr>
      <td height="849"></td>
      <td><div style="text-align:center"><a href="http://www.webcounter.com"><img border="0" src="http://www.webcounter.com/46c3f0d1dc326/counter.png"/></a><br />
      </div></td>
    </tr>
    
    
    
    
    
    
    
    
    
    
    <tr>
      <td></td>
      <td valign="top"><!--DWLayoutEmptyCell--> </td>
    <td> </td>
    </tr>
  </table>
</div>
</body>
</html>

 

Thanks to all of you who have replied.  It's very much appreciated.

Link to comment
Share on other sites
DyslexicDog Newbie

DyslexicDog

Posted
Posted

Easy way would be to check and see if the most recent database update was within the last two hours. If the database isn't recent then echo a message about the database is getting the current info and set your header or a meta refresh tag to send the client to another script that updates the numbers then displays the information. The new entry in the database would get a time stamp of the current time and everything is happy :)

 

Link to comment
Share on other sites
Secondlaw Newbie

Secondlaw

Posted
  • Author
Posted

What I'd like to do is get the information I already have and get it put into a mySQL database.  I will look into the DOM method but I don't know how to get it into the DB via PHP.  How would I go about placing each entry into the DB and erasing the old value that's in there?

 

THanks again!

Link to comment
Share on other sites
DyslexicDog Newbie

DyslexicDog

Posted
Posted

What I'd like to do is get the information I already have and get it put into a mySQL database.  I will look into the DOM method but I don't know how to get it into the DB via PHP.  How would I go about placing each entry into the DB and erasing the old value that's in there?

 

THanks again!

 

You have to start reading.

http://www.tizag.com/mysqlTutorial/

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • 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.