• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 276
  • Last Modified:

How to import data into the following tables using php

I have attached two files. One is an sql file which creates a database and the other is a php file which imports some xml data into the database. However, I am having some trouble.

Can anyone help create a script for importing the data into the following tables
tblContributors
linkContributor_Products
tblProfessionalAffiliation
tblPA_Contributors

Not to sure about the design for the above mentioned tables. If not correctly designed could you also suggest how they should be designed?  
createdb.sql
imp.php
0
Honya
Asked:
Honya
  • 3
1 Solution
 
Ray PaseurCommented:
You probably want to hire a professional programmer or two to help with this.  A data base administrator could give you good advice about the table structure.  And a PHP developer could write the import script - it's not rocket science, but it is tedious, detailed, time-consuming work that really should be paid.

Some of the things in the imp script do not make sense.  See lines 1120 and 1130.  The script creates an empty array in $coa, then merges the empty array with another array.  There are no other instances of $coa in the code.  When I see programming that does this sort of thing, that's a sure sign that you would get a lot of value from hiring a pro to help.

Best of luck with the project, ~Ray
0
 
ropennerCommented:
running the code as presented leaves
    linkContributor_Products
    tblPA_Contributors
    tblProfessionalAffiliation


empty but the rest of the tables are filled.

What data should be in these tables when the data is inserted?

One cannot assume how you want the XML mapped to the database fields and be assured of accuracy.
Please give a spreadsheet view of the data that looks something like the tables that are already filled and that corresponds to your sample XML file.    
Screenshot-30.png
0
 
HonyaAuthor Commented:
I hope that the following information is sufficient.
If you need further clarification please do not hesitate to contact me.
Tbls-to-be-populated.xls
0
 
HonyaAuthor Commented:
I found the answer elsewhere
<?php  

error_reporting(E_ALL);
echo "<pre>" . PHP_EOL;

