PHP读取xml并写入数据库示例

最新推荐文章于 2021-03-21 17:28:25 发布

weixin_30349597

最新推荐文章于 2021-03-21 17:28:25 发布

阅读量129

点赞数

文章标签： php 数据库

原文链接：http://www.cnblogs.com/connectionworld/p/11076617.html

版权

<?php

$xml = simplexml_load_file('books.xml');
// print_r($xml);
// echo "<br/>";
$t = $xml->to;
$f = $xml->from;
$h = $xml->heading;
$b = $xml->body;

$dsn = "mysql:host=localhost;dbname=demo";
$username = "root";
$password = "00000000";
$conn = new PDO($dsn,$username,$password);
try{
$conn->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);

$stmt = $conn->prepare("insert into xml(t,f,heading,body) values(:t,:f,:h,:b)");
$stmt->bindParam(':t',$t);
$stmt->bindParam(':f',$f);
$stmt->bindParam(':h',$h);
$stmt->bindParam(':b',$b);
$stmt->execute();
echo "success";
}catch(PDOException $e){
echo "Error" . $e->getMessage();
}
$conn = null;

xml文件：

<?xml version="1.0" encoding="UTF-8"?>

<note>

<heading>Reminder</heading>

<body>Don't forget me this weekend!</body>

</note>

转载于:https://www.cnblogs.com/connectionworld/p/11076617.html

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

weixin_30349597

关注关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
PHP读取xml并写入数据库示例

<?php $xml = simplexml_load_file('books.xml'); // print_r($xml); // echo "<br/>"; $t = $xml->to; $f = $xml->from; $h = $xml->heading; $b = $xml->body; $dsn = "mysql:host=localho...
复制链接

扫一扫