Re: Storing HTML string in database
| From: | sven | Date: | Fri, 11 Jul 2003 09:39:13 +0000 |
| Subject: | Re: Storing HTML string in database | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-154843@lists.php.net to get a copy of this message | ||
is escaping a solution?
addslashes() for your insert-query
stripslashes() for your select-query
"Aaron Axelsen" <axelseaa@amadmax.com> schrieb im Newsbeitrag
news:003501c34749$99346b80$6400a8c0@DELTA...
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> I have a php script set up for a user to upload a word document,
> which is then coverted to html form, which I would then lke to store
> in a database.
>
> Howver, when I run the following command:
>
> INSERT into sermons (data) VALUE ('$output');
>
> It failes to work, because the $output strings contains "", which
> messes things up. Is there some way that this can be ignored while
> entering into the databse?
>
> Or am I better of replace all the "" with ''?
>
> Thanks for the assistance.
>
> - ---
> Aaron Axelsen
> AIM: AAAK2
> Email: axelseaa@amadmax.com
>
> Want reliable web hosting at affordable prices?
> www.modevia.com
>
> Web Dev/Design Community/Zine
> www.developercube.com
>
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 7.0.3 for non-commercial use
> <http://www.pgp.com>
>
> iQA/AwUBPw4PI7rnDjSLw9ADEQLL5QCg6rxSs/roIiGyxC6nN3XNiuONg00AoK/T
> PSAAAbM+O7+e6iVNMMnpK5AC
> =phqJ
> -----END PGP SIGNATURE-----
>
>