LIBRARY: Tutorials Reviews Interviews Editorials Features Business Authors RSS Feed

PHP, MySQL,and Flash

PHP, MySQL,and Flash
Creativecow.net Flash Tutorial


PHP, MySQL, & Flash

Lee Brimelow
Stanford University
San Francisco Bay Area, California

©Lee Brimelow and Creativecow.net. All rights are reserved.

Article Focus:
In this tutorial, Lee Brimelow shows you how to integrate MySQL database content into your Flash movies. This data integration is accomplished by using PHP to transform the database content into XML before importing into Flash.



Video Tutorial



Please visit the forums or read other articles at Creativecow.net if you found this page from a direct link.

Comments

Re: PHP, MySQL,and Flash
by Andie Ferrer
I am using cs3 and it works. dont use the script assist button
Re: PHP, MySQL,and Flash
by Mutlu Tokat
If i retrieve the database data from a different file and i include this file in product.php it does not work. Altought xml data shown in source code the flash object does not work. How can i get work it?
@Mutlu Tokat
by Andie Ferrer
I didn't get your question, but for the flash, make sure you copied the url direct from the url bar so you will not have a mistake, because sometimes url doesn't need the "www"
and check if you have the same code i have:
var theXML:XML = new XML();
theXML.ignoreWhite = true;
theXML.onLoad = function() {
var nodes = this.firstChild.childNodes;
for (i=0;i theList.addItem(nodes[i].firstChild.nodeValue,i);
}
}

theXML.load("http://yoursite.com/filename.php");
Re: PHP, MySQL,and Flash
by Victor Marinov
Same problem with the flash here. I'm kind of new to Flash and I'm using the Flash Pro from the CS5. My code there is absolutely accurate but the form doesn't load anything, while the browser test with the php file works fine.

I see the thread is kind of old but I hope someone would come accross it.

Thanks!
Re: PHP, MySQL,and Flash
by James Kafantaris
I'm for certain I have my php code identical to yours and I know it's connecting but I have one error:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/content/k/a/b/kabutopendants/html/products.php on line 14

Here is my code from those lines:
while($line = mysql_fetch_assoc($results)) {
echo "" . $line["product"] . "\n";
}

My database is setup in GoDaddy.
Re: PHP, MySQL,and Flash
by pete mac
Sorry, but I have to tell you this. It's not called "my sequel". It should be pronounced letter by letter; "My Ess Que Ell"
Re: PHP, MySQL,and Flash
by dennis joosens
Hi,

Really very good tutorial, but the flash part doesn't work!!??

The reading out in the browser with php and mysql works, but the flashpart doesn't and it doesn't give any output errors.

please help!!
iS THERE A FLASH CS3 ACTION
by Adam Goleck
iS THERE A FLASH CS3 ACTION SCRIPT 3 VERSION OF THIS....AS MINE DOESNT WORK...THE PHP AND WEB HOST WORKS AND CAN SEE THE XML ON THE BROWSER....

IN FLASH I GET ERRORS....REGARDING THE LINE 8 AND 9
PHP, MySQL,and Flash
by Paul Rithivi
great tutorial. I have used MySQL, Flash and PHP for years but have never managed to get them to talk. I created the database and pulled data from it really quickly. Thanks Lee. Muchos appreciato!
PHP, mysql and Flash
by David Monjo
Very good tutorial, made clear for the sake of us new to Flash. Thanks much.
PHP, MySQL,and Flash
by nallib said tala montenegro
thanks a lot for that good tutorial
PHP, MySQL,and Flash
by nallib said tala montenegro
thanks a lot for that good tutorial
PHP, MySQL,and Flash
by Jesse Mitchell
Like the fellow above, I am looking to find a way to do this with AS3.
PHP, MySQL,and Flash
by Malinda Bruce
Could you write the Flash part of this tutorial in ActionScript 3.0?
PHP, MySQL,and Flash
by Analiett Solorzano
I just love you!!! I was trying to do this for days... now in my house this works... but I repeat the same in my office and it dosen't... the only diference I see is the flash version... I have flash MX 2004 and in my office we use flash CS3... is there something else I have to do in CS3? I realy adore you, so nice from you to take your time to do a video =)


Related Articles / Tutorials:
Adobe Flash
Adobe Edge Animate/The Missing Manual Software/Book Review

Adobe Edge Animate/The Missing Manual Software/Book Review

