I'm not shure if this goes in the ActionScript forum, but no one anwsered in the Flash MX 2004 forum. And seens this is 50% ActionScript and 50% PHP i thought i would post it here aswell. Here is the thread that i started in the MX 2004 forum
View 14 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 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 RepliesI have downloaded MySQL JDBC driver from [URL]... How do I configure it?
View 1 RepliesIn my table the Collation is:latin1_swedish_ci (but i tried UTF8_unicode too).In my flex application when it shows the table,it displays it correct,with all accent and pointing correct,but in the table is like :
View 1 Repliestutorials (e.g. ) show how to integrate Flash and MySQL. Also Flash can manipulate and sent this back to serverTo integrate flash and MySQL one can do the following:(1) MySQL -> php -> Flash (e.g. What is the most robust way to set up (1) and (2) to work at scale - as quickly as possible? What are the server loading implications? Is there any other way to do (1) and (2) more effectively?
View 2 RepliesI'm trying to create a dynamic menu in Flash using PHP & MySQL and bring it into Flash using AS3 DataProvider. My menu works fine with a local Array, but I seem to have an issue with the Type being a String and not an Array, but how do I set it up properly so the types are correctSo I started with a typical, non-dynamic array and it works to create my menu:
Code:
var items1:Array = [
{myClass:"SCI101", question:"What color is the sky?"},
{myClass:"MATH110", question:"What is the square root of 81?"},[code].....
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 Repliesim trying to pull .swf files from MySQL by using PHP, ive set everything in the database up with an ID and licked it properly. Im not sure if the 'type' has to be anything special, right now its just a 'VARCHAR' and when altering the javascript part of it that that flash automatically generated-- in the i tried to echo it out by putting it in the value like
< param name="movie" value="<?php echo $row['video_path']; ?>" />
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'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?
Ok so hereby I am starting a new topic after successful coding of xml file I am trying to produce flash text rotators from the xml file.Now i could do this in javascript which I have already implemented see link:dedication message
[Code]...
I am having a huge problem and need a fix or at least to be pointed in the right direction quickly. I am working on a massive flash project for which I have quite a large deadline tomorrow. I have 8 movie clips on my stage, and each of these clips has a number of entities which need to be loaded and changed by data from a database. These entities are all dynamic text boxes bar one thing: the name of the clip, the id of the clip, its internal colour, a question, and an answer to this question. I have already created a table using phpMyAdmin that is laid out like this:
name - number - colour - question - comment There are currently 2 rows in this table but there will eventually be 8 minimum as I am still largely in test mode. I found a tutorial for as2 (bare with me ), which shows me how to take a single source of data from a database and then parsing the xml generated inside of actionscript and add each item to a list. However, taking into account that I am a complete newbie when it comes to xml and php and mysql, I am very confused as to how I could access all these details using php, using the below php and as code as a template:
[Code]...
I'm working on a Site that uses Flash in conjunction with a PHP and MySQL. It is possible that someone could guess the variable names used in my PHP scripts and post bogus data to my data base.
I'm using a script to escape all of the data that goes to MySQL.
I need to create a map of the U.S. that looks at a MySql database and highlights the states that have store locations and makes them buttons, and leaves the states that don't have store locations gray without button actions.
I understand how to create the individual states MCs with a gray state (no button) and a button state. I just need to know how to turn "on" the states from a MySql database.
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 installed on my site php script "Cutenews". It works without any MySQL... It save all archives in text files.
its PHP script looks like this:
<?PHP
include("show_news.php");
?>
The file URL is [URL]
I would like to put this script into my Flash movie. I was trying to find some tutorials but it talks every time about PHP database MySQL and XML, and "Cutenews" doesn't have that...
I'm not sure that I have to use Dynamic Text or not and what ActionScript have I write and where.
i am trying to communicate Flash to PHP then to Mysql..
i have tried and tried but its still didnt work whereas i have cheked many many times about the script
this error is being generated when publishing the flash file:
------
**Error** Symbol=Symbol 1, layer=Layer 1, frame=1:Line 1: Clip events are permitted only for movie clip instances
onClipEvent (load) {
Total ActionScript Errors: 1 Reported Errors: 1
--------------
I've named the Movie Clip and the Dynamic Text window myVar ... not sure where I'm going wrong. The dynamic text window was created, then changed to a movie clip symbol, which is where the onClipEvent was added. (see attachments)After completing the tutorial and browsing the gallery.html page, the following error occurs: "The requested [URL]e was not found on this server." However read.php has been uploaded to my test server. I suspect that the problem is occurring within the .fla file.My end goal is to pull title and imagepath fields from an existing mysql db and display the results in a flash gallery.
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.
I have a set of urls for stored in a mysql database online which each relate to a video on my local hard drive, i am trying to load these into flash using the flvplayback component but not getting very far.
I have created a php file to try and select the necessary information from my database so this can be read as xml for flash.
I was wondering if anyone has any experience in this and could please provide me with some help of loading in these urls to flash.
Communicate flash to php to mysql to get data back to flash. Everything works fine but I found a really annoying bug. Problem: Depending on the URLRequest, I got to put www in the URL of the browser to make my flash work.
[Code]....
how would i display mysql table in flash?
View 11 RepliesI 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 want to pass through an array from php (which queries a MySQL database) to flash.
[Code]....
Can I not use any form of array in php when I sendandload to it from Flash? If so I'm going to be typing a lot of code in the next few days.
Heres 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 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