StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POZipping images referenced from xml generated by mysql query
primarykey
Id
12373509
data
AcceptedAnswerId
12388839
AnswerCount
1
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2012-09-11T15:48:23.003
FavoriteCount
0
LastActivityDate
2012-09-12T13:04:23.477
LastEditDate
LastEditorUserId
0
OwnerUserId
1286551
ParentId
0
PostTypeId
1
Score
0
ViewCount
92
LastEditorDisplayName
text
Body
OK, I'll try and make this as easy to follow as I can! Background: I'm creating an XML feed to display cars on ebay motors pro from a MySql database using php. I have successfully created the xml file with all the relevant details, which also ftp's to my test server. Problem: Each car photo is logged in the database as regnumber_1.jpg, regnumber_2.jpg; and so on, and linked to each vehicle. The images reside in a folder called autotrader. I'm having trouble posting the images from the autotrader folder into the ebay folder within a zip file. I only want to copy the photos from the mysql query (i.e. not the entire folder). I suspect it's because I haven't done the foreach loop correctly, but hopefully someone will be able to point me in the right direction? Here's the code: <pre><code>//Photos bit... $destination = 'tmp/ebay'; $filename = 'ebay-photos'; //images array $row = array(); foreach ($result->images as $images) { $images = explode(',', $row['images']); foreach ( $images as $image ) { copy('uploads/used-cars/autotrader/' . $image, $destination . $image); $all_images[] = $image; } } exec('zip -g0 ' . $zip_filename . ' *.jpg *.jpeg'); foreach ( $all_images as $image ) { @unlink($destination.$image); } $zip_filename = $filename . '.zip'; while ($row = @mysql_fetch_assoc($result)){ $all_images->images as $images); } </code></pre> The XML bit works, and is: <pre><code>while ($row = @mysql_fetch_assoc($result)){ // XML $node = $dom->createElement("ad"); $newnode = $parnode->appendChild($node); $newnode->setAttribute("vrm",$row['vrm']); $newnode->setAttribute("make",$row['make']); $newnode->setAttribute("model",$row['model']); $newnode->setAttribute("type",$row['type']); $newnode->setAttribute("consumerPrice",$row['consumerPrice']); $newnode->setAttribute("numPreviousOwners",$row['numPreviousOwners']); $newnode->setAttribute("transmission",$row['transmission']); $newnode->setAttribute("images",$row['images']); $newnode->setAttribute("numPreviousOwners",$row['numPreviousOwners']); $newnode->setAttribute("color",$row['color']); } $dom->save('tmp/ebay/ebay.xml'); echo $dom->saveXML(); </code></pre> Thanks in advance!
Tags
<php><mysql><xml>
Title
Zipping images referenced from xml generated by mysql query
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USLeeG
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COZipping compressed images like jpegs is a waste of time; You'll be lucky to get a 10% decrease in size. Unless it's a requirement of the ebay side of things, I'd suggest tarring the images if anything. With a tar, you'd still have just on file, but wouldn't waste time trying to compress it.
 singulars
 PostPostId
 POZipping images referenced from xml generated by mysql query
 UserUserId
 USG-Nugget
2. COHi. There are multiple images to go into the zip file as a requirement of ebay.
 singulars
 PostPostId
 POZipping images referenced from xml generated by mysql query
 UserUserId
 USLeeG

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.