Images And Co. From MySQL Database With Php
This one is heavy. In flash I have 15 image groups. Each group has 5 banknotes in it. When I choose one group, I get a screen with 5 preview pics, each with a short info text on mouse-over. On this page I can click <prev next> through all 15 groups of preview images. When I click on a preview image, I get a screen with the big banknote picture. On this screen, I can click <prev next> through other banknote pictures (front and back side - together 10 images in a group). Each banknote has a description text on the side.
I have it working in flash but now it's supposed to work with a content management system which means the images and text are somewhere in a mySQL db and have crazy names and I have to pull them via php. H E L P P L E A S E. I don't know how to do this in flash, for php I need some hints but not all details, I'll have support there once I know what exactly I need.
One more time: first I choose a banknote group, somehow tell php and it sends me back 1) the names and paths for the 5 preview images, 2) the small info texts for the 5 images 3) names/links to the 10 big images of the banknotes 4) longer description texts for the 5 banknotes
thank you thank you thank you
KirupaForum > Flash > Flash 8 (and earlier) > Flash MX 2004
Posted on: 05-11-2004, 02:12 PM
View Complete Forum Thread with Replies
Sponsored Links:
Images And Co. From MySQL Database With Php
This one is heavy. In flash I have 15 image groups. Each group has 5 banknotes in it. When I choose one group, I get a screen with 5 preview pics, each with a short info text on mouse-over. On this page I can click <prev next> through all 15 groups of preview images. When I click on a preview image, I get a screen with the big banknote picture. On this screen, I can click <prev next> through other banknote pictures (front and back side - together 10 images in a group). Each banknote has a description text on the side.
I have it working in flash but now it's supposed to work with a content management system which means the images and text are somewhere in a mySQL db and have crazy names and I have to pull them via php. H E L P P L E A S E. I don't know how to do this in flash, for php I need some hints but not all details, I'll have support there once I know what exactly I need.
One more time: first I choose a banknote group, somehow tell php and it sends me back 1) the names and paths for the 5 preview images, 2) the small info texts for the 5 images 3) names/links to the 10 big images of the banknotes 4) longer description texts for the 5 banknotes
thank you thank you thank you
View Replies !
View Related
Pulling Images From A MySQL Database
I have a client who loves the animation I provided for them. It is a simple movie that has 9 images rotating in adn out of three boxes. Now they want to be able to dump more images into a directory, build a database with those images and have my little Flash movie automatically load the new images.
Help!!! I have no clue what my next step should be.
David
aka Tencast--
View Replies !
View Related
Displaying Images Thru Mysql Database,php In Flash
i like wrote this
getcardimages.php
<?php
$server = "localhost";
$user = "khelorummy_d";
$pass = "khelorummy123";
$database = "khelorummy_d";
mysql_connect($server, $user, $pass);
mysql_select_db($database);
$SqlQuery = "SELECT `c`.* FROM `cards` c, `cardsets` cs WHERE c.`cardID` = cs.`cardID`";
$Result = $DBConn->ExecuteQuery($SqlQuery);
if (!Result || mysql_num_rows($Result)==0) {
$rowset = '&msg='.mysql_error().'&';
} else {
$rowset = '&n='.mysql_num_rows ($Result);
$i = 1;
while ($row = mysql_fetch_assoc ($Result)) {
while (list ($key, $val) = each ($row)) {
$rowset .= '&' . $key . $i . '=' . stripslashes($val);
}
$i++;
}
$rowset .='&';
}
return $rowset;
?>
and getcardimages.fla like this
var lvSend = new LoadVars();
var lvReceive = new LoadVars();
lvSend.SendAndLoad("http://192.168.1.9/projects/khelorummy/user/getcardimages.php",lvReceive,"get");
lvReceive.onLoad = function(bSuccess) {
if(bSuccess == true) {
for (var i:Number=0; i <= this.n; i++) {
this.root.createEmptyMovieClip("container"+i, i);
var mc = this.root["container"+i];
mc.loadMovie("http://192.168.1.9/projects/khelorummy/cards/"+this["label"+i]+".gif");
}
}
and in design mode i took one movie clip and i named it as "container". is it correct?
why images are not displaying when i execute getcardimages.swf?
plz give me right solution.
thankq
View Replies !
View Related
MySQL Database
I want to build a web site for a photographer using Flash. I want to connect it to a MySQL database so that the photographer can add or delete photos and descriptions in the database (This part I can do w/ASP or PHP)
How do I connect the Flash .swf to the database to reflect the new photos and descriptions. I am trying to set this up so that the photographer can maintain the site as far as adding new photos.
Thanks in advance for any help with this...
View Replies !
View Related
AS PHP To MySQL Database
As a newbie trying to get flash to export form data to a MySQL database via php is proving very hard. I really need to get this done though so if anyone could help I would buy them all kinds of doughnuts and cakes and lots of fizzy pop. My latest attempt at the code is below. I have also attached a basic .fla file if that helps.
SUBMIT BUTTON CODE:
on (release) {
if (name eq "" || email eq "" || mobile eq "") {
errorBox._x= 100;
} else {
loadVariablesNum("process.php", 0, "POST");
gotoAndPlay("thankyou");
}
}
PROCESS PHP CODE:
<?php
//Database Information
$dbhost = "localhost";
$dbname = "idaynes_testdb";
$dbuser = "admin";
$dbpass = "admin";
//Connect to database
mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());
if($name=="undefined" || $email=="undefined" || $mobile=="undefined"){
echo "Please fill in all the fields";
}else{
echo "Thankyou for subscribing.";
mysql_connect("localhost", "subscribe", "admin");
mysql_select_db("idaynes_testdb");
mysql_query("INSERT INTO subscribe ('name',`email`,`mobile`) VALUES ('$name',`$email`,`$mobile`)");
?>
View Replies !
View Related
Link To MYSQL Database
Hi,
I am using Flash MX 2004 Pro to link an application that I have in one of the forms in an Accordion to MYSQL database.
The form is supposed to store the info in a table when the person clicks on the submit button. The submit button and all the fields I am using in the Accordion are components.
When I press the submit button, the form does not POST the info to the php file!
Any suggestions will be very appreciated.
This is the submit button action script:
code:
on(click){
with(_parent){
//assign values to variables
initials = initial_cmbbox.value;
forename = firstName_txt.text;
surname = surname_txt.text;
address = address_txt.text;
pCode = pCode_txt.text;
mobilePhone = teleMobile_txt.text;
homePhone = teleHome_txt.text;
email = email_txt.text;
if((forename == "")||(surname == "")||(address=="")){
gotoAndPlay("requiredFields");
}else{
result = "";
loadVariables("InsertPersonalDetails.php", this, "POST");
status = "Processing entry. Please wait...";
gotoAndPlay("thankYou");
}
}
}
Thank you,
RE
View Replies !
View Related
Searching A MySQL Database?
Our website ( mbtractor.com ) has a search option that queries a database of inventory items and displays the results. I am redesigning the header to make better use of the space (it's way too big) and would like to know if it is possible to put the search in the flash header?
MySQL
PHP
-Lee
View Replies !
View Related
Can Flash Get From A MYSQL Database?
hey every1
i was wondering if in flash i could conect to a MYSQl database and get infromation from the database and then put the informartion into Flash Action script?
EXAMPLE
in flash get a link from the database and then have a button and it goes to that link gathered from the databasE?
thanks
softz
View Replies !
View Related
Can Not Connect To MySql DataBase
I desigend a J2EE Aplication using JSP and Servlets in MVC design.
My system was working great untill i tried using filter for gzip compression for response output , after i used filter gzip, my whole application is destroyed, I cannot able to connect to my Mysql data base, my connection object always returns NULL, i tried every thing re-installing the mysql driver, re-installing the NetBeans ide , nothing is working, i am not able to connect with the database.
This application was working perfect before i experimented with the Gzip filter.please any body can help me what i did wrong, did i corrupted tomcat server. My application is still on my laptop and is not have been loaded on internet yet. i am posting some errors it is showing on the tomcat log.
I Want to mention i am using connection pooling which was working great,
all the servlets are present in the application, the whole application and connection pooling was working great before i used this gzip filter.....Also i like to mention the main problem is when i try to load the driver for Mysql database in my java class it always returns a null connection object. I use Class.forName function in java to load a driver for mysql database.Following is the code where my appliacation returns null connection object
public static Connection ConnectDB(String NameParm, String PasswordParm) {
try {
String url = "jdbc:mysql://localhost:3306/mysql";
Class.forName("com.mysql.jdbc.Driver");
conn = null;
conn = DriverManager.getConnection(url, NameParm, PasswordParm);
System.out.println("Database connection established");
return conn;
} catch (Exception e)
{
System.err.println("Cannot connect to database server ");
return conn;
}
}
please guilde me.. my application is totally stoped at this moment.
=========== E R R O R S- ON TOMCAT LOG ============
Jan 3, 2006 3:28:16 PM org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: attributeReplaced('org.apache.catalina.WELCOME_FIL ES', '[Ljava.lang.String;@3a9bba')
Jan 3, 2006 3:28:16 PM org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: attributeReplaced('org.apache.catalina.WELCOME_FIL ES', '[Ljava.lang.String;@1c5ddc9')
Jan 3, 2006 3:28:16 PM org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: attributeReplaced('org.apache.catalina.WELCOME_FIL ES', '[Ljava.lang.String;@163f7a1')
Jan 3, 2006 3:28:16 PM org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextDestroyed()
Jan 3, 2006 3:28:16 PM org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextDestroyed()
Jan 3, 2006 3:28:32 PM org.apache.catalina.core.ApplicationContext log
INFO: Marking servlet ShadiManager as unavailable
Jan 3, 2006 3:28:32 PM org.apache.catalina.core.StandardContext loadOnStartup
SEVERE: Servlet /CofeeAdvice threw load() exception
javax.servlet.UnavailableException: Couldn't create connection pool
at com.example.model.ServletController.init(ServletCo ntroller.java:69)
at org.apache.catalina.core.StandardWrapper.loadServl et(StandardWrapper.java:1091)
at org.apache.catalina.core.StandardWrapper.load(Stan dardWrapper.java:925)
at org.apache.catalina.core.StandardContext.loadOnSta rtup(StandardContext.java:3857)
at org.apache.catalina.core.StandardContext.start(Sta ndardContext.java:4118)
at org.apache.catalina.core.ContainerBase.addChildInt ernal(ContainerBase.java:759)
at org.apache.catalina.core.ContainerBase.addChild(Co ntainerBase.java:739)
at org.apache.catalina.core.StandardHost.addChild(Sta ndardHost.java:524)
at org.apache.catalina.startup.HostConfig.deployDescr iptor(HostConfig.java:589)
at org.apache.catalina.startup.HostConfig.deployDescr iptors(HostConfig.java:536)
at org.apache.catalina.startup.HostConfig.deployApps( HostConfig.java:471)
at org.apache.catalina.startup.HostConfig.start(HostC onfig.java:1102)
at org.apache.catalina.startup.HostConfig.lifecycleEv ent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLife cycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(Conta inerBase.java:1020)
at org.apache.catalina.core.StandardHost.start(Standa rdHost.java:718)
at org.apache.catalina.core.ContainerBase.start(Conta inerBase.java:1012)
at org.apache.catalina.core.StandardEngine.start(Stan dardEngine.java:442)
at org.apache.catalina.core.StandardService.start(Sta ndardService.java:450)
at org.apache.catalina.core.StandardServer.start(Stan dardServer.java:683)
at org.apache.catalina.startup.Catalina.start(Catalin a.java:537)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.startup.Bootstrap.start(Bootst rap.java:271)
at org.apache.catalina.startup.Bootstrap.main(Bootstr ap.java:409)
Jan 3, 2006 3:28:33 PM org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
Jan 3, 2006 3:28:33 PM org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
Jan 3, 2006 3:28:34 PM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Error configuring application listener of class com.sun.faces.config.ConfigureListener
java.lang.NoClassDefFoundError: javax/faces/FacesException
at java.lang.Class.getDeclaredConstructors0(Native Method)
at java.lang.Class.privateGetDeclaredConstructors(Cla ss.java:2328)
at java.lang.Class.getConstructor0(Class.java:2640)
at java.lang.Class.newInstance0(Class.java:321)
at java.lang.Class.newInstance(Class.java:303)
at org.apache.catalina.core.StandardContext.listenerS tart(StandardContext.java:3618)
at org.apache.catalina.core.StandardContext.start(Sta ndardContext.java:4104)
at org.apache.catalina.core.ContainerBase.addChildInt ernal(ContainerBase.java:759)
at org.apache.catalina.core.ContainerBase.addChild(Co ntainerBase.java:739)
at org.apache.catalina.core.StandardHost.addChild(Sta ndardHost.java:524)
at org.apache.catalina.startup.HostConfig.deployDescr iptor(HostConfig.java:589)
at org.apache.catalina.startup.HostConfig.deployDescr iptors(HostConfig.java:536)
at org.apache.catalina.startup.HostConfig.deployApps( HostConfig.java:471)
at org.apache.catalina.startup.HostConfig.start(HostC onfig.java:1102)
at org.apache.catalina.startup.HostConfig.lifecycleEv ent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLife cycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(Conta inerBase.java:1020)
at org.apache.catalina.core.StandardHost.start(Standa rdHost.java:718)
at org.apache.catalina.core.ContainerBase.start(Conta inerBase.java:1012)
at org.apache.catalina.core.StandardEngine.start(Stan dardEngine.java:442)
at org.apache.catalina.core.StandardService.start(Sta ndardService.java:450)
at org.apache.catalina.core.StandardServer.start(Stan dardServer.java:683)
at org.apache.catalina.startup.Catalina.start(Catalin a.java:537)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.startup.Bootstrap.start(Bootst rap.java:271)
at org.apache.catalina.startup.Bootstrap.main(Bootstr ap.java:409)
Jan 3, 2006 3:28:34 PM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Skipped installing application listeners due to previous error(s)
View Replies !
View Related
Using Data From A MySQL Database
Here is the piece of my code:
if (this["projectName"+three] != "") {
_global.projectFile3 = this["projectFile"+three];
heading3_txt.htmlText = this["projectName"+three];
content3_txt.htmlText = this["description"+three];
if (this["thumbnail"+three] != "") {
picHolder3_mc.loadMovie("images/"+this["thumbnail"+three]);
}
} else if (this["projectName"+three] == "") {
content3_txt.htmlText = "";
heading3_txt.htmlText = "";
}
It is for a portfolio thingie i am working on. My script pulls the data from the db three at a time and displays it. the problem is on the last "else if" statment. If there is only 2 items left to display, the third listing is suppose to put in blanks, but instead it places "undefined" in both instances. Any ideas? thanks...
View Replies !
View Related
LoadVars With Mysql Database
I'm using this example found here: http://www.flash-creations.com/notes/servercomm_database.php
And like the tutorial shows I am loading data through php from mysql. The problem is when I create new frames the information from the mysql database wont go away and keeps loading in. Please take a look at the picture: Found here
Is there someway of clearing or unloading this data before the next frame loads?
Attach Code
select_lv.onLoad = function(ok:Boolean) {
if (ok) {
if (this.errorcode=="0") {
for (var i:Number=0; i < this.n; i++) {
scoreInfo.push(
{record:this["id"+i],
nickname:this["nickname"+i],
score:Number(this["score"+i]),
dateposted:this["dateposted"+i]
});
}
// only display Nickname, Score, and Date Posted (not record id)
scores_dg.columnNames = ["nickname", "score", "dateposted"];
// set formatting of nickname column
scores_dg.getColumnAt(0).width = 200;
// trap header click event to sort case-insensitive on this field
scores_dg.getColumnAt(0).sortOnHeaderRelease = false;
// this property will keep track of whether sort is ascending or descending
scores_dg.getColumnAt(0).sortedUp = false;
scores_dg.getColumnAt(0).headerText = "Nickname";
// set formatting of score column
scores_dg.getColumnAt(1).width = 100;
// trap header click event to sort numerically
scores_dg.getColumnAt(1).sortOnHeaderRelease = false;
scores_dg.getColumnAt(1).sortedUp = false;
scores_dg.getColumnAt(1).headerText = "Score";
// set formatting of date column
// auto-sort will work fine for this column
scores_dg.getColumnAt(2).width = 160;
scores_dg.getColumnAt(2).headerText = "Date Posted";
// set dataProvider for datagrid
scores_dg.dataProvider = scoreInfo;
// execute headerRelease function for correct sort when user clicks a header
scores_dg.addEventListener("headerRelease", headerListener);
msg_ta.text = "Enter data and click Add to add a score. Click a row and Delete ";
msg_ta.text += "Selected to delete a score. First four entries may not be deleted.";
} else {
// show kind of error
msg_ta.text = errorMsgs[Number(this.errorcode)];
// if query error, show mysql_error
if (this.errorcode == "3") msg_ta.text += ": " + this.msg;
}
} else {
// if loadvars failed (eg, if script not found)
msg_ta.text = "Flash-database select operation failed";
}
}
msg_ta.text = "Getting high scores from database...";
select_lv.sendAndLoad(filepath + "getscores.php", select_lv, "GET");
View Replies !
View Related
A Lot Of Info Out Of A MySql Database
Hi,
I have a music website.
Formerly I used PHP to get all information out of a MySql Database. Information like, "projectname", "Number of Tracks", "Information", "Track names"...
All this information was put in an Array.
Then the PHP read out the created Array one by one (Array[0], Array[1], etc) and processes a table with in that table all the info.
Now I try using flash. I have done all tutorials on this website about this subject, but I am still not sure how to do it.
I first let AS call to my PHP-file. This PHP-file pulls the information out of the database, and puts it in an array, just like it did before.
Now I want to copy the PHP-array into the FLASH-array, or at least I think this is the way to do it... I don't know how though...
What I want is that I am able then to read out the array in flash, array[0], array[1], etc...
please help me out !! Thanks,
Zagrad
View Replies !
View Related
Form To Mysql Database
-------ok this is my script.......and my actionscript--------
<?php
$venuename = $_POST['venuename'];
$email = $_POST['email'];
$website = $_POST['website'];
$phonenumber = $_POST['phonenumber'];
$areacode = $_POST['areacode'];
$address = $_POST['address'];
$city = $_POST['city'];
$state = $_POST['state'];
$zipcode = $_POST['zipcode'];
$contact = $_POST['contact'];
$inputclubtype = $_POST['clubtype'];
$inputmusictype = $_POST['musictype'];
$inputcrowd = $_POST['crowd'];
$inputdresscode = $_POST['dresscode'];
$comments = $_POST['comments'];
$conn = mysql_connect("localhost", "nigolmvc_nigolmv", "******");
mysql_select_db ("nigolmvc_nightspotz", $conn);
$result = mysql_query("INSERT into venues ( venuename, email, website, phonenumber, areacode, address, city, state, zipcode, contact, clubtype, musictype, crowd, dresscode, comment) VALUES('$venuename', '$email', '$website', '$phonenumber', '$areacode', '$address', '$city', '$state', '$zipCode', '$contact', '$inputclubtype', '$inputmusictype', '$inputcrowd', '$inputdresscode', '$comment')");
if(!mysql_query($query,$conn))
{
echo mysql_error();
exit;
}
?>
----the actionscript is attached to frame not the button-----
submitBtn.onPress = function(){
if(venuename.text!="" && address.text!="" && email.text!="" && city.text!="" && website.text!="" && zipcode.text!="" contact.text!="" areacode.text!="" phonenumber.text!="" comments.text!=""){
myData = new LoadVars();
myData.venuename = venuename.text;
myData.address = address.text;
myData.email = email.text;
myData.city = city.text;
myData.website = website.text;
myData.zipcode = zipcode.text;
myData.contact = contact.text;
myData.areacode = areacode.text;
myData.phonenumber = phonenumber.text;
myData.comments = comments.text;
myData.sendAndLoad("advertise.php", myData, "POST");
gotoAndPlay(113);
venuename = "";
address = "";
email = "";
city = "";
website = "";
zipcode = "";
contact = "";
areacode = "";
phonenumber = "";
comments = "";
Emailstatus = "";
}else{
statusBox.text = "Fill out all required fields!";
}
}
----this is the error im getting from from actiocscript------
**Error** Scene=Scene 1, layer=form, frame=116:Line 15: ')' expected
if(venuename.text!="" && address.text!="" && email.text!="" && city.text!="" && website.text!="" && zipcode.text!="" contact.text!="" areacode.text!="" phonenumber.text!="" comments.text!=""){
**Error** Scene=Scene 1, layer=form, frame=116:Line 40: Unexpected '}' encountered
}else{
Total ActionScript Errors: 2 Reported Errors: 2
DONT KNOW WHAT THIS MEANS...........
View Replies !
View Related
Flash Mx To Mysql Database
ok can u show me how to search the mysql database i would greatly appreciate it cuz im pulling my hair out over here...im using flash mx and PHP....
here' the the query but i dont know how to put it in a script:
$query_searchRS = sprintf("SELECT city, `state`, `area code`, `venue type`, `music type`, `age group`, venues.city FROM venues WHERE `venue name` = '%s' AND venues.`state` AND venues.`area code` AND venues.email AND venues.website AND venues.`venue type` AND venues.`music type` AND venues.`age group` ORDER BY `venue name` ASC", $colname_searchRS);
can u show me how to wright the rest of the script plz..(and please explain like i am very slow lol...)..
here is the .fla......
and there is an example on my site nightspotz.com and go to the search link
View Replies !
View Related
Getting Variables From MySQL Database
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 Replies !
View Related
DATABASE HELP (mySql Php Flash 8)
I have been trying to get my foot in the door on database building with flash for a few years now. I keep finding the same tutorials, and they seem to set them selves up for "local server"...
From what i know, i want to:
-have a flash file that logs into my web-server
-to view the database (using a tiny bit of php)
-writes/reads files to/from the database
-and allows for secure user logins
i want to use flash 8, i recently found a flash mx tutorial and i wonder if that will work the same... they are both AS2 right?
Please help me out.
Thanks:
Frostkeep
View Replies !
View Related
Login From MySQL Database
I want to be able to load username and password info from a MySQL to check authentication. I'm not experienced in PHP and please don't redirect me to http://www.kirupa.com/developer/acti...entication.htm. I have tried it and I get some stupid output errors in flash.
Thanks in advance.
~Zuriki
View Replies !
View Related
Actionscript With Php Into A Mysql Database
http://www.sitepoint.com/article/create-flash-sketchpad
Hi I was looking to utilize a .fla similar to the sketchpad found in the above link.
Here's my situation.
I have a mysql database that goes through a series of steps. Upon reaching step 3 the user has the option to draw in the image area (thus the sketchpad function). What I wish to do is have two buttons created, which I would do so don't need explanations on that, which would clear the sketch pad and the other *save the image.
Thats what I'm looking for help on. Is there a script tutorial or any help one can give me that will allow flash to plot or save the image the user creates as a .jpg or .png (preferably) and truncate the white space and talk to some php file or the mysql database itself and save the image?
I'm in desperate need of finding this script, currently I'm using a java applet that does something similar but haven't found the correct php code to plot its exported .png file so I'm hoping that flash will allow for better communcations with php and mysql?
View Replies !
View Related
A Lot Of Info Out Of A MySql Database
Hi,
I have a music website.
Formerly I used PHP to get all information out of a MySql Database. Information like, "projectname", "Number of Tracks", "Information", "Track names"...
All this information was put in an Array.
Then the PHP read out the created Array one by one (Array[0], Array[1], etc) and processes a table with in that table all the info.
Now I try using flash. I have done all tutorials on this website about this subject, but I am still not sure how to do it.
I first let AS call to my PHP-file. This PHP-file pulls the information out of the database, and puts it in an array, just like it did before.
Now I want to copy the PHP-array into the FLASH-array, or at least I think this is the way to do it... I don't know how though...
What I want is that I am able then to read out the array in flash, array[0], array[1], etc...
please help me out !! Thanks,
Zagrad
View Replies !
View Related
Search In A Mysql Database
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;
myForm_europe.pictureReq = "0";
myForm_europe.fromYear = "0000";
myForm_europe.fromMonth = "00";
myForm_europe.fromDay = "00";
myForm_europe.toYear = "0000";
myForm_europe.toMonth = "00";
myForm_europe.toDay = "00";
myForm_europe.duration = "0";
myForm_europe.continent = "1";
myForm_europe.country = "$country";
myForm_europe.region = "0";
myForm_europe.rCity = "0";
myForm_europe.rooms = "0";
myForm_europe.oldContinent = "0";
myForm_europe.oldCountry = "0";
myForm_europe.oldRegion = "0";
myForm_europe.getURL("../search/searchResults.php", "_parent", "POST");
I have also tried this code:
this.createEmptyMovieClip("myForm", 0);
myForm.newSearch = 1;
myForm.searchType = 0;
myForm.searchArea = 0;
myForm.pictureReq = "0";
myForm.fromYear = "0000";
myForm.fromMonth = "00";
myForm.fromDay = "00";
myForm.toYear = "0000";
myForm.toMonth = "00";
myForm.toDay = "00";
myForm.duration = "0";
myForm.continent = "6";
myForm.country = "$country";
myForm.region = "0";
myForm.rCity = "0";
myForm.rooms = "0";
myForm.oldContinent = "0";
myForm.oldCountry = "0";
myForm.oldRegion = "0";
myForm.getURL("../search/searchResults.php", "_parent", "POST");
Hope you have a solution
/Kafir
View Replies !
View Related
User Submitting To MySQL Database Via PHP...
I have an entry system where by the user submits an entry to a mySQL database using PHP through a flash interface.
Cool and dandy i hear you say, but the problem is that each user can only submit once. If they try again, the PHP goes through the motions and completes its job but doesn't submit to the database.
Anyone got an idea why this maybe so, as I have added a random number to the .swf movie (eg: movie.swf?number=*number generated from unix timestamp* to create a unique swf movie) to stop it caching etc, attempted to turn off caching in all the pages I have etc etc.
Ta
View Replies !
View Related
Vertical Scroller Using PHP And MySQL Database
For a project I'm working, I'm trying to create a dynamic vertical scroller for images. I have a database which holds record information a photos (1 to 3 photos per record). I have created a vertical scroller, but that is fixed to a number of images. What I want to create is a vertical scroller which reads the number of photos and if the total number does not fill the complete height of the scroller, it will repeat the photos continuesly. So what you will get is a continuing vertical scroller with the photos of that day.
Any help would be appreciated!
View Replies !
View Related
Linking A MySQL Database To Flash
Hi,
This is going to be a bit odd (and probably quite advanced as I'm still a beginner at AS)
Anyhow, I need to somehow link my flash SWF to a mySQL database. The SWF needs to contain places for Username and Password. The username/password fields need to be able to process both the bits of info once inputted.
I realise that this is probably very difficult and may need some PHP to do it (if so, could you supply it or give me an address to download it from???), but I need to find out how to do it!!
Anybody help??
View Replies !
View Related
Simple Database Connectivity (PHP, MySQL)
Hello, I have created a site in HTML, PHP which makes use of a MySql database to store all the page content etc. in. I am now creating a Flash version of the site. My Question:
What is the simplest way with Flash to
a) connect to the database
b) write queries using the select statement to get stuff from the Database once connected.
Many thanks,
Eaaaazzzee Now!
View Replies !
View Related
Flash Mx, PHp, MySQL DATABASE INTEGRATION
hI, I NEED HELP WITH THE WRITTING OF CODES TO INTEGRATE FLASH WITH PHP AND THE PHP CODE WITH A MY SQL DATABASE. I AM AN INTERMIDIATE / EXPERT FLASH USER BUT I HAVE NO KNOWLEGDE OF PHP INTEGRATION WITH FLASH LET ALONE PHP WITH MY SQL PLEASE I NEED HELPAND I NEED IT URGENTLY THANK YOU
View Replies !
View Related
Insert Data Into Mysql Database
I have a php/mysql database which is working fine, but I would like to have flash design for my entry and query pages.
I opened a new Flash MX 2004 document with just one frame (no need for validation at this moment, confirmation will be managed by the php script file).
I tried 2 things:
1) drag a button component and a textfield component onto the stage
2) use the text tool and draw a rectangle for 'input text' and put a button from the common libraries menue onto the stage. I'm not sure if both versions are ok, I think so and don't see the difference.
The button has an instance name 'submit' and the input field has the instance name 'name' and in the var field for the input text, I tried 'thisFieldName' or '$thisFieldName' (without 's)
as action for the button I put this code:
on (release)
{
getURL("insertNewFromFlash.php", "_self", "POST");
}
The corresponding table has just two fields, id (autoincrement, so I don't use it in the flash entry form and my insertNewFromFlash.php file is:
<?php
// include_once("../team/ventas/connection.php");
//
// $thisName = addslashes($_REQUEST['thisFieldName']);
//
//$sqlQuery = "INSERT INTO fromflash ( name ) VALUES ( '$thisName' )";
//$result = MYSQL_QUERY($sqlQuery);
//
//?>
A new record has been inserted in the database. Here is the information that has been inserted :- <br><br>
here comes some html code and the following php line wich just works as a confirmation about the inserted data, however it always remains empty
<table>
<tr height="30">
<td align="right"><b>Name : </b></td>
<td><? // echo $thisName; ?></td>
</tr>
</table>
<?php
// include_once("footer.php");
?>
//Tere are no comments in my file, seems to be necessary in order to get the code displayed here in this forum.
The problem is that when I press the submit button, a new entry is registered in my table, the dbconnection works fine but the entry only registers the autoincremental id while the variable $thisname isn't inserted. There are no error messages, the name just isn't inserted although the connection is established and the insert command is carried out, however, looks like the variable isn't parsed from the flash to the php file.
Thank you in advance
View Replies !
View Related
Populating A Combobox From A MySQL Database With PHP
HI,
I have a combobox in this new project, where I need to populate from a table (CARBRANDS) in a MySQL database.
Well, I know how to additems to a combobox and know how to query a database in php. What I dont know, is how to pass the recordset obtained with my query in php to Flash.
Can anyone give me a clue?
Thanks!
View Replies !
View Related
How Can My Swf Read/write To A Mysql Database
i did a little actionscript until now, but here's a problem I don't have ANY clue: is there a possibility for my swf to read data out of a mysql-database?
???
and, 2nd problem: can the swf write to a mysql-database? Or do I have to post the data to a php-file and insert it from there?
I still work with flashMX, may be in MX2004 it is easy?
thank you for any idea
hrrrst
View Replies !
View Related
Where To Start - Setting Up A MySQL Database
Hi,
I want to create a guestbook using MySQL like the one in the tutorial on this site: http://flash-db.com/Tutorials/guestbook/ however Im a newbie to databases and need to know where to start.
I know Im signed up for MySQL and php etc with my host but Im lost as to where to go from here.. Do I need to download anything to get it started??
Any help would be appreciated!
Thanks
View Replies !
View Related
Retreiving Information From MySQL Database?
Hey there,
I am in need of some help,
I have a flash document which has
ID =
and an input box and a submit button..
I want the user to be able to type in an id... lets say... 1
and when they click the button the movie will go to frame 2...
on frame 2 it will have
CONTENTS OF ID
NAME
AGE
PHONE
ADDRESS
I want the Name, Age and etc to be loaded from a mysql database which uses the id in the query so the query would be
SELECT * FROM `blah_test` WHERE id=1
(in PHP)
I WAS thinking about making a php page that used this
PHP Code:
$id = $_GET['id'];
$query = "SELECT * FROM `blah_test` WHERE id=$id";
$result = mysql_query($query);
$data = mysql_fetch_assoc($result);
$name = $data['name'];
$age = $data['age'];
$phone = $data['phone'];
$address = $data['address'];
IF I was to do that... How do I make flash GIVE the id to the page and how do i get the variables back into flash?
I thought in AS 2 it was something about loadvars? or something but specifying a php file like...
index.php&id=1
and making the variables echo out on that page in a certain way?
Are any of these methods plausable or does anyone have any idea how to do this?
View Replies !
View Related
Database Help, Saving Positions MySQL/PHP
I've been working with Flash for a while, but am still a little new with ActionScript 3.0 and database integration into Flash.
I'm working on a project where you can drag and drop a handful of objects, rotate them, etc. I have most of that functionality completed, but the next still is to integrate the mySQL database.
Is PHP the best way to go? I have not seen very many examples with AS 3.0, mostly everything I find is about posting high scores, address books, etc. Any examples/tutorials that deal with saving, uploading X and Y positions of movie clips?
Thanks in advance, I'll keep checking back and post bits of code or links if necessary.
View Replies !
View Related
Best Way To Access Local Mysql Database From AS3?
Hi Guys,
I'm currently working on a flash project which will later run locally and offline on a PC. On this PC, there will also be a MySQL database which I need to access.
Now I'm looking for a proper way to do this. I have good skills in AS3, and have used PHP and MySQL alone in several web projects. But so far I have never used MySQL together with Flash.
So in which direction should I start looking for a good solution? What would be a good way to access a local MySQL database from a locally running SWF?
Any ideas highly appreciated!
View Replies !
View Related
ComboBox DataProvider From MySQL Database
i've attached the code to what i'm trying to do below. i think i even know why it's not working too.... flash thinks the words "data" and "label" are strings, and not identifiers. is that correct?
if so, how can i use the contents of a mysql database as the dataProvider of a ComboBox? fyi, right now there are 205 rows in my database.... which means 205 choices in the ComboBox.
the php works, and in fact when i run this the ComboBox doesn't have any visible options, however it does have length and a slider bar for what looks like about 205 options. so i think it's counting the { } but just doesn't recognize "data" and "label". that make sense?
Attach Code
as -
var serverResponse:LoadVars = new LoadVars();
serverResponse.onLoad = function(success:Boolean) {
if (success) {
var myDataList:String = serverResponse.myDataList;
myComboBox.dataProvider = myDataList;
} else {
trace("bad server, very bad server");
}
};
var myList:LoadVars = new LoadVars();
myList.myOption = whatever;
myList.sendAndLoad("php/getDataList.php",serverResponse,"POST");
php -
// this does some things with the option but ultimately outputs the text like this...
$query = "SELECT id, name FROM myTable ORDER BY id";
$result = mysql_query($query);
echo "myDataList =[";
while ($row = mysql_fetch_array($result)) {
echo '{data:"' . $row['id'] . '", label:"' . $row['id'] . ' - ' . $row['name'] . '"}, ';
}
echo "]";
View Replies !
View Related
Connecting To A Mysql Database With Actionscript 3?
I am wanting to make a login and sign in form in flash cs3. I am using a mysql database. I know how to make a login form in javascript, but I am stuck with actionscript. How do you make one with as3? With the site I'm making it's quite important for me to know how to do it.
Sorry if this is a noob question, I'm still new to flash.
View Replies !
View Related
Actionscript 3 Info. To MySQL Database?
I'm somewhat stuck as to how to do this.
I've loaded my MySQL records into flash with a PHP created XML file. I then change the data using AS3 and it is saved into arrays. The data consists of 12 strings each with a length of 30 or so, like this:
month[3] = "11122200121011110010102221100";
I've used the ExternalInterface() function in the past, but how can I write these arrays to my database? AS3 to javascript? Through a post form and update records?
Thanks ahead of time.
View Replies !
View Related
MySQL Database Return Variables
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.
Can someone help? (I'll post my .fla)
edit: too large to attach, i'll post it on my server
www.barbdwyer.com/misc/quiz.fla
View Replies !
View Related
Loading Xml To Flash From Mysql Database.
Hi! for my project im trying to get output data from xml into flash...
with images & url with description on top of image, load like 10 images with ur and if there is more give me options with numbers.
i looked at lots of tutorials but im still lost, can any one please help me.
Thank you in advance.
sorry im so new to this action scripts so im so lost.
View Replies !
View Related
MySQL Database Return Variables
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.
Can someone help? (I'll post my .fla)
edit: too large to attach, i'll post it on my server
www.barbdwyer.com/misc/quiz.fla
View Replies !
View Related
Flash & MySQL / Database Advice
I am using a FLA file from www.levitated.net (http://www.levitated.net/daily/levEmotionFractal.html)
The FLA contains the following logic (amongst other bits):
// word sets
// emotional words
vernacular = "merry happy christmas xmas greetings seasons";
// array of words
wordList = new Array();
wordList = vernacular.split(" ");
Then it fills the stage with randomly placed instances of the words, which have been split up into the array.
I'd really like to allow users to enter their own words into a form. Then store the words in MySQL, and then when the user views that ecard, I could pull the values entered by the user from MySQL and pass them to flash. Then, instead of the 'vernacular' variable being hard coded, it could be replaced with whatever the user entered when they set up the ecard.
Do you think this would be hard to do? Given the massively complex things people are doing with Flash these days, I am guessing not. But I wanted to check here first.
I'm not asking to be spoon fed here, I'm just after a bit of guidance, as I've never done Flash / MySQL integration before. Obviously I'd need to use ASP or PHP as well...
Thanks
Jim
View Replies !
View Related
INserting Data From Flash Into A MySQL Database HELP
Hello,
I am trying to post data from a flash game into a Mysql database using PHP.
I have written the insert PHP file which works fine with a HTML form but as soon as I try to get it to work from flash
nothing happens......
This is the code in the flash file
on (release) {
loadVariablesNum ("http://www.spiked.tv/stuff/test.php", 0, "POST");
}
Any Ideas Help etc
Regards
Christian
View Replies !
View Related
Laodvariable Database Mysql Php Problem Simple
Ok, I' sure that this has been posted before and that you are all tired of answering and I hate to admit that I'm this stupid, but I'm tired out from trying to get this to work and need help. I'm using flash 5.
I have the following action on the first frame of a movie which has only a dynamic textbox in it. The name of the dynamic textbox is textbox. Nothing more.
loadVariables ("exhibits.php", "/");
stop ();
exhibits.php is pulling info from a database which I simply want to display in the textbox.
Here's the php script
$query=mysql_query("select * from exhibitions order by year");
$num=mysql_num_rows($query);
$i=0;
while($i<$num)
{
$row=mysql_fetch_array($query);
$venue=strtoupper($row['venue']);
$year=$row['year'];
$loc=$row['location'];
$type=$row['type'];
$textbox.=$venue.$year.$loc.$type;
$i++;
}
print "textbox=$textbox";
I'm getting nothing. The php script is returning the proper string in the proper format for flash I think. This is the result of print "textbox=$textbox";
textbox=ART STOP GALLERY1979Grand Rapids, MichiganOne Woman Show
The line above is all that is generated, no html, no nothing.
I'm obviously new at this, so speak slowly.
Thanks so very much. I'll stop crying soon.
B
View Replies !
View Related
|
TRACKER
