Fehler beim XML Import

  • Fehler beim XML Import

    Hallo liebes Team,

    ich versuche eine XML Datei in eine Datenbank zu überführen, dabei triff folgendes Phenomän auf, es werden Filme, Schauspieler u.s.w. in die Datenbank übergeben, wenn ein Film nur einen Schauspieler hat, dann wird nur der erste Buchstabe in die Tabelle übernommen und die actorID ist auch falsch.

    Das Resultat des Import sieht so aus:

    Import wird durchgeführt...

    Array ( [0] => Tasha Hunter [1] => Ryan [2] => Alana Evans [3] => Chris Mountain [4] => Elizabeth Lawrence [5] => Ana nova ) Array ( [0] => Tristan [1] => Melissa Milano [2] => Lena Juliette [3] => Paola Rey [4] => Jasmine Byrne [5] => Neveah [6] => Jackie Diaz [7] => Vanessa Figueroa [8] => Paige Taylor [9] => Alexis Love ) Array ( [0] => Peaches [1] => Shorty [2] => Reggie [3] => G-Man [4] => Foxey [5] => Pretty Tony ) Array ( [0] => Ginger Lynn [1] => Viper [2] => Billy Dee [3] => Sharon Mitchell [4] => Marc Wallace [5] => Jerry Butler [6] => Kristara Barrington [7] => Rick Savage [8] => Harry Reems [9] => Greg Rome [10] => Dan T. Mann [11] => Sandy Taylor [12] => Crystal Loving [13] => Danica Rae [14] => Debbie Does [15] => Don Osmand ) Array ( [0] => Tony Cappuci [1] => Jake Cruise ) Array ( [0] => Mark Wood [1] => Lee Bang [2] => Alex Gonz [3] => Kitty Wildwood [4] => Britney Blew [5] => Mimi Allen [6] => C-Lo [7] => Nikki Vee [8] => Jessie Electra ) Array ( [0] => Bunny Bleu [1] => Taija Rae [2] => Honey Wilder [3] => Janey Robbins ) Array ( [0] => Brooke [1] => Alexis May [2] => Keiran Lee [3] => Alysha Tyler [4] => Jez Christ [5] => Simon Girth ) Array ( [0] => Amile Waters [1] => Ms. Platinum [2] => Jordan Skye [3] => Gorgeouz ) Array ( [0] => Tristan [1] => Lindsey Meadows [2] => Kacey Villainess [3] => lielani [4] => Jocelyn Jayden [5] => Priscilla Milan [6] => Italia Christie [7] => Joey Ray [8] => Barry Scott [9] => Derrick Pierce [10] => Johnny Sins [11] => Big Pike ) Array ( [0] => Max Hardcore [1] => Vivian [2] => Candi Cash ) Array ( [0] => Eva [1] => Lucky [2] => Iveta [3] => Erik [4] => Mirek [5] => Jerry Harris [6] => Rado [7] => Hans Strong [8] => Carlo Horky [9] => Idka [10] => Alexa Bold ) Array ( [0] => Nyomi Marcela [1] => Sandra Romain [2] => Harmony [3] => Faith Leon [4] => Cassandra Cruz [5] => Misty Stone [6] => Bree Olson [7] => Erika Vution [8] => Lauren Vaughn ) Array ( [0] => Chayse Evans [1] => Kalee Hunter [2] => Tera Dice [3] => Tara Bentley [4] => Alyssa Hall ) Array ( [0] => Sean Michaels [1] => Lili Marlene [2] => Summer Rose [3] => Paul Thomas [4] => Carol Cummings [5] => Saki [6] => Sabrina Dawn [7] => Dan Mann ) Array ( [0] => Mistress D [1] => Jimmy Broadway ) Array ( [0] => Jill Kelly [1] => Vince Vouyer ) Array ( [0] => Lena [1] => Klava [2] => Jerry Geroshvile [3] => Nina Saley [4] => Ulia Butina [5] => Kalina Sharina [6] => Tonova Taisia ) Array ( [0] => Rene Morgan [1] => Whitney Prescott [2] => Doreen Lazlo ) Array ( [0] => Kalena Rios (TVTS) [1] => Cinthya Maia [2] => Priscila Ferrari [3] => Anytha Cordeiro [4] => Fernanda Alencar ) Array ( [0] => Mistress Jade Indica [1] => Slave Liam [2] => Liam [3] => Jade Indica ) Array ( [0] => Julian [1] => Kandi Peach ) NaomiArray ( [0] => Cindy [1] => Allison Wyte [2] => Rick Masters [3] => Layla Rivera [4] => Summer Luv [5] => Honey B [6] => Katio Kailin ) Array ( [0] => Lynden Johnson [1] => Jaye Milo [2] => Brittany O\'Neil [3] => Angel Bust [4] => Randy Spears [5] => Tom Byron [6] => Mike Horner ) Array ( [0] => Mia Smiles [1] => Mika Tan [2] => Jasmine [3] => Lyla Lei [4] => May [5] => Naomi [6] => Saphire [7] => Dana Vespoli [8] => Tami Lynn [9] => Connie [10] => Carman Sancha [11] => Ayoko [12] => Kyanna Lee [13] => Niya Yu [14] => Luci Thai ) . . .

    An der Stelle, die ich Fett markiert habe tritt der Fehler auf, wie man sieht ist auch kein array erzeugt worden. Zum Import benutze ich folgende Scripts:

    Quellcode

    1. <p> Import wird durchgeführt...<p>
    2. <?php
    3. sleep(1);
    5. ?>
    8. <?php
    9. ini_set("max_execution_time","false");
    10. include 'import1.php';
    12. ?>
    Alles anzeigen


    Quellcode

    1. <?php
    3. set_time_limit(0);
    5. require_once 'simplexml.class.php';
    8. $file = 'http://www.roter-planet.de/import.xml';
    9. $sxml = new simplexml;
    10. $data = $sxml->xml_load_file($file,"array");
    14. include 'dbconnect.php';
    16. $find[] = "<b>";
    17. $replace[] = "ß";
    18. $data = str_replace($find, $replace, $data);
    20. $find[] = "</b>";
    21. $replace[] = "ß";
    22. $data = str_replace($find, $replace, $data);
    24. foreach ($data["dvds"]["dvd"] as $dvd)
    25. {
    26. $videoID = (int)trim($dvd["videoID"]);
    27. $title = trim($dvd["title"]);
    28. $description = trim($dvd["description"]);
    29. $weight = (int)trim($dvd["weight"]);
    30. $studioTitle = trim($dvd["studioTitle"]);
    31. $releaseDate = $dvd["releaseDate"];
    34. $find[550] = " ";
    35. $replace[550] = "-";
    36. $releaseDate = str_replace($find, $replace, $releaseDate);
    38. $find[550] = ":";
    39. $replace[550] = "-";
    40. $releaseDate = str_replace($find, $replace, $releaseDate);
    42. $thumbUncensored = trim($dvd["images"]["thumbUncensored"]);
    43. $coverUncensored = trim($dvd["images"]["coverUncensored"]);
    44. $thumbCensored = trim($dvd["images"]["thumbCensored"]);
    45. $coverCensored = trim($dvd["images"]["coverCensored"]);
    48. $find[] = "%";
    49. $replace[] = " Prozent";
    50. $title = str_replace($find, $replace, $title);
    52. $find[] = "ß";
    53. $replace[] = "ß";
    54. $title = str_replace($find, $replace, $title);
    56. $find[] = "ä";
    57. $replace[] = "ä";
    58. $title = str_replace($find, $replace, $title);
    60. $find[] = "ö";
    61. $replace[] = "ö";
    62. $title = str_replace($find, $replace, $title);
    64. $find[] = "ü";
    65. $replace[] = "ü";
    66. $title = str_replace($find, $replace, $title);
    68. $find[] = "“";
    69. $replace[] = "\"";
    70. $title = str_replace($find, $replace, $title);
    72. $find[] = "”";
    73. $replace[] = "\"";
    74. $title = str_replace($find, $replace, $title);
    76. $find[] = "'";
    77. $replace[] = "";
    78. $title = str_replace($find, $replace, $title);
    80. $find[] = "'";
    81. $replace[] = "";
    82. $description = str_replace($find, $replace, $description);
    84. $find[] = "\'";
    85. $replace[] = "";
    86. $description = str_replace($find, $replace, $description);
    88. $find[] = "\\";
    89. $replace[] = "";
    90. $description = str_replace($find, $replace, $description);
    92. $find[] = "'";
    93. $replace[] = "";
    94. $studioTitle = str_replace($find, $replace, $studioTitle);
    101. $sql = "REPLACE INTO movies (title, videoID, description, studioTitle, releaseDate, thumbUncensored, coverUncensored, thumbCensored, coverCensored) VALUES ('$title', $videoID, '$description', '$studioTitle', '$releaseDate', '$thumbUncensored', '$coverUncensored', '$thumbCensored', '$coverCensored')";
    103. mysql_query($sql) or die(mysql_error());
    105. $newMovieID = mysql_insert_id();
    108. $actorNames = $dvd["actorInformation"]["actorNames"]["actorName"];
    109. $actorIDs = $dvd["actorInformation"]["actorIDs"]["actorID"];
    110. $catNames = $dvd["categoryInformation"]["mainCategoriesGerman"]["mainCategoryGerman"];
    111. $subcatNames = $dvd["categoryInformation"]["subCategoriesGerman"]["subCategoryGerman"];
    112. print_r($actorNames);
    116. for ($i = 0, $c = count($actorNames); $i < $c; $i++)
    118. {
    119. $name = $actorNames[$i];
    120. $externalID = (int)trim($actorIDs[$i]);
    121. $sql = "REPLACE INTO actors (name, actorID, videoID) VALUES ('$name', '$externalID', '$videoID')";
    122. mysql_query($sql) or die(mysql_error());
    125. $newActorID = mysql_insert_id();
    128. $sql = "REPLACE INTO actorsmovies (actorID, movieID) VALUES ('$newActorID','$newMovieID')";
    129. mysql_query($sql) or die(mysql_error());
    131. }
    135. for ($i = 0, $c = count($catNames); $i < $c; $i++)
    136. {
    137. $cat = $catNames[$i];
    138. $sql = "INSERT INTO cat (catName, videoID) VALUES ('$cat', $videoID)";
    139. mysql_query($sql) or die(mysql_error());
    140. //print_r($sql);
    141. $newsubcatID = mysql_insert_id();
    144. $sql = "INSERT INTO catmovies (catID, movieID, videoID) VALUES ($newsubcatID,$newMovieID,$videoID)";
    145. //print_r($sql);
    147. mysql_query($sql) or die(mysql_error());
    148. }
    151. for ($i = 0, $c = count($subcatNames); $i < $c; $i++)
    152. {
    153. $subcat = trim($subcatNames[$i]);
    154. $sql = "INSERT INTO subcat (subcatName, videoID) VALUES ('$subcat', $videoID)";
    155. mysql_query($sql) or die(mysql_error());
    157. $newcatID = mysql_insert_id();
    160. $sql = "INSERT INTO subcatmovies (subcatID, movieID, videoID) VALUES ($newcatID,$newMovieID,$videoID)";
    161. //print_r($sql);
    163. mysql_query($sql) or die(mysql_error());
    164. }
    169. }
    170. echo "IMPORT 1 ERFOLGREICH!<br>";
    171. mysql_close();
    177. ?>
    179. <style type="text/css">
    181. .txt{
    182. font-family:Arial, Helvetica, sans-serif;
    183. font-size:12px;
    184. }
    185. #box{
    186. width:700px;
    187. border:1px solid #000;
    188. padding:10px;
    189. }
    191. </style>
    Alles anzeigen


    . . .fortsetzung im nächsten Post
    Man muss nicht wissen wie es geht, man muss nur wissen wo es steht! Natürlich bei easy-coding 8o de

    Dieser Beitrag wurde bereits 1 mal editiert, zuletzt von kingluui ()

  • und folgende Klasse:

    Quellcode

    1. <?php
    3. /**
    4. * If the result will be an object, this container class is used.
    5. *
    6. */
    8. class SimpleXMLObject{
    9. function attributes(){
    10. $container = get_object_vars($this);
    11. return (object) $container["@attributes"];
    12. }
    13. function content(){
    14. $container = get_object_vars($this);
    15. return (object) $container["@content"];
    16. }
    18. }
    20. /**
    21. * The Main XML Parser Class
    22. *
    23. */
    24. class simplexml {
    25. var $result = array();
    26. var $ignore_level = 0;
    27. var $skip_empty_values = false;
    28. var $php_errormsg;
    29. var $evalCode="";
    31. /**
    32. * Adds Items to Array
    33. *
    34. * @param int $level
    35. * @param array $tags
    36. * @param $value
    37. * @param string $type
    38. */
    39. function array_insert($level, $tags, $value, $type)
    40. {
    41. $temp = '';
    42. for ($c = $this->ignore_level + 1; $c < $level + 1; $c++) {
    43. if (isset($tags[$c]) && (is_numeric(trim($tags[$c])) || trim($tags[$c]))) {
    44. if (is_numeric($tags[$c])) {
    45. $temp .= '[' . $tags[$c] . ']';
    46. } else {
    47. $temp .= '["' . $tags[$c] . '"]';
    48. }
    49. }
    50. }
    51. $this->evalCode .= '$this->result' . $temp . "=\"" . addslashes($value) . "\";//(" . $type . ")\n";
    52. #echo $code. "\n";
    53. }
    55. /**
    56. * Define the repeated tags in XML file so we can set an index
    57. *
    58. * @param array $array
    59. * @return array
    60. */
    61. function xml_tags($array)
    62. { $repeats_temp = array();
    63. $repeats_count = array();
    64. $repeats = array();
    66. if (is_array($array)) {
    67. $n = count($array) - 1;
    68. for ($i = 0; $i < $n; $i++) {
    69. $idn = $array[$i]['tag'].$array[$i]['level'];
    70. if(in_array($idn,$repeats_temp)){
    71. $repeats_count[array_search($idn,$repeats_temp)]+=1;
    72. }else{
    73. array_push($repeats_temp,$idn);
    74. $repeats_count[array_search($idn,$repeats_temp)]=1;
    75. }
    76. }
    77. }
    78. $n = count($repeats_count);
    79. for($i=0;$i<$n;$i++){
    80. if($repeats_count[$i]>1){
    81. array_push($repeats,$repeats_temp[$i]);
    82. }
    83. }
    84. unset($repeats_temp);
    85. unset($repeats_count);
    86. return array_unique($repeats);
    87. }
    90. /**
    91. * Converts Array Variable to Object Variable
    92. *
    93. * @param array $arg_array
    94. * @return $tmp
    95. */
    96. function array2object ($arg_array)
    97. {
    99. if (is_array($arg_array)) {
    100. $keys = array_keys($arg_array);
    101. if(!is_numeric($keys[0])) $tmp = new SimpleXMLObject;
    102. foreach ($keys as $key) {
    103. if (is_numeric($key)) $has_number = true;
    104. if (is_string($key)) $has_string = true;
    105. }
    106. if (isset($has_number) and !isset($has_string)) {
    107. foreach ($arg_array as $key => $value) {
    108. $tmp[] = $this->array2object($value);
    109. }
    110. } elseif (isset($has_string)) {
    111. foreach ($arg_array as $key => $value) {
    112. if (is_string($key))
    113. $tmp->$key = $this->array2object($value);
    114. }
    115. }
    116. } elseif (is_object($arg_array)) {
    117. foreach ($arg_array as $key => $value) {
    118. if (is_array($value) or is_object($value))
    119. $tmp->$key = $this->array2object($value);
    120. else
    121. $tmp->$key = $value;
    122. }
    123. } else {
    124. $tmp = $arg_array;
    125. }
    126. return $tmp; //return the object
    127. }
    129. /**
    130. * Reindexes the whole array with ascending numbers
    131. *
    132. * @param array $array
    133. * @return array
    134. */
    135. function array_reindex($array)
    136. {
    137. if (is_array($array)) {
    138. if(count($array) == 1 && $array[0]){
    139. return $this->array_reindex($array[0]);
    140. }else{
    141. foreach($array as $keys => $items) {
    142. if (is_array($items)) {
    143. if (is_numeric($keys)) {
    144. $array[$keys] = $this->array_reindex($items);
    145. } else {
    146. $array[$keys] = $this->array_reindex(array_merge(array(), $items));
    147. }
    148. }
    149. }
    150. }
    151. }
    153. return $array;
    154. }
    157. /**
    158. * Parse the XML generation to array object
    159. *
    160. * @param array $array
    161. * @return array
    162. */
    163. function xml_reorganize($array)
    164. {
    165. $count = count($array);
    166. $repeat = $this->xml_tags($array);
    167. $repeatedone = false;
    168. $tags = array();
    169. $k = 0;
    170. for ($i = 0; $i < $count; $i++) {
    171. switch ($array[$i]['type']) {
    172. case 'open':
    173. array_push($tags, $array[$i]['tag']);
    174. if ($i > 0 && ($array[$i]['tag'] == $array[$i-1]['tag']) && ($array[$i-1]['type'] == 'close'))
    175. $k++;
    176. if (isset($array[$i]['value']) && ($array[$i]['value'] || !$this->skip_empty_values)) {
    177. array_push($tags, '@content');
    178. $this->array_insert(count($tags), $tags, $array[$i]['value'], "open");
    179. array_pop($tags);
    180. }
    182. if (in_array($array[$i]['tag'] . $array[$i]['level'], $repeat)) {
    183. if (($repeatedone == $array[$i]['tag'] . $array[$i]['level']) && ($repeatedone)) {
    184. array_push($tags, strval($k++));
    185. } else {
    186. $repeatedone = $array[$i]['tag'] . $array[$i]['level'];
    187. array_push($tags, strval($k));
    188. }
    189. }
    191. if (isset($array[$i]['attributes']) && $array[$i]['attributes'] && $array[$i]['level'] != $this->ignore_level) {
    192. array_push($tags, '@attributes');
    193. foreach ($array[$i]['attributes'] as $attrkey => $attr) {
    194. array_push($tags, $attrkey);
    195. $this->array_insert(count($tags), $tags, $attr, "open");
    196. array_pop($tags);
    197. }
    198. array_pop($tags);
    199. }
    200. break;
    202. case 'close':
    203. array_pop($tags);
    204. if (in_array($array[$i]['tag'] . $array[$i]['level'], $repeat)) {
    205. if ($repeatedone == $array[$i]['tag'] . $array[$i]['level']) {
    206. array_pop($tags);
    207. } else {
    208. $repeatedone = $array[$i + 1]['tag'] . $array[$i + 1]['level'];
    209. array_pop($tags);
    210. }
    211. }
    212. break;
    214. case 'complete':
    215. array_push($tags, $array[$i]['tag']);
    216. if (in_array($array[$i]['tag'] . $array[$i]['level'], $repeat)) {
    217. if ($repeatedone == $array[$i]['tag'] . $array[$i]['level'] && $repeatedone) {
    218. array_push($tags, strval($k));
    219. } else {
    220. $repeatedone = $array[$i]['tag'] . $array[$i]['level'];
    221. array_push($tags, strval($k));
    222. }
    223. }
    225. if (isset($array[$i]['value']) && ($array[$i]['value'] || !$this->skip_empty_values)) {
    226. if (isset($array[$i]['attributes']) && $array[$i]['attributes']) {
    227. array_push($tags, '@content');
    228. $this->array_insert(count($tags), $tags, $array[$i]['value'], "complete");
    229. array_pop($tags);
    230. } else {
    231. $this->array_insert(count($tags), $tags, $array[$i]['value'], "complete");
    232. }
    233. }
    235. if (isset($array[$i]['attributes']) && $array[$i]['attributes']) {
    236. array_push($tags, '@attributes');
    237. foreach ($array[$i]['attributes'] as $attrkey => $attr) {
    238. array_push($tags, $attrkey);
    239. $this->array_insert(count($tags), $tags, $attr, "complete");
    240. array_pop($tags);
    241. }
    242. array_pop($tags);
    243. }
    245. if (in_array($array[$i]['tag'] . $array[$i]['level'], $repeat)) {
    246. array_pop($tags);
    247. $k++;
    248. }
    250. array_pop($tags);
    251. break;
    252. }
    253. }
    254. eval($this->evalCode);
    255. $last = $this->array_reindex($this->result);
    256. return $last;
    257. }
    259. /**
    260. * Get the XML contents and parse like SimpleXML
    261. *
    262. * @param string $file
    263. * @param string $resulttype
    264. * @param string $encoding
    265. * @return array/object
    266. */
    267. function xml_load_file($file, $resulttype = 'object', $encoding = 'ISO-8859-1')
    268. {
    269. $php_errormsg="";
    270. $this->result="";
    271. $this->evalCode="";
    272. $values="";
    273. //$data = file_get_contents($file);
    274. $url = $file;
    275. $ch = curl_init();
    276. curl_setopt($ch, CURLOPT_HEADER, 0);
    277. curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    278. curl_setopt($ch, CURLOPT_URL, $url);
    279. $data = curl_exec($ch);
    281. if (!$data)
    282. return 'Cannot open xml document: ' . (isset($php_errormsg) ? $php_errormsg : $file);
    284. $parser = xml_parser_create($encoding);
    285. xml_parser_set_option($parser, XML_OPTION_CASE_FOLDING, 0);
    286. xml_parser_set_option($parser, XML_OPTION_SKIP_WHITE, 1);
    287. $ok = xml_parse_into_struct($parser, $data, $values);
    288. if (!$ok) {
    289. $errmsg = sprintf("XML parse error %d '%s' at line %d, column %d (byte index %d)",
    290. xml_get_error_code($parser),
    291. xml_error_string(xml_get_error_code($parser)),
    292. xml_get_current_line_number($parser),
    293. xml_get_current_column_number($parser),
    294. xml_get_current_byte_index($parser));
    295. }
    297. xml_parser_free($parser);
    298. if (!$ok)
    299. return $errmsg;
    300. if ($resulttype == 'array')
    301. return $this->xml_reorganize($values);
    302. // default $resulttype is 'object'
    303. return $this->array2object($this->xml_reorganize($values));
    304. }
    305. }
    307. ?>
    Alles anzeigen


    warum wird kein ordentliches array() erkannt?

    Kann sich jemand da rein denken, und hat jemand eine Idee?

    LG

    kingluui
    Man muss nicht wissen wie es geht, man muss nur wissen wo es steht! Natürlich bei easy-coding 8o de

  • Hi.
    Installiere dir lieber mal PHP5. 307 Zeilen XML Parser zu Debuggen ist nicht so einfach. Und wer sagt überhaupt, dass das XML Dokument gültig ist.
    Die resultierenden Fehler sind klar, wenn mit Array Funktionen auf einen String zugegriffen wird. (Ein String ist auch nur ein Array von Buchstaben) - aktivier mal error_reporting(E_ALL)