I am trying to establish a connection between my swf and a database using PHP. I keep getting the following error:
Error: Error #2101: The String passed to URLVariables.decode() must be a URL-encoded query string containing name/value pairs.
at Error$/throwError()
[code].....
I have this little piece of code to retrieve data from a local SQLite database (to an AIR app):
import flash.filesystem.File;
import flash.data.SQLConnection;
import flash.data.SQLStatement;
[Code]....
It is only a "proof of concept" piece of code and it "lives" in the first frame of the timeline of the Flash IDE. What happens? When I compile my SWF (AIR for iPhone), I get this error:
SQLError: 'Error #3115: SQL Error.', details:'no such table: 'background'', operation:'execute', detailID:'2013'
I created a basic db with a Firefox extension (SQLiteManager). What can cause this error? The table exists!
I am having issues getting Flash to connect to a SQL 2000 Database. I keep getting an error with flash.data.*.The code is :
import flash.data.*
I receive the following error:
1172: Definition flash.data could not be found.
Error: Error #2101: The String passed to URLVariables.decode() must be a URL-encoded query
string containing name/value pairs. at Error$/throwError() at flash.net::URLVariables/decode() at flash.net::URLVariables() at flash.net::URLLoader/onComplete()
[code]......
im trying to pass my AS3 array to a sendmail.php page to send the user details of the order (the arrays contents) my array is called 'details'. The method im using is a bit unreliable and im wondering if theres a more effective way of doing this? Im currently using....
ActionScript Code:
//submit button
function cartsubmit(e:Event):void {
[Code].....
I'm encountering a problem I did not think of. I have a single textfield, that oncesubmitted via "Get" method, sends the data to the site (Think of a google search field in a banner).In any case, I have some default text in the field. But when someone clicks on the submitbutton, the default text gets submitted as the search string. Is there a way to get the result from submitting the form without entering text into the textfield to be a default URL, and not the text string? See Below:
myfield.text = "Enter Your Text";
myfield.onSetFocus = function(oldFocus) {
myfield.text = "";
[code].....
Can anyone help me with getting a message that is said in flash (like a game) go to a mysql database?
View 2 Replieshow to send data from a flash to a database and how the receive it aswell. Im presuming you pass the data from the flash to a php file to the database when sending and call the data using a php file to the database aswell. What im trying to do is just have a button that will increment a number in a database by 1 and then display that information on a different Frame within the flash later.
Basically what i want to do if have a button pressed to increment a number in a database.
I am reading one tutorial :- But I can't understand what is "Gateway.php" and all such things. I am a beginner in Flash.
View 2 RepliesI have to fetch data from database into the flash..
View 1 RepliesI need to create a database using Flash which gets the data such as "name , last name..." from the user and stores it in a database.
View 1 RepliesI am creating e-learning material that will be accessedonline by students. Is there anyway that Flash can write to adatabase to tell us how long the student was logged in for and how
long there were on a page?
I have made a .swf file that scrolls boxes- these boxes willin the end contain products contained in a ASP database. Here isthe problem, I don't know how to get the Flash movie I have made toSince I don't know flash that well, I have made transparentbuttons to go over the scrolling boxes to open a URL with theaction scripting -----on (release) {getURL("http://www.myurl"); } This works finebut I would like the content in the scrolling boxes to changedepending upon items in an ASP database. In the database, there isan area to specify "featured" items, which are dynamically put onthe site in specified areas where tags(anchors) for the "featured"items are placed. What I think I should do is code the tag(anchor) for the"featured" item into my flash movie but I don't know how to dothis.
View 1 RepliesI am trying to create a 'Password' database with flash to push both to and from an external database, the only problem is that I do not want to have to run IIS or Apache or any other web server. Is there any way to read a non localhost/web based type database within flash? If so can someone point me to a tutorial or
at least in the right direction?
First of all I am using Flash MX 2004 and have Office 2003.
I am trying to use my flash form to insert data into a ms access database but it is not going too well.
I have 4 input fields on the flash form and a submit button, ActionScript on the Submit button is as follows.[code]...
Is it possible for flash to accept value from a database?There is a database storing values "postions" and "descriptions" (there are 2 coloumns named so to store the values).In flash I want to accept the values entered in these 2 coloumns. How to go about it? If I create 2 dynamic text boxes with variable names "p" and "d" respectively and an "accept" button on the scene, what script should I add to the button so that these text boxes accept the values?
so my 2 queries are:
1) how do I send the value from the database to flash?
2) how do I accept the same in flash?
im trying to figure out if there is a way to use flash as a front end for a database. i need flash to be able to search the database for part numbers and match the part number with an excel file and be able to open the excel file from flash.
View 3 RepliesI am looking for some advice on creating a flash sound game. The visuals are all done as is the animation. I am trying to create a piano, that you can play a tune, somehow (when pressing down a button) 'record' the sound and once you have finished, send the link to the sound you have created to a friend, where it can be played back when they visit the website and see what you did.
View 1 Repliesgetting data from a database and displaying it in a Flex (Flash) swf. Currently I have some C# code that gets the data from the DB and saves it to an XML file on my site. Then the .swf reads that xml file.
protected void Page_Load(object sender, EventArgs e)
{
DataTable _dt = new DataTable();
_dt = ProductList.GetProductssForAdmin(10);
[code]....
I know how to get the data from my database, but i can't seem to figure out how to send data to the database from flash using amfphp! give me an as3 and php service example.
View 1 RepliesI want to display html(text) data into flash .Is there any way to do this dynamically? I am able to do this by creating an external xml file but how is it possible to do the same job without creating the external xml file using php and database?
View 3 RepliesI am working on creating a basic message board for my website and I am having difficulty getting things to pass from Flash to Database to Flash. I just checked out the tutorial on this site that shows how to go from Flash to Database. Which is awesome by the way. I was wondering if anyone could help me on how to get the database data back into flash and post in a message board style. In another related note. Through a form set
[Code]...
I have a little application with five text fields and a submit button that i want to put the inputted data from into a database. i have my database done and everything, and here is the code for the PHP file i'm using:
PHP Code:
<?php
$server = "localhost";
$username = "reintro_matt";
[Code].....
i'm not very good with PHP but after doing some research and reading some tutorials i think that is good to go. my text fields in flash have the variables that i'm using in the POST_VARS commands in PHP and similar instance names. how would i go about writing the actionscript to collect this data and insert it into the database in flash (or make corrections to the PHP i already have if it isn't ready).
What I am trying to do is bring data in from (mysql)PHP into flash 8 (actionscript 2.0). I got part of this to work. I bring in the text and diplays just fine. So the next step was, To set the font size from anothere php loadvars (code below). Flash will not pick up that part of the code, were I set the font size.
Here is the code:
onClipEvent (load) {
info4 = new LoadVars()
lv = new LoadVars();
[Code]....
I am completely new to Flash and actionscript.I have a small project which requires me to submit details into a MS Access Database. I have created an asp scrip to do the same but it doesnt seem to be working. I am posting the code.
my fla code
********
import flash.events.Event;
[code]........
I'm trying to send data to my database through Flash. I've got some fields and I've got a submit button. On press, it will send data off using:
Code:
getURL("(myServer).php","_blank","POST");
Why do I find something like this in the address bar?
.../highscores/new_score.php?player_name=test48&time_complete=489 &resources=379&accuracy=34&combo=598&general=69
Aren't they supposed to be hidden when using the POST method?
How to retrieve and show data from database in flash? I want to show data on a page like below,
1. Name1 -- Address1
2. Name2 -- Address2
3. Name3 -- Address3
I have a quiz game that i have finish. in this game have a finish button. if the finish button clicked the score from the quiz want to insert into mysql database.
View 1 RepliesI looked at different flash chart software (free and commercial) and could find only one that supports the feature I want: map my dataset on the predefined X axis. Let me give an example.
Let's say my X axis is time. The time is represented in hours. So let's assume my X axis has last 24 hours. Now the data I have in the database contains data coming every 50 minutes. My goal is to have a chart that will show this data. The point on the graph will not correspond to X axis values one to one.
The simple solution (and all charts support this) is to set X axis resolution to 1 minute and only show "ticks" on A axis every hour. Assuming that chart supports "null" values (and most of them are) - it works fine as an idea.
The problem is that in this case (for all of the charts I know) I have to provide XML/json/CSV as a source of data that will contain 24 hours * 60 minutes points of data, with only ~29 (24 hours, every 50min) containing meaningful data. This puts a stress on 1) database, 2) more traffic 3) makes chart less responsive.Are there any flash graphs that will accept a dataset of ~29 values and map into 24 points on X axis.
I have a website in which the content on the index page is controlled by a PHPMyAdmin database. I want a a flash "movie" at the top, that can take the data from the site, and slide-show it until a user clicks on a specific link, in which the movie will direct itself to the clicked event.
The page is for a booking/promotion concert company. They want a "Featured Shows", "Calendar", and flash file that all are interconnected. One page. Does anyone know how to do this, where to find tutorials, or so on? Note, i'm not wanting to WRITE data to the database, I just want to GET data to post on the flash file.