Flash :: Connection To Database?

Database Connection
Is MX 2004 capable of connecting directly to a database - for instance Acces or Excel - to dynamically obtain and present records?
If not, which language/program would you recommend to present dynamic data on a graphics? For example, if you wanted to have few hotspots on a graphic map which on a rollover would pop a little box with data from an external table/database?
Thanks

How Do I Get Connection To A Database
How can I get connection to mySql database which stores movies? Please Help anybody

Connection Database
Hello every one, please some body to help me. How to store the data text in Access databases using flash form and to search into the database. It is possible to work without server because I donâ€™t want to put this flash file on the net. If it isnâ€™t possible please some body to tell me how to make databases and to connect with flash and to have possibility to search the database, but to work database in the local computer.

Database Connection?
Hello,

can anyone explain me how to access and use the data from database (ms access) to flash file?

thanks in advance,

Trupti

Database Connection
Hi everyone...i really need some advise concerning database connection with flash mx2004 pro. I'm building a very complex forms application and need to get lots of data in and out of the database backend to my flash app. the app is an web deployed Intranet app situated on a server running ASP. The database is SQL2000. I've looked at using the LoadVar method...which would be pretty much the same as a normal HTML to asp application. I've also looked at using the XML connector...but this looks like it would actually be more difficult. SQL Server will return XML data but its not in a format that i can easily use, and i dont want to write an XML parser in ASP to then pace it to the flash app. Has anyone got any thoughts or guidence on this......?

thanks nik

Doubt In Php/sql Database Connection
I downloaded this example from flashkit :
http://www.flashkit.com/tutorials/Ba...-635/index.php

I get :
Error opening URL "file:///C|/WINDOWS/Desktop/arjuna/sql1/Login.php?Name=raj"

when i try using it. the path is correct but it just doesnt seem to work. please help!

also if u can.. please tell me if theres a better way of accessing an SQL database through flash. If anyone has any example files... it would be highly appreciated!!

