Loading AVI movie from Mysql

programming flash
1

How do I load an AVI movie from Mysql database? Say if the database contains the location of the AVI movie which is going on my Flash.

And what should I do in Flash so that I can display the AVI movie on the stage? Do I put a new movieclip and link the movieclip to Mysql database which in turns point it to the location?

2

Storing the location of the file is a good start, but I don’t think that you can load an external .avi file (maybe in 2004 I don’t know) to flash, you do have one option wich is saving in .swf format (the .avi movie) and then being able to load it with the function loadMovie. Good luck!

3

  1. write a php script. from it connect to the mysql database and
    echo the name and path to the avi file.
    like
    <?php echo “avifilename=” . $row[“avifilename”]; ?>

  2. use loadvars in flash to access this php
    oLoadvars = new LoadVars();
    oLoadvars.load(“http://…file.php”);

now you have

oLoadvars.avifilename with filename in flash.

  1. use this in loadmovie
    movEmptyMovieClip.loadMovie(oLoadvars.avifilename);
4

thanks guys! so how do I control the size of the movie? Because it gonna be like 3 avi movies running at the same time on the same stage. Just like front angle, left angle, right angle this stuffs.