Re: [nyphp-talk] MySQL/Flash/Apostrophe issue

2007-12-07 Thread Kristina Anderson
you guys are the best! > Welcome to the internet! > > > Kristina Anderson wrote: > > Thanks -- I have downloaded Firefox and think this is life > > changinglots of new toys to play with :) > > > > > >> Kristina Anderson wrote: > >> > >>> I don't think you can do any of that sort

Re: [nyphp-talk] MySQL/Flash/Apostrophe issue

2007-12-07 Thread Ben Sgro
Welcome to the internet! Kristina Anderson wrote: Thanks -- I have downloaded Firefox and think this is life changinglots of new toys to play with :) Kristina Anderson wrote: I don't think you can do any of that sort of thing with IE...what a piece of sh%t it truly is

Re: [nyphp-talk] MySQL/Flash/Apostrophe issue

2007-12-07 Thread Kristina Anderson
Thanks -- I have downloaded Firefox and think this is life changinglots of new toys to play with :) > Kristina Anderson wrote: > > I don't think you can do any of that sort of thing with IE...what a > > piece of sh%t it truly is. Is there any Windows software that can > > give me this fun

Re: [nyphp-talk] MySQL/Flash/Apostrophe issue

2007-12-07 Thread David Krings
Kristina Anderson wrote: I don't think you can do any of that sort of thing with IE...what a piece of sh%t it truly is. Is there any Windows software that can give me this functionality? There is a firebug plugin for FireFox. ___ New York PHP Commun

Re: [nyphp-talk] MySQL/Flash/Apostrophe issue

2007-12-07 Thread Carlos A Hoyos
[EMAIL PROTECTED] wrote on 12/07/2007 03:51:52 PM: > I don't think you can do any of that sort of thing with IE...what a > piece of sh%t it truly is. Is there any Windows software that can > give me this functionality? If you do need to use IE, Fiddler is pretty useful to intercept and manage

Re: [nyphp-talk] MySQL/Flash/Apostrophe issue

2007-12-07 Thread Kristina Anderson
Nifty, thanks! I will keep you posted. > On Dec 7, 2007 3:51 PM, Kristina Anderson <[EMAIL PROTECTED]> wrote: > > I don't think you can do any of that sort of thing with IE...what a > > piece of sh%t it truly is. Is there any Windows software that can > > give me this functionality? > > firefo

Re: [nyphp-talk] MySQL/Flash/Apostrophe issue

2007-12-07 Thread John Campbell
On Dec 7, 2007 3:51 PM, Kristina Anderson <[EMAIL PROTECTED]> wrote: > I don't think you can do any of that sort of thing with IE...what a > piece of sh%t it truly is. Is there any Windows software that can > give me this functionality? firefox with the firebug extension. Now that I think about

Re: [nyphp-talk] MySQL/Flash/Apostrophe issue

2007-12-07 Thread Kristina Anderson
I don't think you can do any of that sort of thing with IE...what a piece of sh%t it truly is. Is there any Windows software that can give me this functionality? > > allowScriptAccess is set to "sameDomain" but the name of any script > > calling the database is not immediately apparent from t

Re: [nyphp-talk] MySQL/Flash/Apostrophe issue

2007-12-07 Thread John Campbell
> allowScriptAccess is set to "sameDomain" but the name of any script > calling the database is not immediately apparent from the page code...? Do you use firebug? You need to open the page, and look through the list of downloaded files (firebug is the way I do it, it is built in in Safari, and I

Re: [nyphp-talk] MySQL/Flash/Apostrophe issue

2007-12-07 Thread Kristina Anderson
allowScriptAccess is set to "sameDomain" but the name of any script calling the database is not immediately apparent from the page code...? > A swf file cannot directly access the database because it runs on the > client side (I'll assume you are not using remoting). The swf > accesses a php scr

Re: [nyphp-talk] MySQL/Flash/Apostrophe issue

2007-12-07 Thread John Campbell
A swf file cannot directly access the database because it runs on the client side (I'll assume you are not using remoting). The swf accesses a php script on the server that outputs something. There are two major methods, load vars and xml. My guess is that the php script outputs data for flash's

Re: [nyphp-talk] MySQL/Flash/Apostrophe issue

2007-12-07 Thread Kristina Anderson
Thanks Ken, so what you're saying is there is no way to do this without going into the .swf file itself. By the way -- $caption = str_replace("'", "'", $caption) yields record in database of A Reporter's Life Displays in Flash applet as A Reporter's Life (it's encoding the & apparently

Re: [nyphp-talk] MySQL/Flash/Apostrophe issue

2007-12-07 Thread David Krings
Ken Robinson wrote: Quoting Kristina Anderson <[EMAIL PROTECTED]>: Yes it's definitely a flash issue. I will replace the apostrophes in the strings with ' before database insert and let you know how that works! Don't replace the single quotes in the database. Use the htmlentities() function

Re: [nyphp-talk] MySQL/Flash/Apostrophe issue

2007-12-07 Thread Ken Robinson
Quoting "P. Ju (???)" <[EMAIL PROTECTED]>: Hi Kristina, PHP has a function to take care of this for you: mysql_escape_string http://www.php.net/mysql_escape_string That's not her problem. That escapes quotes and other symbols so they can be stored in the database. Her problem is that the s

Re: [nyphp-talk] MySQL/Flash/Apostrophe issue

2007-12-07 Thread Ken Robinson
Quoting Kristina Anderson <[EMAIL PROTECTED]>: Yes it's definitely a flash issue. I will replace the apostrophes in the strings with ' before database insert and let you know how that works! Don't replace the single quotes in the database. Use the htmlentities() function on the output with

Re: [nyphp-talk] MySQL/Flash/Apostrophe issue

2007-12-07 Thread P. Ju (朱漢璇)
Hi Kristina, PHP has a function to take care of this for you: mysql_escape_string http://www.php.net/mysql_escape_string PJ On Dec 7, 2007 1:43 PM, Kristina Anderson <[EMAIL PROTECTED]> wrote: > Yes it's definitely a flash issue. I will replace the apostrophes in > the strings with ' before

Re: [nyphp-talk] MySQL/Flash/Apostrophe issue

2007-12-07 Thread Kristina Anderson
Yes it's definitely a flash issue. I will replace the apostrophes in the strings with ' before database insert and let you know how that works! > Kristina Anderson wrote: > > The previous programmers neglected to properly handle apostrophes and > > there are many text strings displayed in the

RE: [nyphp-talk] MySQL/Flash/Apostrophe issue

2007-12-07 Thread Edgar Reyes
Have you looked at the action script in flash? It may just be an easy fix there too. ER -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gary Mort Sent: Friday, December 07, 2007 1:22 PM To: NYPHP Talk Subject: Re: [nyphp-talk] MySQL/Flash/Apostrophe

Re: [nyphp-talk] MySQL/Flash/Apostrophe issue

2007-12-07 Thread Gary Mort
Kristina Anderson wrote: The previous programmers neglected to properly handle apostrophes and there are many text strings displayed in the .swf files, unfortunately what exists now is that whenever an apostrophe occurs, it cuts off the rest of the string. One thing that I tried was to go int

[nyphp-talk] MySQL/Flash/Apostrophe issue

2007-12-07 Thread Kristina Anderson
Hi Everyone, This is my first post to the list and I appreciate any feedback, thanks. I'm debugging a site someone else built in PHP & MySQL and on a few places in the site, there are Flash applets (.swf files) that are directly pulling strings from the MySQL database. The previous programmer