Loading images in a movieClip using PHP/MySQL

[Bjørn-Ole Schjølberg]

Loading images in a movieClip using PHP/MySQL
I'm just starting to learn Actioncript, so this may be simple.
I would be very happy if anyone could help me out.

This is my code. It's OK, but I want more.

//instance of movieClip called "imagecontainer" and path to where the image
is
imagefield_01.loadMovie("jpg/my_image01.jpg");

//positioning the second movieclip containing the second image
setProperty("_level0.imagefield_02", _x, 262);

//instance of movieClip called "imagecontainer" and path to where the image
is
imagefield_02.loadMovie("jpg/my_image02.jpg");

This is what I would like to find out:

1. I'm storing the path of the image in a MySQL database. I'm using PHP to
query the database.
This is OK, but how do I get the value of the query in the Actionscript
code?

2. How do I position each image relative to the previous one? The challenge
is that each image may have a different width than the previous and the
next.

3. My plan is to create a fixed number of movieclips. But is there a way to
generate movieclips based on the number of images(paths) returned from
PHP/MySQL?

Thank you so much if you can help me!

Nole

[knut einar skjær]

Bjørn-Ole Schjølberg <bos@botanikus.net> wrote:

> Loading images in a movieClip using PHP/MySQL
> I'm just starting to learn Actioncript, so this may be simple.
> I would be very happy if anyone could help me out.
>
> This is my code. It's OK, but I want more.
>
> //instance of movieClip called "imagecontainer" and path to where the image
> is
> imagefield_01.loadMovie("jpg/my_image01.jpg");
>
> //positioning the second movieclip containing the second image
> setProperty("_level0.imagefield_02", _x, 262);
>
> //instance of movieClip called "imagecontainer" and path to where the image
> is
> imagefield_02.loadMovie("jpg/my_image02.jpg");
>
> This is what I would like to find out:
>
> 1. I'm storing the path of the image in a MySQL database. I'm using PHP to
> query the database.
> This is OK, but how do I get the value of the query in the Actionscript
> code?

You return the value as echo ("my_query_result=$my_query_result"); (You
may have to url_encode or use utf8_encode to get it right in Flash, but
PHP does whatever you need)

>
> 2. How do I position each image relative to the previous one? The challenge
> is that each image may have a different width than the previous and the
> next.

If you want relative positioning, I suggest you get wharever property
you need from the image you place related to (like:

new_y_pos = _root.first_image._y+40;
_root.second_image._y = new_y_pos;

>
> 3. My plan is to create a fixed number of movieclips. But is there a way to
> generate movieclips based on the number of images(paths) returned from
> PHP/MySQL?

That should easily be accomplished by getting a result_count from php.

>
> Thank you so much if you can help me!
>

Your welcome. BTW: This isn't beginners stuff :)

--
Knut Einar Skjær
[url]www.rsd.no[/url]

[Nole]

Hello again. Thanks for replying.

I'm still struggling with how to reference the variable in my script.

I get a variable sent from the PHP scipt. This is OK. It is the right
reference in the Flash file. I've tried to output the variable to a dynamic
textfield and it shows the correct string. My challenge is to reference to
this variable in the correct manner.

If I get a variable like &imagename=../jpg/image.jpg from the php script. In
the dynamic textfield only "../jpg/image.jpg" would appear. Instead of
appearing in the textfield I'd like the variable to be the path of the
image, but I don't know how to write this to get it right.

Do I write:

imagefield_01.loadMovie("imagename");

or

imagefield_01.loadMovie(imagename);

or

imagefield_01.loadMovie("&imagename");

or som other way?

Hope this explains better what I'd like to accomplish.

Bjørn-Ole


""knut einar skjær"" <knut-einar@#ikkedette#rsd.no> skrev i melding
news:1gmrs2g.1qa5ypyzs9mcoN%knut-einar@%23ikkedette%23rsd.no...

> Bjørn-Ole Schjølberg <bos@botanikus.net> wrote:
>

>> Loading images in a movieClip using PHP/MySQL
>> I'm just starting to learn Actioncript, so this may be simple.
>> I would be very happy if anyone could help me out.
>>
>> This is my code. It's OK, but I want more.
>>
>> //instance of movieClip called "imagecontainer" and path to where the
>> image
>> is
>> imagefield_01.loadMovie("jpg/my_image01.jpg");
>>
>> //positioning the second movieclip containing the second image
>> setProperty("_level0.imagefield_02", _x, 262);
>>
>> //instance of movieClip called "imagecontainer" and path to where the
>> image
>> is
>> imagefield_02.loadMovie("jpg/my_image02.jpg");
>>
>> This is what I would like to find out:
>>
>> 1. I'm storing the path of the image in a MySQL database. I'm using PHP
>> to
>> query the database.
>> This is OK, but how do I get the value of the query in the Actionscript
>> code?

>
> You return the value as echo ("my_query_result=$my_query_result"); (You
> may have to url_encode or use utf8_encode to get it right in Flash, but
> PHP does whatever you need)

>>
>> 2. How do I position each image relative to the previous one? The
>> challenge
>> is that each image may have a different width than the previous and the
>> next.

>
> If you want relative positioning, I suggest you get wharever property
> you need from the image you place related to (like:
>
> new_y_pos = _root.first_image._y+40;
> _root.second_image._y = new_y_pos;

>>
>> 3. My plan is to create a fixed number of movieclips. But is there a way
>> to
>> generate movieclips based on the number of images(paths) returned from
>> PHP/MySQL?

>
> That should easily be accomplished by getting a result_count from php.

>>
>> Thank you so much if you can help me!
>>

> Your welcome. BTW: This isn't beginners stuff :)
>
> --
> Knut Einar Skjær
> [url]www.rsd.no[/url]

[knut einar skjær]

Nole <bos@botanikus.net> wrote:

> If I get a variable like &imagename=../jpg/image.jpg from the php script. In
> the dynamic textfield only "../jpg/image.jpg" would appear. Instead of
> appearing in the textfield I'd like the variable to be the path of the
> image, but I don't know how to write this to get it right.
>
> Do I write:
>
> imagefield_01.loadMovie("imagename");
>
> or
>
> imagefield_01.loadMovie(imagename);
>
> or
>
> imagefield_01.loadMovie("&imagename");

You are very close to get this working! If you can see your variable in
Flash, its just a matter of placing it right, and your done. Sounds a
litle strange to me that you have the "&" attached to your variable, but
that can be something in your php-script.

Can you show me the code you've been using so far? As I told you, I
think you almost got it, but its difficult to tell you where the problem
is whithout seeing the code.

--
Knut Einar