PDA

View Full Version : Switching from XML to database


ingvaro
12-10-2006, 03:27 PM
Hey guys, im new here so hi everyone! :D

I got this photogallery that loads images through a xml file, but what i want to do is change it so it loads images through a database, know any good ways to to this?


function loadXML(loaded) {

if (loaded) {

xmlNode = this.firstChild;
image = [];
description = [];
total = xmlNode.childNodes.length;
for (i=0; i<total; i++) {

image[i] = xmlNode.childNodes[i].childNodes[0].firstChild.nodeValue;
description[i] = xmlNode.childNodes[i].childNodes[1].firstChild.nodeValue;

}
firstImage();

} else {

content = "file not loaded!";

}

}
xmlData = new XML();
xmlData.ignoreWhite = true;
xmlData.onLoad = loadXML;
xmlData.load("images.xml");
/////////////////////////////////////
listen = new Object();
listen.onKeyDown = function() {

if (Key.getCode() == Key.LEFT) {

prevImage();

} else if (Key.getCode() == Key.RIGHT) {

nextImage();

}

};
Key.addListener(listen);
previous_btn.onRelease = function() {

prevImage();

};
next_btn.onRelease = function() {

nextImage();

};
/////////////////////////////////////
p = 0;
this.onEnterFrame = function() {

filesize = picture.getBytesTotal();
loaded = picture.getBytesLoaded();
preloader._visible = true;
if (loaded != filesize) {

preloader.preload_bar._xscale = 100*loaded/filesize;

} else {

preloader._visible = false;
if (picture._alpha<100) {

picture._alpha += 10;

}

}

};
function nextImage() {

if (p<(total-1)) {

p++;
if (loaded == filesize) {

picture._alpha = 0;
picture.loadMovie(image[p], 1);
desc_txt.text = description[p];
picture_num();

}

}

}
function prevImage() {

if (p>0) {

p--;
picture._alpha = 0;
picture.loadMovie(image[p], 1);
desc_txt.text = description[p];
picture_num();

}

}
function firstImage() {

if (loaded == filesize) {

picture._alpha = 0;
picture.loadMovie(image[0], 1);
desc_txt.text = description[0];
picture_num();

}

}
function picture_num() {

current_pos = p+1;
pos_txt.text = current_pos+" / "+total;

}

senocular
12-10-2006, 03:36 PM
just have the content from the database formatted to xml. Then you wont have to change anything in Flash

ingvaro
12-10-2006, 03:49 PM
just have the content from the database formatted to xml. Then you wont have to change anything in Flash

Can you give me an example or something?

Sorry, im very new at this :)

senocular
12-10-2006, 04:06 PM
Its not as easy as just posting a few lines of code in a forum post. It all depends on what kind of database you're going to use, what server-side language you're going to use to interact with that database, the content, the structure of that database to hold that content, and the structure of the XML used to present it.

You might be able to find more concrete and complete examples online somewhere. Check out the tutorials on this site or try google :)

ingvaro
12-11-2006, 06:20 AM
Its not as easy as just posting a few lines of code in a forum post. It all depends on what kind of database you're going to use, what server-side language you're going to use to interact with that database, the content, the structure of that database to hold that content, and the structure of the XML used to present it.

You might be able to find more concrete and complete examples online somewhere. Check out the tutorials on this site or try google :)

Well i use PHP and MySQL, and the XML script looks like this:

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<images>
<pic><image>images/000.jpg</image></pic>
<pic><image>images/001.jpg</image></pic>
<pic><image>images/002.jpg</image></pic>
<pic><image>images/003.jpg</image></pic>
<pic><image>images/004.jpg</image></pic>
<pic><image>images/005.jpg</image></pic>
</images>