Parsing a string, and XML attributes

[spivey]

I have an XML document that goes a little something like this:

<marc_field tag="245" label="Title">
Lies will take you somewhere / Sheila Schwartz.
</marc_field>
<marc_field tag="100" label="Personal Author">
Schwartz, Sheila.
</marc_field>
<marc_field tag="020" label="ISBN">
9780979745065
</marc_field>

I want to insert each of these in a separate database entry.

But first, in the "Title," I need to strip off the "/" and everything to the right of it. I am unsure with string command to use. I am trying substr, but that hasn't helped.

But, how to I select "marc_record" fields by their attributes, since these aren't nested elements?

Here is my rather sad attempt:

$xml=simplexml_load_file('marctest.xml') or die ('error: cannot find file.');
//print_r($xml);


foreach ($xml as $addabook) {
    db_connect();
$result = mysql_query("insert into node (title, type) values (\"$addabook->substr(marc_field->label=\"Title\", "/"'], "/")\", \"addabook\" )");
if (!$result) {
    die('Invalid query: ' . mysql_error());
}

Thanks in advance for any sage advice.

spivey

[CoderDan]

If you can provide a completely formed xml file (even if it only has 2 books in it) I can figure it out for you, but make sure it contains the root tag and has more than 1 'entry'

[spivey]

<?xml version="1.0" encoding="iso-8859-1"?>
<titles><output_catalog_shelflist>
<catalog_year_of_pub><![CDATA[2009]]></catalog_year_of_pub>
<marc primary_key="0|165541871|">
<marc_field tag="245" label="Title">
Lies will take you somewhere / Sheila Schwartz.
</marc_field>
<marc_field tag="100" label="Personal Author">
Schwartz, Sheila.
</marc_field>
<marc_field tag="020" label="ISBN">
9780979745065
</marc_field>
<marc_field tag="020" label="ISBN">
0979745063
</marc_field>
</marc>
</output_catalog_shelflist>
<output_catalog_shelflist>
<catalog_year_of_pub><![CDATA[2009]]></catalog_year_of_pub>
<marc primary_key="0|302054296|">
<marc_field tag="245" label="Title">
Secret son / a novel [by] Laila Lalami.
</marc_field>
<marc_field tag="100" label="Personal Author">
Lalami, Laila, 1968-
</marc_field>
<marc_field tag="020" label="ISBN">
9781565124943
</marc_field>
<marc_field tag="020" label="ISBN">
1565124944
</marc_field>
</marc>
</output_catalog_shelflist>
<output_catalog_shelflist>
<catalog_year_of_pub><![CDATA[2009]]></catalog_year_of_pub>
<marc primary_key="0|299815775|">
<marc_field tag="245" label="Title">
Pride and prejudice and zombies : the classic Regency romance -- now with ultraviolent zombie mayhem! / by Jane Austen and Seth Grahame-Smith.
</marc_field>
<marc_field tag="100" label="Personal Author">
Grahame-Smith, Seth.
</marc_field>
<marc_field tag="020" label="ISBN">
9781594743344 (pbk.)
</marc_field>
<marc_field tag="020" label="ISBN">
1594743347 (pbk.)
</marc_field>
</marc>
</output_catalog_shelflist>
<output_catalog_shelflist>
<catalog_year_of_pub><![CDATA[2001]]></catalog_year_of_pub>
<marc primary_key="0|93569329|">
<marc_field tag="245" label="Title">
Promethea. Book 2 / Alan Moore, writer ; J.H. Williams III, penciller ; Mick Gray, inker.
</marc_field>
<marc_field tag="100" label="Personal Author">
Moore, Alan, 1953-
</marc_field>
<marc_field tag="020" label="ISBN">
1563899574 (pbk.)
</marc_field>
<marc_field tag="020" label="ISBN">
9781563899577 (pbk.)
</marc_field>
<marc_field tag="020" label="ISBN">
1563897849
</marc_field>
<marc_field tag="020" label="ISBN">
9781563897849
</marc_field>
</marc>
</output_catalog_shelflist>
<output_catalog_shelflist>
<catalog_year_of_pub><![CDATA[2006]]></catalog_year_of_pub>
<marc primary_key="0|279890046|">
<marc_field tag="245" label="Title">
The walking dead . Volume 5, The best defense / [creator, writer, Robert Kirkman ; penciler, inker, Charlie Adlard ; gray tones, Cliff Rathburn ; letterer Rus Wooten].
</marc_field>
<marc_field tag="100" label="Personal Author">
Kirkman, Robert.
</marc_field>
<marc_field tag="020" label="ISBN">
158240612X (pbk.)
</marc_field>
<marc_field tag="020" label="ISBN">
9781582406121 (pbk.)
</marc_field>
</marc>
</output_catalog_shelflist>
</titles>
[\CODE]

Thanks!

spivey

[CoderDan]

well, there are more elegant solutions using xpath, however this should do teh trick for you: (and yeah, I know I could make this code about half teh size, and should have error checking instead of assuming it's getting the right xml, etc, but i spread it out a lil for clarity, and left error checking to the spivey 🙂)

<?php
$xml=simplexml_load_file('marctest.xml') or die ('error: cannot find file.'); 
foreach ( $xml->output_catalog_shelflist as $entry )
{
	$target_string = $entry->marc->marc_field[0];
	$slashpos = strpos( $target_string, '/' );
	if ( $slashpos !== false )
	{
		$string = substr( $target_string, 0, $slashpos );
	}
	else
	{
		$string = $target_string;
	}
	$query = "INSERT INTO node (title, type) VALUES ( '".mysql_escape_string( $string )."', 'addabook' )";
	// etc
}
?>

[spivey]

Thanks for the code.

I think I even understand how it works!😃

But I get this error message:
Invalid query: Duplicate entry '0' for key 2

The table that this is being inserted into has an "nid" table that is autoincrement. Is that the problem?

Thanks

spivey

[CoderDan]

well duplicate entry for a key means you have a unique field that is getting the same value - this is most commen when you forget to add autoincrement flag to a primary key, but sounds like you have a second unique field that doesn't autoincrement and that you aren't providing a unique value for.

[spivey]

I'm inserting this into a Drupal database, and there is a "vid" table (node revision) that cannot accept null values. So, I have to figure out how to generate the right "vid" to insert into the database at the same time as the "nid" is created. Maybe query to get the last vid and add one to it? Worth a shot.

thanks for your help.

spivey