ActionScript 2.0 :: Need Input Data With MySQL In DataGrid?
Feb 17, 2011I have mySQL database with data: username and password, I need output data with mySQL in DataGrid when I press button.
View 1 RepliesI have mySQL database with data: username and password, I need output data with mySQL in DataGrid when I press button.
View 1 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 Repliesi want to know how to show some data in database in the data grid in flash, like as php.[code]
View 2 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"}]
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 RepliesThere are three methods: loadvars, xml and flash remoting. I have a great tutorial from Lee Brimlow but he only passes one column into a listbox. I want various columns passed into a datagrid.
I'm not too sure how to amend the php code
<?PHP
$link = mysql_connect("Localhost","user","password");
mysql_select_db("cambridgekidsdb");
$query = 'SELECT * FROM trivia_user';
$results = mysql_query($query);
[Code] .....
I'm almost there and this will be fundamental to my website as I can create important stats on hundreds of children.
I got a music portfolio web site running PHP, MySQL and Flash. There's a page showing all the artists my client worked for and when you click on a song title, this title is passed as a variable to a PHP page then to a Flash page. The Flash page contains an actionscript music player which then looks for the right audio file in the database and plays the song. Everything works great except for the dynamic text field which displays the song title. If the song title contains an apostrophe or a single quote, the Flash dynamic text field then shows the apostrophe.[code]
View 1 RepliesDoes anyone know how to connect the Macromedia's datagrid component to a PHP/MySQL database? I can't seem to find ANY info or tutorials on the web for this.
View 2 RepliesI have just updated my site and added the AS3 datagrid tutorial where I populate the datagrid using a PHP script and a MySQL database.
View 1 RepliesCan anyone help me with getting a message that is said in flash (like a game) go to a mysql database?
View 2 RepliesI would like flash to send and receive data from mysql.
To send data I would like to create 5 input fields, and then use a submit button.
Then to retrieve the data I would like to use the data grid or a dynamic text field.
I need to create a login page in my flash site that relates to information input to a mysql database. after the submit their information we want to send them a link to a differnt flash page with a login screen they will use their first name and a password (already in our database) to gain access to this "new" page. on that page there will be a welcome message that says "Welcome, User First Name" so I guess i have two questions
1: how do i set up a login page?
2: how do i pull that login info to a welcome page?
I've got a Gridcolumn in a Datagrid (Spark). The Column's dataprovider is a Number value that gets updated via Binding.Now, without an item renderer the cell displays the correct values.If I set an item renderer, I can't access the values in this renderer.My renderer looks like this, so nothing really do here (for now) but to trace the value, but the value is always NaN.
<?xml version="1.0" encoding="utf-8"?>
<s:GridItemRenderer xmlns:fx="http://ns.adobe.com/mxml/2009"
xmlns:s="library://ns.adobe.com/flex/spark" width="100%" height="100%" >[code].......
without the renderer, the column displays the correct values, so apparently the DefaultGridItemRenderer works fine.As requested, here is my Datagrid;
<s:DataGrid id="dataGrid" dataProvider="{_listItems}">
<s:columns>
<s:ArrayList>[code]..........
_listItems is an ArrayList with instances of a model class, which has (amongst others) a property called change of type Number.
I have a DataGrid whose dataProvider is an Array of int Arrays (each with different lengths). Since each row has variable size (and I want to display all the data), I decided to extend DataGridColumn and overwrite the itemToLabel function to be able to display the data. The problem is that I also need to display the data differently depending on the int value.
I believe the only solution is to write an itemRenderer, but the only input the itemRenderer.set(data) function receives is the entire int Array. I believe I need either the exact string returned by itemToLabel or the column index of the cell the itemRenderer is for (to basically do the same parsing I implemented in itemToLabel).
I like to call for different SWF files from a link in a MySQL database to use in a Detailpage with PHP. Photos and text are no problem. The AC code is probably complicating things.
View 6 RepliesThere an input textfield, name.text. There is a button with the following script,
send.onPress = function () { getURL ("name.php", "_blank", "POST"); }The info will be send to MySQL database, name, when pressing the button.
PHP---
<?// Receiving the variables.$name = $_POST['name'];
// Printing out the variables.print "Your name is ". $name . ".";
?>
I am not able to perform the task.
I'm trying to get some data from PHP/MySQL and send it to Flex..Let's say That my object in Flex would look like this:
package some.package.VO {
[RemoteClass(alias="VOPerson")]
[Bindable]
public class VOPerson {
[code]....
In my case, personDetails is an Array, and in theory, it could be some other object... But is it really necessary to make it an object? I do not intend to use that data nowhere else except within my VOPerson class. It is some associative array, and I can easily transform it to another object, but there will be lots of similar situations in my app, so I would like to avoid making unnecessary (value) objects if there is no need for it...
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 need to pass private data from MySQL to a flash file securely. I have a PHP script that is assigning variables on the server side - how do I pass this to flash without being available publically? I assume XML and an HTTP query string are out of the question because of security. What's the most secure way of doing this? Basically I have some file paths that I need to load into a music player - however, I don't want these URLs to be publicly known. I was hoping I could pass data directly to flash securely somehow.
View 2 RepliesI don't like cookies. For saving data, submitting scores, etc. I'd like everything to be submitted into user's accounts in a mySQL database. I can do all that very easily with PHP, but how would I make it worth with flash/actionscript (I mainly/am used to working with AS2, but I have Flash CS5 now, so I can work with AS3 if necessary or more efficient). I have no idea how to mix actionscript with other languages (other than using a link with get variables, but, aside from the obvious reasons why that won't work, I'd prefer, if possible, to transmit data without any page reloading).
Are there any security holes or downsides I should consider before making a flash login system? I'd like to allow users to login if they wish to submit their score or save their data (mainly for users playing on a third-party site).
i'm trying to connect Action Script 2.0 Scrollpane to get data from php and mysql... my problem is in the action script 2.0 i'm trying to recieve data from mysql by php, Here is my php code :
[Code]....
and my data base is working 100%
i need to display the result in a ScrollPane Object In AS 2.0
I have a move clip called 101.
[Code]...
assigned to 101. Inside of 101 I have dynamic text fields with the var names of price, fee, and state.I have a movieclip 102 that is exactly like 101. What I need to know is, how can differentiate 101 from 102 so that when the db data comes in that 101 and 102 display different info?Also, I can't change the var names. They must stay as price, fee, and state in both movieclips.
Does anyone knows how do I readback data from mySQL with PHP?
E.g: I've a registration of students data and when I click on individual, flash reads back the particular student's data for me to edit.
I use loadvariables to get data from mySQL using PHP and up to Flash. Flash gets the data flawlessly. Now one of the data I load into Flash is a path to an image.
My problem is, when I check the imgVar variable, it telles me, its value is: images/news/001.jpg
Now When I use the AS:
loadMovie(imgVar, blanker);
it does nothing (blanker is the movie clip I load the picture to).
When I use the AS:
loadMovie("images/news/001.jpg", blanker);
it shows the picture...
My other question: If I solve this problem, how Can I resize the externally loaded image by just setting either the height or width and doing the resize so that it won't deform my image.
I have a move clip called 101.
onClipEvent (load) {
loadVariables("you.php", this, "GET");
}
assigned to 101. Inside of 101 I have dynamic text fields with the var names of price, fee, and state.I have a movieclip 102 that is exactly like 101. What I need to know is, how can differentiate 101 from 102 so that when the db data comes in that 101 and 102 display different info?Also, I can't change the var names. They must stay as price, fee, and state in both movieclips.
I 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'm making a login script and adding the data to my local mysql database using php.it works as long as I browse in my browser to localhost/ flash/ movie.swf but if I just open the folder and run the .swf file it doesnt work
View 2 RepliesI 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 Replies