Re: ' giving problem while inserting in table.

thanx, its working perfect now anil :) ----- Original Message ----- From: "1LT John W. Holmes" <holmes072000@charter.net> To: "Anil Garg" <anilg@niksun.com>; "Martin Clifford" <MLC1@nrc.gov>; <php-general@lists.php.net> Sent: Friday, July 12, 2002 12:46 PM Subject: Re: [PHP] ' giving problem while inserting in table. > If you're using addslashes, then a string like this: > > It's going to be a good \ bad day > > Will be converted to > > It\'s going to be a good \\ bad day > > And then you can safely put that into your database. So I don't see why > using a \ in your string is causing you problems. > > ---John Holmes... > > ----- Original Message ----- > From: "Anil Garg" <anilg@niksun.com> > To: "1LT John W. Holmes" <holmes072000@charter.net>; "Martin > Clifford" > <MLC1@nrc.gov>; <php-general@lists.php.net> > Sent: Friday, July 12, 2002 12:30 PM > Subject: Re: [PHP] ' giving problem while inserting in table. > > > > Hi, > > addslashes() works fine for me( and as John said i dint need to use > > stripslashes) > > NOW( :( ) whats happening is if i *want* to add a backslash in the string > > that also gets stripped off (as i have to specify many windows paths e.g. > > c:\niksun\config\ ). Is there any fix to this of its a trade off between > > ',",... and \ ? > > > > Note: putting a \\ to add \ doesnt help coz for one time it works one i > open > > the entry in edit mode again i have to put \ before all the \. > > please help > > regards > > anil > > > > ----- Original Message ----- > > From: "1LT John W. Holmes" <holmes072000@charter.net> > > To: "Martin Clifford" <MLC1@nrc.gov>; <php-general@lists.php.net>; > > <anilg@niksun.com> > > Sent: Friday, July 12, 2002 12:12 PM > > Subject: Re: [PHP] ' giving problem while inserting in table. > > > > > > > You DON'T have to use stripslashes() on data coming out of a database. > The > > > slashes were there to escape certain characters so they could make it > into > > > the database. The actual slashes do not go into the database. If they > are > > in > > > your case, then you're using addslashes() twice, somehow. The only time > > you > > > have to use stripslashes on database data is if your > magic_quotes_runtime > > > setting is on in php.ini. > > > > > > ---John Holmes... > > > > > > ----- Original Message ----- > > > From: "Martin Clifford" <MLC1@nrc.gov> > > > To: <php-general@lists.php.net>; <anilg@niksun.com> > > > Sent: Friday, July 12, 2002 10:49 AM > > > Subject: Re: [PHP] ' giving problem while inserting in table. > > > > > > > > > Use addslashes() on ALL strings before inserting them into your > database. > > > Then, on your frontend, extract the data and use stripslashes() on all > > > strings. > > > > > > Hope to help! > > > > > > Martin Clifford > > > Homepage: http://www.completesource.net > > > Developer's Forums: > > > http://www.completesource.net/forums/ > > > > > > > > > >>> "Anil Garg" <anilg@niksun.com> 07/12/02 10:45AM > > > >>> >>> > > > Hi, > > > I am making a faq maintenance system using mysql and php. > > > To insert a entry in to a faq table i am using the following query: > > > --------- > > > INSERT INTO faq_table_netvd (id,question, > > > > > > answer,netvcr,netdetector,add_date,mod_date,keyword,category,display,attach_ > > > id) > > > VALUES ('0','$frm[question]', > > > > > > '$frm[answer]','$frm[netvcr]','$frm[netdetector]','$frm[add_date]','$frm[mod > > > > > > _date]','$frm[keyword]','$frm[category]','$frm[display]','$frm[attach_id]') > > > "); > > > ----------- > > > now the problem is when $frm[question] has some string like: "why i > can't > > > eat". > > > i get the following error: > > > MySQL Error: You have an error in your SQL syntax near 't eat?' ,answer > = > > > 'Please recheck the power of your specs:)' ' at line 3.Putting a > > > '\' > > before > > > ' (e.g. \')solves my problem...but when i open the same quesion to edit > > it, > > > again i have to put backslashes where ever i find " ' " in the quesion > or > > > answer. > > > > > > Can anyone please suggest a solution to this. > > > > > > thanx and regards > > > > > > anil > > > > > > [please ask if i havent explained the problem fully] > > > > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > >