drg14799 2012-05-14 17:57
浏览 42
已采纳

使用php从xml获取的yql查询数据覆盖其他金融股票代码的值

This is the script i used to grab data from the yahoo finance stock quotes . but i am facing problem here.. and cant find solution from the answers i get. The PHP script is ...

<?php
session_start();

$yql_base_url = "http://query.yahooapis.com/v1/public/yql";  
$yql_query = "select * from yahoo.finance.quotes where symbol in ('XAUUSD=X','XAGUSD=X','PLN12.NYM','PAK12.NYM','USDCAD=X')";  
$yql_query_url = $yql_base_url . "?q=" . urlencode($yql_query);
$yql_query_url .= "&env=http://datatables.org/alltables.env";
$yql_query_url .= "&format=json";
$session = curl_init($yql_query_url);  
curl_setopt($session, CURLOPT_RETURNTRANSFER,true);      
$json = curl_exec($session);
$phpObj =  json_decode($json);  
if(!is_null($phpObj->query->results)){  
}  
if(!is_null($phpObj->query->results)){  
    foreach($phpObj->query->results->quote as $quotes){  
        $_SESSION['Ask'] = $quotes->Ask;
        $_SESSION['Bid'] = $quotes->Bid;
        $_SESSION['AskRealtime'] = $quotes->AskRealtime;
        $_SESSION['BidRealtime'] = $quotes->BidRealtime;
        $_SESSION['LastTradeDate'] = $quotes->LastTradeDate;
        $_SESSION['LastTradePriceOnly'] = $quotes->LastTradePriceOnly;
        $_SESSION['LastTradeTime'] = $quotes->LastTradeTime;
  }  
}  
?>

And the Display part or body part where i print the session is ...

    <body>
    <div>
    <ul>
    <li>Gold Price</li>
    <li><?php echo $_SESSION['Ask'];?></li>
    <li><?php echo $_SESSION['Bid'];?></li>
    <li><?php echo $_SESSION['AskRealtime'];?></li>
    <li><?php echo $_SESSION['BidRealtime'];?></li>
    <li><?php echo $_SESSION['LastTradeDate'];?></li>
    <li><?php echo $_SESSION['LastTradePriceOnly'];?></li>
    <li><?php echo $_SESSION['LastTradeTime'];?></li>
    </ul>
    <ul>
    <li>Silver Price</li>
    <li><?php echo $_SESSION['Ask_2'];?></li>
    <li><?php echo $_SESSION['Bid_2'];?></li>
    <li><?php echo $_SESSION['AskRealtime_2'];?></li>
    <li><?php echo $_SESSION['BidRealtime_2'];?></li>
    <li><?php echo $_SESSION['LastTradeDate_2'];?></li>
    <li><?php echo $_SESSION['LastTradePriceOnly_2'];?></li>
    <li><?php echo $_SESSION['LastTradeTime_2'];?></li>
    </ul>
    <ul>
    <li>Platinum Price</li>
    <li><?php echo $_SESSION['Ask_3'];?></li>
    <li><?php echo $_SESSION['Bid_3'];?></li>
    <li><?php echo $_SESSION['AskRealtime_3'];?></li>
    <li><?php echo $_SESSION['BidRealtime_3'];?></li>
    <li><?php echo $_SESSION['LastTradeDate_3'];?></li>
    <li><?php echo $_SESSION['LastTradePriceOnly_3'];?></li>
    <li><?php echo $_SESSION['LastTradeTime_3'];?></li>
    </ul>
    <ul>
    <li>Palladium Price</li>
    <li><?php echo $_SESSION['Ask_3'];?></li>
    <li><?php echo $_SESSION['Bid_3'];?></li>
    <li><?php echo $_SESSION['AskRealtime_3'];?></li>
    <li><?php echo $_SESSION['BidRealtime_3'];?></li>
    <li><?php echo $_SESSION['LastTradeDate_3'];?></li>
    <li><?php echo $_SESSION['LastTradePriceOnly_3'];?></li>
    <li><?php echo $_SESSION['LastTradeTime_3'];?></li>
    </ul>
    <ul>
    <li>USD to CAD</li>
    <li><?php echo $_SESSION['Ask_3'];?></li>
    <li><?php echo $_SESSION['Bid_3'];?></li>
    <li><?php echo $_SESSION['AskRealtime_3'];?></li>
    <li><?php echo $_SESSION['BidRealtime_3'];?></li>
    <li><?php echo $_SESSION['LastTradeDate_3'];?></li>
    <li><?php echo $_SESSION['LastTradePriceOnly_3'];?></li>
    <li><?php echo $_SESSION['LastTradeTime_3'];?></li>
    </ul>
    </div>
    </body>

