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]........
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]...
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 Repliesvar variable:URLVariables = new URLVariables();
var myRequest:URLRequest = new URLRequest();
myRequest.data = variable;
[code]....
So, here is the question. I have a small flash application that sends some variables to a php script (via POST), and that php script sends them to a mySQL database.
This works fine when I'm testing my flash offline, I go to phpmyadmin, and the registry is done. When I upload the swf to a online html, this stops working. It no longer creates another registry in the database. I have no ideia why this happens.
I read a bit about it and found out about cross domain policy, and thought it might be the problem. Thus I made a small .xml file and uploaded it to both servers (the one the swf is on, and the one that has the database), and its still not working.
[Code]...
I'm using flex to develop my first desktop app and I'm working with sqlite for the first time as well. I'm creating my database and all the tables and I would also like to add a few rows of data into a couple of the tables so that the users have some data to work with on first install.
The only problem I'm having is every time I run the program it keeps inserting the same data over and over again. I'm just wondering if its possible to do a - INSERT INTO IF NOT EXISTS. or some other kind of work around.
I have a function that inserts data into a SQLite database. I can manually add data using
sqlStatement.text = "INSERT INTO users (First_Name, Last_Name) VALUES ('John', 'Doe')";
This works perfectly. Now I am trying to insert the data from a variable instead. I can trace my variable from this function- trace(Main._firstName); //returns John, but when I insert it using this:
sqlStatement.text = "INSERT INTO users (First_Name, Last_Name) VALUES (" + Main._firstName + ", 'Doe')";
it inserts it as "null Doe".
Can anyone help me with getting a message that is said in flash (like a game) go to a mysql database?
View 2 Replieswriting a PHP script that will decide to create a new row in mysql or just update an exsisting account and pass the information back to my swf file.. I am sure alot of people would need this when creating a form that updates or creates account information...
View 1 RepliesI'm trying to insert some data into my DB from two Combo Boxes in Flash. I'm not quite sure how to go about it. I have no idea how to give the combo box a 'var' value like we do for a regular textfield. I have other pages where I have regular text fields that work fine as I can specify the 'var' value in the properties but not for combo boxes. I'm new to actionscript so please bear with me.
Action Script for my button:
Code:
on (press) {
loadVariablesNum
("http://localhost/Test/acadForm.asp",0, "post");
[code]....
how 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?
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'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 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.