[FMX]MySql Data In Flash

Export Querries From Flash 8 To MySQL And Import Data From MySQL
Hi friends,
I am making a web site for a customer and i need to import data from MySQL Database but i don't know how to do it.
I would appreciate it if somebody could give me an idea or tell me where to find a tutorial.
Also i heard that there is a .dll file that Macromedia made, in order to make it easier to connect Flash with Databases, is that true ?

View Replies !    View Related

---

DATA From Flash To MYSQL Via Php
hello
i find a script for a form in flash, then i send data come in by the internaute into mysql.
or a tutorial
thanks you
alinovitch

View Replies !    View Related

---

Getting Data From Mysql To Flash
hi

plesas visit the following link http://www.eurorelais.co.uk/ and you found that (Find your holiday home)a map with some data getting from mysql using php.

anybody explain how to do this in flash.

i already use the examples which is availabe kiruba.com in flash.

i need this very urgently.

i know PHP and Flash intermediately

Thanks

Regards

V.N.Gnaneswaran

View Replies !    View Related

---

[FMX]MySql Data In Flash
Hi,

I'm busy with a real estate site and some of the data is coming from a MySql database. It are the three latest properties (three titles, three comments and three Images). I'm using this script:
Code:
myData = new LoadVars()
myData.load("properties.php")
myData.ref = this
myData.onLoad = function(succes){
if(succes){
for(var i=0; i<this.cant; i++){
this.ref["Title_txt"+i].htmlText = "<b>"+this["Title"+i]+"</b>"
this.ref["Comments_txt"+i].text = this["Comments"+i]
this.ref["holder_mc"+i].loadMovie(this["Image"+i])
}
}
}
stop()
The information is related to three .cfm pages. So what I need now is a getURL script insite the excisting script. When sombody press the first Image and/or comment newproperty1.cfm should open. and the same for 2 and 3.Is there please somebody who can help me with this?

Thanks in advance

View Replies !    View Related

---

DATA From Flash To MYSQL Via Php
hello
i find a script for a form in flash, then i send data come in by the internaute into mysql.
or a tutorial
thanks you
alinovitch

View Replies !    View Related

---

[F8] Display MySql Data In Flash?
I have a mySql database with a table called sites which has 3 fields:
id, name and link

I have a flash file with 3 dynamic text boxes:

id_text, name_text and link_text

How do I input the mySql table information into flash?

View Replies !    View Related

---

[CS3][AS2] Loading Data From Flash Into MySQL: Help?
I am looking for a method to read Flash variables into PHP and from there into mySQL databases, in order to populate a database with information created within the Flash file. Already figured out how to do it the other way - loading information from mySQL into Flash. Any tutorials or hints would be greatly appreciated

View Replies !    View Related

---

Passing MySQL Data To Flash (using PHP)
Hi, I suppose I am really checking my theory here and seeing if I'm thinking along the right lines.

I have a flash site, consisting of galleries, and text based content. I am building a CMS in PHP with MYSQL to add and update content, upload images etc. This is the simple part.

I want to populate a flash site with this data, now working from what i have read, and understanding so far, when we want to display data in flash i can do this using XML, or a text file loading as variables. Now when this file is requested form the server it takes time to load (and as we are using PHP to effectively build this file from a recordset) we cannot know when the whole file has loaded, or been processed from the server, and if we try and start loading from this half formed file we won't get the output we want, effectively it will break and not load properly, so i thought if was to add an additional variable, or xml value to the bottom of the outputted content/document which i can then either listen for, or run a loop checking for the value, once it is present i can then run all my scripts to display the content.

Is my train of thought in the right direction.

Thinking about moving forwards and building this, i've come to the conclusion that i can suss this in a few stages, load in xml/variables and display after a value is found (this will be with an already created xml/text file) then replace this with the php generated file, run it off the server and see what happens...

Any input please that may save me time, or perhaps even a tutorial i should look at.

Many thanks in advance.

Matt

View Replies !    View Related

---

Display MySQL Data In Flash
Hi,

I'm new to this forum so hello all and I hope i'm posting in the right place! I have a independent record label and need a way to display my releases for each month from a database. I have some experience using flash but am struggling with the best way to implement this. I found a tutorial that does almost exactly what I need and would really appreciate some help modifying it:

http://www.adobe.com/devnet/flash/ar...sh_xmlphp.html

I have set up a database and, in keeping with the tutorial, was intending to use PHP to convert the data into XML before it goes to Flash. The process is as follows:

1. Select a Month from drop down box in flash movie dynamically populated from database. (This is done already)

2. Get results (i.e. songs released that month) from database:

SELECT releaseDate, track, artist from databaseName WHERE month LIKE (whatever month is selected)

3. Send these back into Flash and display all the releases for that month. I do not know how many releases there will be so i need a looping system that keeps adding results until there are no more left. The original tutorial mentioned above uses a datagrid but it does not allow very flexible styling so it isn't an option for me.

The information i need to display for each release that month is:

- Release Date (a specific date - not just the month)
- Track
- Artist

So basically all i need is to know how to modify the tutorial so the data is displayed in dynamic text boxes instead of the datagrid. I would be really grateful for any help.

