Mysql :: Database - Connection With Sockets Or PHP?
Jan 9, 2012
So, we want to move out from Air (Adobe stopping support and really bad implementation for the sqlite api, among other things). I want to make 3 things:
Connect with a flash (not web) application to a local mysql database.
Connect with a falsh (not web) application to a remote mysql database.
Connect with a flash (web) application with a remote mysql database.
[Code]...
if you can connect with socket wit mysql server, why use a web server (for example with php) to connect like a inter connectioN? why not connnect directly? I have done this a lot of times, using AMFPHP for example, but wouldn't be faster going directly? In the case of accessing local machine, it will be a more simple deploy application that only require the flash application + mysql server, not need to also instal a web server.
View 2 Replies
Similar Posts:
Apr 29, 2011
i have been trying to execute a simple flash program that communicates with a php page which is linked to a mysql database. somehow the php is not returning any data to flash , and even falsh is not sending any data to php.. I am using wamp server on win7.
[Code].....
View 4 Replies
Jan 13, 2010
I have a Flex application which manage a database composed by 7 tables.I have created the insert form and all work great. Now I wanto to improve the Form performances; the idea is to replace the TextInput of the Form with ComboBoxes which are provided by the DataBase tables
View 1 Replies
Sep 20, 2010
I read about a project that enables the developer to program a HTML5 web sockets application that is compatible with older browsers by automatically falling back to using a flash method.
View 1 Replies
Jan 13, 2012
On my network I have a couple of pc's all running a bespoke server which will return the username of the person logged in when queried.I have the following piece of code.
private function LoopAndList():void
{
var loopSocket:Socket;
var fourthOctet:Number = 6;
[code]....
Now when this runs it doesn't work as I first thought. The iterations go though. the fourthOctet value is decremented. But somethinjg strange happens. You will notice in the above code that I have a hardcoded IP address in the loop. I have put this there to ensure that there is always a valid connection. So am aware it will always be connecting to 192.168.0.4.
But the connection only happens on the last connect call.
The ouput is:
192.168.0.6
Connecting to 192.168.0.6
192.168.0.5
Connecting to 192.168.0.5
[code]....
View 2 Replies
Oct 5, 2009
how to connect Flash to a server Using Sockets connection using in AS3.
View 16 Replies
Aug 4, 2009
I want to open a connection back to the server using Flex so I can stream chat messages to the Flex front-end. How do I do this and does Flex enforce any same-origin restrictions on ports or subdomains?
View 1 Replies
Nov 10, 2009
I've written a basic FTP client to allow me to upload files through the browser without using the FileReference.upload() func (because it's damn slow). I've got all the socket logic worked out and it works for one upload. When the upload is completed, the FTP data socket is closed by the socket.close() func which triggers a response from the command socket and starts the whole process over again. This logic works perfectly on my Mac in both Safari and FF.
I can upload files and cancel uploads and it all works as I want. When I test it on Windows (IE 8, FF 3.5, Safari 4 on WinXP and Win7) it is busted. I've tracked down the problem to the fact that on Windows, the socket.close() function is not causing the server to close the connection. I don't know if this is because it's not sending a proper command or what... but that's where it's at.
View 4 Replies
Jun 28, 2010
This is driving me nuts and because it's a combination of various technologies together I have a hard time tracking the problem. I wrote a tiny HTTP server that serves .flv files; these flv files are encoded on the spot. The flv files are encoded with adobe's screencodec (I started with libflv but that was too buggy so I ended up implementing my own flv encoder). For the problem below it doesn't matter which codec I use or if I serve plain flv files instead of on-the-spot generated ones (the problem also occurs if I just send 12 h264 encoded files).
I also have a swf that I coded in as3. The as3 opens 12 connections to my server and requests 12 different flv's and just displays them as 12 different videos on the page. I tested the setup with Firefox and chrome and am using the latest flash client (version 10). The HTTP server is pseudo streaming those files; e.g. it tells the client the file is of mime type video/x-flv, tells the filesize is 2GB and just starts streaming. For sake of completeness here's a header it generates:
[Code]....
View 1 Replies
Jan 12, 2009
I have a flash file which uses asp to connect to a mysql database. Is there some way to add an event listener which will send a notification to the user when the connection to the server has been lost?I was thinking of just setting a timer so every 10 seconds it runs an asp file which checks if there is still a connection.
View 1 Replies
Sep 11, 2009
i have been trying to execute a simple flash program that communicates with a php page which is linked to a mysql database.somehow the php is not returning any data to flash , and even falsh is not sending any data to php.. I am using wamp server on win7.Heres my actionscript code:
stop();var variables:URLVariables = new URLVariables();var varSend:URLRequest = new URLRequest("php.php");
varSend.method = URLRequestMethod.POST;varSend.data = variables;
[code].....
View 5 Replies
Feb 4, 2010
I've started with Flex recently, I've noticed that some plugin for Visual Studio exist, instead of buying a licence for another program (Flex Builder).I was wondering how I could manage to remotely connect to my database with a Flash/Flex application with the help of C#/Asp.Net.
If I've correctly understood what I've read in the last few days, there is basically no way to 'query' to a database with Flex 3. So I suppose there is another way by using a webservice in C# on the database server that would respond to the Http query from Flex.
View 3 Replies
Jan 16, 2009
I have some troubles writing a database connection in AS2.0.I use LoadVars for loading and sending data. This is an example how it works, but when I use this inside a class it doesn't work.
ActionScript Code:
var loadVars_in:LoadVars = new LoadVars();
var loadVars_out:LoadVars = new LoadVars();
[code].....
View 5 Replies
May 20, 2009
how tp use databases with Flash CS4 ?I have created a form, an email page and a username/password protected pages, but I cannot find any tutorials that would help me how to connect to a database.
View 7 Replies
Feb 18, 2010
how different is actionscript 3 compared to actionscript 2 i mean to integrate a datebase using mySQL if so how?
View 1 Replies
Oct 24, 2010
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 Replies
Jan 7, 2011
I have a problem with saving the £ symbol to a mysql database.I am running a flex front end, with a php + mysql backend When I save a record from flex, the string gets sent to the server as "This amount is £10" php views the string as above, and when it gets saved into the DB, it gets saved as "This amount is £10".
My understanding is that this is correct based on MySQL or PHP is appending a whenever the £ is used I now retrieve the above record, and it gets sent to flex as "This amount is £10". Flex correctly displays this in a textarea as "This amount is £10" I change another field in the same record in flex, and re-save the transaction. The string now gets sent to the server as "This amount is £10" The record is now saved into the DB as "The amount is £10". Each time the record is re-saved, this effect snowballs.
View 3 Replies
May 31, 2010
I am accessing my MySQL database through Flash using AS3. I am using php scripts to access my database and send and receive variables. Everything is working fine. No problems there. The problem, or rather the question is, is it possible for flash to run a script to access a database without a webserver running on the machine? Isn't there some sort of plugin or adapter or interface class available in flash that will allow me to do that?
View 7 Replies
Feb 7, 2006
I have a database with info about each of my movies (filename, size, length, credits, etc) How would I load the variables for a particular movie from the database into the flash?
I did a search on the forum, but I wasnt sure excatlly to search for so I didn't find anything.
View 6 Replies
Feb 12, 2007
i am trying to connect php to a mysql database by doing the following: $con = mysql_connect("localhost:8080","username","passwor d"); when i try to run the php file in the browser it takes forever to load. What could be the problem? and what am i doing wrong. i created the database with mysql in xampp.
View 2 Replies
Feb 10, 2009
something strange about loading database mysql with urlloader
[url]
when i compile and run it via flash it worked , i can load the data but when i embed that swf into website the data won't loaded . what's happened?
View 3 Replies
Dec 24, 2010
I am making an online game with AS2 and my method for storing the location of users is with a table with columns: name, x, y. The table has many rows.
I have a PHP script which makes a query in the DB for all x and y locations from -6x to +6x and -4y to +4y (Relative to the user).
If a user exists at that location, then they will be printed on a list that will end up looking something like this:
&username1=John&x1=16&y1=8&username2=Fred&x2=16&y2 =9
I want to know how to make a loop which takes the information printed from the PHP script and use some sort of efficient loop to take username1, username2, username3, etc. and place them at the x and y positions listed. I will use the "loadVariables" function to get the variables from the PHP script.
The main thing that confuses me is how I am to make a loop which manipulates the variable name. I am thinking of using OO with which I can do username(1), username(2), etc. but I am not familiar with actionscript so it would be difficult.
I also need to be able to place an object from my library to the screen and when I did a search, I could not find how to do this.
View 1 Replies
Aug 25, 2004
I have made the following script to search in a Mysql database. The script works fine the first time you search. Second time if you try to search for some thing else the old search result keep appearing. Is there some way that i can clear the search result when ever i initiate in a new search?
This is my script:
this.createEmptyMovieClip("myForm_europe", 0);
myForm_europe.newSearch = 1;
myForm_europe.searchType = 0;
myForm_europe.searchArea = 0;
[code]....
View 2 Replies
Aug 24, 2010
How can I establish connection of a Flash site with a database(i.e. MYSQLetc)?
View 4 Replies
Mar 14, 2011
When working with CRUD operation in flex, I want to know how to open only one time for all update and delete operations. How can I do this?
View 2 Replies
Aug 30, 2010
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 Replies
Jun 20, 2011
I can get the data from the mysql database into the flash onDataLoad function but cant get it outside the function, and that is what i need to malipulate other data already in the project (update it)
var myLoader:URLLoader = new URLLoader() myLoader.dataFormat = URLLoaderDataFormat.VARIABLES myLoader.load(new URLRequest("http://localhost/flash_php_mysql/FormData.php?"))
[code].....
View 6 Replies
Aug 8, 2010
I cannot pre-view a flash movie in a php.page. Question, How, where, do i store a swf file name and location in mySQL database and then use this data to call it in the application?
View 1 Replies
May 15, 2011
I need some help with a flash app im currenctly programming. I have a management flash app that does some operations in a MySql databases. I have had some problems, but for the most part, I have been able to press on. I'm a flash AS3 newb, so bear that in mind.
My actual problem is that I need to do a "Search" module, and I need it to print several results at once. I am although unsure how to get the results on flash. what I have been doing now is calling a php script that, after doing its operation, does something like (for example):
[Code]...
View 2 Replies
May 15, 2004
I am using Freddy Thunder's tutorial on how to make a login script with php/mySQL The problem is that the button doesn't do anything when I click it. I can't tell if it goes to the php script, but it sure doesn't return the correct variables like it is supposed to.
View 3 Replies
