ActionScript 3.0 :: Grabbing Info Based On Id# (php Mysql)?
Mar 19, 2010
I'm trying to create a website that will grab content from a MYSQL database, and display it inside of a dynamic text field in Flash. There are several buttons on the page, and I want each button to grab different information depending on id #. So far, I've done a few tutorials both here and elsewhere, and I've finally figured out how to get the Flash to connect to the database, but I'm not sure how to get info based on the id. My current database only has two columns: id & home_body with one row. I want to add more rows to this soon so I'll have something like this:
id | home_body
1 | info <-button 1 grabs this
2 | info <-button 2 grabs this
Here's my code thus far:
AS3:
// this code gets the home page data from the database for display
var homePageText:String;
// Assign a variable name for our URLVariables object
var home_variables:URLVariables = new URLVariables();
[code]....
View 3 Replies
Similar Posts:
Nov 2, 2006
Ok, in a nuthsell I am looking to write a piece of actionscript using an included PHP file that connects to a mySQL databse. Depending on the result of the database, I want to know if its possible for the actionscript to then control a movie clip.
Ok I'm probably not making an awful lot of sense, so I'll basicaly lay out what I want to perform (if it is at all possible).
The flash file will essentialy be a map of the world and will list certain ports (i.e. New York Harbour, London Harbour, Sydney Harbour). The flash file then connects to a database to find out if each harbour has a sailing ship present. If a ship is present at the harbour, a movie clip of a ship would be turned on for that particular harbour, if no ship is present the movie clip would remain hidden.
View 4 Replies
Jul 14, 2010
looking to create an option menu (at least that is what it is called in HTML).[code]looking to do this in flash though with AS3, PHP and MySQL. The data can be stored in XML. please let me know if anyone has done something like this before, or if they know of a good tutorial which details how.
View 1 Replies
Aug 2, 2009
Currently I'm setting up a webservice, which includes a login to access the member area.I'm testing all components seperately, and I've ran into a problem. When the user logs in I want flash to retrieve the user_id as a variable, so that I can use this user_id for member related database access. However, I'm having problems with retrieving the user_id.The login is done by inputting the email and password of the user. If these variables match the data in the database the user is send to the member area. I want to get the user_id by posting the email variable to a php file. In the php file the following code is responsible for this:
PHP Code:
$email = mysql_real_escape_string($_POST["email"]);
View 2 Replies
May 6, 2010
I want to collect email addresses on my Flash/AS3 site for a project.I just have basic web hosting (just FTP upload space) and do not have access to a LAMP server.I assume this is what I need to be able to run PHP/MySQL etc.Does this mean there is no way of me making a form that will allow visitors to input their email addresses to sign up for a newsletter I send out?
View 2 Replies
Aug 22, 2009
I want to set a maximum in the database and then for each row as a percentage of the maximum - it would fill the image based on the black volume.
Take the volume in flash of the lightning bolt (pixels), then fill it with a color as rows increase from 0 to the maximum number.
View 1 Replies
May 26, 2004
I read through the random colour tutorial with interest, and wondered to myself if an objects colour could be altered in other ways... such as by a weather feed or stocks feed. I thought it would be interesting if the design of a site could be changed regularly by outside influences.
View 5 Replies
May 26, 2004
I read through the random colour tutorial with interest, and wondered to myself if an objects colour could be altered in other ways... such as by a weather feed or stocks feed.I thought it would be interesting if the design of a site could be changed regularly by outside influences.
View 5 Replies
May 13, 2011
I'm creating a backend using flash, php and mysql. The problem i'm having is that i have 2 dynamic text fields on the stage that i want it to display their content based on the page i am. My txtTitle is showing both mysql rows together like this: Aboutabout_content=About from MySQL Here is my coding:
[Code]...
View 1 Replies
Nov 28, 2010
I'm trying to develop a simple as3 flash program that passes a collection a variables and returns a result based on the filtered results of a mysql table. Here is my as3 file:
[Code]...
No value is returned. If I replace with '$test4' and '$test5' with numbers such as 1 and 17, a value is returned. Where am I making a mistake?
View 1 Replies
Jun 24, 2010
I have some scrolling content (info). I've also made my own scroll bar.I want the scrollBar dragger to be positioned in relation to the info._y as the user scrolls info.I have created two vars: one that worsk out where info._y is as a percentage and the other that works out where the scroll._y dragger should be as a percentage...
Actionscript Code:
var scrollBarPercent = Math.round(scrollBar.dragger._y / [code]........
also onMouseWheel working too.I need a small bit of code that takes the % of info._y and moves the scrollBar dragger to the same % but in relation to the Stage.height...so if projectGalleryPercent = 50%, make dragger._y 50% of Stage.height using scrollBarPercent.
View 1 Replies
Feb 2, 2011
I have a typical Flex-based application that was written to use a Java/Hibernate/MySQL backend. The client changed the requirements - now they want to distribute it on a CD where the user can just run the app without any installation or a network connection.
To do this, I certainly need to eliminate the web server and the database server and adapt my application (with as few changes as possible, of course) to a stand-alone application that will fit on a CD/DVD. I've managed to export the data to XML and read it into Flex, but I'm wondering if there's a way to recreate the Hibernate data structures in Flex so I could change as little code as possible. Failing that, is there any way to keep the existing Java/Hibernate external to the Flex code but retrievable without installing Apache Tomcat or MySQL?
View 3 Replies
Jan 13, 2010
I have a Flex application which manage a database composed by 7 tables.I have created the insert form and all work great. Now I wanto to improve the Form performances; the idea is to replace the TextInput of the Form with ComboBoxes which are provided by the DataBase tables
View 1 Replies
May 25, 2010
I have downloaded MySQL JDBC driver from [URL]... How do I configure it?
View 1 Replies
Jul 13, 2011
I am tasked with trying to do a slideshow of sorts, and I need to pull the filename of the slide from an xml file and display it, as well as display the appropriate slide notes in a text box.
the xml file they gave me is formatted as below, and with my current code (also below) I'm able to (trace) list all the file names, but I am missing how to address the filename on just one slide � say, slide 1, so I can then load it into a loader.
here's my code
Code:
import flash.net.URLLoader;
import flash.events.Event;
import flash.net.URLRequest;
[code]....
View 1 Replies
Nov 13, 2009
I have a flash menu that needs to play a different scene depending on which page it is embedded into. So I need the it to grab the URL of the html page it is on and do some simple test on it to figure out what scene it should be on. *For the record, I tried to do it without scenes but the frame jumping started doing some cracked out things
Code: (on a single empty frame in Scene 1) import flash.external.ExternalInterface; var urlPath; urlPath = ExternalInterface.call("window.location.href.toStr ing()"); getURL("javascript:alert('"+urlPath+"');"); if (urlPath == "http://www.awesome.com/Portfolio/portfolio.html"){ gotoAndPlay("Scene 3", "portfoliopage"); } else if (urlPath ==
[code]....
Somehow, my urlPath isn't getting the correct value, and therefore the if-else latter isn't functioning appropriately. I am posting the website on my test server, so the http addresses are correct, and the if-else latter functions perfectly when I just change the conditions to 'true'/'false', so neither is the problem. The problem is that the alert shows me that the value of urlPath is undefined, and so then all conditions in the latter evaluate to false.
View 5 Replies
Apr 28, 2010
I can't seem to find anything that tells me how to do this.Is there a way to grab the name of a symbol on the stage? Not the instance name but the name that it has in the library.
View 2 Replies
Oct 22, 2011
In my table the Collation is:latin1_swedish_ci (but i tried UTF8_unicode too).In my flex application when it shows the table,it displays it correct,with all accent and pointing correct,but in the table is like :
View 1 Replies
Mar 23, 2009
I'm having trouble adjusting to the way functions pass in AS3. How come when I say "this" it doesn't know I'm refering to AudioTrack?
PHP Code:
var AudioTrack:Object = new Object();
AudioTrack.myVar = "Hello";
AudioTrack.onComplete = function(){
[Code]....
View 2 Replies
Aug 26, 2011
I'm getting my head around XML E4X in Actionscript 3 and been looking at Senocular's article about filters [URL] for a better way of validating the code below?
Essentially I want to check the profile nodes exist and if theres a profile node with a matching locale attribute (passed via FlashVars), and if not it grab the text of the first node. Anyway heres the code snippet and my XML is below:
function addInfoBubble(countryName:String, countryDataXML:XML):void {
// (theres other non related code here)
if(countryDataXML.achievers.achiever[0].profile as XMLList && countryDataXML.achievers.achiever[0].profile.length() > 0){
[Code].....
View 1 Replies
Jun 27, 2009
grabbing / formating a string.My mission is connecting to a web site - let's say domain.com/one.html - which returns the following html code:
Code:
<HTML><meta http-equiv="Pragma" content="no-cache"></head><body>1,1,4,20,1,128,Harry J. All Stars - The Liquidator</body></html>
What I am looking for is a actionscript function which returns the text after the 6th comma - in this case:
Harry J. All Stars - The Liquidator
The thing is: The numbers are always different, but the text I want to "grab" and "show" in mytext.text (dynamic text) is ALWAYS present after the 6th comma.
View 1 Replies
Dec 21, 2005
Okay, what I want is kinda hard to explain, so bear with me.If I have an array:Code:myPets = ["cat", "dog", "bird", "fish"];Now, is there any AS that can use the value of say "dog", and return the position that "dog" is in the array, I know this seems a bit stupid and dog is obviously myPets[1], but when I'm creating arrays on the fly it becomes slightly harder.
View 3 Replies
Nov 10, 2009
I'm used to flash grabbing an xml file that's manually edited with image file paths. Is it possible for flash or xml to automatically grab images that are in a specific folder?
View 2 Replies
Jan 14, 2010
I am building a flash component to be embedded on an html side - the flash will include buttons to 'share' - i.e. on facebook, twitter, etc. I want to be able to grab the URL of the page and put it into the coding on the button.
Currently the button says:
tweetbtn.onRelease = function() {
getURL("http://twitter.com/home?status=Check Out This Company at www.thiscompany.com",
[code]......
View 1 Replies
Sep 16, 2009
I'm not sure if you able to do this or not. But basically I want to be able to grab text off a website (not the one the SWF is hosted on).
I have several sites from which I am making small amounts of money online.. I want to make a small app that loads the URL and searches the pages for the spot where the money is listed, then add them all up to shorten me having to consistently check each. The app could refresh loads, say every 30 seconds or so. Is there a way to do that?
Another example would be to make a text box in flash that displays the headline of an article on CNN.com
I did the like with loading XML from other pages, but what I want to do just involves grabbing any said text from a site.
View 2 Replies
Jun 11, 2005
I have 36 buttons on my stage that are named [thumbBut0, thumbBut1, thumbBut2,..., thumbBut35]. Each button is a thumbnail image. I want to have it so that when the user clicks on a given thumbnail, the full-sized image corresponding to the thumbnail gets loaded and viewed...yada, yada, yada... So, if the user clicks on thumbBut25, the 25th image gets viewed...
My question: is there some cool way that I could avoid writing 36 different (although they would be similar) "_level0.thumbButXX.onRelease = function()..." type things for each of the 36 buttons. In other words, when the user clicks the instance "thumbBut25" something grabs the "25" part out of the instance name, converts it to an integer, and passes it on to a function that loads up the image that corresponds to "25"?
View 3 Replies
Feb 21, 2007
I need to trace out the variable currentClip from the following code that is in an external swf. The parent swf calls the external swf empty_mc via loadclip.
[AS]
function setNextClip():Void
{
currentClip = clipArray[iterator];
[Code]....
View 4 Replies
Dec 27, 2010
[URL]..and I wanted to duplicate the effect and turn it into something.. I don't know, something. I just want to get it to work!
It's been a while since I did AS3 programming, so excuse me for being a bit rusty. I loaded a .mov as a FLVPlayback exported it as movie.swf and in the main.fla I made an URLRequest for the .swf. I then did all the silly math things that strobes it, and it all works out when I have an image, but with the movie.swf I just can't get it to work.
With the image it's just a matter of copying the bitmap and repositioning it. But how do I capture a still of the playing .swf?
I am a little bit lost within all the CopyPixels and BitmatData's and I just can't get it to work.
To make it short:
- I want to load a movie (a .mov in this case)
- I want in every frame to capture the frame of the playing movie and duplicate it/reposition it
View 1 Replies
Jan 9, 2012
I simply don't understand why now at the end of my project, the last 5 frames are giving me such trouble. I have five scenes. The first scene plays fine. Second scene plays fine until just the end, then it grabs audio from the third, fourth and fifth scenes and starts playing them. Here is the site: [URL] (it is a site for children in Swedish) if you click the 3rd button to the right (3 Delan) you will notice that the sound starts truncating and then starts grabbing and placing into scenes before the next scene.
View 1 Replies
Mar 28, 2009
After 2 nights of *almost* getting it I realized that Flash's RegExp doesn't support lookbehinds. Here are the 3 scenarios:
1) [URL]
2) <a href="http://example.com">http://example.com</a>
3) <br><br>http://example.com<br><br>
Basically what I want to happen is to ignore scenario #2. I know the solution, but I can't seem to nail it. All that needs to happen is to select the http (and everything after that) as long as it's not preceded by a "> or =", but since I don't know a way for RegExp to look backwards, I'm sort of at a loss. Here's hoping that someone has run into this issue before
View 5 Replies