After this is working I also wish to add:

- Play/stop button (that uses link to MP3 file stored in database)
- Vote button (adds 1 vote to the database)

Is this a lot more work? I am willing to pay for this part if so.

Thanks a lot guys

View Replies !    View Related

---

Data Integrity Between Flash And Mysql
I am working on a very simple online application that allows users to create, edit, and delete notes.

The notes exist in a mysql table and are ported to flash using the remoting component and php.

My main concern is the integrity of the data as it is being manipulated in a local dataset component first and then sent to mysql for updating.

Here are the methods I’m currently using, please feel free to let me know if you’ve got any helpful hints.

1. A typical submit button that trigger the send data method.
2. A setInterval that triggers the send data method every 20 seconds
3. An on change function that triggers the send data method when a user changes from one record to another.

As long as the user is moving around the records I am safe. My main concern is what happens when and if they leave. Because this application is meant to be displayed in a browser popup window, I really have no way to know when they shut their browser or when they close the popup.

Any suggestions or am I making a big deal out of nothing?

Thanks a lot,
Ward

View Replies !    View Related

---

MySQl And Flash - How To Read In The Data Using Php?
i've got a mySQL database that i've just started learning to use.
i've also been working on a flash file that reads in and displays data contained in a text file. i use php to do this.

both are working independently, but i can't figure out how to tie them together. all i really need to do is read in the mySQl database info, and get that data into variaables that flash can manipulate. i'd like to use php to do this. are there any relevant tutorials?

View Replies !    View Related

---

Data List In Flash MX With PHP & MySQL
Helloes all!

Im working on a Flash site and I need to use a MySQL data base for it. I've never worked with that much programming before and Im having trouble now..

What I need is to make a list of movie titles that would be buttons. Now, I understood how to make a list by creating dynamic text fields using AS only i don't know how to make them buttons, since the fields only exist in my AS code. Is there a possibility to do that? Or at least to create each text field inside a movie of its own that would have a transparent button over it? But then I need to create that button in AS as well.. ahh!!

Here's the code I have so far:


ActionScript Code:
limit = 12;
l = new LoadVars();
l.load("http://intranet:7331/get.php");
l.onLoad = function() {

myy = 30

myTextFormat = new TextFormat();
myTextFormat.font = "MyArial";


_root.createEmptyMovieClip("mymovie",500);

for(i=0; i<limit; i++){
            mytextfield     = "mytextfield" + (i)      
            _root.mymovie.createTextField(mytextfield,i,30,myy,300,18);
           

            _root.mymovie[mytextfield].embedFonts = true;
            _root.mymovie[mytextfield].setNewTextFormat(myTextFormat);
            _root.mymovie[mytextfield].setTextFormat(myTextFormat);
            _root.mymovie[mytextfield].border = false;
            _root.mymovie[mytextfield].text += +this["title"+i]+" ("+this["date"+i]+")";

            myy+=18
    }
    myscrollpane.setScrollContent(_root.mymovie);
    }

If anyone could help it would be very much appreciated

View Replies !    View Related

---

Reading MYSql Data In Flash
Hi,

I'm newbie to flash. My boss gave me some flash files designed by some designers and asks me to retrieve some information from mysql database into a text box.

I have gone thorugh some tutorials in this site and figured out how to export data into an xml file and how to retrieve it within flash.

But to my bad luck, it's not a single flash file but of several files.

The task is
+ in the file 1 there are some menu buttons.
+ when I click this menu the text box in file2 or file 3 has to be populated with data from mysql

My problem is I don't know how to refer the text box of file2 in file 1

The designer has simply used the following scripts


PHP Code:



on (release) {    loadMovie("file2.swf",1);} 




The above script simply loads the file2

This swf file has same width & height as file1 and it goes behind the file1 (the menus are visible on the top)

All I want to know is how to change the text in file2->textbox when clicking button in file1

Thanks a lot for your time

Cheers
Ahmad
Hong Kong

View Replies !    View Related

---

MySQL Data Into Flash Via PHP Problem
Hi everyone,

I've been making flash based websites recently with a simple PHP and MySQL backed CMS. The only problem I'm getting is when the text is loading from the database into the dynamic textfield in the flash movie, it prints either 'false' or '_level0...'

It isn't a serious problem, the text does eventually load correctly, it just looks ugly and unproffessional. Does anyone know of any way I can get it to print LOADING instead of these two or something similar?

Cheers,

View Replies !    View Related

---

Displaying Mysql Data With Php In Flash
Hi
Im new here in thís forum, my problem is how to display the all rows from one table in MySql in one dynamic text field in flash using PHP?

thank you

View Replies !    View Related

---

