这种XML数据我想PHP写入MYSQL数据库,怎么写?

WBOY
Release: 2016-06-23 14:26:53
Original
1146 people have browsed it

http://vol.stock.hexun.com/charts/Close/Share/Info_3.ashx?code=600111


回复讨论(解决方案)

你想按什么样式写入

simxml 数据读出来后 写入数据库

每一行Item的数据都要写入MYSQL,我刚学PHP,望老师给个代码,谢谢!

$con=file_get_contents("http://vol.stock.hexun.com/charts/Close/Share/Info_3.ashx?code=600111");$xml = simplexml_load_string($con);  foreach($xml->Item as $v){     $arr=(array)$v->attributes();   $ar[]=$arr['@attributes'];  }print_r($ar);   //形成一个二维数组。插入库应该难不倒你了吧!
Copy after login

PHP code
$con=file_get_contents("http://vol.stock.hexun.com/charts/Close/Share/Info_3.ashx?code=600111");
$xml = simplexml_load_string($con); 
 foreach($xml->Item as $v){ 
    $arr=(array)$v->attr……


我改了一下,用CURL会更加稳定,非常谢谢你。

[Quote=引用 4 楼  的回复:]
PHP code
$con=file_get_contents("http://vol.stock.hexun.com/charts/Close/Share/Info_3.ashx?code=600111");
$xml = simplexml_load_string($con); 
 foreach($xml->Item as $v){ 
    $arr=(array)$v->attr……


我改了一下,用CURL会更加稳定,非常谢谢你。能否给个代码

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template