[UPHPU] filter XML content against database

[Wade Preston Shearer]

I have an XML file full of records that match records in a database. The XML file contains more records than in the database however. I need to read the XML file in, loop through the object, and print our each record. I need to filter the XML records by the records in the database however; meaning, I only want the records that are also in the database. The two ways I have thought to do this are:

1. Query the database on each loop to check if that record exists.




Both see really inefficient. Can anyone suggest a better way?
        

2. Create a comma-separated string of the ID all of the XML records and then query the database using the IN() function.

smime.p7s
Description: S/MIME cryptographic signature

_______________________________________________

UPHPU mailing list
UPHPU@uphpu.org
http://uphpu.org/mailman/listinfo/uphpu
IRC: #uphpu on irc.freenode.net