How To Edit MySQL Data In Flash? :(
Hello, Are there any tutorials on how to edit MySQL databases, with flash?
I think you can only do this if you use php, (Including the php file with AS in flash)

Or maybe someone could help me, Say you would write in some information, such as 'John' then in the MySQL database, called 'name_test', it would edit the table called 'test' and submit a new piece of information, that would display John.

Thanks ;[

View Replies !    View Related

---

Showing Data From Mysql In Flash?
Hi,i just found this site and first i have to tell that this is a great site.
congratulations,where i look it looks so clean,respect!
Then to my question since i don´t seem to get it.
My big problem is that i can´t make it work to show data from mysql in flash.
My question is if in html the var to use is for example $title.
I have a phpnuke site which works with templates.
Im making a flashtheme and would like to show the titles in flash.
any good explaination with that loadvariables cauz i dont seem to get it and what file i need to load?mainfile so where the connection is made or can i call to theme.php where i declaree the title or to mainfile where i declare the function?
im a bit lost plzz hellp
and what i should put in the var ? $title for instance.
plz help

View Replies !    View Related

---

Display Mysql Data In Flash
I have a .php file that displays 20 images from a mysql database. These images are the avatars of 20 users, and when you click on the image... you are taken to the user's profile. I wanted to know how to display these 20 images in flash. I have wrestled with this issue for months, but never found a solution. I didn't know if amfphp was the best way to go, or if someone here would know.

Currently the images are resized in a poor fashion, but I would like to use something like the GD Library so that they are cropped properly. I wanted to have one movie clip in flash that increments in an i++ fashion 20 times, so that when I am editing the flash movie I don't have to make 20 edits...

The .php file is located here: http://www.defymedia.com/screen.zip

If anyone can help I would GREATLY appreciate it!!

Thanks!

View Replies !    View Related

---

Show Data From Mysql In Flash
I am new with flash scripting can anybody guide me in step how should i view records of mysql database in flash stage

View Replies !    View Related

---

INserting Data From Flash Into A MySQL Database HELP
Hello,
I am trying to post data from a flash game into a Mysql database using PHP.
I have written the insert PHP file which works fine with a HTML form but as soon as I try to get it to work from flash
nothing happens......
This is the code in the flash file


on (release) {
loadVariablesNum ("http://www.spiked.tv/stuff/test.php", 0, "POST");
}

Any Ideas Help etc


Regards

Christian

View Replies !    View Related

---

[F8] Best Method For Passing MySQL Data Into Flash?
Here is the scenario. I have an FMS application that can record an FLV from a webcam and save it to the server with a unique name. At the same time I have a form which allows the user to send an email out with a URL that will play the video the user just recorded. I had originally just added the unique file name of the FLV as a string variable in the URL and passed it as a FlashVar via PHP. Now, I want to pass more information about the video and other components than is allowed with the GET method (ie a paragraph of text). So, I created a MySQL database with a table that stores about 10 values for each FLV that is sent out via email. I have that work properly via PHP. Now my question is what is the best method for this situation for retrieving the data from MySQL and passing it into Flash? I know I could retrieve all of the value from MySQL via PHP if I pass the unique ID number in the URL, but would passing all 10 variables as FlashVars into Flash be an acceptable solution or should I move onto an XML or other type of solution?

If you know of any examples/tutorials please post the links as well.

Thanks!

View Replies !    View Related

---

[MX04] How To Display Mysql Data In Flash?
I have a database with these fields:
userName/ID (user's name)
userMail (user's registered email)
userPass (user's password)
FriendInv (number of friends)

I would like to know how I can display this information into flash using one frame preferrably and dynamic text fields....

View Replies !    View Related

---

Getting Data From PHP/MySQL To Show Up In Flash In Certain Format.
Hey guys first time post here. Need some help.

We are working on a senior capstone design project and we have a flash based restaurant menu. We currently have a php file that will add items and prices to a check (one on top of another) and tally them up for a total.

This is all done with the click of a flash button. However, although it displays in php, we can not get it to display in flash. Do we have to use seperate dynamic text boxes? or can we use 2 large dynamic text boxes (one for items and one for price)

basically, when we press on a button (say cheesburger), and then press again, it should keep piling them on top of each other and adding them up.

Any tips or advice would be great!

View Replies !    View Related

---

Retrieve Data From MySQL And Show In Flash
Hi.

Before I start, I will say that I have searched these forums, Flash Kit and Google, but every tutorial I get is really complicated. I have done this before, but cannot remember how.

I have a database, and I just want flash to connect up to it and retrieve 4 values [id, date, venue & city]. I then want these shown in a flash movie. There is more than 1 record in the DB, but I will be limiting the results to 1 that is = or > than todays date.

Can anyone tell me how to do this, or point me somewhere that will.

I do not need the flash movie to insert info to the datbase.


Thanks
Günter

View Replies !    View Related

---

Can Flash Be Used To Show MySQL Database Data?
Can Flash be used to show mySQL database data? is there an online tutorial that I can check out from somewhere?

View Replies !    View Related

---

Uxxxx Data From MySQL, To PHP, To Flash...what's Wrong?
Hi Gang:
I have a mySQL (4.0) table with chinese unicode characters encoded in the uXXXX format.

When I receive the strings from PHP, they print in their unescaped form, i.e uXXXX, instead of the actual character. However, if I just type in the code, like:

field.text = "uXXXX";

Then the character displays, no problem.

Here is the actionscript, any help is greatly appreciated...

function showContent() {

var txtHanzi;
txtHanzi = this["hanzi0"] ;
content.text += txtHanzi + "
";
}


var c = new LoadVars();
c.onLoad = showContent;


c.load("http://www.shufawest.us/test.php4");

View Replies !    View Related

---

Loading [mySQL] Text Data Into Flash
Hi all,

Was wondering if anyone could help.

I am trying to load text data from a mySQL database into flash mx.

I have a textboxwith an instance name of 'Results' that receives the info from php.

Does anyone know the best way to code the php?

code:

<?php

$db = mysql_connect("localhost", "benbaker",'********');

mysql_select_db("benbaker",$db);

$result = mysql_query("SELECT * FROM pets",$db);


?>

At the moment this comes up in Flash with all of the variables and with %20 where there should be spaces...

My flash file contains one frame with with this code on it:

myLoad = new LoadVars();
myLoad.onLoad = function(done){
if (done){
Result.text = myLoad
} else {
trace("something went wrong");
}
}

myLoad.load(".../PHP/dogs.php");

View Replies !    View Related

---

MySql Data Extraction Into Flash Without A Txt File?
Hi guys :

Heres the situation. I have a page (call it name.php) that lists profiles for users that have registered on the site. It scrolls through a database and displays the data as a table.

The name of the user also acts as a link to another php file (call it profile.php) that sends the name ie :



PHP:--------------------------------------------------------------------------------
<a href='profile.php?name=$name'>

--------------------------------------------------------------------------------


When this is passed to profile.php it pulls down all the data and formats it so that flash can read it as strings. Now the problem that is causing me to go bald(!). The flash movie sits on another page (call it flashname.htm) and this uses :


PHP:--------------------------------------------------------------------------------
loadVariablesNum ("profile.php", 0, "GET");

--------------------------------------------------------------------------------


There are a number of dynamic text fields that are then populated with the data that the flash movie pulls down. I was hoping that the profile.php page could format the data and then insert the data into hidden text fields so that when the php has been processed, it just redirects to the flash movie. However this doesn't work as the flash movie calls the profile.php page and not the other way around. If I use the hidden text fields with profile.php, the data that flash calls is incorrect as it not only displays the php variable, but it also displays the html code for the hidden text field it resides in as well.

The only way my tiny brain can think of to resolve this problem is to to get name.php to pass the name variable directly to flashname.htm, which in turn passes the the variable to profile.php and then flashname.htm calls profile.php for the data. But I don't know how to achieve this.

I can't seem to find a way to resolve this issue. Any help appreciated!

View Replies !    View Related

---

Using Flash And PHP To Submit Data To A MYSQL Database.
Hey there. I'm fairly new to flash and AS as well as to this site. My first big(er) project I have undertaken is designing a flash registration system that takes form data, sends it to PHP which then sends it to a MySql DB.

I successfully made a working(I think) FLA with everything. There seems to be a problem with the data transfer from flash to PHP. As far as I can tell the PHP part works. I've been working on this for a while, not quite sure where to turn now, so I thought I'd turn to outside help. Could one of you guys kindly tell me what I'm doing wrong? I'm code savvy on an OK level with PHP so I can take explanations on a somewhat deeper level.

Ok, so, I am using URLVariables to (hopefully) send a retrive the vars. Here is my code:

Actionscript Code:






Original
- Actionscript Code





var scriptRequest:URLRequest = new URLRequest("http://localhost/reg.php");

var scriptLoader:URLLoader = new URLLoader();

var scriptVars:URLVariables = new URLVariables();

scriptRequest.method = URLRequestMethod.POST;
scriptRequest.data = scriptVars;


stop();
status_txt.text = "";
submit_btn.addEventListener(MouseEvent.CLICK, form);
function form(event:MouseEvent):void
{







//validate form fields
if(!cfirst_txt.length) {
status_txt.text = "Please enter your childs first name.";
} else if(!clast_txt.length) {
status_txt.text = "Please enter your childs last name.";
} else if(!gender_txt.length) {
status_txt.text = "Please enter your childs gender.";
} else if(!bday_txt.length) {
status_txt.text = "Please enter your childs birthday.";
} else if(!grade_txt.length) {
status_txt.text = "Please enter the grade your child just completed.";
} else if(!tss_txt.length) {
status_txt.text = "Please enter your childs T-Shirt size.";
} else if(!pn_txt.length) {
status_txt.text = "Please enter your name.";
} else if(!addy_txt.length) {
status_txt.text = "Please enter your address.";
} else if(!city_txt.length) {
status_txt.text = "Please enter your city.";
} else if(!hphone_txt.length) {
status_txt.text = "Please enter your home phone.";
} else if(!email_txt.length) {
status_txt.text = "Please enter an email address";
} else if(!validateEmail(email_txt.text)) {
status_txt.text = "Please enter a VALID email address";
} else if(!ecn_txt.length) {
status_txt.text = "Please enter an emergency contact name.";
} else if(!ecp_txt.length) {
status_txt.text = "Please enter an emergency contact phone number.";
} else if(!ss_txt.length) {
status_txt.text = "Please enter your Sunday School information.";
} else if(!med_txt.length) {
status_txt.text = "Please enter your childs medical information.";
} else if(!pickup_txt.length) {
status_txt.text = "Please enter who may pick-up your child.";
} else
scriptLoader.addEventListener(Event.COMPLETE, handleLoadSuccessful);

scriptLoader.addEventListener(IOErrorEvent.IO_ERROR, handleLoadError);
scriptVars.child_first = "cfirst_txt.text";
scriptVars.child_last = "clast_txt.text";
scriptVars.child_gender = "gender_txt.text";
scriptVars.child_birth = "bday_txt.text";
scriptVars.child_grade = "grade_txt.text";
scriptVars.child_size = "tss_txt.text";
scriptVars.parent_name = "pn_txt.text";
scriptVars.parent_address = "addy_txt.text";
scriptVars.parent_city = "city_txt.text";
scriptVars.parent_home = "hphone_txt.text";
scriptVars.parent_work = "work_txt_txt.text";
scriptVars.parent_cell = "cell_txt.text";
scriptVars.parent_email = "email_txt.text";
scriptVars.eme_name = "ecn_txt.text";
scriptVars.eme_phone = "ecp_txt.text";
scriptVars.sunday_school = "ss_txt.text";
scriptVars.med_info = "med_txt.text";
scriptVars.pick_up = "pickup_txt.text";


scriptLoader.load(scriptRequest);



function handleLoadSuccessful($evt:Event):void

{
gotoAndStop(2);
status_txt.text = "Registration Submitted.";

}



function handleLoadError($evt:IOErrorEvent):void

{

status_txt.text = "Registration Failed for some reason. Please try again.";

}

}
function validateEmail(str:String):Boolean {
var pattern:RegExp = /(w|[_.-])+@((w|-)+.)+w{2,4}+/;
var result:Object = pattern.exec(str);
if(result == null) {
return false;
}
return true;
}






 var scriptRequest:URLRequest = new URLRequest("http://localhost/reg.php");       var scriptLoader:URLLoader = new URLLoader();       var scriptVars:URLVariables = new URLVariables();            scriptRequest.method = URLRequestMethod.POST;      scriptRequest.data = scriptVars;               stop();      status_txt.text = "";      submit_btn.addEventListener(MouseEvent.CLICK, form);      function form(event:MouseEvent):void      {                                    //validate form fieldsif(!cfirst_txt.length) {status_txt.text = "Please enter your childs first name.";} else if(!clast_txt.length) {status_txt.text = "Please enter your childs last name.";} else if(!gender_txt.length) {status_txt.text = "Please enter your childs gender.";} else if(!bday_txt.length) {status_txt.text = "Please enter your childs birthday.";} else if(!grade_txt.length) {status_txt.text = "Please enter the grade your child just completed.";} else if(!tss_txt.length) {status_txt.text = "Please enter your childs T-Shirt size.";} else if(!pn_txt.length) {status_txt.text = "Please enter your name.";} else if(!addy_txt.length) {status_txt.text = "Please enter your address.";} else if(!city_txt.length) {status_txt.text = "Please enter your city.";} else if(!hphone_txt.length) {status_txt.text = "Please enter your home phone.";} else if(!email_txt.length) {status_txt.text = "Please enter an email address";} else if(!validateEmail(email_txt.text)) {status_txt.text = "Please enter a VALID email address";} else if(!ecn_txt.length) {status_txt.text = "Please enter an emergency contact name.";} else if(!ecp_txt.length) {status_txt.text = "Please enter an emergency contact phone number.";} else if(!ss_txt.length) {status_txt.text = "Please enter your Sunday School information.";} else if(!med_txt.length) {status_txt.text = "Please enter your childs medical information.";} else if(!pickup_txt.length) {status_txt.text = "Please enter who may pick-up your child.";}  else scriptLoader.addEventListener(Event.COMPLETE, handleLoadSuccessful);       scriptLoader.addEventListener(IOErrorEvent.IO_ERROR, handleLoadError);      scriptVars.child_first = "cfirst_txt.text";      scriptVars.child_last = "clast_txt.text";      scriptVars.child_gender = "gender_txt.text";      scriptVars.child_birth = "bday_txt.text";      scriptVars.child_grade = "grade_txt.text";      scriptVars.child_size = "tss_txt.text";      scriptVars.parent_name = "pn_txt.text";      scriptVars.parent_address = "addy_txt.text";      scriptVars.parent_city = "city_txt.text";      scriptVars.parent_home = "hphone_txt.text";      scriptVars.parent_work = "work_txt_txt.text";      scriptVars.parent_cell = "cell_txt.text";      scriptVars.parent_email = "email_txt.text";      scriptVars.eme_name = "ecn_txt.text";      scriptVars.eme_phone = "ecp_txt.text";      scriptVars.sunday_school = "ss_txt.text";      scriptVars.med_info = "med_txt.text";      scriptVars.pick_up = "pickup_txt.text";                   scriptLoader.load(scriptRequest);               function handleLoadSuccessful($evt:Event):void       {          gotoAndStop(2);          status_txt.text = "Registration Submitted.";       }               function handleLoadError($evt:IOErrorEvent):void       {           status_txt.text = "Registration Failed for some reason. Please try again.";       } }function validateEmail(str:String):Boolean {var pattern:RegExp = /(w|[_.-])+@((w|-)+.)+w{2,4}+/;var result:Object = pattern.exec(str);if(result == null) {return false;}return true;}



Ok, so as You can see the movie is waiting for a mouse click on a button then runs the function "form". That includes an error check and, if all goes well, a "scriptLoader.load(scriptRequest);" which goes with this:

scriptRequest.method = URLRequestMethod.POST;

I think any problems I'm having are in the AS since it appears that my PHP works. If you want/need to see the PHP for submitting the data to SQL than I'll post that. I can also post the FLA after I get 5 posts

Thanks guys,
Nathaniel

View Replies !    View Related

---

Loading PHP Or Data From Mysql Database Into My Flash Movie
Hi

Im currently building a flash site which will replace a html site... There has been an admin part of the old site set up in which we can input information into and it displays the information on the page http://www.acusis.co.uk/v2/giglist.php

It uses a mysql database stored on the server.

I would like keep to admin part running and load the information on this page into my flash movie or just load the page into my flash movie, so that it can still be used... I'm relatively new to flash so any help would be much appriciated.

Does anyone know how I can do this???

Cheers

Marc Bernard

View Replies !    View Related

---

Posting Data To PHP/MySQL Database Via Flash Forms.
Hi, Can anyone direct me or guide me through as to how I can send some text in a dynamic flash textfield to a mySQL database and vice versa?

Basically I've created a text field - assuming it has to be dynamic (with an instance name of "tUserdata"), it's going to be multiline text, and upto 255 characters. As the user clicks the submit button, the data held in the flash text field is sent to the mySQL database and stored there. I understand that i have to use PHP as well - and heard i need to use the loadVars function.

Could anyone help me especially with the coding in PHP and connecting to a MySQL database, and what actionscript i need to insert.... it probably sound really easy for u guys.

View Replies !    View Related

---

How Do I Save Data To Mysql And How Do I Make A Table In Flash
how do i save data to mysql and how do i make a table in flash

View Replies !    View Related

---

Passing Large Amount Of Data To Flash From Mysql...
What is the best method to go about this?

Pass each thing through GET? example: &var1=hi&var2=bye&etc...
Pass an XML string through GET?
Make an XML file and then read that file in? (I feel this isn't as secure)

Any suggestions?

View Replies !    View Related

---

How Do I Save Data To Mysql And How Do I Make A Table In Flash
how do i save data to mysql and how do i make a table in flash

View Replies !    View Related

---

Flash PHP MySQL - Submit Form Data To Database
I'll start it off

Learn how to set up a mySQL database, a Flash form, and a PHP page which will submit the Flash data into your database.

http://digitalosophy.com/experiments.../dbInterv2.zip

View Replies !    View Related

---

Loading MySQL Data Into Flash Text Fields
Hey, I'm trying to load two fields from a MySQL database into one dynamic text field in Flash.

I use a PHP script to move the data from MySQL to Flash and Flash uses the PHP to load the data.

Heres the PHP script...

<?PHP
//Connects to the database
$link = connNBT();

//Get the stories from the mysql database
$query = "SELECT story, UNIX_TIMESTAMP(date) FROM newsTable ORDER BY date ASC ";
$result = mysql_query ($query)
or die ("Query failed - $query");

$i = 0;
$returnData = "";
while( $myrow = mysql_fetch_row($result) ) {

$story = $myrow[0];
$date = date("F j, Y", $myrow[1]);

$returnData .= "&story" . $i . "=" . $story . "&date" . $i . "=" . $date . "&";
$i++;
}

mysql_close ($link);

$data = "num=$i&" . $returnData;
echo $data;

//Function to connect to database
function connNBT() {
$link = mysql_connect ("localhost", "username", "password")
or die ("Could not connect");

mysql_select_db ("databasename")
or die ("Could not select database");

return $link;
}
?>



...and heres the actionscript I have in the first frame of my Flash movie...


function getStory() {
var myStories = new LoadVars();

myStories.onLoad= setStories;
myStories.load("storyEngine.php",myStories,"POST");
}
function setStories() {
if( this.num != "" ) {
for(var i=0; i<this.num; i++) {

displayNews.htmlText = this["story"+i];


}
}
}



____

Can somebody tell me why Flash isn't loading the MySQL data??

View Replies !    View Related

---

Loading MySQL Data Into Flash Varibles To Use In AS... SIMPLE WAY NEEDED
Hey,

I'm making a "Who am I?" game where people input some data about themself's when they signup... Then in flash, I need a way to get the data into varibles... SImple varibles that I can compare and do usual AS on. Is there a simple way to do this?

If anyone has a working script done that would be great for me to use.

Thanks,

Alex

BTW Here is my database setup:

whoami
Table comments: Created by phpFormGenerator

Field Type Null Default
id int(10) No
Username text No
FirstName text No
LastName text No
Class text No
Email text No
Password text No
SomeInfoAboutYourSelf text No
Comments text No

View Replies !    View Related

---

Including Data From Mysql Into Flash Dyanmic Text Field?
Anyone know how I can go about doing this? Sorry, I'm such a newbie @ Flash!

http://www.bowarren.com/home.php is the page I'm working on. I want the dyanmic text field in the middle to grab data via PHP from a mysql database. I just don't have a clue where to begin.

Any help is greatly appreciated.

Thx,
jp

View Replies !    View Related

---

Use Form To Query MySQL DB, Then Pass Data To Flash File?
Say I have a form (form.html) that asks for a login name and password.
It then queries a mysql db via php (login.php) and if there's a match, then the user is taken to a page (welcome.php) with an embedded flash file (hello.swf) in which it says Hello [username].

If I could get just that far, it would be great. I'm getting confused on a number of things but most notably what kind of text box I'd use in the flash file (dynamic or input) and what method to use pass the variable. I mean if I were doing this as a regular php page (Hello [username]) then I know how to print the name in the new page but I'm clueless when flash comes into play

View Replies !    View Related

---

Inserting Data To Mysql Database Trough A Flash Form - Combobox Script Not Working
Hi, im trying to build a flash form that pass som data to a mysql server database i´ve been reading some tutorials and i made the actionscript for the submit(=grabar in spanish) button so that it colects data and send it to the server. (i have a form with textfield that is where people enter data, and 2 combobox, one for selecting a person´s name and the other to select a place).

but im having the same record duplicated on the database, but, the first record is complete and the duplicate it´s the same but for the two selections of the 2 combobox that are missing. As a result of running the form an loading data normally i then get on the database 2 records added the are equal but one of them has no combobox data.

I think the problem is definitly the combo box code that i use cos after using it the script worked perfectly maybe someone can help me with it. And also i ´ve found some tutorials for showing a mysql database content with flash but they are really difficult, some of they se PHPObject and others just tones of actionscript code, isn´t an easyier way for doing it??

Here´s the script:

on (release) {

if (apellido =="") {
status = "Debe llenar el apellido del cliente!";
} else if (nombre =="") {
status = "Debe llenar el nombre del cliente!";
} else if (fecha =="") {
status = "Debe llenar la fecha de la entrevista!";
} else if (hora =="") {
status = "Debe llenar la hora de la entrevista!";
} else if (asunto =="") {
status = "Debe llenar el asunto del cliente!";
}else{
userData = new LoadVars();
userData.apellido = apellido;
userData.nombre = nombre;
userData.telefono = telefono;
userData.dni = dni;
userData.fecha = fecha;
userData.hora = hora;
userData.asunto = asunto;
userData.abogado = "";
userData.donde = "";

userData.abogado = abogado_cb.getValue();
userData.donde = donde_cb.getValue();

userData.send("inserta.php", "this", "POST");
getURL("inserta.php","this","POST");
status = "Datos Guardados!";
apellido = "";
nombre = "";
dni = "";
telefono = "";
fecha = "";
hora = "";
asunto = "";

}
}


Thanks.
Emilio

View Replies !    View Related

---

Getting MySQL Field Data Into Dynamic Text Field In Flash
Hi, im having some trouble as to how to retreive data from a mySQL database field and putting the values into a dynamic text field in Flash... im quite new to this so any help will be appreciated! thanks.

View Replies !    View Related

---

My Last Cry Of Help - Data From MySQL Using PHP Help
Well ... I have NO idea what the hell is going on, so maybe someone can help me.

I have a movieclip that has this code upon it ...


Quote:




for (i=0; i<posts; i++) {
duplicateMovieClip(_root.sectionholder.newssystem. newscon, "newscon"+i, i);
setProperty("newscon"+i, _x, 0);
setProperty("newscon"+i, _y, i*80);
this["newscon"+i].title = [title+i]+" - POSTED BY"+[postedby+i];
this["newscon"+i].date = [date+i];
this["newscon"+i].post = [post+i];
}






The problem is the variables. INSIDE the movieclip I have some dynamic text fields, just as construction aids, and all the variables are in them and present.

They are loaded using a PHP file from a MySQL database, this is the file and its output - http://www.sekka.co.uk/clients/bp/system_getnews.php

BUT .. in the code above, the variables are empty. I have tried both [title+i] and [this.title+i], but both come up blank.

---------------------------
Edit: I tried this,

this["newscon"+i].post = post0;
post0 is what [post+i] should be, and that code altered works, as in shows the data. why does [post+i] not work?
---------------------------

Why oh why is beyond me, please help me. I will be done when this is sorted!

Thanks in advance.

N.B. I know the setProperty is old, but if I use this.["newcon"+i]._x = 0"; it doesnt work.

View Replies !    View Related

---

Get The Data From MySQL
Hi,

I develop a simple animation in flex3 using actionscript 3.0 and also have MySQL database for storing of movement. I want know what is the fast way to get the data from mySQL. I know using AS3.0 with PHP is one way but is there any faster way, can AS3.0 directly talk to MySQL?

Thank.....

View Replies !    View Related

---

Getting Data From MySQL
I'm a web developer that is familiar with PHP and MySQL. I just started working with a guy who has created a site in Flash for a client, and I've created the backend in PHP. It was understood that all I'd have to do would be to PUT information into the database and he'd pull it out on the site. Things have changed and I've been asked to pull the data down for him.

I've Googled to find out that it's possible to get data from MySQL into Flash via a textfile formated as such: 'myVar=[data]'. I don't know the specifics, but I can figure that all out. However, I have two particular questions regarding the data:

1.) How does Flash handle HTML formatting? The CMS I've written allows an administrator to input plain HTML and I store that in the database; how will that translate into Flash? Does Flash have an HTML parser? I've been having trouble filtering through searches on Google about using HTML to put Flash on a page instead of Flash parsing HTML. I read on another forum that Flash has an HTML 1.0 parser, but the post was dated August 2003.

2.) I've also been storing images as BLOBs in MySQL. How do I go about pulling these images out? Of the tutorials I've found on Google, all I can hit with my searches are scenarios in which people store image paths in the database, and output them in the same textfile, 'myImage=/images/image.jpg' etc. [url=http://forums.devarticles.com/web-development-40/flash-mysql-longblobs-9659.html]This unanswered forum post off-site[/url], is similar to what I'm trying to do, but I'd need to display many images in a flash movie and I don't think passing them via src would work.

I'm not necessarily asking for complete solutions for these problems, I just need to be pointed in the correct direction, maybe a function or a document I'm missing.

View Replies !    View Related

---

Show MySql Data
Hello

I am a bit confused about all the defrent ways i can show data from database with flash.
There is the Remoting, and amphp Remoting, or use component, or just dynamic text with php.

What is the best way?
hould i use or buy remoting?

Please help. Confused Adi.

View Replies !    View Related

---

Assigning MySQL Data
OK, lets see if I can explain this correctly.

I have a move clip called 101.
I have...
onClipEvent (load) {
loadVariables("you.php", this, "GET");
}
assigned to 101. Inside of 101 I have dynamic text fields with the var names of price, fee, and state.

I have a movieclip 102 that is exactly like 101. What I need to know is, how can differentiate 101 from 102 so that when the db data comes in that 101 and 102 display different info?

Also, I can't change the var names. They must stay as price, fee, and state in both movieclips.

Please give me a hand with this, it is very urgent. If you need more info please ask. Thanks!

View Replies !    View Related

---

Need A Way To Just Display Mysql Data
Please,

I need a way that I can run querys from Flash-PHP-Mysql and Mysql-PHP-Flash.

I'm pretty sure this is easy to do, but I havent found a good tut that would be flexible enough to run with my app.

I was thinking if I had differnt PHP files for differnt querys: INSERT, UPDATE, DELETE etc.

Could someone clerfy this for me?

Like I want Flash to send a varible to PHP. Then run a query in which record has the clue that you have choosen. Then send the data back to flash, so I can compare them and such.

Thanks!

View Replies !    View Related

---

Data FROM Datagrid To MySQL
I have no problems populating a datagrid from both the database and user entry. What I am confused is how to then go back to the datbase! I have been unable to find any examples of how to insert/update values in a database (mysql) with values from a datagrid.

I can use amfphp or PHPObject to talk to php and then mysql. I just don't understand the best method (best meaning easiest ) to do this.

TIA for any pointers

View Replies !    View Related

---

Using Data From A MySQL Database
Here is the piece of my code:
if (this["projectName"+three] != "") {
_global.projectFile3 = this["projectFile"+three];
heading3_txt.htmlText = this["projectName"+three];
content3_txt.htmlText = this["description"+three];
if (this["thumbnail"+three] != "") {
picHolder3_mc.loadMovie("images/"+this["thumbnail"+three]);
}
} else if (this["projectName"+three] == "") {
content3_txt.htmlText = "";
heading3_txt.htmlText = "";
}

It is for a portfolio thingie i am working on. My script pulls the data from the db three at a time and displays it. the problem is on the last "else if" statment. If there is only 2 items left to display, the third listing is suppose to put in blanks, but instead it places "undefined" in both instances. Any ideas? thanks...

View Replies !    View Related

---

AS3: Store Data In Mysql
Hi there, and... yes... i got a little problem with the store data. when i press it the button "submit" save 3 entries , not only one, why, this is my code:








Attach Code

as3 code:

var req:URLRequest=new URLRequest("http://localhost/wong/include/Query.php");
var vars:URLVariables=new URLVariables();
vars.v1=reg.firstname.text,
vars.v2=reg.lastname.text,
req.data=vars;
sendToURL(req);
navigateToURL(req);

PHP code:

$v1=$_GET['v1'];
$v2=$_GET['v2'];
$insert="insert into myvalues (fn, sn) values ('$v1','$v2')";

























Edited: 10/04/2007 at 09:01:10 AM by eze_diablo

View Replies !    View Related

---

Php Mysql Xml Data Integration
Hi!

I've been trying to connect my swf to a mysql database and I did it thanks to tutorials from Adobe. The problem is that in this tutorial, my data goes to a combo box... and it is really easy to bind the data to that combo box. But what if I want to push those info into an array? For an array I have no Data Binding dialog box... and have no idea how to do it.

Thanks...

View Replies !    View Related

---