ActionScript 3.0 :: Show Data In Mysql To DataGrid In Flash
Jan 17, 2010i want to know how to show some data in database in the data grid in flash, like as php.[code]
View 2 Repliesi want to know how to show some data in database in the data grid in flash, like as php.[code]
View 2 RepliesI've scripted a connection to PHP that gets data from MYSQL and outputs that into a datagrid.When I encrypt the swf with Ameyata SWF Encrypt 5.0, and upload it to my webhost, it looks fine. I can click the header of the datagrid (that sorts the data), but when I click on a field of the datagrid, it just freezes and my datagrid is not usable. I'd have to reload the page in order to do something with the datagrid again. But the problem with the field remains.It works when I'm not encrypting the swf.URL...
View 2 RepliesIn my flex datagird i have a checkbox and a datgrid with seven columns. im populating values in first five column(remaining two column no values) of datgrid by an Arraycollection. now,By clicking the checkbox i want to show all seven column values and if i uncheck five columns has to show... how its possible?? heres my code
[Code]...
I have mySQL database with data: username and password, I need output data with mySQL in DataGrid when I press button.
View 1 RepliesI'm populating a datagrid with some JSON data that came from a mysql query.I was wondering if it's possible to tell a piece of JSON data to go to a column other than the name it has?My JSON data comes in with abbreviated names...
[{"gID":"Rock","vID":"Darby's Pub","gRec":"Yes"}]
and I load it into my dataGrid's data provider...
myDG.dataProvider = new DataProvider(myJSON);
Currently, my columns have to be named...
gID, vID, and gRec
for the above data to be populated.Is it possible to have more meaningful column names, while keeping the abbrieviated form in the JSON data? eg...
GIG STYLE, VENUE, CAN BE RECORDED
or do I have no choice but to make the full names a part of the JSON like...
[{"GIG STYLE":"Rock","VENUE":"Darby's Pub","CAN BE RECORDED":"Yes"}]
I want to show in data grid only few dataProvider rows. For example my arrayCollection has 30 rows and I want to show in dataGrid only rows from 15 to 30. Is there a way to do this on dataGrid class or should I filter the arrayCollection?
View 3 RepliesI have traced the data via php from mysql in actionscript but the datagrid doesn't show it.
Here is my code.
import fl.controls.DataGrid;
import fl.controls.dataGridClasses.DataGridColumn;
import fl.data.DataProvider;
import fl.controls.ScrollPolicy;
import fl.managers.StyleManager; //needed to format text in cells
[Code] .....
It might sound like a trivial question but how can I show progress bars, when datagrids and other components that "talk" to web services, update their data providers
View 1 Repliesi will make slide show using Flash actionScript 3.0, PHP and using MySql also (have animation too inside) for my final exam. how to make the slide show from begining ?
View 2 RepliesCan anyone help me with getting a message that is said in flash (like a game) go to a mysql database?
View 2 RepliesI have a datagrid with some custom renderrers and I'm just curious how I should approach the ability to freeze and always show the left 3 most columns at all times when scrolling left/right.
I thought that I might have to resort to 2 datagrids, side-by-side, the first showing the 3 columns that I want at all times, and the ability to scroll the rest. Only issue then I guess is linking the row selection to select that row in both and to tie the column sorts together...
Or would it be better to try and take columns 4+ and shrink their width to 0 as a person scrolls right, and then increase it back to the max width as they scroll left? Though that would cause funny issues to happen as the content of the datagrid would get smaller and smaller until you were 100% to the right and the scrollbar would disappear.
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 am trying to load data from mysql to xml to flash using actionscript and php. Im doing something wrong but not sure what.Basically, my php file (latestnews.php) looks like this
Code:
<?php
header("Content-type: text/xml");
$host = "host";
$user = "user";
$pass = "password";[code].......
this is placed in the same frame number as the dynamic text fields but on a seperate layer. The dynamic text fields are:
Title_txt
Comments_txt
Date_txt
There is no output error but nothing is showing up. The file is using actionscript 2.0 and wondering if the actionscript i am using is write for that format?
I need to create a stand alone desktop app that uses a database. It's been a long time since I did any VB work, and I need to learn Flash for another job anyway...is there any reason why I shouldn't use Flash for the desktop app?
View 1 RepliesI'm in the process of expanding an admin area for a website (coded with PHP and MySQL) and would like to get my client list into a flash combo box. the main columns I would need would be the account and the company name... In a regular example would be
<select name='client'>
<option value='2460'>Client 1</option>
<option value='2461'>Client 2</option>
</select>
If I could get this I should be away...
ive managed to get info from a mysql database into flash in a combo box. i have a text field and i want it to load in the corresponding data when a new title is selected in the combo box.
View 1 RepliesI've been struggling with this for a few weeks, but I still can't get it right, and all the info I found is too ambiguous or uses AS2. What I want to do is to retrieve info from a MySQL database, using PHP, and send it to Flash; and in the other way, input info into the database from a Flash form. I want this to make a series of Flash tests for my website. show me a simple example code (on both PHP and Flash) of how to exchange data? PD: I know how to work with databases on PHP, so the only PHP code i need to see is the php-flash communication part.
View 3 Repliesso i managed to get data from mysql through php through xml and output it in flash by dynamic textfield. So i got a value from mysql, an integer, modified it with flash using commands, and want to send it to php and overwrite the old integer and save
View 1 RepliesI am trying to load data from mysql to xml to flash using actionscript and php. Im doing something wrong but not sure what. Basically, my php file (latestnews.php) looks like this
[Code]...
There is no output error but nothing is showing up. The file is using actionscript 2.0 and wondering if the actionscript i am using is write for that format?
I am wanting to load a list of names from mysql into a textfield in flash. I also want to load just one image from an image path in mysql. How can this be done easily?EX. SELECT name FROM table WHEREEX. SELECT imagepath FROM images WHERE id=`1
View 1 RepliesI am wanting to load a list of names from mysql into a textfield in flash. I also want to load just one image from an image path in mysql. How can this be done easily?
EX. SELECT name FROM table WHERE
EX. SELECT imagepath FROM images WHERE id=`1`
it took me so long to write this tutorial Well, here I go... Section 1: Introduction So you want dynamic content on your Flash movie. Sounds simple, right? Well let me tell it is, and well, it isn't. This tutorial assumes a basic knowledge of Actionscript, PHP and MySQL. If you have that, it's time to move on. Otherwise, I recommend you do some reading on the subjects... Section 2: Setting up your SWF to receive external data Loading external data into an SWF is a fairly simple task. Although the external text file method is probably the most widely known, it is by far the clumsiest way to get data into your SWF. Of course, this may be your only option of your server doesn't support MySQL/PHP! But for those of us who are fortunate to have these privileges, let me show you how Flash can get external data without having to create additional text files.
Dynamic text fields In order for Flash to get data from an external source, you need to make use of dynamic text fields. Simply place a blank dynamic text field on the stage and make sure you give it a variable name (NB: dynamic text fields have both an instance AND a variable names. In this case we want to focus on the variable name). Note the name you give to the field's variable name, as we'll need it when we write our PHP script. Once you have a text field setup, convert it to a movie clip symbol. Attach the following code to the resulting movie clip:
[Code]...
I have a flash file that loads data from a mysql database through php. I was wondering, is it possible to reload the mysql data every X seconds in flash?
View 1 RepliesI am a DBA and I provide data to the developers at my companyin XML format. The developers create Flash graphics and use the XMLto populate data variables. I want to start requiring thedevelopers to make calls directly to my MySQL databases so anytimei have to make a change to the underlying data, I don't get stuckgenerating an updated XML file for the developers.My developers tell me a Flash graphic cannot make a calldirectly to a mySQL database. They say Flash has to reference apage in which variables are defined, such as an XML, PHP, ASP pageetc. This page, they say, is generated from database info, butFlash does not directly make the call to the database ... thatanother programming technology (XML, PHP, etc.) does and has toparse the information, making it available to Flash.
View 3 RepliesI am using the function below to convert a Flash AS3 Date type to a MySQL- compatible 'datetime' string. It is working fine, BUT I am worried that AS3 may not extract the 'same date format' from different client computers thereby rendering my function useless.Is there a better way of passing date to MySQL? One that gaurantees consistancy.
public function getMySQLdate(flashDate:Date):String var year:String;var month:String;var day:String;var hours:String;
var minutes:String;var seconds:String;
[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 RepliesBasically, I want a sample php script, that can let me call from Flash, to save a bitmap data as a record into a mysql table!
View 1 RepliesI've been making flash based websites recently with a simple PHP and MySQL backed CMS. The only problem I'm getting is when the text is loading from the database into the dynamic textfield in the flash movie, it prints either 'false' or '_level0...' The text does eventually load correctly, any way I can get it to print LOADING instead of these two or something similar?
View 2 RepliesI have managed to connect to my database in flash using php. I need to be able to add records to the database using a flash interface.
Here is my existing code:
Code:
stop();
Security.allowDomain("*", "localhost:8888");
var dives_xml_url:String = "http://localhost:8888/pembrokeshire_diving/generate_wrecks_xml.php";
[code]....
Obviously I will also need to add buttons and text fields to facilitate adding the data but I wanted to know if it was possible first.I am using PHP and MySQL with MAMP.
just wondering having some trouble getting my head around the way to pass data and show data in my datagrid component from my mysql database.
View 1 Replies