PHP and XML

teddyjas

hi,
i need to know what's the best way to get started.
I have large image files over thousands of images, the description of the images are stored in mySQL database.
They are categorised into different categories for example cartoon, comics, animal etc.

Now, i want this images appears on my clients websites same way as it's categorise in my website, i'm thinking using XML/RSS but how do i start to do it??

i've tried one using XML/RSS and the whole images appears on the client's side but i think it's not good... what i want is that it appears on the client side limited to say 50.. then they can click next to view next images...

theeper

Is there a reason you want to use XML for this?

joel426

I am working on a simliar solution at the moment.

I have create a website for a rock band ;-)
But I don't have time to admin there site and they are so lazy so I reckon would this be great to let them upload picutre and etc then it just display.

so i done a very long script.

Well it's hard done. I am solving some very strange problem at the moment.

But I can tell you that you can not just use XML alone to solve the problem.

first stop let see my example

Once they finish the upload a PHP script will create a XML file like this

<album title="xxx">
<picture>
<name>YYY</name>
<size>20K</size>
<caption>something about this pic</caption>
</picture>
.... //more <picture></picturer>
</album>

Then go to the display page.

after the parsing (I guess you know how to do it right?)

I get a few array

$photo_album_info = array();
$picture_info["name"] = array();
$picture_info["size"] = array();
$picture_info["caption"] = array();

//on my version there is one more array which is the total xml_files arrray
because each album has it's only xml file.

Now that you get all this info what can you do with it???
You get the total picutres number
$total_picutres = count($picutre_info);

set you offset like you say you want 50
so offset become $offset=50;

get how many pages you have (remeber start from 0)
$total_pages = round($total_picutres/$offset);

from here I think you already get what's the idea.

The page 0 will be
0--> 50

page 1 will be
51 --> 100

and so on and so forth.

I could not give you more detail here sorry since I still haven't finish the entire script (but I do get this function working though)
So use your imagination to finish it.

Hope this help

joel426