How to connect to MYSQL DB from Java, create table, insert data, retrieve it with datatypes. How to make use of the data to/from in Flex application. i have basic knowledge in sending and receiving messages using BlazeDS.
View 1 RepliesI 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 RepliesWhile I am connecting the dateservice via menu Data> connect to BlazeDS the error showing that RDS server message : connection refused : connect
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 RepliesHow do I load data from a mysql table to a combobox using php and AS ?
I do know how to retrieve the data from my table needed but how is this inserted the combobox ?
Assume you have combobox1 and combobox2. When I, in combobox1 select: 'cars' I would now like the script to search my table for cars in the column 'stuff' and then insert the result in combobox2.
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 Repliesi have a sprite,this sprite function is to connect to mysql database and print data to the sprite..and now if i have a new data in my database.. and i want the sprite can automatically add a new sprite to print the new data.so if i add a new data.. in flash a new sprite can occur and print the new data.. and so on.
View 1 RepliesI have a server with some simple java objects running. I want to build the client with Flex and connect to the server data with BlazeDS. The problem is the Flash Builder is not generating the Classes correctly. Just the properties are being generated, the inheritance are not being generates.
View 1 RepliesI have a typical Flex-based application that was written to use a Java/Hibernate/MySQL backend. The client changed the requirements - now they want to distribute it on a CD where the user can just run the app without any installation or a network connection.
To do this, I certainly need to eliminate the web server and the database server and adapt my application (with as few changes as possible, of course) to a stand-alone application that will fit on a CD/DVD. I've managed to export the data to XML and read it into Flex, but I'm wondering if there's a way to recreate the Hibernate data structures in Flex so I could change as little code as possible. Failing that, is there any way to keep the existing Java/Hibernate external to the Flex code but retrievable without installing Apache Tomcat or MySQL?
I have downloaded MySQL JDBC driver from [URL]... How do I configure it?
View 1 RepliesWSDL defines a number of datatypes supported by web service . Is there a documentation stating the various equivalents of those datatypes on flex side. In general for any language that we use to consume web service, how do we get to know the equivalent datatypes of the wsdl types.
One of the web service that I am consuming is returning base64Binary (an image binary data) , What is the equivalent datatype of this on flex ?
Whenever i start my flash game ... it updates my mysql table at cash and sets it to 0 and in no place do i have a update statement...
the only thing i have is at the very end it loadvar command thing and then the script selects cash but it selects 0 everytime because whenu start the game ... it sets cash to 0
i am trying to insert my html table format into flash... but flash doesn't support that html table tags.. i'm creating a filp book for help manual..In that we use flash and html tags.. His there any other way to insert html table in to flash..
View 1 Replieshow would i display mysql table in flash?
View 11 RepliesHeres my setup:MySQL Table:ID, FIRSTNAME, LASTNAME, DATE of BIRTH, EMAILMy PHP file reads a email from flash and finds any matches. Then it relays them back to flash using echo command.Now i need my flash swf to generate a table with all the matches using collumns for each piece of data.When i tried to do it, it only showed the last match and that was it...How do i make it generate a full table?
View 2 RepliesIs it possible to insert and retrieve images from sql server using actionscript. Also is it possible to create a flash scrolling gallery based on images stored in a database and everytime an image is added it is displayed in the gallery.
View 1 RepliesI'm trying to insert embeddable video code, such as youtube/viddler/etc.. which all start with the object tag:
<object width="480" height="385">
<param name="movie" value="[URL]">
</param><param name="allowFullScreen" value="true">
</param><param name="allowscriptaccess" value="always">
</param><embed src="[URL]" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="480" height="385">
</embed></object>
into MySQL with PHP.
I'm trying to call it in php, but only get the text value back, basically, the entire embed code as text is displayed instead of the video itself. Here is my display code which shows text. How can I make it show the actual video instead?
<?php
//assuming a connection to the database exists
$sql = "SELECT * FROM table";
$result = mysql_query( $sql );
while( $row = mysql_fetch_array( $result, MYSQL_ASSOC ) ) {
$html = array(); //create an array of html formated values.
[Code] .....
The php code right above it pulls out this data, without the slashes and it displays the embed code perfectly as text, but the actual video does not form from that. Is there anyway to have the code displayed act as code and show the video instead of text?
I have spent many days tearing my hair out trying to get this simple flash code to work. I have four text fields named player,tournament,position,prize and a submit button. I have a working mysql database. The php file without the POST variables (i.e. using static data) works fine. I just cannot get the flash to talk to the php correctly. I have looked at many examples and tutorials and forums, but am at a loss. I have had many flash errors over the days. At the moment it is ArgumentError: Error #1063: Argument count mismatch on actions::main/processLogin(). Expected 0, got 1
[Code]...
I have spent many days tearing my hair out trying to get this simple flash code to work.I have four text fields named player,tournament,position,prize and a submit button.I have a working mysql database. The php file without the POST variables (i.e. using static data) works fine.I just cannot get the flash to talk to the php correctly. I have looked at many examples and tutorials and forums, but am at a loss.I have had many flash errors over the days. At the moment it is ArgumentError: Error #1063: Argument count mismatch on actions::main/processLogin(). Expected 0, got 1
[CODE]<?php
$player = $_POST['player'];
$tournament = $_POST['tournament'];
[code].....
I'm building a Flash website with database information with php>mysql>xml>Flash mx 2004. I'm having some major problems!I need to retrieve information of different tables in mysql, and was worried about performance issues.The first query gets the whole model list...The second query will be performed after a model is clicked. Something like: select * from modelinfo where modelID=modelIDinFlash.
The third query is what I have a lot of trouble with! This has to run on the same time or immediatly after the second query. It reads the picture urls and id's from that particular model. I need the filenames for the picture viewer.But everytime I try this third query, the site becomes very slow and have problems displaying the model info.NOW I have a temporary solution: in the first table I have a field which states how much pics each model has, and this number Flash uses to build the nr buttons. But this is not a very solution since I want to keep everything dynamic. I also want to build a drag and drop function... something like a shopping cart. For that to work, every picture must have an unique ID.
how I connect with SQL or MySQL FMS3
View 1 RepliesPossible Duplicate: How to update a MySql DB using Flex
I want to connect flex with mysql
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 RepliesI've set up a small project as a test. I'm using BlazeDS and JPA with Hibernate on my test server, and flex with with dpHibernate to access the Java entities. Each Java entity extends BaseEntity, a class that contains ID and UUID fields. The Flex entities are created by DTO2FX.
when I run the Flex project to try and display a few rows from a Users entity, the SQL that is actually being executed is joining every table in my database. This continues until I get java.lang.StackOverflowError. This behavior is completely unexpected, and I'm not really sure where to look to fix the problem.
@Entity
@FXClass(ignoreSuperclasses={Principal.class, UserDetails.class})
@Table(name="edrUser")
[Code].....
Currently I'm setting up a webservice, which includes a login to access the member area.I'm testing all components seperately, and I've ran into a problem. When the user logs in I want flash to retrieve the user_id as a variable, so that I can use this user_id for member related database access. However, I'm having problems with retrieving the user_id.The login is done by inputting the email and password of the user. If these variables match the data in the database the user is send to the member area. I want to get the user_id by posting the email variable to a php file. In the php file the following code is responsible for this:
PHP Code:
$email = mysql_real_escape_string($_POST["email"]);
I'm trying to develop a simple as3 flash program that passes a collection a variables and returns a result based on the filtered results of a mysql table. Here is my as3 file:
[Code]...
No value is returned. If I replace with '$test4' and '$test5' with numbers such as 1 and 17, a value is returned. Where am I making a mistake?
you know about database examples/tutorials for cs3 ? (i intend to connect flash with php/mysql, if possible)
View 3 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 RepliesSo, here is the question. I have a small flash application that sends some variables to a php script (via POST), and that php script sends them to a mySQL database.
This works fine when I'm testing my flash offline, I go to phpmyadmin, and the registry is done. When I upload the swf to a online html, this stops working. It no longer creates another registry in the database. I have no ideia why this happens.
I read a bit about it and found out about cross domain policy, and thought it might be the problem. Thus I made a small .xml file and uploaded it to both servers (the one the swf is on, and the one that has the database), and its still not working.
[Code]...
In the flex app (without BlazeDS), I send an arrayCollection to Java using a webservice.[code]How can I retrive the properties from ElementNSImpl?
View 1 Replies