我要找的是一个服务或脚本,它每x分钟从url中提取xml一次,将数据保存到mysql数据库,然后用户就可以搜索一个项目,并显示该项目的历史价格数据。
这是1项的xml外观:
<?xml version="1.0" encoding="UTF-8"?>
<Success>
<Result>
<AccId>2075</AccId>
<Type>2793</Type>
<Price>100</Price>
<SaleId>211557</SaleId>
<Time>636662891054273275</Time>
<Hours>47</Hours>
</Result>
<Result>
<AccId>7911</AccId>
<Type>2793</Type>
<Price>100</Price>
<SaleId>198528</SaleId>
<Time>636662291658957640</Time>
<Hours>31</Hours>
</Result>
<Result>
<AccId>8839</AccId>
<Type>2793</Type>
<Price>110</Price>
<SaleId>203789</SaleId>
<Time>636662477761119929</Time>
<Hours>36</Hours>
</Result>
<Result>
<AccId>9897</AccId>
<Type>2793</Type>
<Price>120</Price>
<SaleId>211261</SaleId>
<Time>636662870212977640</Time>
<Hours>47</Hours>
</Result>
<Result>
<AccId>9897</AccId>
<Type>2793</Type>
<Price>120</Price>
<SaleId>211445</SaleId>
<Time>636662885517249200</Time>
<Hours>47</Hours>
</Result>
<Result>
<AccId>9897</AccId>
<Type>2793</Type>
<Price>120</Price>
<SaleId>211396</SaleId>
<Time>636662880277082389</Time>
<Hours>47</Hours>
</Result>
<Result>
<AccId>9897</AccId>
<Type>2793</Type>
<Price>120</Price>
<SaleId>211399</SaleId>
<Time>636662880277106287</Time>
<Hours>47</Hours>
</Result>
<Result>
<AccId>9897</AccId>
<Type>2793</Type>
<Price>120</Price>
<SaleId>211259</SaleId>
<Time>636662870086140573</Time>
<Hours>47</Hours>
</Result>
<Result>
<AccId>9897</AccId>
<Type>2793</Type>
<Price>120</Price>
<SaleId>211400</SaleId>
<Time>636662880279095669</Time>
<Hours>47</Hours>
</Result>
<Result>
<AccId>9897</AccId>
<Type>2793</Type>
<Price>120</Price>
<SaleId>211257</SaleId>
<Time>636662870086133672</Time>
<Hours>47</Hours>
</Result>
<Result>
<AccId>9897</AccId>
<Type>2793</Type>
<Price>120</Price>
<SaleId>211256</SaleId>
<Time>636662870086130216</Time>
<Hours>47</Hours>
</Result>
<Result>
<AccId>9897</AccId>
<Type>2793</Type>
<Price>120</Price>
<SaleId>211388</SaleId>
<Time>636662879775606621</Time>
<Hours>47</Hours>
</Result>
<Result>
<AccId>9897</AccId>
<Type>2793</Type>
<Price>120</Price>
<SaleId>211389</SaleId>
<Time>636662879775618280</Time>
<Hours>47</Hours>
</Result>
<Result>
<AccId>8839</AccId>
<Type>2793</Type>
<Price>120</Price>
<SaleId>189990</SaleId>
<Time>636661845264224374</Time>
<Hours>18</Hours>
</Result>
<Result>
<AccId>1570</AccId>
<Type>2793</Type>
<Price>120</Price>
<SaleId>185279</SaleId>
<Time>636661608303483850</Time>
<Hours>12</Hours>
</Result>
<Result>
<AccId>6144</AccId>
<Type>2793</Type>
<Price>120</Price>
<SaleId>193953</SaleId>
<Time>636662075376965802</Time>
<Hours>25</Hours>
</Result>
<Result>
<AccId>6867</AccId>
<Type>2793</Type>
<Price>120</Price>
<SaleId>210396</SaleId>
<Time>636662809913772219</Time>
<Hours>45</Hours>
</Result>
<Result>
<AccId>10091</AccId>
<Type>2793</Type>
<Price>150</Price>
<SaleId>209347</SaleId>
<Time>636662744031038414</Time>
<Hours>43</Hours>
</Result>
<Result>
<AccId>9326</AccId>
<Type>2793</Type>
<Price>150</Price>
<SaleId>192933</SaleId>
<Time>636662020656105309</Time>
<Hours>23</Hours>
</Result>
<Result>
<AccId>9326</AccId>
<Type>2793</Type>
<Price>150</Price>
<SaleId>192934</SaleId>
<Time>636662020656108191</Time>
<Hours>23</Hours>
</Result>
<Result>
<AccId>5979</AccId>
<Type>2793</Type>
<Price>150</Price>
<SaleId>190952</SaleId>
<Time>636661905157273715</Time>
<Hours>20</Hours>
</Result>
<TotalAuctions>4114</TotalAuctions>
</Success>
我需要它来计算所有数据的高,低和平均值,并将其添加到数据库和图表将基于历史
暂无答案!
目前还没有任何答案,快来回答吧!