But the result i get from above is ..
1.0015
1.0005
5/11/2012
1.001 5:55pm

which is only the session output of 'USDCAD=X' of the $yql_query = "select * from ...'PLN12.NYM','PAK12.NYM','USDCAD=X')";

The Query is ..

$yql_query = "select * from yahoo.finance.quotes where symbol in ('XAUUSD=X','XAGUSD=X','PLN12.NYM','PAK12.NYM','USDCAD=X')";

And the XML output for yahoo finance quote from yahoo website is.

<query yahoo:count="5" yahoo:created="2012-05-12T22:01:43Z" yahoo:lang="en-US">
<diagnostics>
  <publiclyCallable>true</publiclyCallable>
  <redirect from="http://datatables.org/alltables.env" status="301">http://www.datatables.org/alltables.env</redirect>
  <url execution-start-time="417" execution-stop-time="775" execution-time="358" proxy="DEFAULT">http://datatables.org/alltables.env</url>
  <url execution-start-time="826" execution-stop-time="1040" execution-time="214" proxy="DEFAULT">http://www.datatables.org/yahoo/finance/yahoo.finance.quotes.xml</url>
  <url execution-start-time="1247" execution-stop-time="1261" execution-time="14" proxy="DEFAULT">http://download.finance.yahoo.com/d/quotes.csv?f=aa2bb2b3b4cc1c3c6c8dd1d2ee1e7e8e9ghjkg1g3g4g5g6ii5j1j3j4j5j6k1k2k4k5ll1l2l3mm2m3m4m5m6m7m8nn4opp1p2p5p6qrr1r2r5r6r7ss1s7t1t7t8vv1v7ww1w4xy&s=XAUUSD%3DX,XAGUSD%3DX,PLN12.NYM,PAK12.NYM,USDCAD%3DX</url>
  <query execution-start-time="1045" execution-stop-time="1261" execution-time="216" params="{url=[http://download.finance.yahoo.com/d/quotes.csv?f=aa2bb2b3b4cc1c3c6c8dd1d2ee1e7e8e9ghjkg1g3g4g5g6ii5j1j3j4j5j6k1k2k4k5ll1l2l3mm2m3m4m5m6m7m8nn4opp1p2p5p6qrr1r2r5r6r7ss1s7t1t7t8vv1v7ww1w4xy&s=XAUUSD%3DX,XAGUSD%3DX,PLN12.NYM,PAK12.NYM,USDCAD%3DX]}">select * from csv where url=@url and columns='Ask,AverageDailyVolume,Bid,AskRealtime,BidRealtime,BookValue,Change&PercentChange,Change,Commission,ChangeRealtime,AfterHoursChangeRealtime,DividendShare,LastTradeDate,TradeDate,EarningsShare,ErrorIndicationreturnedforsymbolchangedinvalid,EPSEstimateCurrentYear,EPSEstimateNextYear,EPSEstimateNextQuarter,DaysLow,DaysHigh,YearLow,YearHigh,HoldingsGainPercent,AnnualizedGain,HoldingsGain,HoldingsGainPercentRealtime,HoldingsGainRealtime,MoreInfo,OrderBookRealtime,MarketCapitalization,MarketCapRealtime,EBITDA,ChangeFromYearLow,PercentChangeFromYearLow,LastTradeRealtimeWithTime,ChangePercentRealtime,ChangeFromYearHigh,PercebtChangeFromYearHigh,LastTradeWithTime,LastTradePriceOnly,HighLimit,LowLimit,DaysRange,DaysRangeRealtime,FiftydayMovingAverage,TwoHundreddayMovingAverage,ChangeFromTwoHundreddayMovingAverage,PercentChangeFromTwoHundreddayMovingAverage,ChangeFromFiftydayMovingAverage,PercentChangeFromFiftydayMovingAverage,Name,Notes,Open,PreviousClose,PricePaid,ChangeinPercent,PriceSales,PriceBook,ExDividendDate,PERatio,DividendPayDate,PERatioRealtime,PEGRatio,PriceEPSEstimateCurrentYear,PriceEPSEstimateNextYear,Symbol,SharesOwned,ShortRatio,LastTradeTime,TickerTrend,OneyrTargetPrice,Volume,HoldingsValue,HoldingsValueRealtime,YearRange,DaysValueChange,DaysValueChangeRealtime,StockExchange,DividendYield'</query>
  <javascript execution-time="279" instructions-used="302744" table-name="yahoo.finance.quotes"/>
  <warning>Unable to sort response according to field 'Ask,Bid,AskRealtime,BidRealtime,LastTradeDate,LastTradePriceOnly,LastTradeTime'.</warning>
  <user-time>1326</user-time>
  <service-time>586</service-time>
  <build-version>27222</build-version>
