PHP generated hotspot issue

Douglas Rhiner · July 6, 2011 at 5:31 AM

Once again I need an extra set of eyes to look over something before I go insane.

I have a php script that generates XML for krpano.
The relevant portion being.....

$query = "SELECT * FROM `vthotspot` WHERE `parent` = '$scene' ";
$result = mysql_query($query);
if($result) {
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$index = $row['index'];
$name = $row['name'];
$ath = $row['spotath'];
$atv = $row['spotatv'];

echo "<hotspot name=\"hs$index\" style=\"icongeneral\"";
echo " ath=\"$ath\"";
echo " atv=\"$atv\"";
echo " zoom=\"false\"";
echo " scale=\"0.5\"";
echo " />";
}
}

When the script is run the output visually looks just perfect, but none of the hotspots are rendered and an error is returned ERROR: parsing parameters failed - TypeError: Error #1034.
I even tried copying one of the hotspots from the output XML and pasting it in the script, so it was not dynamically generated, and the hard-code shows up just fine!
So there has to be something with the PHP. But yet lines 2 and 3 of the XML below are exactly the same - except that line two is hard-coded and line 3 is dynamic.?!?!?!

WTF?!

Here is the relevant output of the script. The first two lines are the hard coded ( and hotspots that are rendering ), the remaining three are dynamically generated and not rendering.

<hotspot name="editSpot" style="dragablehotspot" ath="0" atv="0" zoom="false" scale="0.5"/>
<hotspot name="hs93" style="icongeneral" ath="37.0" atv="-22.0" zoom="false" scale="0.5"/>
<hotspot name="hs93" style="icongeneral" ath="37.0" atv="-22.0" zoom="false" scale="0.5"/>
<hotspot name="hs104" style="icongeneral" ath="-115.4" atv="-5.6" zoom="false" scale="0.5"/>
<hotspot name="hs103" style="icongeneral" ath="34.7" atv="-19.9" zoom="false" scale="0.5"/>

Zephyr · July 6, 2011 at 10:16 AM

add a space before />

This is part of my code:

PHP

<?php
   
            foreach ($hotspots as $hs)
    {
        ?>
        <hotspot name="<?php echo $hs->Name; ?>"
                 url="../hotspots/<?php echo $hs->Url; ?>"
                 alturl="<?php echo $hs->Alturl; ?>"
                 keep="<?php echo $hs->Keep; ?>"
                 devices="<?php echo $hs->Devices; ?>"
                 visible="<?php echo $hs->Visible; ?>"
                 enabled="<?php echo $hs->Enabled; ?>"
                 handcursor="<?php echo $hs->Handcursor; ?>"
                 zorder="<?php echo $hs->Zorder; ?>"
                 capture="<?php echo $hs->Capture; ?>"
                 children="<?php echo $hs->Children; ?>"
                 preload="<?php echo $hs->Preload; ?>"
                 blendmode="<?php echo $hs->Blendmode; ?>"
                 style=""
                 ath="<?php echo $hs->Ath; ?>"
                 atv="<?php echo $hs->Atv; ?>"
                 edge="<?php echo $hs->Edge; ?>"
                 ox="<?php echo $hs->Ox; ?>"
                 oy="<?php echo $hs->Oy; ?>"
                 zoom="<?php echo $hs->Zoom; ?>"
            <? if ($hs->Distorted == "true") { ?>
                 distorted="<?php echo $hs->Distorted; ?>"
                 rx="<?php echo $hs->Rx; ?>"
                 ry="<?php echo $hs->Ry; ?>"
                 rz="<?php echo $hs->Rz; ?>"
            <? } ?>
                 inverserotation="<?php echo $hs->Inverserotation; ?>"
                 flying="<?php echo $hs->Flying; ?>"
                 width="<?php echo $hs->Width; ?>" height="<?php echo $hs->Height; ?>"
                 scale="<?php echo $hs->Scale; ?>"
                 altscale="<?php echo $hs->Altscale; ?>"
                 rotate="<?php echo $hs->Rotate; ?>"
                 smoothing="<?php echo $hs->Smoothing; ?>"
                 accuracy="<?php echo $hs->Accuracy; ?>"
                 alpha="<?php echo $hs->Alpha; ?>"
                 usecontentsize="<?php echo $hs->Usecontentsize; ?>"
                 scale9grid="<?php echo $hs->Scale9grid; ?>"
                 crop="<?php echo $hs->Crop; ?>"
                 onovercrop="<?php echo $hs->Onovercrop; ?>"
                 ondowncrop="<?php echo $hs->Ondowncrop; ?>"
                 scalechildren="<?php echo $hs->Scalechildren; ?>"
                 mask="<?php echo $hs->Mask; ?>"
                 effect="<?php echo $hs->Effect; ?>"
                 onover="<?php echo $hs->Onover; ?>"
                 onhover="<?php echo $hs->Onhover; ?>"
                 onout="<?php echo $hs->Onout; ?>"
                 ondown="<?php echo $hs->Ondown; ?>"
                 onup="<?php echo $hs->Onup; ?>"
                 onloaded="<?php echo $hs->Onloaded; ?>"
                 altonloaded="<?php echo $hs->Altonloaded; ?>"
                />
        <?php
    }
    ?>

Display More

Douglas Rhiner · July 6, 2011 at 4:43 PM

Zephyr,

Thanks for the reply and suggestion!

But I'm still having issues.
What has me really miffed is that the hard coded and dynamic versions of a hotspot, both having seemingly identical XML output will and will-not, respectively, render.
It's almost as if the XML is getting parsed before the PHP has completely worked it's magic?

sachagriffin · July 6, 2011 at 5:09 PM

Nah, that ain't possible unless you use the flush function

It's probably something in your style.
I suggest that you need to post an actually link to your issue.

Most likely thinking about the possible issues relating to php is keeping you from seeing the obvious somewhere else.

jpdeglet69 · July 6, 2011 at 7:48 PM

To delete...

Zephyr · July 6, 2011 at 8:06 PM

or maybe it's a sign that looks like a other sign like '' (2 single quotes) instead of a " (double quote), or the < . Try retyping it.

PHP generated hotspot issue

Participate now!

Users Viewing This Thread