// TEST DATA FROM THE POST AT EE
$xml = <<<EOXML
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE ONIXMessage SYSTEM "http://www.editeur.org/onix/2.1/03/reference/onix-international.dtd">
<ONIXMessage>
    <Header>
		<FromCompany>Elsevier Science and Technology</FromCompany>
		<FromPerson>Jim Darwin, 612-698-6123</FromPerson>
		<SentDate>20100219</SentDate>
		<DefaultCurrencyCode>USD</DefaultCurrencyCode>
	</Header>
	<Product>
		<RecordReference>1093123:10880222</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9780123814128</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9780123814128</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>DH</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>Student Solutions Manual, Partial Differential Equations &amp; Boundary Value Problems with Maple</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>George A.</NamesBeforeKey>
			<KeyNames>Articolo</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>Rutgers University, New Brunswick, NJ, USA</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<BASICMainSubject>COM023000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>13</TextTypeCode>
			<Text>Dr. George A. Articolo has 35 years of teaching experience in physics and applied mathematics at Rutgers University, and has been a consultant for several government research laboratories and aerospace corporations. He has a Ph.D. in mathematical physics with degrees from Temple University and Rensselaer Polytechnic Institute.&lt;p&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>5</NameCodeValue>
			<ImprintName>Academic Press</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20090801</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2009</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780123747327</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>20</ProductAvailability>
			<ExpectedShipDate>20090822</ExpectedShipDate>
			<PackQuantity>16</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>61</DiscountCode>
				</DiscountCoded>
				<PriceAmount>9.99</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>1057584:10579551</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781856178433</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781856178433</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>BC</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>Working Guide to Drilling Equipment and Operations</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>Williams</NamesBeforeKey>
			<KeyNames>Lyons</KeyNames>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<IllustrationsNote>Approx. 224 illustrations</IllustrationsNote>
		<BASICMainSubject>SCI024000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>&lt;p&gt;Drilling technology has evolved in order to get at the increasingly harder to find oil, and in a more environmentally friendly way. Successful drilling operations require blending many technologies. Drilling equipment and procedures have a unique language that must be conquered in order to understand drilling operations. &lt;/p&gt;&lt;br&gt;&lt;p&gt;Working Guide to Drilling Equipment and Operations provides a fundamental, basic knowledge of the intricacies of drilling fluid, drilled solids management, drill bits, drill string design, directional drilling, cementing, casing, hydraulic optimization, and a discussion of predominant problems such as stuck pipe and lost circulation. Background information, such as: clay structure (needed to understand well bore instability and drilling fluids), discussion of pressure and pressure effects, the theory behind factors affecting drilling performance, and rock failure under pressure, are included to enhance the understanding of the drilling process and problems. &lt;/p&gt;
                                    &lt;br&gt;&lt;br&gt;&lt;ul&gt;&lt;br&gt;&lt;li&gt;Drilling and Production Hoisting Equipment&lt;/li&gt;&lt;br&gt;&lt;li&gt;Hoisting Tool Inspection and Maintenance Procedures&lt;/li&gt;&lt;br&gt;&lt;li&gt;Pump Performance Charts&lt;/li&gt;&lt;br&gt;&lt;li&gt;Rotary Table and Bushings&lt;/li&gt;&lt;br&gt;&lt;li&gt;Rig Maintenance of Drill Collars&lt;/li&gt;&lt;br&gt;&lt;li&gt;Drilling Bits and Downhole Tools&lt;/li&gt;&lt;br&gt;&lt;p&gt;&lt;/p&gt;&lt;/ul&gt;</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>&lt;p&gt;Chapter 1 Drilling Mud and Completion Systems &lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 2 Drilling String: Composition and Design&lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 3 Air and Gas Drilling &lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 4 Directional Drilling &lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 5 Selection of Drilling Practies &lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 6 Well Pressure Control&lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 7 Fishing Operations and Equipment&lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 8 Casing and Casing String Design&lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 9 Well Cementing &lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 10 Tubing and Tubing String Design&lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 11 Environmental Considerations&lt;/p&gt;</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>18</TextTypeCode>
			<Text>&lt;p&gt;Drilling technology has evolved in order to get at the increasingly harder to find oil, and in a more environmentally friendly way. Successful drilling operations require blending many technologies. Drilling equipment and procedures have a unique language that must be conquered in order to understand drilling operations. &lt;/p&gt;&lt;br&gt;&lt;p&gt;&lt;/p&gt;&lt;br&gt;&lt;p&gt;Working Guide to Drilling Equipment and Operations provides a fundamental, basic knowledge of the intricacies of drilling fluid, drilled solids management, drill bits, drill string design, directional drilling, cementing, casing, hydraulic optimization, and a discussion of predominant problems such as stuck pipe and lost circulation. Background information, such as: clay structure (needed to understand well bore instability and drilling fluids), discussion of pressure and pressure effects, the theory behind factors affecting drilling performance, and rock failure under pressure, are included to enhance the understanding of the drilling process and problems. &lt;/p&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>71</NameCodeValue>
			<ImprintName>Gulf Professional Publishing</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20091001</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2010</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<Measure>
			<MeasureTypeCode>01</MeasureTypeCode>
			<Measurement>9</Measurement>
			<MeasureUnitCode>in</MeasureUnitCode>
		</Measure>
		<Measure>
			<MeasureTypeCode>02</MeasureTypeCode>
			<Measurement>6</Measurement>
			<MeasureUnitCode>in</MeasureUnitCode>
		</Measure>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9781856178440</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>20</ProductAvailability>
			<ExpectedShipDate>20091022</ExpectedShipDate>
			<PackQuantity>18</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>61</DiscountCode>
				</DiscountCoded>
				<PriceAmount>99.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>100780:100789</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>1928994563</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781928994565</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781928994565</IDValue>
		</ProductIdentifier>
		<Barcode>03</Barcode>
		<ProductForm>BC</ProductForm>
		<Series>
			<TitleOfSeries>.NET Developers Series</TitleOfSeries>
		</Series>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>.NET Mobile Web Developers Guide</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<KeyNames>Syngress</KeyNames>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>520</NumberOfPages>
		<BASICMainSubject>COM051000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>Introducing Microsoft's flagship wireless development tool&lt;br&gt;The .NET Mobile Web Developer's Guide will provide readers with a solid guide to developing mobile applications using Microsoft technologies. The focus of this book is on using ASP.NET and the .NET mobile SDK. It provides an introduction to the .NET platform and goes into moderate details on ASP.NET to allow readers to start developing ASP.NET applications. In addition, this book will give the readers the insight to use the various Microsoft technologies for developing mobile applications.&lt;br&gt;This book assumes the readers have experience in developing web applications and are familiar with any one of the server-side technologies like ASP, JSP or PHP.
                                    &lt;br&gt;&lt;br&gt;The first book available on Microsoft's cornerstone wireless development tool&lt;br&gt;Best selling, high profile authors. Wei Meng Lee and Shelley Powers are frequent speakers at all of the major developer conferences have previously authored best selling books for O'Reilly &amp; Associates, Wrox Press, SAMS and Que&lt;br&gt;Comes with wallet-sized CD containing a printable HTML version of the book, all of the source code examples and demos of popular ASP .NET and .NET Mobile programming tools&lt;br&gt;Comprehensive Coverage of the .NET Mobile SDK and ASP.NET for Mobile Web developers</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>76</NameCodeValue>
			<ImprintName>Syngress</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20020302</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2002</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080481838</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>32</ProductAvailability>
			<ExpectedShipDate>20020323</ExpectedShipDate>
			<PackQuantity>12</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>69</DiscountCode>
				</DiscountCoded>
				<PriceAmount>51.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>112530:112619</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>1856174670</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781856174671</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781856174671</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>BB</ProductForm>
		<Series>
			<TitleOfSeries>World Pumps</TitleOfSeries>
		</Series>
		<Set>
			<TitleOfSet>Forsthoffer's Rotating Equipment Handbooks</TitleOfSet>
		</Set>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>1. Forsthoffer's Rotating Equipment Handbooks</TitleText>
			<Subtitle>Fundamentals of Rotating Equipment</Subtitle>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>William E</NamesBeforeKey>
			<KeyNames>Forsthoffer</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>President, Forsthoffer Associates Inc., Washington Crossing, PA USA</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>512</NumberOfPages>
		<BASICMainSubject>TEC009070</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>'Fundamentals of Rotating Equipment' is an overview of the main types of rotating machinery in industry, and covers such aspects as system dynamics, surge control, vibration and balancing, radial bearing design, performance parameters, rotor system design and operation, rotor axial (thrust) forces, performance objectives and mechanical restraints, auxiliary systems and seals.&lt;br&gt;&lt;br&gt;This book will enhance rotating equipment reliability and safety throughout the many industries where such equipment is vital to a successful business.&lt;br&gt;&lt;br&gt;Over recent years there have been substantial changes in those industries  which are concerned with the design, purchase and use of special purpose (ie critical, high-revenue) rotating equipment. Key personnel have been the victims of early retirement or have moved to other industries: contractors and end-users have reduced their technical staff and consequently have to learn complex material from scratch. &lt;br&gt;&lt;br&gt;As a result, many companies are finding that they are devoting unnecessary man hours to the discovery and explanation of basic principles, and having to explain these to clients who should already be aware of them. In addition, the lack of understanding by contractors and users of equipment characteristics and operating systems often results in a wrong fit and a costly reliability problem. &lt;br&gt;&lt;br&gt;The stakes can be high, and it against this background that this book has been published. It is the outcome of many years experience and is based on well-honed teaching material which is easily readable, understandable and actually enjoyable!&lt;br&gt;&lt;br&gt;This is a five volume set. The volumes are: &lt;br&gt;1. Fundamentals of Rotating Equipment &lt;br&gt;2. Pumps &lt;br&gt;3. Compressors &lt;br&gt;4. Auxiliary Systems&lt;br&gt;5. Reliability Optimization thru Component Condition Monitoring and Root Cause Analysis
                                    &lt;br&gt;&lt;br&gt;* A distillation of many years of on-site training by a well-known US Engineer who also operates in the Middle East.&lt;br&gt;* A Practical book written in a succinct style and well illustrated throughout.&lt;br&gt;* An overview of the main types of rotating machinery in industry.</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>Rotating equipment overview; compressor characteristics; operation of a compressor in a system; pump types and applications; pump performance data; centrifugal pump hydraulic disturbances; pump mechanical design; mechanical seals; compressor types and applications; the concept of fluid head; performance relationships; surge (stall) and stonewall; the effect of a gas density change; turbo-compressor mechanical design overview; radial bearing design; rotar axial (thrust) forces; compressor seal system overview and types; reciprocating compressors major component functions; flexible coupling design, installation and operation; steam turbine function and types; steam turbine performance; steam turbine mechanical design overview; steam turbine inlet steam regulation; steam turbine control/ protection systems; steam turbine operation; gas turbine types and applications; gas turbine performance; gas turbine mechanical design; gas turbine support systems; gas turbine control and protection; lubrication system overview and types; monitoring reliability and component condition; conversions to metric system; index</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>68</NameCodeValue>
			<ImprintName>Elsevier Science</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20060123</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2005</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<Measure>
			<MeasureTypeCode>01</MeasureTypeCode>
			<Measurement>9.21</Measurement>
			<MeasureUnitCode>in</MeasureUnitCode>
		</Measure>
		<Measure>
			<MeasureTypeCode>02</MeasureTypeCode>
			<Measurement>6.125</Measurement>
			<MeasureUnitCode>in</MeasureUnitCode>
		</Measure>
		<RelatedProduct>
			<RelationCode>02</RelationCode>
			<ProductIdentifier>
				<ProductIDType>02</ProductIDType>
				<IDValue>1856174727</IDValue>
			</ProductIdentifier>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9781856174725</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080949321</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>32</ProductAvailability>
			<ExpectedShipDate>20060213</ExpectedShipDate>
			<PackQuantity>12</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>61</DiscountCode>
				</DiscountCoded>
				<PriceAmount>161</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>100741:100747</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>1931836590</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781931836593</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781931836593</IDValue>
		</ProductIdentifier>
		<Barcode>03</Barcode>
		<ProductForm>BC</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>10 Cool Lego Mindstorm Dark Side Robots Transports and Creatures</TitleText>
			<Subtitle>Amazing Projects You Can Build in Under an Hour</Subtitle>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<KeyNames>Syngress</KeyNames>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>176</NumberOfPages>
		<BASICMainSubject>TEC037000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>LEGO MINDSTORMS let you design and program robots that can do just about anything!&lt;br&gt;The Dark Side Developer's Kit is targeted towards the young or novice LEGO MINDSTORMS designer, age 9 and up, although experienced MINDSTORMS fans will appreciate the unique possibilities offered by this kit as well. The Dark Side Developer's Kit includes special MINDSTORMS pieces that allow the user to create a host of Star Wars themed robots, creatures, and vehicles. It also comes with the Micro Scout, a mini-computer with 7 built-in programs, a motor, and a light sensor that brings the MINDSTORMS creations to life with a minimum of effort.&lt;br&gt;&lt;br&gt;10 Cool LEGO MINDSTORMS Dark Side Robots, Transports, and Creatures: Amazing Projects You Can Build in Under an Hour provides step-by-step instructions and detailed illustrations for users of all skill levels and proficiencies.
                                    &lt;br&gt;&lt;br&gt;A blend of the hugely popular LEGO and STAR WARS lines. Appealing to fans of both, this book will allow readers to build unique creations using the special parts found in the "LEGO MINDSTORMS: Dark Side Developer's Kit" that mimic the robots, vehicles and creatures found in the STAR WARS movies. &lt;br&gt;From out of the box to up and running in less than an hour. This book teaches users how to create 10 amazing projects, each in under an hour.&lt;br&gt;8-page color insert. An eight-page color insert illustrates the complete projects in full-detail.</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>Chapter 1: Sith Stealth Infiltrator&lt;br&gt;Chapter 2: Imperial Devastator&lt;br&gt;Chapter 3: Bounty Hunter Droid&lt;br&gt;Chapter 4: Imperial AT-ST&lt;br&gt;Chapter 5: Dark Side Reconnaissance Droid&lt;br&gt;Chapter 6: Dark Side Battle-Trainer&lt;br&gt;Chapter 7: Trade Federation Land Transport&lt;br&gt;Chapter 8: Sith Scout Ship&lt;br&gt;Chapter 9: Imperial TIE Interceptor&lt;br&gt;Chapter 10: Trade Federation Security Droid</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>76</NameCodeValue>
			<ImprintName>Syngress</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>06</PublishingStatus>
		<PublicationDate>20020913</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2002</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080546292</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>OI</AvailabilityCode>
			<ProductAvailability>40</ProductAvailability>
			<ExpectedShipDate>20021004</ExpectedShipDate>
			<PackQuantity>34</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>69</DiscountCode>
				</DiscountCoded>
				<PriceAmount>25.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>100811:100824</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>1931836612</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781931836616</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781931836616</IDValue>
		</ProductIdentifier>
		<Barcode>03</Barcode>
		<ProductForm>BC</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>10 Cool Lego Mindstorm Robotics Invention System 2 Projects</TitleText>
			<Subtitle>Amazing Projects You Can Build in Under an Hour</Subtitle>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<KeyNames>Syngress</KeyNames>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>176</NumberOfPages>
		<BASICMainSubject>TEC037000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>LEGO MINDSTORMS lets you design and program robots that can do just about anything!&lt;br&gt;The LEGO MINDSTORMS RIS 2.0 is the core set for all MINDSTORMS users, that lets users design and program working robots - limited only by their imagination. Initially designed for users 12 and up, LEGO MINDSTORMS has taken off with LEGO enthusiasts of all ages.  &lt;br&gt;10 Cool LEGO MINDSTORMS RIS 2.0 Projects: Amazing Projects You Can Build in Under an Hour provides step-by-step instructions and detailed illustrations for users of all skill levels and proficiencies.
                                    &lt;br&gt;&lt;br&gt;From out of the box to up and running in less than an hour. &lt;br&gt;8-page color insert. A color insert illustrates the complete projects in full-detail.&lt;br&gt;Specifically targeted at new users of the LEGO MINDSTORMS RIS 2.0.</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>Chapter 1: There's a Mouse in House&lt;br&gt;Chapter 2: How to Build a Better Mouse Trap&lt;br&gt;Chapter 3: Trains...&lt;br&gt;Chapter 4:  Planes...&lt;br&gt;Chapter 5: And Automobiles...&lt;br&gt;Chapter 6: BattleTank with Treads and Turrets&lt;br&gt;Chapter 7: Chore-Doer 3000&lt;br&gt;Chapter 8: Arachnoid-what?  Building a Spider&lt;br&gt;Chapter 9: Making the Band: Building a Drummer&lt;br&gt;Chapter 10: Just Desserts: Building a Gumball Machine</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>76</NameCodeValue>
			<ImprintName>Syngress</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20021129</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2002</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080546308</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>20</ProductAvailability>
			<ExpectedShipDate>20021220</ExpectedShipDate>
			<PackQuantity>22</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>69</DiscountCode>
				</DiscountCoded>
				<PriceAmount>25.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>100742:100748</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>1931836604</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781931836609</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781931836609</IDValue>
		</ProductIdentifier>
		<Barcode>03</Barcode>
		<ProductForm>BC</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>10 Cool Lego Mindstorm Ultimate Builders Projects</TitleText>
			<Subtitle>Amazing Projects You Can Build in Under an Hour</Subtitle>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>Mario</NamesBeforeKey>
			<KeyNames>Ferrari</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>Author of bestselling "Building Robots with LEGO Mindstorms", Italy</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>176</NumberOfPages>
		<BASICMainSubject>TEC037000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>LEGO MINDSTORMS lets you design and program robots that can do just about anything!&lt;br&gt;You've just purchased the LEGO MINDSTORMS Ultimate Builder Kit. Now what? Overwhelmed by the creative possibilities? The Builder Kit is targeted towards those who want to become "master LEGO builders." &lt;br&gt;&lt;br&gt;10 Cool LEGO MINDSTORM Ultimate Builder Projects: Amazing Projects You Can Build in Under an Hour provides step-by-step instructions and detailed illustrations for users of all skill levels and proficiencies. This MINDSTORMS kit features many rare parts, a spare motor, a turntable, special gears, transparent beams, and even a pneumatics system-parts that can be confusing and that will be new to many LEGO builders. 10 Cool LEGO MINDSTORM Ultimate Builder Projects teaches readers how to incorporate these new features into their creations as they build 10 unique robots.
                                    &lt;br&gt;&lt;br&gt;From out of the box to up and running in less than an hour. This book teaches users how to create 10 amazing projects in under an hour.&lt;br&gt;8-page color insert. An eight-page color insert will illustrates the complete projects in full-detail.&lt;br&gt;Specifically targeted to both new users of the LEGO MINDSTORMS and experienced MINDSTORMS fans.</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>13</TextTypeCode>
			<Text>Mario Ferrari received his first Lego box around 1964, when he was 4. Lego was his favorite toy for many years, until he thought he was too old to play with it. In 1998, the Lego Mindstorms RIS set gave him reason to again have Lego become his main addiction. Mario believes Lego is the closest thing to the perfect toy. He is Managing Director at EDIS, a leader in finishing and packaging solutions and promotional packaging. The advent of the MINDSTORMS product line represented for him the perfect opportunity to combine his interest in IT and robotics with his passion for LEGO bricks, which started during his early childhood. Mario has been a very active member of the online MINDSTORMS community from the beginning and has pushed LEGO robotics to its limits. Mario holds a bachelor's degree in Business Administration from the University of Turin and has always nourished a strong interest for physics, mathematics, and computer science. He is fluent in many programming languages and his background includes positions as an IT manager and as a project supervisor. Mario estimates he owns over 60,000 Lego pieces. Mario works in Modena, Italy, where he lives with his wife Anna and his children Sebastiano and Camilla.&lt;p&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>76</NameCodeValue>
			<ImprintName>Syngress</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20021214</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2002</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080555157</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>20</ProductAvailability>
			<ExpectedShipDate>20030104</ExpectedShipDate>
			<PackQuantity>18</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>69</DiscountCode>
				</DiscountCoded>
				<PriceAmount>25.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>120947:127931</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>0444504761</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9780444504760</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9780444504760</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>BB</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>10&lt;SUP&gt;th&lt;/SUP&gt; European Conference on Mixing</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>H.E.A.</NamesBeforeKey>
			<KeyNames>van den Akker</KeyNames>
		</Contributor>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>J.J.</NamesBeforeKey>
			<KeyNames>Derksen</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>Kramers Laboratorium voor Fysische Technologie, Delft University of Technology, Delft, The Netherlands</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>572</NumberOfPages>
		<BASICMainSubject>TEC009010</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>Traditionally, fluid mixing and the related multiphase contacting processes have always been regarded as an empirical technology. Many aspects of mixing, dispersing and contacting were related to power draw, but understanding of the phenomena was limited or qualitative at the most.&lt;br&gt;&lt;br&gt;In particular during the last decade, however, plant operation targets have tightened and product specifications have become stricter. The public awareness as to safety and environmental hygiene has increased. The drive towards larger degrees of sustainability in the process industries has urged for lower amounts of solvents and for higher yields and higher selectivities in chemical reactors. All this has resulted in a &lt;i&gt;market pull&lt;/i&gt;: the need for more detailed insights in flow phenomena and processes and for better verifiable design and operation methods.&lt;br&gt;&lt;br&gt;Developments in miniaturisation of sensors and circuits as well as in computer technology have rendered leaps possible in computer simulation and animation and in measuring and monitoring techniques. &lt;br&gt;&lt;br&gt;This volume encourages a leap forward in the field of mixing by the current, overwhelming wealth of sophisticated measuring and computational techniques. This leap may be made possible by modern instrumentation, signal and data analysis, field reconstruction algorithms, computational modelling techniques and numerical recipes. &lt;br&gt;</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>&lt;b&gt;Section headings:&lt;/b&gt; &lt;b&gt;Turbulence Characteristics in Stirred Tanks.&lt;/b&gt; (3 papers). &lt;b&gt;Measurements in Chemically Reacting Flows.&lt;/b&gt; (3 papers). &lt;b&gt;Modelling of Micro-Mixing.&lt;/b&gt; (6 papers). &lt;b&gt;Effects of Viscosity and Rheology on Mixing.&lt;/b&gt; (3 papers). &lt;b&gt;Slurry Systems.&lt;/b&gt; (2 papers). &lt;b&gt;Liquid-Liquid Dispersions.&lt;/b&gt; (6 papers). &lt;b&gt;Gas-Liquid Systems.&lt;/b&gt; (4 papers). &lt;b&gt;Particle Collisions in Crystallisation.&lt;/b&gt; (2 papers). &lt;b&gt;Advanced CFD.&lt;/b&gt; (3 papers). &lt;b&gt;Posters.&lt;/b&gt; (33 papers).&lt;br&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>68</NameCodeValue>
			<ImprintName>Elsevier Science</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>06</PublishingStatus>
		<PublicationDate>20000614</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2000</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080525792</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>OI</AvailabilityCode>
			<ProductAvailability>40</ProductAvailability>
			<ExpectedShipDate>20000705</ExpectedShipDate>
			<PackQuantity>16</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>61</DiscountCode>
				</DiscountCoded>
				<PriceAmount>340</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>1095034:10895161</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9780240814254</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9780240814254</IDValue>
		</ProductIdentifier>
		<Barcode>03</Barcode>
		<ProductForm>BC</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>100% Photoshop</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>Steve</NamesBeforeKey>
			<KeyNames>Caplin</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>Graphic artist/illustrator, contributing editor for MacUser magazine and the best-selling author of How to Cheat in Photoshop</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>256</NumberOfPages>
		<BASICMainSubject>COM012000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>&lt;p&gt;Just when you think you have learned all that you could ever know about working in Photoshop, digital artist and photomontage king Steve Caplin comes along with yet another masterful method for creating incredible works of art in Photoshop. This time, he will show you how to create complete images, from start to finish, &lt;U&gt;entirely&lt;/U&gt; within the software program. No source material, photographs, or existing files from other software packages are needed, saving you valuable time and resources. The techniques you will learn in this ground-breaking new book will help you combine your artistic vision and skills with an understanding of how to manipulate the built-in Photoshop filters to produce impressive, eye-catching artwork.&lt;/p&gt;&lt;br&gt;&lt;p&gt;Each chapter opens with a complete double page illustration, created entirely in Photoshop. Then, carefully laid out step-by-step instructions show you how each element in the illustration is created, and how they are all combined in the end to make a convincing final image. Using Steve&apos;s proven methods for success, you will be able to produce images that reflect a more finely crafted, hand drawn approach, whether you are an artist for your own enjoyment or a working professional looking for a leg up on the competition. &lt;/p&gt;
                                    &lt;br&gt;&lt;br&gt;&lt;p&gt;*The only book of its kind that does not rely on any external images whatsoever -- each and every element is created directly in Photoshop &lt;/p&gt;&lt;br&gt;&lt;p&gt;*A chapter covering the basics of using specific filters and textures and a chapter providing a summary of common techniques and tools will help you brush up on your general Photoshop skills so you can move through the rest of the book successfully &lt;/p&gt;&lt;br&gt;&lt;p&gt;*Visit the book website at [url to come] for supplemental material to help you get started &lt;/p&gt;</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>&lt;p&gt;Chapter 1: Textures: Using Clouds, Noise, Blur, Fibers to create basic texture; Texture creation: paper, wood, stone, and metal; Chapter 2: Setting the Scene: Hallway -- door, light, glass, gold text, shadows, metal handle, layer masks; Chapter 3: The Great Outdoors: trees, grass, leaves (custom brush design), water and reflections, clouds, sky, mountains; Chapter 4: In the Attic:LPs, cardboard boxes, guitar, cork boards, beams, brick walls, assorted items; Chapter 5: To Boldly Go: Space scene with stars, planets, aurora, spaceship, alien; Chapter 6: Treasured Possessions: Desk drawer with jewelry, letters, sealing wax, pens, magnifying glass, pencils, rubber stamp, folder with coffee stains; Chapter 7: In the Lab: Mad scientist&apos;s laboratory with Bunsen burner, lab bottles, stone wall, lightning through window; Chapter 8: The Operation:&amp;nbsp;Operating theatre scene with close-up of opened body featuring internal organs, bone, skin texture, scalpels and clamps; Chapter 9: Fantasy Scene: Organic-looking synthetic scene with intertwining tentacles, texture generated background, H R Giger-style anatomical elements;&amp;nbsp;Chapter 10: Photoshop Reference: Quick start guide &lt;/p&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>70</NameCodeValue>
			<ImprintName>Focal Press</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>02</PublishingStatus>
		<PublicationDate>20100601</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2010</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780240814261</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>NP</AvailabilityCode>
			<ProductAvailability>10</ProductAvailability>
			<ExpectedShipDate>20100622</ExpectedShipDate>
			<PackQuantity>24</PackQuantity>
			<Price>
				<PriceTypeCode>21</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>69</DiscountCode>
				</DiscountCoded>
				<PriceAmount>39.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>1092624:10872821</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9780444534729</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9780444534729</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>BB</ProductForm>
		<Series>
			<TitleOfSeries>Computer Aided Chemical Engineering</TitleOfSeries>
			<NumberWithinSeries>27</NumberWithinSeries>
		</Series>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>10th International Symposium on Process Systems Engineering - PSE2009</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>Rita Maria</NamesBeforeKey>
			<KeyNames>de Brito Alves</KeyNames>
		</Contributor>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>Claudio Augusto</NamesBeforeKey>
			<KeyNames>Oller do Nascimento</KeyNames>
		</Contributor>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>Evaristo Chalbaud</NamesBeforeKey>
			<KeyNames>Biscaia</KeyNames>
			<SuffixToKey>Jr.</SuffixToKey>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<BASICMainSubject>SCI013000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>&lt;p&gt;This book contains the proceedings of the10th edition of a series of international symposia on Process Systems Engineering (PSE)&amp;nbsp;initiated in 1982. The special focus of PSE09 is how PSE methods can support sustainable resource systems and emerging technologies in the areas of green engineering.&lt;/p&gt;
                                    &lt;br&gt;&lt;br&gt;&lt;p&gt;* Contains fully searchable CD of all printed contributions&lt;/p&gt;&lt;br&gt;&lt;p&gt;* Focus on sustainable green engineering&lt;/p&gt;&lt;br&gt;&lt;p&gt;* 9 Plenary papers, 21 Keynote lectures by leading experts in the field&lt;/p&gt;</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>&lt;p&gt;&lt;b&gt;Part A&lt;/b&gt;&lt;/p&gt;&lt;br&gt;&lt;p&gt;Plenary lectures&lt;/p&gt;&lt;br&gt;&lt;p&gt;Keynote lectures&lt;/p&gt;&lt;br&gt;&lt;p&gt;Modelling, Supporting Methods and Tools&lt;/p&gt;&lt;br&gt;&lt;p&gt;Product and Process Design&lt;/p&gt;&lt;br&gt;&lt;p&gt;&lt;b&gt;Part B&lt;/b&gt;&lt;/p&gt;&lt;br&gt;&lt;p&gt;Operations and Control&lt;/p&gt;&lt;br&gt;&lt;p&gt;Non-traditional Applications of Process Systems Engineering&lt;/p&gt;&lt;br&gt;&lt;p&gt;Business Decision Support&lt;/p&gt;&lt;br&gt;&lt;p&gt;Education in Process Systems Engineering&lt;/p&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>109</NameCodeValue>
			<ImprintName>Elsevier</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20090903</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2009</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>01</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080963273</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780444534736</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>32</ProductAvailability>
			<ExpectedShipDate>20090924</ExpectedShipDate>
			<PackQuantity>1</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>61</DiscountCode>
				</DiscountCoded>
				<PriceAmount>575</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
