PHP Code in XML which is generated in PHP

Question

I have a problem with XML data generated by a PHP file.

here is my code:

$requestXmlBody .= "<PictureURL>";

    //find black

  while($row = mysql_fetch_object($ergebnis))
  {
    $posblack = strpos($row->image, $findBLACK);
    if ($posblack !== false) 
    {
    echo $row->image;
    }
  }
    $requestXmlBody .= "</PictureURL>";

This code will generate the XML Code

<PictureURL></PictureURL>

but not the name I fetch from the database. The database query is working but my problem ist to have it inserted between the XML code. Usually a variable is inserted like this

$requestXmlBody .= '<PictureURL>$variable</PictureURL>';

I just don't know how to wrap this around my database query.

Any help is very appreciated.

Double check that you are getting rows returned by assigning $rows outside of your while loop and echoing the count. — Rob Allen
– Rob Allen, Commented Mar 7, 2013 at 19:17
You are mixing string concatenation (for the xml tags) with a raw echo (for the image URL). Decide on one. Place both in the loop and if block. — mario
– mario, Commented Mar 7, 2013 at 19:18

James Coyle · Accepted Answer · 2013-03-07 19:19:18Z

1

Something like this?

while($row = mysql_fetch_object($ergebnis)) {
  $posblack = strpos($row->image, $findBLACK);
  if ($posblack !== false) {
    $requestXmlBody .= "<PictureURL>";
    $requestXmlBody .= $row->image;
    $requestXmlBody .= "</PictureURL>";
  }
}

answered Mar 7, 2013 at 19:19

James Coyle

10.5k2 gold badges42 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user2132799 Over a year ago

It worked with the '$requestXmlBody .= "<PictureURL>";' outside the loop. Thanks a lot. this made my day :)

Adam Plocher · Accepted Answer · 2013-03-07 19:18:31Z

0

You are echo'ing $row->image instead of appending to $requestXmlBody

Change your code to:

$requestXmlBody .= $row->image;

answered Mar 7, 2013 at 19:18

Adam Plocher

14.3k6 gold badges51 silver badges83 bronze badges

2 Comments

Adam Plocher Over a year ago

Are you ever going to have more than one result? If so, you should have the <PictureURL> part added to the while loop.

user2132799 Over a year ago

It's only one result. Thanks anyway.

Collectives™ on Stack Overflow

PHP Code in XML which is generated in PHP

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related