Professional :: Ql Database And Display Results Based On The Data?
Jul 4, 2010
Is it possible for recent versions of flash to directly (or thru Php) access (& update) data from a mysql database and display results based on the data?
So if my database were like this (math scores):User 13Jerry | 20Kane | 7 the flash output would be a bar graph like this (those hyphens would be bars in flash)
Is this possible these days? Google analytics does something like similar to this.
I last used flash somewhere in 2003/4. Never after that :-) I've completely lost touch.
View 6 Replies
Similar Posts:
Nov 27, 2010
would go about setting up flash to display results returned by a SQL query one at a time.I can work out the query and PHP, but want I want to know is how to make flash take each one and animate it, including pausing and clearing the screen when full, then continuing on a 'new' screen. It's basically for displaying a list of events in a database.
Blank screen
Event 1 (pause)
Event 2 (pause)
[code].....
View 1 Replies
May 9, 2008
Is there a tutorial somewhere that tells/shows how to display an image from a db. I have my image paths in a mysql db and I am using php to display my other text fields. I just haven't been able to get my images to show. Below is the code that I am using so far. Here is my actual goal, I am trying to have a flash document the has a list in the datagrid that is connected to a mysql db. I have successfully done this. When a user clicks on a product in the datagrid it populates the details below the grid and I have done so successfully. What I now need is to show a picture of the product in the details section. I would also like to see how to show different images for different vendors, each vendor has its own image size, so if I put just one image placeholder then some of the images will be scewed. I need something that shows image in placeholder 1 if company=1, show image in placeholder 2 if company=2, etc.
View 1 Replies
Sep 1, 2011
I 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 Replies
Sep 9, 2010
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.
View 3 Replies
Jan 8, 2012
I am trying to retrieve data from database through php scripts and display in flash using actionscript 3. For actionscript 3, I have 2 functions:
private var postArrayTxt:Array;
public function stampTwo() {
// constructor code
var stampNumber1:MovieClip = new stamp1();
[code]....
if I were to run the php script itself, the data could be retrieved from database. However, if I run in Flash, it returns a null value.
View 1 Replies
Aug 16, 2008
Is there a way to easily get data from mySQL database and display it in a dynamic text field?
View 5 Replies
Sep 15, 2006
I have a question regarding preloaders.I am wondering if someone could help me figure out how to display an animation based on how much data has downloaded.For example.I have a preloader, it gets to 10% or xxx bytes loaded, I want a movie clip to play (or whatever, sparks to fly, etc.), then at 20% or zzz bytes, another movie clip plays (or again, something else happens).So basically I want the movie to react to how much of it has been downloaded.A real world example of this that I can find quick is.url...(ya ya, everyone uses this as their example).The loader seems to animate based on how much of the movie has actually loaded.play an animation, movie clip, etc based on how many bytes/percent, has loaded.
View 4 Replies
Jul 15, 2009
i want to intertwine php, MySql and flash. so i can make a flash movie display text that is in the sql database and a php script to change the database, php > sql = i can do but sql > flash = i can't do..i want it so the sql data show's in a text box in the flash movie...
View 1 Replies
Mar 22, 2010
i am wanting to creat a small quiz that runs from xml which pulls questions from a database, then submits the results to the mysql database upon completion.
View 4 Replies
Mar 4, 2012
I have been making huge strides in learning Flex and I am very much enjoying it, however,one thing I cannot find is how to bind results from a query in Flex. I have managed to create lists etc no problem but when I try to bind one specific value to a variable, it does not work.First off, here is my PHP function:
public function getRepnameByUsername($itemID) {
$stmt = mysqli_prepare($this->connection, "SELECT * FROM $this->tablename where Username=?");
[code]......
View 1 Replies
Jan 13, 2010
I have been working with this script for a few days now and have gotten to a near completed point, but I can't seem to script the final step. I have an xml file that is being parsed into my .fla file. There are 3 buttons which are dynamically created based on a tag called <navItem>. The function 'displayContent' should be displaying the appropriate chunk of xml in various text boxes, but instead, it only displays the last chunk (the 3rd chunk) no matter which button I click on. I have pasted my code on pastebin here:[URL]
View 13 Replies
Jan 2, 2012
I'm having some trouble getting around a security restriction of flex. Saving a file is apparently an action that can only be invoked upon user interaction. The problem is that after my user clicks on the save button, I need to perform a database query to get the data for the file I want to save.
Because Flex works asynchronous, I have to make the database call and then catch the ResultEvent in a different function. In that function, I no longer have the user's mouseclick event. How am I then supposed to save this file?
[Code]...
View 1 Replies
Feb 22, 2011
I have a dropdown box that is used to select a Category. I need the Flash Application to send the value of Category plus the search string in my textbox to my Access query and return results for each product meeting selection criteria. The Flash Application is calling an ASP.NET web service which in turn queries an MS Access database.
To start, how do I define the category ID and search value in my Actionscript 3 code?I've placed a series of 12 or so objects that will be populated with the product description, title and price. How do I setup each field to be dynamic text associated with the title description and price from my query results? If there are more than 12 products returned by the query, how do I add an additional page of objects to house more than 12 query results?
View 2 Replies
Dec 15, 2009
I have been looking for a tutorial that shows or explains how to display the contents of a search engine like 'Google' or 'Youtube' inside Flash. No luck so far...
View 1 Replies
Jan 18, 2010
I am working in Flash 8 and using AS 2.0 coding. I am working with page flipping application. Here I have an option "search". I will tell you the scenario. Here I am loading images/pages dynamically thru an xml. It was loading and working like a page flipping. so far it was done. Now if you enter some text inside the search option and press the button, it has to search for all the loaded images/pages and has to display the resulted pages. How this functionality has to done. How to search the jpg's with a given string?
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
Jan 20, 2006
I'm trying to create a loop which generates a single series of sine results ranging from 0 to 1 based on 100 loops ( ie 0 ,0.011 ,0.1111........up to 1 in a single run)The results I want start at 0 and increment in a series up to 1 and then stop. I suppose this would be one half of a sine wave I have tried the following but it goes from 0 to 1 ,1 to 0 , 0 to 1 etc whereas I want a single straight run of 100 values from 0 to 1
I tried :
for(var i:Number=0;i<=100;i++){
trace((0.5*Math.sin(i)) + 0.5);
}
This does not work.
View 1 Replies
Nov 4, 2011
I just discovered impure.com and was very impressed by what can be achieved in terms of visualizing data using their workspace. Although the platform is free to use, but not open source yet. This causes a few problems because the API section works with .com sites for eg. for ebay, so I cannot visualize ebay listings for regional sites such as ebay.in because the link to ebay.com is hardcoded.I searched around, but didn't find other projects that offer a similar way to work with site APIs and other data sources with the kind of user interface and detail that impure.com does in a realtime way within a browser window.This brings me to the questions:
-What technologies would be involved in creating a similar kind of project
-What are the open source tools that can help develop a fullscreen UI to render the workspace. Are there any alternatives to flash for this, and how do they compare
The goal would be to use standard python data structures, python scripts to do some processing on these data structures, scripts to gather data from csv, json and API sources such as google yahoo, wikipedia and flickr, and scripts to render graphs, tag clouds, network visualizations etc. Then bring them all together into a visual interface that supports drag drop and simple type checking.How would the python backend integrate with the UI.
View 1 Replies
Feb 9, 2011
This is more of a database design issue but almost everybody here uses database integration with their apps so I feel it is important. I am integrating AS3 + mysql + php and need to clear up the database design for multiple students results in various activities. Developing an online e-learning course with a "dashboard" or teacher control panel with all kids results in each activity. I have read the database design rules by Codd etc... understand the need for parent and child tables so information is relational and not duplicated etc... BUT I am not sure how to design the results part. Various students do various lessons with 10 activities which each give a mark out of ten. The table would be updating every few seconds as 10,000 users would be online at the same time
1. Would I create a results table with all the students results going in the same table ie: Tom would be the first row
[Code]....
View 5 Replies
Jan 17, 2010
I am working in Flash 8 and using AS 2.0 coding.
I am working with page flipping application. Here i have an option "search". I will tell you the scenario.
Here I am loading images/pages dynamically thru an xml. It was loading and working like a page flipping. so far it was done. Now if you enter some text inside the search option and press the button, it has to search for all the loaded images/pages and has to display the resulted pages.
How this functionality has to done. How to search the jpg's with a given string ?
View 1 Replies
Mar 24, 2010
I need to show the results in my flash program. The results are working great in a trace. I get the text to show, but not the results from high1.lab, high2.lab and high3.lab.
[Code].....
View 3 Replies
Apr 23, 2010
I've made a query in PHP, and I'm trying to send the results back into Flash via AS3, but it's throwing up this error...
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()
Here is the relevant part of the PHP and AS3 code, including the query. The Flash variable rssAdd is passed over to the PHP which is using it in the PHP query accordingly.
$url = $_POST['rssAdd'];
$query= SELECT title
FROM Feed
WHERE category = (SELECT category
FROM Feed
WHERE url =$url) AND url!=$url;
$result = mysql_query($query);
echo $query;
Here is the AS3 code I've done so far.
function recommendation(){
var request:URLRequest = new URLRequest("url");
request.method = URLRequestMethod.POST
var recVars:URLVariables = new URLVariables();
[Code] .....
View 2 Replies
Apr 11, 2011
I've got a simple app that is currently getting information form a database and just displaying the content into a datagrid.
Instead of having this information displayed in a datagrid, I'd like to display it in a couple of labels (first name, last name, phone, etc.), but I'm not really sure how to.
Currently on creationComplete I call my php query function - which looks like this.
public function getPeople() {
return mysql_query("SELECT * FROM tbl_people ORDER BY pers_name ASC");
}
[Code].....
Eventually my query will be modified and will only ever return 1 row from the database. So how do I get the results to display in labels instead of the datagrid?
View 1 Replies
Jan 18, 2010
I am working in Flash 8 and using AS 2.0 coding. I am working with page flipping application. Here i have an option "search". I will tell you the scenario. Here I am loading images/pages dynamically thru an xml. It was loading and working like a page flipping. so far it was done. Now if you enter some text inside the search option and press the button, it has to search for all the loaded images/pages and has to display the resulted pages. How this functionality has to done. How to search the jpg's with a given string?
View 0 Replies
Apr 7, 2010
I am trying to adapt this search code to display the results one at a time.Right now it displays all the terms it finds all at once and separated by commas. How would I adapt the code so it displays one item or term at a time.
[Code]...
View 9 Replies
May 5, 2010
I am trying to create an array (1-35), mix that array and display the results with a trace. I am getting an error with the following code.
public function generateArray(toNumber : int) : Array {
var result : Array = [];
for (var i : int = toNumber;
i != 0; i--) {
result.push(i);
[Code] .....
The error(s) are:
1180: Call to a possibly undefined method generateArray.
1120: Access of undefined property generateArrays.
View 27 Replies
Sep 20, 2011
Any Info about using the new Twitter API's to search images with a hashtag and display the results?
View 2 Replies
Mar 24, 2011
Why flash don't display my data query send from a php file that use the $_GET to retrive the information and run a query to display the result back to flash.but when I change the $_GET variable in the php file for a static value let's say (2), flash display the data that was requested in the php query..with $_GET I get in flash undefined with "2".I get in flash the data requested...
View 12 Replies
Feb 18, 2011
i am using Flash CS4 (AS3) + AMFPHP + MySQL to do own flash frontend for Wordpress CMS. Everything is going fine but i`ve got one problem. Problem with properly display of result of query in AS3 by using ArrayCollection.
When i check my service in "amfphp/browser/" in web browser i`ve got this (with all needed data):
...
(mx.collections::ArrayCollection)#0
filterFunction = (null)
length = 2
[Code].....
I know that "result" is an ArrayCollection type but i don`t know how to get rows and columns from this. I know that my data is there but i have no idea how to get it.
how to get to Arrays and simple data variables which are in ArrayCollection.
P.S. I tried also change query type in service.PHP for mysql_fetch_query but in that case i`ve got only one row (not all data).
View 3 Replies
