21 Jan 2008, 17:37
#1
New Zenner
- Join Date:
- Sep 2007
- Posts:
- 14
- Plugin Contributions:
- 0
Slideshowpro SSP ?
I searched for this a while back and found a couple people asking for it, so I thought I would post this.
I created a php script for the xml output to work with slideshowpro. It pulls the product title and links to the item when you click on the slideshow. Just input your mysql info and point the flash file to this php script and you should be good to go.
I made it pull a random 20 items, but you could easily modify the SQL to grab the featured products, specials, etc...
here's the code.
<?php
echo "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>
";
?>
<gallery>
<album id='1' title='Album Title'>
<?php
// connect to db
$data = mysql_connect("localhost", "username", "password");
$db = mysql_select_db("database_name", $data);
// get our product ID's and titles
$sql = "
SELECT zc_products.products_id, zc_products.products_image, zc_products_description.products_name
FROM zc_products, zc_products_description
WHERE zc_products.products_status = 1
AND zc_products.products_id = zc_products_description.products_id
ORDER BY RAND()
LIMIT 0, 20
";
$get_p = mysql_query($sql, $data);
while($row = mysql_fetch_array($get_p)) {
?>
<img src="images/<?php echo $row['products_image'] ?>" title="<?php echo $row['products_name'] ?>" caption="<?php echo $row['products_name'] ?>" link="index.php?main_page=product_info&products_id=<?php echo $row['products_id'] ?>" target="_self"/>
<?php
}
?>
</album>
</gallery>
I tried to keep it simple, so if anyone has modifications feel free to contribute!
