List Database Records Using Amf Php
Jul 7, 2009
I'm trying to list in flash, several records that come from my database. I'm not talking about a datagrid or anything to fancy. I just want to list the values inside text boxes. (to allow editing). I already have fetch an array of records that come from the database, here:
[Code]...
My question is: How can I display several records, instead of only 1? Should I change the call to, instead of 1, uses a variable? But where would that variable comme from? Then I should loop again the addChild method for each child of form2 that needs to have different records on each of them?
View 1 Replies
Similar Posts:
Feb 6, 2009
I've got records being populated into our database from paypal's Instant payment notification methods...great. now i turn to our flash cs3 app to populate a component datagrid with the stored database data and to my surprise I'm unable to identify any examples on how this might even be done.
How do you connect to an mssql database from within flash cs3 to retrieve data for displaying within a flash datagrid?
I can write a cfc from coldfusion to return a dataset, but overall i'm not sure if i 'have' to learn Flex, or AIR or what to get the records 'read'.
My ActionScript 3.0 bible is vague at best and resorts to php. (which i dont know)
View 6 Replies
Feb 11, 2012
Case1: When a client makes a remoteObject request ie to save some Info... A call is made to Java SAVE_INFO method. If request failed ie came back to FaultHandler ( we save the info in an arrayCollection).Later we call SAVE_INFO again for each item in arrayCollection ie( if arrayCollection has 10 items.. We call 10 times the same method.. I know that's kind of stupid but we have no control over java to write a overloading method). Some times we see there are multiple records of same info in DB. I am not sure if this happens when looping over arraycollection and making calls or during normal one time call. We could not find a pattern to reproduce. Java LOG level is at Error level in production. can't set to INFO in production to monitor all calls. We dont know if this multiple times saved record is, the one in arrayCollection or normal one.
Flex3 RemoteObject --> WAS 6.1 , lCDS 3.0, Java1.5 --> Webservice -- > Java (hibernate) --> Oracle 10gCase2: When application is left open and user leaves for the day and submits info the following morning, we see duplicate records in DB of that info.(No arrayCollection here. Simple straight one call)Flex3 RemoteObject --> OC4J Blazeds Java1.5 (JDBC) --> Oracle 10g.Recently one of our Testers testing case 2 application found this pattern and I am starting to think that may be in the case 1 also.. users might be leaving for lunch/break and resubmitted the arrayCollection after coming back. During lunch java might have killed the sessions for the client and after resubmitting 10 at same time.
View 1 Replies
Feb 25, 2011
I have a List that displays the contents of an SQlite database I have created. However, When I run the function to delete one of the user-selected items from the database, the items is still displayed until I refresh the View (right now by clicking 'home' and the reentering the View). How can I get the list to automatically update when the user deletes an item? [code]...
View 2 Replies
Aug 31, 2009
I am acquiring the contents of a table to fill a dropdown box in a Flex 3 application:
<mx:ComboBox dataSource="{myList}" />
The list is populated by the contents of a database table of persons:
Public, John Q
Doe, Jane
...
The combo box, however, also needs to have some other meta-entries in it that do not come from the database:
ALL
ALL MEN
ALL WOMEN
Public, John Q
Doe, Jane
...
View 1 Replies
Oct 19, 2006
How can i make sure i only can see the last 10 records of a xml file in flash 8?
and when clicked on a button goes to the rest after that 10 records. (this is easy)
but i don't know how to stop at 10 records at the homepage
View 2 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
Dec 17, 2009
I want to create a Flex 3 application running in Adobe Air that accesses an SQLite database and I need to keep this database in sync with an SQL server 2005 database running a website.Is this something that Flex supports or is it going to be a custom script? Also, has anybody done anything like this?
Edit: The synchronisation can be done on a daily basis rather than real time. The data will be read only from a front end perspective with a CMS to do updates on the website.
View 2 Replies
Jun 18, 2009
I am writing a Flash object which will be an on-line quiz. I got most of it working ok, but it reads the questions sequentially from an xml file. I want it to be random. Each record in the xml file has an 'ID' attribute. This is my code that currently reads the questions in sequential order:
var question = new XML();question.ignoreWhite=true;question.load("Questions.xml");
question.onLoad=function(){ question_txt=this.firstChild.childNodes[_root.record].attributes.ques tion; answer1_txt=this.firstChild.childNodes[_root.record].attributes.answe r1;
[Code]...
There are 300 questions in the xml file. I want to assign a variable with a random number, then look in the xml file for the question which has the ID attribute matching the random number. How do I achieve this?
View 5 Replies
Jun 7, 2010
I have researched this issue all over and most people say use the .refresh() method to update a datagrid after updating or adding a new record. This does not do anything. So, my issue is this. I have a mySQL database hosted I am connecting via PHP, I have 1 mxml file and 2 php files (I know I can use just 1 but I am learning and this was easier for me to use for troubleshooting). The issue is no matter what I change on the datagrid the update does not show on the datagrid unless I close out of IE and reopen it. I can refresh or open the page in another window and the update does not show. I have to exit entirely and restart in order for any updates or additions to show.Here is my licenseTracker.mxml
<?xml version="1.0" encoding="utf-8"?>
<s:Application xmlns:fx="http://ns.adobe.com/mxml/2009"
xmlns:s="library://ns.adobe.com/flex/spark"
[code]....
View 9 Replies
Jun 17, 2010
I am working on a function to generate a form at runtime in Flex based on a call to the DB. The call to the DB returns the field types, id, tooltips etc as an arraycollection, the arraycollection is then parsed in order to ascertain what control to display based on the type field in the array - this bit works fine.However, i am stuck on trying to save the form fields back to the database using a CFC.my form rendering code is as follows but how do i save values entered back to the database? rendering code..
[Bindable]
public var getglobalprofileb:ArrayCollection;
public function init(event:ResultEvent):void {[code].......
View 1 Replies
Aug 31, 2011
I have updated the mxml code to only show the needed code for the program to run the update.
I am new to Flex and have an issue I hope you all can help me out with.
I have researched this issue all over and most people say use the .refresh() method to update a datagrid after updating or adding a new record. This does not do anything.
So, my issue is this. I have a mySQL database hosted on 000webhost.com, I am connecting via PHP, I have 1 mxml file and 2 php files (I know I can use just 1 but I am learning and this was easier for me to use for troubleshooting). The issue is no matter what I change on the datagrid the update does not show on the datagrid unless I close out of IE and reopen it. I can refresh or open the page in another window and the update does not show. I have to exit entirely and restart in order for any updates or additions to show.
Here is my licenseTracker.mxml
<?xml version="1.0" encoding="utf-8"?>
<s:Application xmlns:fx="http://ns.adobe.com/mxml/2009"
xmlns:s="library://ns.adobe.com/flex/spark"
[Code].....
View 1 Replies
Dec 14, 2006
I have a created a flash searchable database with xml,following this tutorial url...It seem to be work great but my the xml file seems to be too
large so when certain words are search I get a script error and eventually freezing up, my question is Is there a way to tell flash to load the 10 or 20 records at a time? By loading sections of the xml one at a time will this stop the script error?
View 1 Replies
Jul 19, 2010
I have a advanced datagrid and displying the 10 records. but when loading the data, the first record should be selected.
View 1 Replies
Aug 29, 2011
I am trying to create some charts in Flex/FlashBuilder 4.5The issue I have it that the information I wish to display is the number of events within an area. I am using HTTP service to access a rails controller which is returning an XML list of the events.I need to figure out how to chart the number of events, eg number of records returned. There is no numeric value within chart, as there would be if I was charting sales or prices for example.
View 1 Replies
Mar 29, 2012
I have a Wowza Media Server 2 running on Amazon EC2 and I've noticed from time to time a flv is recorded from a webcam using Flash that has audio but no video. It works fine most of the time but from time to time this error occurs
View 1 Replies
Feb 5, 2009
I load in 8 XML records at random - the actual xml file contains about 37 + but the method i am using at the moment doesnt semm to be that random. It was done this way so i dont pull in the same record twice as i do not want duplicate entries
Code:
for (a = 0; a < randNo; a++)
{
var num:Number = xmlAd.firstChild.childNodes.length;
[Code].....
View 1 Replies
Jul 7, 2009
programming and on AS3... have patience. :s
I have the following on my php service file :
Code: Select all function updateRecords($id,$name,$age){
$query = mysql_query("UPDATE data SET name= '$name', age= '$age' WHERE id = '$id'");
[code]....
View 4 Replies
Feb 18, 2008
I am getting problem in flash,php,mysql integration .The php page is fetching the data from database .But when i include this php page into flash document ,the data are not showing.
This is the sites.as file.
function lv(l, n, t, e, f) {
if (l == undefined) {
[code]....
View 2 Replies
Feb 23, 2005
I have results from my mysql coming to flash mx and I am trying to format it in rows like:
VENUENAME ADDRESS PHONENUMBER
And I want about 10 records to show in flash at a time....
Here is the actionscript and the PHP code:
// Create another LoadVars instance to receive the server's reply
replyData = new LoadVars();
// Specify a function to call when this new instance receives the reply.
replyData.onLoad = handleReply;
// Submit the order data
[Code] .....
View 1 Replies
Jan 17, 2011
I am planning on using Flash Builder 4/Flex to write an AIR application which is primarily based around recording, storing and analyzing data.I'll be creating charts etc that need to update in almost real time.It's essential to me that the application be able to function without an internet connection so I need a local database of some variety,but I would also eventually like to build in online synchronization of the data where either database can be update each other based on newer information. Moreover, some type of encryption would definitely be welcome, and speed is a large concern
Synchronization: Primarily updates/additions/deletions will be done on the offline database, but ideally I want to have a web interface that will allow the same updates/additions/deletions and will be synced (beyond that I'm not sure exactly how to do it as I can model that based on what is most achievable).I'm wondering if there's any prebuilt engine that could handle the synchronization of 2 databases. I may end up having the web interface only be for additions, which would be significantly easier to sync.. and I may start that way, but i want to build with technologies that will best allow me to implement full online crud at some point.
View 1 Replies
Jul 17, 2011
Can I build flash application that connects to database? (MySQL) For example: Photo Gallery that brings me the photos from database...
View 3 Replies
Sep 26, 2011
Here is the issue: a client wants his entire equipment inventory accessible by persons navigating to his jquery mobile site. The inventory that exists on the desktop site was, as I understood, built with Flex. Is it possible to access this database for the jquery mobile site? I believe it is. I was then given this information from someone in the know:
Database:
mlxx.db.xxxxxxx.hostedresource.com
login: mxxx
[code]...
View 1 Replies
Oct 26, 2006
Is it possible to create a database driven website using these alone? Or do i need to learn any other technology? If i do then what should i learn? I know j2se for the desktop and oracle SQL/MySQL i finally got the feeling that i need to learn PHP anyway along with css and javascript. So it is fine. Also another query. Which CMS should i consider? Wordpress or Joomla?
View 1 Replies
Apr 7, 2009
I've been searching all over for an answer to this, but have not had much luck. I have an .xml file that loads its data into a DataGrid. However, I don't want all the data to load up at once. I would like it to load the first five records, and after x amount of seconds fade out and fade in with the next five records.
View 2 Replies
Apr 14, 2010
Ive made a php file which shows me all the records from a table in a db
PHP Code:
Actionscript Code:
<?phprequire_once 'db_config.php';$sql="SELECT * FROM guestbook";
$result=mysql_query($sql) or die(mysql_error());
$count=mysql_num_rows($result);while ($data = mysql_fetch_assoc($result)){
$id = $data"[msg_id"]; $sender = $data["msg_sender"]; $subject = $data["msg_subject"];
$text = $data["msg"]; $date = $data["msg_date"]; echo($count);
echo($id); echo($sender); echo($subject); echo($text);echo($date);}?>
Which gives me this result in a browser
Actionscript Code:
21Arnetest 1.2 3hallo, dit is een eerste test berichtje grtzzzzzzzzz2010-04-14 14:03:0022Arne Janssenshallo!test nog een keer2010-04-14 14:03:00
Now is my question:
How can I write this code better, so that flash can handle it? Do I make an array of the results?
View 5 Replies
Mar 1, 2011
I make my fla file and then want to move an image on the stage slightly without recording the movement!
I have tried many ways and cannot - I even set up guides as I end up deleting layer and resetting.
View 6 Replies
Feb 2, 2011
In the AdvancedDataGrid shown bellow I have one groupingField as one can see. I would like to have the ability to click in a record (letīs say the 26/01/2011 - Pag.) and right bellow it to have some action buttons.
How can I do it? Would it be by using a AdvancedDataGridRendererProvider? Iīve tried to do it but didnīt get the expected result.
View 1 Replies
Aug 8, 2011
I'm using Flex 4.5 with PHP Zend webservice framework. Basically, I have 2 DataGrids that can drag and drop between each other. At the initializing of the component, I call a webservice to populate the top DataGrid. Then the user can drag rows to the bottom DataGrid that get processed and saved later on. My problem is that I want to have a reset button (or cancel button), that will take the user to a new component in the ViewStack, and if they return to the component with the DataGrids, the top DataGrid has the original records and the bottom DataGrid is empty.
I just can't figure out a good way to repopulate the top DataGrid. I can clear it, but it doesn't seem to refresh with the original data. I've tried unsuccessfully to call the webservice again and set the dataprovider to the new lastResult token. I've also tried unsuccessfully to copy the results of the initial webservice call to an ArrayCollection and simply set a Bindable variable to that ArrayCollection (or a backup of that ArrayCollection holding original records).
<?xml version="1.0" encoding="utf-8"?>
<s:NavigatorContent xmlns:fx="[URL]"
xmlns:s="library://ns.adobe.com/flex/spark"
xmlns:mx="library://ns.adobe.com/flex/mx"
xmlns:valueObjects="valueObjects.*"
[Code] .....
View 1 Replies
Oct 5, 2011
I know how to use AS3 to record sound from the user and enable them to save it to their computer. However, I would really like instead to allow them to either send it to an email address right after recording (without them having to save it to their computer first and find the file), OR to let them save it so that the site owner can access it (They would know that it was happening.).
View 1 Replies