Database Connection (MX 2004 Pro)
Hi all!
Question: Can I connect a MS Access DB to Flash? If so, how do I do that? Perhaps you can point me to some good tutorial about it or something?
I want to connect a DB to my movie and let the users to be able to search for items by writing a key word or by selecting options etc... The results should be displayed in different text fields (ie - part 1 of the DB's entry displayed in field 1, part 2 - in field 2 etc...)

Opening A Connection With A Database?
Could anyone link me to some useful tutorials of how to make a connection or open a connection with a database? I've been looking at macromedia site all day, can't get a thing, they describe it, but i couldnt find anything to somewhat show you how it's done.. thanks!

is the only way through Flash Remoting?

Database Connection With FLASH? Help Please
Hi All

Can anyone tell me if we can connect our database with flash some how and if any one can provide a sample or tutorial for it would be really helpful.

Waiting for some help.

Thanks
F.

[CS3] Help: Interactive Map W/ Database Connection
Here is an example of what I'm looking to come up with in the end: http://smu.edu/maps/flash

Right now, my Flash file just consists of a floorplan picture for a certain building on campus.

Certain rooms are going to be clickable (a library item will present instead of just having the whole room area clickable). When a room is clicked, a pop up window/quote box will show up on the screen (much like the example in the link above).

As for the database connection, it will be used to put information in those individual windows/boxes (not the main concern yet).

I'm going to keep track of my overall progress in this thread, so I'm just asking for any other examples, or suggestions right now.

Thanks in advance.

Local Database Connection
Hi,

I am looking to build a desktop application with Flash and was wondering if there is a way to connect to a local desktop database. I would like to be able to distribute the application on CD and need to use a database as storage.

Thanks

Flash Database Connection (k)
I'm working on a portfolio for my company and would like to store the
information in a database and have Flash pull the information from that
database. I was thinking about using Filemaker Pro for the
database(we're an all Mac shop). The data would be stored locally and
shown locally.

Thoughts? What the best way to do this? XML?

-Kirk

Creating A Database Connection
Hello everyone,

I must program a mobile application for school. It must work on a Nokia N70 mobile phone so I'm working with Flash Lite 1.1.

Anyway, I have a database in PHPMyAdmin.

How can i read data from that database with flash lite?

I've searched with Google but dind't find something usefull.

i hope you guys can help me.

All the best,
Jeroen

Database Connection Without Swf In Browser
hey

is it possible to play a swf-file without a browser and still connect it to a asp-document and save data into a database?

we're making a game where we don't want to use the browser to play the game, and we still wan't to save highscores in a database..

/HI

Database Connection & Extraction
At the moment, I am just trying to extract info from a MySQL database through Flash via a PHP script. The script is:

PHP Code:

<?phpinclude ('include.inc');mysql_connect($DBhost,$DBuser,$DBpass);@mysql_select_db("$DBName");$query = "SELECT value FROM content WHERE field = 'FrontPageNews'";$result = mysql_query($query);$value = mysql_result($result,0,"value");print "&value=$value";?>

I have a multiline dynamic text box with a variable name of "value" and the following actionscript:
Code:
loadVariablesNum("php/read.php", 0, "POST");
stop();
But it is not extracting the info. It connects to the database fine, as I used it from a tutorial on FlashKit. The script works in phpMyAdmin, just not in Flash.

It does, however, work when I use the following PHP script, but it's not extracting the info from a database though:
PHP Code:

<?phpinclude ('include.inc');mysql_connect($DBhost,$DBuser,$DBpass);@mysql_select_db("$DBName");$query = "SELECT value FROM content WHERE field = 'FrontPageNews'";$result = mysql_query($query);$value = mysql_result($result,0,"value");$test_msg = "hello"; $test = "&value=$test_msg"; print "$test"; ?>

The page is at http://test.bigworms.com

Any Ideas?

Close Database Connection?
Hi. Got another problem boys & girls.

This time my connection to the Access database wonÂ´t close. IÂ´ve tried everything..but nothing. The .swf and the dllhost.exe consumes all of my CPU and I have no clue what to do.

This is my .asp file:

<%
    Set DataConn = Server.CreateObject("ADODB.Connection")
    DataConn.Open "Driver=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("Status.mdb")

    Set cmdTemp = Server.CreateObject("ADODB.Command")
    Set rstContacts = Server.CreateObject("ADODB.Recordset")
    cmdTemp.CommandText = "Select Status From users"
    cmdTemp.CommandType = 1
    Set cmdTemp.ActiveConnection = DataConn

    rstContacts.Open cmdTemp, , 1, 3
    rstContacts.Move CLng(Request("Record"))
Response.write "Status=" & Server.URLEncode(rstContacts("Status"))
    rstContacts.Close
    DataConn.Close
    set rstContacts = Nothing
    set DataConn = Nothing
%>

And that shouldnÂ´t be any major problems.

This is my flash-call:

onClipEvent (enterFrame) {
    loadVariables("http://localhost/GetDetails.asp?Record=0" , this);
        if (Status == "False") {
             this._visible = true;
    } else {
        this._visible = false;
    }
}

Database Connection In Director MX
I want to connect a SQL Server 2000 database in Director MX. What is the best way to do this?

I imported a .swf file ,which got the datas from DB,into Director MX project. In Director MX, when I play the stage, it gets the datas from swf file. But when I export the project as .exe file, I can't see the datas from .exe screen. If I export it like .htm file, I can see the datas. ( I used getURL, loadVariables) How can I see (get) the datas in .exe file?

Input Text Connection To A Database Help
Help.
I have a mySQL database set up on my server with one table in it called streetTeam.
I am attempting to put together a form in flash that will populate the database.
the only inputs I have are input text boxes that have been labeled with the corasponding row names in my table. ie. st_firstName for (enter your first name)

Unfortunatly that is as far as I have gone. I know almost nothing about connecting to a database. I have tried in Dreamweave MX and it keeps wanting a testing server that I have recently asked my server what that is and if I can get one.

My question is (asuming that I can even connect to the darn table) how do I make the form work in flash MX.

thank you in advance for any help anyone can offer.

Chuck
http://www.wellchild.net

Plz Help Me On Database Connection Through Flash Mx(with Xml Or If Any Other Option)
Hi friends,

Help me how we can connect database.I know through asp using loadvariabls.I want direct connection to datadase through flash mx itself.

thanx

Database Connection In 2004 Prof
hi there,

is there any possibility of connecting to a database through flash 2004 prof directly (without using asp or any other prg language)...if yes then can u pls post a smaple file(s)...

thanks in advance

Question: Flash Database Connection?
hello there people...im a new user in this site. i really need ur help...how can i create a flash-database connection without using asp??? Y, bcoz i'll be making a stand alone system (interactive learning cd almost the same as ENCARTA)! Another reason is, i don't know how to use ASP!

i hope you can answer my question....pleeeezzzzz.....

thanks!

Test For Internet/database Connection
Hi,

I have a flash GUI that connects to a PHP script to enter data into a MySQL database.

The problem I'm having is testing for a connection to the php script - if i can reach it, i can spit back an error code, but if it's offline or unavailable, the flash page doesn't reflect that.

Is there any way to test for an Internet connection in a Flash script and output an error message if there is a problem?

How To Establish Database Connection Using ActionScript ?
I am using Flash MX Professional 2004 and trying to create a database connection. I try to google but found only database connection using PHP. Is it actionscript itself do not have database connection? I must use the scripting language to create a database connection? I also read something about Flash Remoting but i think it require the scripting language as well.

I just started learning flash. Any help would be much appreciated. Thankz in advance.

Using DWMX: Php/mysql Database Connection Ok, Doesn't See Tables
Hello,

Forgive me if this has been brought up. I did a search for it and couldn't find anything, so I hope I'm not rehashing an old problem.

I have the database connection through the MySQL server working fine (after I had to go change the stupid old password thing), but it doesn't list any tables in the 'databases' tab of the Applications panel, and if I try to define a recordset in the 'bindings' tab, it says no columns are found. Anyone know how to get it to see the tables? I looked at the table properties in MySQL Control Center and it doesn't say it had restricted permission or anything like that.

Thank you very much.

Net Connection Without Internet Connection Whoas
Hi does flash media server 2 require a connection to the internet i'm using the evaluation version on a computer which is not connected to the Internet at all I've checked my net connection strings and they are in order and these apps work on the computer that is connected to the Internet....this is a strange problem here is my netconnection string ....
my_nc.connect (" rtmp://localhost/server_test");.......what could possible be wrong.

Database Driven Design Database?
Do forgive my vague query in the title here.

Greetings all. I'm new to the site. Have searched this site and others and did a lot of googling but haven't found what I'm looking for. Perhaps because the query is wrong.

There are two things I would like to accomplish:

1.

I have an archive of over 250 designs which I have titled in a specific alphanumerical order.

I'd like to put up a "catalog" of these designs online on my site (which is the site I want to create).

The functionality should be somewhat like this:

The 250 designs would be broken down into 3 categories.

Each category will have x number of designs (around 80 to 100).

A scrolling navigation for the designs is what I need. Although I have done a scrolling menu in the past, I've never done anything for so many designs.

The designs are already sitting on the server in the database.

I know that I can create the scroll menu such that once the thumbnail in the scrolling menu is clicked, it'll open another section of the page and load the larger version of the design. This is however tedious to do for over 200 designs.

I'm looking for a way that when the mouse clicks on the thumbnail, the place where the full scale of the design would be displayed knows which design to display.

2. The second part of this site should have search capability. For instance, if I key in the following code: SFA-1205 (which is a design number), it can search the database and display the design in the same viewable area I had designated for the first step.

Anyone any ideas?

Thanks in advance,
Raju

Database > ASP > Flash > ASP > Database
Alright, so I have my database, ASP code to get the database, and I have my flash movie that gets the ASP. Now I want to send stuff form Flash to ASP and into my Database using a different ASP file. How can I do this?

Can Someone With A 56k Connection...
Or dialup, please check my site out to see if the main flash animation loadup bar works....

http://fatesfaze.tripod.com

How Can I Know If There's No Connection ?
If I used LoadVariables, how can I know if it succeded or not ?
or do I need to manually have a flag,poll for a period of time to see wether my php set the flag ??

thanks

Swf Connection
Hi, I have this problem which seems to be difficult to me to solve. Maybe you could help.

I have the main .swf to which, at certain point, I load another movie (loadMovie "two".swf, 1). In this second swf I have a button that should unload it ("two".swf) and then, back in the main .swf, send me to frame 100. I know how to unLoad the movie but still, I dunno how to tell that button to go to the specyfied frame.

Thanks for help!

Net Connection
Dear colleagues, a such a question . AS it is possible to
organize transfer of a text file from one swf project in another,
the text is typed{collected} by the user,
and swf projects are started On from different domains and from different
computers by the Net

AS3.0 To ASP Connection?
I'm trying to work on some differnet AS3.0 > ASP > MS Access.mdb connections

However I'm having trouble finding any support for AS3.0, i found alot of tutorials on AS2.0 but I cant figure out the code to Send / Receive Variables to/from Flash/ASP

IF anyone could post a sample that illustrates this in AS3.0 it would be great

Thanks!
Trig

Connection Between PHP And AS2
What I'm trying to do here, is simply get a part from the url, lets say it's "play" and the url looks like this "blabla.com/watch.php?play=153". So in my datebase this 153 from the url is codename to the actual link of a .flv video file.

In my PHP I'm using this:

Code:
//ex.
$getPlay = $_GET['play']
//now i select the datebase
$query = "SELECT file FROM video WHERE code = '$getPlay'";
$results = mysql_query($query);

//now i define my var
while($row = mysql_fetch_assoc($results)) {
echo $row['file'];
}
Now the script will output f.ex. "somevideo.flv".
Simple as that the only thing missing here is how to tell actionscript to read this $row['file'] var and play whatever .flv video is under it.

Can anyone help me?

A / V Connection
Hi,

I am going to do a live broadcast and I need to know how to connect the live feed from a A / V computer to the Flash Media Encoder. The encoder is looking for a camara and I am not confident it will see the live feed from the A / V computer.

I have done live before but from my own camara not from a feed. Any help would be appreciated!

Connection
::my problem:
1.I have an advanced rollover button which means that I have a button with in the movie clip.
2.I have an movie clip animation

How can I call the movie clip which is the animation, from the button to be on the main time line

thank you ::

Php/AS Connection
yo guys, i havent been around here in ages and i know this was like posted a thousand times but here's the diff and a the question:

how can i link the php code/var/field to the fields in my flash?! it's like i want an automated news manager (done in php - like fusion news and cute news) but instead of posting it to a field on a static site, i want the values to be posted on my dynamic textfield on flash to relieve me of constantly and manually updating my site whenever there's a news... a friend told me it's similar to loadvars when tyring to load from notepad but i can't seem to do it in php (since i have no formal training in php)

thanks and hope someone can get me out of this predicament..

kudos..

PHP Connection
Hi,
I have an organizational flow chart in flash with each branch of the tree as a button. Each button is having a link to a separate .htm file.
My problem is I dont want to give the links in flash but to give the links in a PHP file for some reason i.e. when I click the button in swf file the link will come from PHP file. This I need because the links are going to be changed very often and the person who will be changing does not know much of flash. So he wants the link should be stored in a PHP file so that he can change one or all the 14 links in the PHP file without ever changing the flash file when ever he wants.
Any suggestion would be greatly appreciated.
Thanks,
kedar

Connection Speed
any ideas on how to get the users connection speed in kb/sec?

56k Connection Crunk
The site is very straightforward... main flash movie that uses a "go to and play" to change different background images and load external swf files. Simple, but there's a very weird problem... the site works fine on both platforms in all browsers we have tried ONLY IF the computer is on a fast connection, but on all the computers we've tried with a 56k or slower connection the browser will not recognize the "stops" in the actionscript and the movie just plays all the way through and the buttons don't work.

Has anyone encountered this before?

http://www.lorajappleton.com

JJ

Connection Speed
Hi I was wondering if there was a way that you could detect the connectins speed of the computer the movie is playing on...

Any help would be great
cheers, Josh

Ability To Tell Connection
I was wondering if anyone knew how to make a preloader or movie to tell what the connection speed of a user is, and then direct the movie to a different movies depending on speed. Like if a person logs on to the site at 56K, I would want to send the person to a low graphic version. Likewise, if they are on a T1, I want to send them to a killer version with full sound and multi-media. Any Thoughts? or do you know where I could find this script? I would even be up to using Java.

Thanks!

Connection To Database?

Hi Guys! I'm New here! I have a question in my mind??? do have a Macromedia flash has a Connection to the Database?? like MYSQL??? Just a theory in my mind!! Thanks Guys!