</diagnostics>
<results>
<quote symbol="XAUUSD=X">
  <Bid>1585.30</Bid>
  <AskRealtime/>
  <BidRealtime/>
  <LastTradeDate>5/11/2012</LastTradeDate>
  <LastTradePriceOnly>1580.3002</LastTradePriceOnly>
  <LastTradeTime>5:15pm</LastTradeTime>
  <Ask>1575.30</Ask>
</quote>
<quote symbol="XAGUSD=X">
  <Bid/>
  <AskRealtime/>
  <BidRealtime/>
  <LastTradeDate>5/11/2012</LastTradeDate>
  <LastTradePriceOnly>28.858</LastTradePriceOnly>
  <LastTradeTime>5:39pm</LastTradeTime>
  <Ask/>
</quote>
<quote symbol="PLN12.NYM">
  <Bid/>
  <AskRealtime>1478.60</AskRealtime>
  <BidRealtime>1462.90</BidRealtime>
  <LastTradeDate>5/11/2012</LastTradeDate>
  <LastTradePriceOnly>1465.30</LastTradePriceOnly>
  <LastTradeTime>5:02pm</LastTradeTime>
  <Ask/>
</quote>
<quote symbol="PAK12.NYM">
  <Bid/>
  <AskRealtime>0.00</AskRealtime>
  <BidRealtime>0.00</BidRealtime>
  <LastTradeDate>3/23/2012</LastTradeDate>
  <LastTradePriceOnly>658.80</LastTradePriceOnly>
  <LastTradeTime>7:12am</LastTradeTime>
  <Ask/>
</quote>
<quote symbol="USDCAD=X">
  <Bid>1.0005</Bid>
  <AskRealtime/>
  <BidRealtime/>
  <LastTradeDate>5/11/2012</LastTradeDate>
  <LastTradePriceOnly>1.001</LastTradePriceOnly>
  <LastTradeTime>5:55pm</LastTradeTime>
  <Ask>1.0015</Ask>
</quote>

For a clear view of XML Click Here

I want to extract all the Ask Prices, Bid prices , ... and so on on the specified div.

Suggestions please

  • 写回答

2条回答 默认 最新

  • dtr87341 2012-05-14 18:25
    关注

    You're not storing the data properly. You want to print out $_SESSION['Ask_2'] but it is never set! Instead in the loop you keep overwriting $_SESSION['Ask'] - what you might want to do is get the quote symbol, then store your data in $_SESSION[$symbol]['Ask'].

    In fact I would suggest using another array to compile the data, then set a single session variable with that array in it, instead of updating the session variable continually.

    You want to have a loop like this:

    foreach($phpObj->query->results->quote as $quote){  
    $mydata[$quote->Symbol]['Ask'] = $quote->Ask;

    Then when you display the results, display from foreach ($mydata as $quote) rather than $_SESSION. Finally you can just say $_SESSION['quotedata'] = $mydata if you want to store everything in the session.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题？

悬赏问题

  • ¥15 C#算法问题, 不知道怎么处理这个数据的转换
  • ¥15 YoloV5 第三方库的版本对照问题
  • ¥15 请完成下列相关问题！
  • ¥15 drone 推送镜像时候 purge: true 推送完毕后没有删除对应的镜像,手动拷贝到服务器执行结果正确在样才能让指令自动执行成功删除对应镜像，如何解决？
  • ¥15 求daily translation（DT）偏差订正方法的代码
  • ¥15 js调用html页面需要隐藏某个按钮
  • ¥15 ads仿真结果在圆图上是怎么读数的
  • ¥20 Cotex M3的调试和程序执行方式是什么样的？
  • ¥20 java项目连接sqlserver时报ssl相关错误
  • ¥15 一道python难题3