Re: import csv
Posted: Sat Mar 08, 2008 8:17 am
iv created a table with two fields, ID and time.
and have put your code in my imort script,
Am i doing this right? How do i change it so it updates every 20mins or so?
Code: Select all
CREATE TABLE `time` (
`ID` varchar(1) NOT NULL,
`minutes` varchar(250) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Code: Select all
<?php
$query = "SELECT * FROM time WHERE ID = 1 ";
$result=mysql_db_query ($$dbdatabase, $query, $db);
$currRow = mysql_fetch_array ($result) ;
$hrnow = date('H');
$daynow = date('D');
$lastupper=$currRow['hr'];
if (($hrnow <> $lastupper) AND ($daynow <> "Sat" AND $daynow <> "Sun")) {
$db=mysql_connect ($dbhost, $dbuser, $dbpassword);
$hquery = "UPDATE time SET hr=$hrnow WHERE ID = 1" ;
$hresult=mysql_db_query ($dbdatabase, $hquery, $db);
session_start();
require("connect.php");
$db = mysql_connect($dbhost, $dbuser, $dbpassword);
mysql_select_db($dbdatabase, $db);
$filename="http://uk.old.finance.yahoo.com/d/quotes.csv?s=@%5EFTSE&f=sl1d1t1c1ohgv&e=.csv";
$handle = fopen("$filename", "r");
// print "<pre>";
$sql="TRUNCATE TABLE stocks";
$result=mysql_db_query ($dbdatabase, $sql, $db);
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)
{
$import="INSERT into stocks(name, currentprice, time, date, percentage, previousprice1, previousprice2, previousprice3, other ) values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]')";
$result=mysql_db_query ($dbdatabase, $import, $db);
// print_r($data);
}
// print "</pre>";
?>Am i doing this right? How do i change it so it updates every 20mins or so?