ActionScript 3.0 :: How To Read A Database
Feb 16, 2010I'm trying to figure out how to read a MYSQL database with as3 and php.. I can't find any tutorials for this.
View 8 RepliesI'm trying to figure out how to read a MYSQL database with as3 and php.. I can't find any tutorials for this.
View 8 Replieshow to read from the database.as i said, that is only part of the job since it only shows how to read from the database, i also need to send to the database a string of about 7k (more or less 5000 to 700 bytes, in a single string)i would like to do that trough php, since it should use the same php session id. does anyone have references to this? (write to a databse from flash, if possible using php as middle layer)
View 1 RepliesI'm reading data from an SQL database and send it to my Flex app. My source code in Flex is the follow[code]...
View 1 RepliesI would like to create a database and read/write data via actionscript3. I'm an absolute beginner in this field, where do I have to start?
View 9 Repliesim trying to read values from a mysql database into different textboxes but as at now all the textboxes are filled with the same thing which is the first item of the database. This is not what i want. What i want is for the text boxes to be filled with the different items of the database. Attached to this message is the php code i have and the actionscript code
phpcode $userName = "helena"; $password = "GODLOVESME"; $con = mysql_connect("localhost",$userName,$password); if (!$con) { echo "not connect"; die('Could not connect: ' . mysql_error()); } else { mysql_select_db("helena", $con); $result = mysql_query("SELECT * FROM messages "); $j= 0; $nRows = mysql_num_rows($result); $rString ="&n=".$nRows; for ($o=0; $o< 10;
[code]....
I would like to create a database and read/write data via actionscript3. I'm an absolute beginner in this field, where do I have to start?
View 4 RepliesI'm working on this flash game right now and I need to implement a simple players database...
It needs to be both read and writable . Meaning, when the player register to save his character information , he needs to key in his email and a password and create an account. The account shall store that player's life amount, ammunition etc . All the infos are stored on an external file and retrieved again when the player logins to the game with the email as his login ID. Security issues are not the biggest concern here because its not exactly meant to be an online game and I don't think hacking would be something I need to worry about ^^'''
I've tried Xml with AS, but I realised that, that alone canot allow me to write the player's info into the xml file.
I'm not exactly an mySQL idiot...but I really have very(x2) rusty and limited knowledge of it. All the server topics confuses me and I've had no experience with Microsoft Access.
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 RepliesI 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.
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]....
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].......
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].....
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.
Can I build flash application that connects to database? (MySQL) For example: Photo Gallery that brings me the photos from database...
View 3 RepliesHere 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]...
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 RepliesI am planning to develop a standalone application, which infact will be used for personal purposes. So only single user access may be there. I want to develop it in Flex. Just want some opinions from the gurus over here : Whether i should use Flex or AIR (I know only Flex, AIR i need to start learning)Which database i should use? SQLLite or HSQLDB or some other.
View 3 RepliesI have a database on a server and I transfer the data from it to a web site. So I need to build a flash grid on this site and to load the data on it. But the problem is that I do not know how to do it. So my question is how to build a dynamic flash grid wich is fill with data from a database? Is there a way to do it with action script only or I must do it another way?
View 1 RepliesAs the title says, suppose I have an hypothetical XML containing this:
[Code]....
I can check if a certain speech has a bg change by simply doing this:
if(bgs[i])
{
//true!
}
what should I compare in the case of sounds, I've tried many, like:
[Code]....
I am writing a large flex app that has to connect to a database many times. I currently am using asp pages to connect, but I would like to use the most efficient option. What do you think is the best way to connect to a database from a flex app?
View 1 RepliesA friend of mine has a Flash Action script running on a LAMP server that currently reads an xml config file. He's asked me if it's possible to remove the xml file, and replace it somehow with a system (lets call it an 'auto xml generator') that intercepts the request to read that file and generates an output, so it appears to all intents and purposes as if the file still exists and contains the contents that has actually been returned from our auto xml generator'
View 3 RepliesSo I want to read http streams using flash tcp sockets. I do not really need the http header at all - all I need is body which contains flv. so how to read http response body into byte array using flash sockets?
View 1 RepliesI want to create a login page in Flash, containing two text fields (username password) and an Enter button. The database I am using is MYSQL where is a table with username and password elements. For the connection I must use ASP.NET and not PHP.
View 1 RepliesI am wanting to try to use a sqlite database in my project.I have downloaded several sqlite managers from the internet and they all save the database with a sqlite extension.However I see in flash we use the db extension (is this correct?);How can I use the databases I create if they all save with a sqlite extension?
View 4 RepliesHow to connect the sql database to retrieve and send the data from flash application? Is there any possbile of two tier concept in flash?
View 1 RepliesI want to connect to MS SQL Database using Action Script 3.
View 1 RepliesI have a list of items in a database as well as images in a directory folder. I am looking for a flash app that can pull from the database to display the info and also the images and scroll this info vertically with associated links. I need to change this for each client by adding their unique "ID" in the code so their information pulls in correctly.
View 1 RepliesI have written a flash program using AS3 which allows the user to build a picture of a product using a variety of options displayed in checkboxes. Very simply these checkboxes either make a layer visible or invisible in my flash movie and certain choices may change the list of options. This information is currently being supplied by XML. Once the user has built his product, I would like to be able to save his choices in a SQL Server database and also be able to download his options again at a later date and view these choices at the manufacturing plant.
So far I have tried using asp.net to write to the database and have got the information to the asp.net program by using the querystring, however there may be up to 50 options which does make a querystring rather unwieldy. Also I cannot seem to send back information from the asp.net page to my actionscript.Can anyone tell me how to do this or give me an example? I am supposing that I use the response.write function in asp.net but what command in AS3?I looked into the possibility of using a webservice but see that AS3 no longer supports this as all the functionality is in Flex. I have read about Flex but still do not understand whether
I visited a website today and saw something that really interested me. They seem to have built a generic .swf that looks like it calls another .swf maybe from a database. I think this would be pretty slick as you would never have to touch the main page, only update with a newer .swf on the database. [URL]
View 4 RepliesI have an ongoing project that outputs xml data to my client's server via a php script. The client would like to move the XML into a database, and their database company has instructed me to POST the XML to a web address with a form field linked to the database. This produces a server error (if I manually paste the XML into the form it works). In order to get this to work, does there need to be a PHP or some other server side script between Flash and the database
View 12 Replies