Increasingly, web developers are being asked to create sites that are viewable on tablets and mobile devices, as well as desktops and laptops running Windows, OS X or Linux. One of the challenges in creating a site like that is animation. Flash, for many years the preferred cross-platform animation solution, is no longer supported on many tablets and mobile devices. Michael looks for - and finds - answers within Adobe's Edge Animate.

Review, Editorial
Michael Hurwicz
Adobe Flash
HTML5 (CreateJS): Interactivity and Debugging

HTML5 (CreateJS): Interactivity and Debugging
  Play Video
Building on two previous tutorials on CreateJS for Flash Pro CS6, Creative COW leader Michael Hurwicz introduces interactivity (specifically, responding to a mouse click), debugging using the JavaScript "alert" statement, and assigning names to objects exported from Flash. Project files included.

Tutorial, Video Tutorial
Michael Hurwicz
Adobe Flash
HTML5 (CreateJS): Animate with JavaScript

HTML5 (CreateJS): Animate with JavaScript
  Play Video
Building on a previous introductory tutorial on CreateJS for Flash Pro CS6, Creative COW leader Michael Hurwicz shows how to modify the JavaScript exported from Flash, to change attributes such as position, speed, wait time, and color. Project files are included.

Tutorial, Video Tutorial
Michael Hurwicz
Adobe Flash
HTML5 (CreateJS) for Adobe Flash Professional CS6

HTML5 (CreateJS) for Adobe Flash Professional CS6
  Play Video
Creative COW leader Michael Hurwicz provides a brief introduction to CreateJS, an extension for Adobe Flash Professional CS6 that allows you to export Flash projects as HTML and JavaScript, even on platforms that do not support the Flash Player.

Tutorial, Video Tutorial
Michael Hurwicz
Adobe Flash
Building an Interactive Whiteboard in Flash: Part Two

Building an Interactive Whiteboard in Flash: Part Two
  Play Video
In part two of this series, Justin Junda walks you through the necessary steps to connect the graphical elements from part one, with Actionscript 3.0 using the Flash drawing API in order to bring this whiteboard to life.

Tutorial, Video Tutorial
Justin Junda
Adobe Flash
Building an Interactive Whiteboard in Flash: Part One

Building an Interactive Whiteboard in Flash: Part One
  Play Video
In this tutorial, Justin Junda takes you through the step by step process on how to build and interactive whiteboard. These whiteboard are often seen in drawing applications, scratch pads, and educational sites. This is part one of a two part series. Part one takes you through setting up all the graphical elements within the stage. Then part two shows a user how to connect the graphics to Actionscript using flashes drawing API to make this whiteboard truly interactive.

Tutorial, Video Tutorial
Justin Junda
Adobe Flash
Embedding a Speech Transcript in a Flash Video with Adobe CS5

Embedding a Speech Transcript in a Flash Video with Adobe CS5
  Play Video
In this tutorial, Creative COW Leader Michael Hurwicz shows you how to create a scrolling transcript synced with a Flash video, using Adobe Creative Suite 5 (Story, OnLocation, Premiere Pro, Soundbooth and Flash Professional).

Tutorial, Video Tutorial
Michael Hurwicz
Adobe Flash
Inverse Kinematics - Springs

Inverse Kinematics - Springs
  Play Video
Springs are a new feature for Inverse Kinematics in Flash CS5. In this video tutorial, Creative COW leader Michael Hurwicz shows you a simple technique for implementing springs, as well as several other "tricks and traps" to make your work with Inverse Kinematics in Flash easier, more flexible and more powerful.

Tutorial, Video Tutorial
Michael Hurwicz
Adobe Flash
Inverse Kinematics - Control Points

Inverse Kinematics - Control Points
  Play Video
Fine-tune your Inverse Kinematics animations in Flash CS5 by working with control points. In this Adobe Flash video tutorial, Creative COW leader Michael Hurwicz shows you how to associate bones with control points, how to move, add and delete control points, and how to adjust control point handles.

Tutorial, Video Tutorial
Michael Hurwicz
Adobe Flash
Inverse Kinematics

Inverse Kinematics
  Play Video
Inverse Kinematics allows you to create structures of bones and joints and use them to animate characters in Flash. Fun and easy! Creative COW leader Michael Hurwicz shows you how in this video tutorial, step by step. Learn some basic ActionScript, too!

Tutorial, Video Tutorial
Michael Hurwicz
MORE
© 2016 CreativeCOW.net All Rights Reserved
[TOP]