Hamed
May 1st, 2007, 13:25
Hi all I code php that can import XML file to DB
xml.php
<?php
echo "<center>HamedOnLine</center><br />";
//connect to DB
mysql_connect("localhost", "root", "") or die(mysql_error());
echo "Connected to MySQL<br />";
mysql_select_db("mf") or die(mysql_error());
echo "Connected to Database";
//Theme
//Zaher1988
$file = "./theme.xml";
$data_array = array();
$data_index = "";
$data_array_counter = 0;
function startTree($parser, $name, $attrs)
{
global $data_array, $data_array_counter, $data_index;
switch($name)
{
case "TEMPLATE":
case "TEMPLATES":
$data_index = "";
break;
default:
$data_index = $name;
$data_array[$data_array_counter][$data_index] = "";
break;
}
}
function endTree($parser, $name)
{
global $data_array, $data_index, $data_array_counter;
switch($name)
{
case "TEMPLATE":
$data_array_counter++;
break;
}
$data_index = "";
}
function actualData($parser, $data)
{
global $data_array, $data_array_counter, $data_index;
if ($data_index != "")
{
$data_array[$data_array_counter][$data_index] .= trim($data);
}
}
$xml_parser = xml_parser_create();
xml_set_element_handler($xml_parser, "startTree", "endTree");
xml_set_character_data_handler($xml_parser, "actualData");
if (!($fp = fopen($file, "r")))
{
die("could not open XML.");
}
while ($data = fread($fp, 4096))
{
if (!xml_parse($xml_parser, $data, feof($fp)))
{
die(sprintf("XML error: %s at line %d", xml_error_string(xml_get_error_code($xml_parser)), xml_get_current_line_number($xml_parser)));
}
}
xml_parser_free($xml_parser);
for($i = 0;$i < count($data_array);$i++)
{
$sid = -2;
$time = time();
mysql_db_query("INSERT INTO `mybb_templates` ( `tid` , `title` , `template` , `sid` , `version` , `status` , `dateline` ) VALUES ('1', '2', '3', '4', '5', '6', '7')");
}
?>
and this is my XML file
<?xml version="1.0" encoding="ISO-8859-1"?>
<templates>
<template>
<name>something</name>
<codes><![CDATA[<div>hello</div>]]></codes>
<version>version</version>
</template>
<template>
<name>something</name>
<codes><![CDATA[<div>hello</div>]]></codes>
<version>version</version>
</template>
</templates>
who can help me about it??
this is my DB sql
CREATE TABLE `mybb_templates` (
`tid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(120) collate latin1_general_ci NOT NULL default '',
`template` text collate latin1_general_ci NOT NULL,
`sid` int(10) NOT NULL default '0',
`version` varchar(20) collate latin1_general_ci NOT NULL default '0',
`status` varchar(10) collate latin1_general_ci NOT NULL default '',
`dateline` int(10) NOT NULL default '0',
PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;
xml.php
<?php
echo "<center>HamedOnLine</center><br />";
//connect to DB
mysql_connect("localhost", "root", "") or die(mysql_error());
echo "Connected to MySQL<br />";
mysql_select_db("mf") or die(mysql_error());
echo "Connected to Database";
//Theme
//Zaher1988
$file = "./theme.xml";
$data_array = array();
$data_index = "";
$data_array_counter = 0;
function startTree($parser, $name, $attrs)
{
global $data_array, $data_array_counter, $data_index;
switch($name)
{
case "TEMPLATE":
case "TEMPLATES":
$data_index = "";
break;
default:
$data_index = $name;
$data_array[$data_array_counter][$data_index] = "";
break;
}
}
function endTree($parser, $name)
{
global $data_array, $data_index, $data_array_counter;
switch($name)
{
case "TEMPLATE":
$data_array_counter++;
break;
}
$data_index = "";
}
function actualData($parser, $data)
{
global $data_array, $data_array_counter, $data_index;
if ($data_index != "")
{
$data_array[$data_array_counter][$data_index] .= trim($data);
}
}
$xml_parser = xml_parser_create();
xml_set_element_handler($xml_parser, "startTree", "endTree");
xml_set_character_data_handler($xml_parser, "actualData");
if (!($fp = fopen($file, "r")))
{
die("could not open XML.");
}
while ($data = fread($fp, 4096))
{
if (!xml_parse($xml_parser, $data, feof($fp)))
{
die(sprintf("XML error: %s at line %d", xml_error_string(xml_get_error_code($xml_parser)), xml_get_current_line_number($xml_parser)));
}
}
xml_parser_free($xml_parser);
for($i = 0;$i < count($data_array);$i++)
{
$sid = -2;
$time = time();
mysql_db_query("INSERT INTO `mybb_templates` ( `tid` , `title` , `template` , `sid` , `version` , `status` , `dateline` ) VALUES ('1', '2', '3', '4', '5', '6', '7')");
}
?>
and this is my XML file
<?xml version="1.0" encoding="ISO-8859-1"?>
<templates>
<template>
<name>something</name>
<codes><![CDATA[<div>hello</div>]]></codes>
<version>version</version>
</template>
<template>
<name>something</name>
<codes><![CDATA[<div>hello</div>]]></codes>
<version>version</version>
</template>
</templates>
who can help me about it??
this is my DB sql
CREATE TABLE `mybb_templates` (
`tid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(120) collate latin1_general_ci NOT NULL default '',
`template` text collate latin1_general_ci NOT NULL,
`sid` int(10) NOT NULL default '0',
`version` varchar(20) collate latin1_general_ci NOT NULL default '0',
`status` varchar(10) collate latin1_general_ci NOT NULL default '',
`dateline` int(10) NOT NULL default '0',
PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;