Re: still learning php
| From: | Dimitris Kossikidis | Date: | Mon, 01 Oct 2001 12:52:23 +0000 |
| Subject: | Re: still learning php | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-69450@lists.php.net to get a copy of this message | ||
Use addslashes() to escape single quotes or double quotes. It 's in the
manual....
// giving some values
$firstname ="Bob";
$lastname = "O' Reily"; // This could cause an error if not use addslashes
$address = "Somewhere";
$age= 19;
// adding slashes to quotes
$firstname = addslashes($firstname);
$lastname = addslashes($lastname);
$address = addslashes($address);
$sql = " insert into TABLE values ( '$firstname', '$lastname',
'$address',
$age) ";
----- Original Message -----
From: "Caleb Carvalho" <havanero@hotmail.com>
To: <dikos@vip.gr>
Cc: <php-general@lists.php.net>
Sent: Monday, October 01, 2001 3:36 PM
Subject: Re: [PHP] still learning php
> Hi Dimitris,
>
> thanks, but what if I have 5 fields to add into ie name,surname,comments?
>
>
>
> Caleb Carvalho
> Application Engineer
> LoadRunner/APM
> --------------------------------------------------------------------------
---------------
> Enterprise Testing and Performance Management Solutions
> --------------------------------------------------------------------------
---------------
> Mercury Interactive
> 410 Frimley Business Park
> Frimley, Surrey. GU16 7ST
> United Kingdom
> Telephone : +44 (0)1276 808300
>
>
>
> >From: "Dimitris Kossikidis" <dikos@vip.gr>
> >To: "Caleb Carvalho" <havanero@hotmail.com>
> >CC: <php-general@lists.php.net>
> >Subject: Re: [PHP] still learning php
> >Date: Mon, 1 Oct 2001 14:29:14 +0300
> >
> >$field_value = "I 'm bla bla";
> >$field_value = addslashes($field_value);
> >
> >$sql = "Insert into TABLE values('$field_value');
> >
> >
> >----- Original Message -----
> >From: "Caleb Carvalho" <havanero@hotmail.com>
> >To: <php-general@lists.php.net>
> >Sent: Monday, October 01, 2001 2:05 PM
> >Subject: [PHP] still learning php
> >
> >
> > > I posted a msg earlier on regarding error when adding text with quotes
'
> > > ..
> > > I have just found out thar I need to use addslash() function,
> > >
> > > my q's is
> > >
> > > where do i put this function?
> > >
> > >
> > >
> > > Caleb Carvalho
> > > Application Engineer
> > > LoadRunner/APM
> > >
>
>--------------------------------------------------------------------------
> >---------------
> > > Enterprise Testing and Performance Management Solutions
> > >
>
>--------------------------------------------------------------------------
> >---------------
> > > Mercury Interactive
> > > 410 Frimley Business Park
> > > Frimley, Surrey. GU16 7ST
> > > United Kingdom
> > > Telephone : +44 (0)1276 808300
> > >
> > >
> > > _________________________________________________________________
> > > Get your FREE download of MSN Explorer at
> >http://explorer.msn.com/intl.asp
> > >
> > >
> > > --
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> > > For additional commands, e-mail: php-general-help@lists.php.net
> > > To contact the list administrators, e-mail:
php-list-admin@lists.php.net
> > >
> > >
> >
> >
> >--
> >PHP General Mailing List (http://www.php.net/)
> >To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> >For additional commands, e-mail: php-general-help@lists.php.net
> >To contact the list administrators, e-mail: php-list-admin@lists.php.net
> >
>
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at
> http://explorer.msn.com/intl.asp
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>