我正在尝试将XML数据导入MySQL数据库,但我不知道如何做到这一点。我正在使用 Linux 主机和 goaddy 的 cPanel 和 php 5.4。此脚本来自教程,但即使在填写了必要的 MySQL 登录信息后,也会导致空白页,并且不会将任何信息添加到数据库表中。我做错了什么?
<?php
$url ="XML.php";
$ch = curl_init();
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_URL, $url);
$data = curl_exec ($ch);
curl_close($ch);
$xml = simplexml_load_string($data);
$con=mysql_connect("localhost","dbusername","dbpassword");
mysql_select_db("dbname", $con) or die(mysql_error());
foreach ($xml -> item as $row) {
$title = $row -> title;
$description = $row -> description;
$categories = $row -> categories;
$sql = "INSERT INTO 'test_xml' ('title', 'description', 'categories')"
. "VALUES ('$title', '$description', '$categories')";
$result = mysql_query($sql);
if (!$result) {
echo 'MySQL ERROR';
} else {
echo ' SUCCES';
}
?>
要解决此问题,请按如下方式更改您的语句
取代
$sql = "INSERT INTO 'test_xml' ('title', 'description', 'categories')"
. "VALUES ('$title', '$description', '$categories')";
跟
$sql = "INSERT INTO 'test_xml' ('title', 'description', 'categories')"
. "VALUES ('".$title."', '".$description."', '".$categories."')";