下面这个代码为什么本地windows下可以,上传服务器linux就没反应了。有人帮忙不?<?php
$url = "http://download.finance.yahoo.com/d/quotes.csv?e=.csv&f=sl1d1t1&s=USDCNY=x";
?>
<?php
$handle = curl_init($url);
curl_setopt($handle, CURLOPT_RETURNTRANSFER, true);
$result = curl_exec($handle);if(curl_errno($handle)):
echo "CURL Error: " . curl_error($handle);
else:
$sql = "insert into forexrates (`currencypair`, `rate`, `source-time`) values ";
$values = array();$rows = explode("\n", $result); //echo print_r($rows); echo print_r($result);
foreach($rows as $row):
//"AUDCNY=X",6.8059,"2/29/2012","7:54pm"
$cols = explode(",", $row);
if(count($cols) < 4):
continue;
endif;
$currency_pair = substr($cols[0], 1, 6);
$rate = $cols[1];
$t = trim($cols[2], '" ') . ' ' . trim(trim($cols[3]), '"'); //echo $t;$source_date = new DateTime($t);
$source_date_str = $source_date->format('Y-m-d H:i:s');$values[] = " ('$currency_pair', '$rate', '$source_date_str')";
endforeach;mysql_selectdb('falcon');
$sql .= implode(',', $values); //
echo $sql;
mysql_query($sql);endif;
curl_close($handle);
?>
$url = "http://download.finance.yahoo.com/d/quotes.csv?e=.csv&f=sl1d1t1&s=USDCNY=x";
?>
<?php
$handle = curl_init($url);
curl_setopt($handle, CURLOPT_RETURNTRANSFER, true);
$result = curl_exec($handle);if(curl_errno($handle)):
echo "CURL Error: " . curl_error($handle);
else:
$sql = "insert into forexrates (`currencypair`, `rate`, `source-time`) values ";
$values = array();$rows = explode("\n", $result); //echo print_r($rows); echo print_r($result);
foreach($rows as $row):
//"AUDCNY=X",6.8059,"2/29/2012","7:54pm"
$cols = explode(",", $row);
if(count($cols) < 4):
continue;
endif;
$currency_pair = substr($cols[0], 1, 6);
$rate = $cols[1];
$t = trim($cols[2], '" ') . ' ' . trim(trim($cols[3]), '"'); //echo $t;$source_date = new DateTime($t);
$source_date_str = $source_date->format('Y-m-d H:i:s');$values[] = " ('$currency_pair', '$rate', '$source_date_str')";
endforeach;mysql_selectdb('falcon');
$sql .= implode(',', $values); //
echo $sql;
mysql_query($sql);endif;
curl_close($handle);
?>
2、mysql_selectdb 写错了吧
3、echo $sql; //是什么结果
请问服务器curl怎么弄啊?
sudo apt-get install php5-curl