</ONIXMessage>	
EOXML;

// LOAD IT INTO AN OBJECT
$obj = SimpleXML_Load_String($xml);

// ACTIVATE THIS TO VISUALIZE THE OBJECT
// var_dump($obj);

// SHOW HOW TO GET SOME OF THE INFORMATION OUT OF THE OBJECT
$h = (string)$obj->Header->FromCompany;
$h1 = (string)$obj->Header->FromPerson;
$h2 = (string)$obj->Header->SentDate;
$h3 = (string)$obj->Header->DefaultCurrencyCode;

echo PHP_EOL . $h;
echo PHP_EOL . $h1;
echo PHP_EOL . $h2;
echo PHP_EOL . $h3;

// SHOW HOW TO GET COUNTS OF DATA FIELDS
$k = count($obj->Product);
echo PHP_EOL . "$k PRODUCT LISTINGS";

// SHOW HOW TO ITERATE OVER THE ARRAY OF "Product" AND GET SOME DATA FIELDS
$n = 0;
foreach ($obj->Product as $p)
{
    $n++;
    $t = (string)$p->Title->TitleText;
    $i = (string)$p->Imprint->ImprintName;
    $y = (string)$p->CopyrightStatement->CopyrightYear;
    $c = (string)$p->CopyrightStatement->CopyrightOwner->CopyrightOwnerIdentifier->IDValue;
    $m = (string)$p->SupplyDetail->Price->PriceAmount;
	
	$rr = (string)$p->RecordReference;
    $nt = (string)$p->NotificationType;
    $pf = (string)$p->ProductForm;
    $nop = (string)$p->NumberOfPages;
    $bms = (string)$p->BASICMainSubject;
   	$ac = (string)$p->AudienceCode;
    $pubn = (string)$p->PublisherName;
    $pubs = (string)$p->PublishingStatus;
    $pubd = (string)$p->PublicationDate;
	
	
	
    echo PHP_EOL;
    echo PHP_EOL . "LISTING NUMBER $n";
    echo PHP_EOL . $t;
    echo PHP_EOL . $i;
    echo PHP_EOL . "&copy;" . $y . ' ' .$c;
    echo PHP_EOL . '$' . $m;
		

    foreach ($p->ProductIdentifier as $pi)
    {
        // CAST AS STRING VARIABLES
        $ProductIDType = (string)$pi->ProductIDType;
        $IDValue       = (string)$pi->IDValue;
        
		// STORED IN THE ARRAY
 
        $pia[$ProductIDType==03] = $IDValue;	
    
    }	
	   
	// PRODUCT IDENTIFIERS - PRESENTED FROM THE ASSOCIATIVE ARRAY
    foreach ($pia as $ProductIDType => $IDValue)
    {
   	   $GTIN13 = $pia[$ProductIDType==03];
	} 
	   
	$pia1 = array();
    foreach ($p->ProductIdentifier as $pi1)
    {
        // CAST AS STRING VARIABLES
        $ProductIDType1 = (string)$pi1->ProductIDType;
        $IDValue1       = (string)$pi1->IDValue;
        
		// STORED IN THE ARRAY
 
        $pia1[$ProductIDType1] = $IDValue1;
    
    }	
	   
	// PRODUCT IDENTIFIERS - PRESENTED FROM THE ASSOCIATIVE ARRAY
    foreach ($pia1 as $ProductIDType1 => $IDValue1)
    {
	  		
		echo PHP_EOL . 'PIM: ' . $ProductIDType1 . ' ' . $IDValue1. ' ' . $GTIN13;
		
   
$con = mysql_connect("localhost", "root", "Jason01");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("book", $con);


	 if ($ProductIDType1==02) {
               mysql_query("INSERT INTO tblIsbn10 (
			   ProductIDType, 
			   IDValue, 
			   Gtin13) 
			   
			   VALUES (
			   '$ProductIDType1', 
			   '$IDValue1', 
			   '$GTIN13') 
			   ");
			   
     }
	   
	   if ($ProductIDType1==03) {
               
			   mysql_query("INSERT INTO tblGtin13 (
			   ProductIDType, 
			   IDValue, 
			   Gtin13) 
			   
			   VALUES (
			   '$ProductIDType1', 
			   '$IDValue1', 
			   '$GTIN13') 
			   ");
			   
			    //INSERT DATA INTO PRODUCTS TABLE
			    mysql_query("INSERT INTO books (
				RecordReference, 
				NotificationType, 
				ProductIDTypeIDValue, 
				ProductFormCode, 
				NumberOfPages, 
				BASICMainSubject, 
                AudienceCode, 
				PublisherName, 
				PublishingStatus, 
				PublicationDate)

                VALUES (
		        '$rr', 
                '$nt', 
       	        '$IDValue',
                '$pf',
                '$nop', 
                '$bms',
                '$ac', 
                '$pubn', 
                '$pubs', 
                '$pubd') 
                ");    
	        } 
	 
	           if ($ProductIDType1==15) {
               mysql_query("INSERT INTO tblIsbn13 (
			   ProductIDType, 
			   IDValue, 
			   Gtin13) 
			   
			   VALUES (
			   '$ProductIDType1', 
			   '$IDValue1', 
			   '$GTIN13') 
			   ");

     }
	 
	 }
	 
       // CONTRIBUTOR  - EXTRACTED INTO AN ASSOCIATIVE ARRAY
       
        foreach ($p->Contributor as $co)
        {
           // CAST AS STRING VARIABLES
            $ContributorRole = (string)$co->ContributorRole;
            $NamesBeforeKey  = (string)$co->NamesBeforeKey;
            $KeyNames = (string)$co->KeyNames;
            $SuffixToKey = (string)$co->SuffixToKey;
				
     	 
	     echo PHP_EOL . 'CO: '  . ' ' . $ContributorRole . ' ' . $NamesBeforeKey. ' '. $KeyNames. ' '.   $SuffixToKey . ' ' .$GTIN13; 
	 
	   		mysql_query("INSERT INTO tblContributors  (
            ContributorRole,
            NamesBeforeKey,
            KeyNames,
            SuffixToKey)
                    

		   VALUES (
          '$ContributorRole', 
		  '$NamesBeforeKey',
		  '$KeyNames', 
		  '$SuffixToKey')
		  ");
		  
		  	
		// GET CONTRIBUTOR DATA OUT OF DATABASE
         $sqlget = "SELECT * FROM tblContributors WHERE ContributorRole = '$ContributorRole' and  NamesBeforeKey = '$NamesBeforeKey' and KeyNames = '$KeyNames' and SuffixToKey = '$SuffixToKey'";
         $sqldata = mysql_query($sqlget, $con) or die('error getting data');


        while ($row = mysql_fetch_array($sqldata, MYSQLI_ASSOC)) {
       
	    echo PHP_EOL . 'DBCO:' . ' ' .$row['ContributorID']. ' ' . $row['ContributorRole']. ' ' . $row['NamesBeforeKey']. ' ' . $row['KeyNames']. ' ' . $row['SuffixToKey'];
        
		$cid = $row['ContributorID'];
		

		//INSERT DATA INTO LINKCONTRIBUTOR-PRODUCTS TABLE
			mysql_query("INSERT INTO linkContributor_Products  (
            ContributorID,
            Gtin13)
                    

		    VALUES (
            '$cid', 
		    '$GTIN13')
		    ");	
					
		    }
			

         // PROFESSIONAL AFFLIATION  - EXTRACTED INTO AN ASSOCIATIVE ARRAY
       
        foreach ($co->ProfessionalAffiliation as $pa)
        {
           // CAST AS STRING VARIABLES
            $ProfessionalPosition = (string)$pa->ProfessionalPosition;	
            $Affiliation = (string)$pa->Affiliation;
	 
	   		
			//INSERT DATA INTO TBLPROFESSIONALAFFILIATION TABLE
			mysql_query("INSERT INTO tblProfessionalAffiliation  (
            ProfessionalPosition,
            Affiliation)
                    

		   VALUES (
          '$ProfessionalPosition', 
		  '$Affiliation')
		  ");
		 		
        
		// GET PROFESSIONAL AFFLIATION DATA OUT OF DATABASE
         $sqlget1 = "SELECT * FROM tblProfessionalAffiliation WHERE ProfessionalPosition = '$ProfessionalPosition' and  Affiliation = '$Affiliation'";
         $sqldata1 = mysql_query($sqlget1, $con) or die('error getting data');


        while ($row1 = mysql_fetch_array($sqldata1, MYSQLI_ASSOC)) {
       
	    echo PHP_EOL . 'DBPA:' . ' ' .$row1['ProfessionalAffiliationID']. ' ' . $row1['ProfessionalPosition']. ' ' . $row1['Affiliation'];
       
		$paid = $row1['ProfessionalAffiliationID'];
		

		 //INSERT DATA INTO LINKCONTRIBUTOR_PRODUCTS TABLE
			mysql_query("INSERT INTO tblPA_Contributors  (
            ContributorID,
            ProfessionalAffiliationID)
                    

		    VALUES (
            '$cid', 
		    '$paid')
		    ");	
					
		    }		  
			
		}
		
		}
		
		mysql_close($con);
}
		 
?>

Open in new window

0
 
HonyaAuthor Commented:
I found the answer elsewhere.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now