I have a flash front end that displays information and is capable of building MySQL queries and handing them off to PHP via loadVars. PHP handles the dirty work of connecting to the database, executing the queries, and returning any results. So my problem is with single quotes. In flash I can build the query string with single quotes easy enough, but for some reason php keeps doubling them up and messing up the query.
Here is an example of the flash code:
ActionScript Code:
var send_lv:LoadVars = new LoadVars();
var load_lv:LoadVars = new LoadVars();
load_lv.onLoad = function(bSuccess){
if(bSuccess){
trace(this.output);
[Code] .....
The problem is that the sql statement that php is trying to execute looks like this:
insert into mytable (field1, field2) values (''value1'', ''value2'')
Where each single quote has been turned into two single quotes for some reason.
One of the moderators, could you've a look at this tutorial: [URL] it doesn't works with me, maybe because I've 2004 so if you change loadVars() into LoadVars() it should work
Create a flash application which will be displayed on a web page which will read from a list of text inside an XML file and display them randomly with fade-in fade-out effects and also at random positions.My current approach to the problem is using a Dynamic Text Area which will read from the xml file, however I only got to the stage where the swf will read the xml file. Trying to get the fade effect and the positioning effect is proving very difficult for me.The sample XML I am working with:
<tag> <tagline>Global Jobs Pact</tagline> <tagline>Green Jobs</tagline> <tagline>Decent Work</tagline>[code]......
How do I escape double quote " in XML when I load it in Flash? I use createTextField and I have created a Font in the Library. I use TextFormat to embed the font. When just use " in my XML file, it will show " in my flashmovie, why is that?
I'm using the quote randomizer from kirupa, but the same couple lines out text seems to arise far too frequently. any ideas? I was thinking that i could remove the random part of the script, and just make it go from 1-100 in order,
current AS: /**************************************** **Random Quotes Script*******************
i want a quote to appear in the dynamic text box but obviously you cant just write it as it thinks its text data, but im thinking its " but how do impliment it, i want a quote before and after +username_ti.text+ _parent.user_mc.user_ti.text = "Welcome you are currently logged in as " + username_ti.text +"
What's the best way to handle the " symbol, dynamically written to XML output from a PHP upon request, and then pulled into Flash, parsed, and assigned to a String?Should the entire node's data be wrapped as CDATA in the XML document? But when when it gets assigned as a String in Flash, will Flash freak out because there's a " in it?Should PHP write escape characters into the node's text to escape quotes, ampersands, gt/lt, and apostrophes (and then will Flash handle these ok?)? Or should PHP convert all unsafe characters into their HTML equivalent?What about the British pound symbol? We're using UTF-8, so is there a safe way to handle this?
I've been messing around with this XML random quote rotators from this site but I'm unable to make it so it doesn't repeat the same quote twice. It has a tendency to show the same quote 3x in a row.
PHP Code: //importing tween classesimport fl.transitions.Tween; import fl.transitions.easing.*; //we create a variable to store the loaded XMLvar xml:XML; //the path to the xml filevar xmlPath:String = "data/quotes.xml"; [Code] .....
I am build a rotating quote display for a website I'm working on -- the quotes come from a MySQL database and are displayed with PHP. A new (randomly selected) quote needs to fade in and then out every few seconds.I am mildly accustomed to Flash and know PHP and MySQL very well, so I was able to get the database interaction and whatnot going. You can see my progress here: [URL]I am willing to post the .fla file;
I don't need a website designed, just a flash 'movie'-style animation (2 min. approx. duration)I've created static content in Ai CS4 that I just need to be animated, and I could supply people with a storyboard. Similar look to the animation on this site: URL.. but with more complex animations and graphics.[code]
I have an XML driven Flash site and can't get quote marks to work in Flash 6. They show up fine in version 7 and 8 of the flash player. Here's what I'm doing:
My XML file: (added line breaks just for this example)
[Code]...
how to get this working in Flash 6? We really want to use REAL quote marks.
I'm trying to produce a one frame random quote field. I have a dynamic text field "quotebox" with the var of "quotefield" rn=random(10); loadText=new loadVars(); loadText.load("quotes.txt"); quotern=["quote"+rn]; loadText.onLoad=function() { quotefield.text=quotern; };
That's what I have for code. On the qoutes.txt file I have quote1-quote10 listed. I can get the quotern to display in the text field but can't get the quotes in the text field unless I do this loadText.onLoad=function() { quotefield.text=quote10; Add the quote# to the code which then displays the quote.
I'm trying to populate a Flash quote system with XML but as try as I may I'm unable to get the subsuboption (like Jewelcase --> Insert --> Glossy finish) to work.
Basically this quoting system has been dumped on my desk and I have till Monday to update it (I'm a graphic designer not a flash developer and I don't have a clue as to what I'm doing!).
The AS Code is:
Code: var xmlLoader:URLLoader = new URLLoader(); xmlLoader.addEventListener(Event.COMPLETE, LoadXML); var xmlData:XML = new XML();
[Code].....
Now I can get it to compile, but when it goes to pull the data it will work upto the Suboptions and then any code further on fails to load (so I suspect there is something wrong with either the XML or the AS tying to the XML).
When changing wmode to transparent or opaue, or just by default, some browers change the @ to a " ... so you have to use the opposite button, ie shift-2.The only fix I know is to run a listener and switch double quotes for @ symbols...
I followed the Random Quote Tutorial, pretty self explanatory really as all the tutorials are. is simple to have a whole bunch of words, load them randomly into a text box and then animate that text box randomly on the stage. So for example I'd have 'BLAH' loaded into a random area on the stage (or a specific set of coords if needs be) and then 'BLAH' would scale up from zero to fade out into _alpha=0 and a massive scale.
The problem I'm having is that whilst I can follow the random quote tutorial that relies on pressing a button to trigger the quote being loaded, thats my first problem. How to load the random word into this text box to then be displayed on the screen, do something with that text box (the animation) then loop back round once its finished. I'm assuming I get this by....if textbox._alpha = 0 then go back to the beginning type thing?!
I am using this random code below to choose a quote to display and I want to move the quotes list to a text file.
Code: quotes = [Fish are the last to recognize water.","I am my brains publisher.", "Every tool carries with it the spirit by which it has been created.","Curiosity is the mother of intelligence.","Thinking is drawing in your head.","A person without imagination is like a teabag without water.","Realism is a corruption of reality.","Its always better to be looked over than to be overlooked.","The hardest thing to see is what is in front of your eyes.","The soul has no secrets that conduct does not reveal.","Creativity is the defeat of habit by originality.","Those who cannot remember the past are condemned to repeat it.","If you want to get lucky... it pays to get ready" ,"Realism is the corruption of reality","I'd give my right arm to be ambidextrous.","Music is noise submitted to order by wisdom.","God...invented the giraffe,the elephant,the cat.He has no real style.He just goes on inventing things.","The person you love is 72.8% water."]
As part of my brief, I have to create a small flash movie that will load a random quote (which is actually a jpeg image), fade it in to view, display it for a length of time (probably only 3-5 seconds), fade it out and then load another random quote. Is this possible to do, purely using actionscript? I can randomly load an image - I used the "Random Background Image" tutorial on this site - but getting the fading/pausing/fading then moving to another quote has got me stumped.
The images are imported into their own swf file that is loaded into a placeholder movie on the html page. I tried adding in a for loop to the individual swf and the placeholder movie, to loop through alpha property of the image (just to fade up for the moment, till I get it working) - but this didn't work at all. I could use tweens for the fading, but this could end up a mess and more work than it needs to be as there could be quite a lot of quotes added over time.
I am using this random code below to choose a quote to display and I want to move the quotes list to a text file, can point me in the right direction I cant seem to get it to work.
Code:
quotes = [Fish are the last to recognize water.","I am my brains publisher.", "Every tool carries with it the spirit by which it has been created.","Curiosity is the mother of intelligence.","Thinking is drawing in your head.","A person without imagination is like a teabag without water.","Realism is a corruption of reality.","Its always better to be looked over than to be noverlooked.","The hardest thing to see is what is in front of your eyes.","The soul has no secrets that conduct does not reveal.","Creativity is the defeat of habit by originality.","Those who cannot remember the past are condemned to repeat it.","If you want to get lucky... it pays to get ready" ,"Realism is the corruption of reality","I'd give my right arm to be ambidextrous.","Music is noise submitted to order by wisdom.","God...invented the giraffe,the elephant,the cat.He has no real style.He just goes on inventing things.","The person you love is 72.8% water."]
OK, I am trying to do my first simple user authentication for a test built in Flash. I'm just checking to see if someone with the same name and email exists in the mySQL database and then echoing out entryAllowed=false if they exist.
Code: PHP Code: //query is successful and these vars trace out in flash
I have created a site that calls in text from an external .txt file. The text file is a flat file that is updateable using PHP. What I need is for the Flash site to reflect the current contents of the text file each time it's updated through the PHP interface. I'm using the standard:
I did get it to 'kind of work' at one point, but the output text would flash 'undefined', then show the contents of my text file, then go blank then start that loop over again. Not acceptable.
I am converting a class into AS3 (was AS2). What would be the best way to replace the loadVars ? This is how the code looked like in AS2
ActionScript Code: public function load(csvPath:String): void { // Use the LoadVars class to load in the CSV file as a String var csvLoad:LoadVars = new LoadVars();
I have managed to develop code that will run a php script by passing a variable (obtained from a combobox control) to the MySQL database. Initially this works fine but if I try to repeat the excercise using a different value nothing happens.[code]...
I have read a little bit about loadVars and loadVariables, so I am trying to read and write to a .txt on my server. This is my functions: (only Read works, but Send doesn't)
ActionScript Code: function Load(F, VAR) { var DATA:LoadVars = new LoadVars();[code]...........
There are no errors or something; but the file is the same after Send();
