double and single quotes in text fields acting up... help please


Posted on 16th Feb 2014 07:03 pm by admin

Single quotes, when entered into a text field, create an sql error upon Submit. It seems to create the query OK but says there's an SQL syntax error and stalls out on that field.

Also any time a double-quote is in a text field, all characters to the right of it GET DELETED upon Submit and have to be re-entered before trying to Submit form again.

Did you know?Explore Trending and Topic pages for more stories like this.
The two larger textarea fields in the form seem to handle the single and double quotes perfectly. Stripslashes functions correctly and no deleting of data. Yet my code doesn't treat these two areas any differently that the text fields(!?)

I have used stripslashes on all posted variables

http://www.cmfsc.ca/coachingapplication_Feb10email.php

Thanks for any help
No comments posted yet

Your Answer:

Login to answer
237 Like 35 Dislike
Previous forums Next forums
Other forums

Edit MySQL Row Using PHP and HTML Form
Hello,

Here's what I'm trying to do. Build a page where a user enters a MySQL row number in.

passing data from one page to another
hey guys
i have the follwoing code to get information from one page and place on another:

disable all input buttons
Hello Friends,

suppose i do have a file ( file.php ) has a submit button

Code: [Sele

Mail Script Problems
I have created a PHP mail script. I am having a problem though. In $body i am trying to put two va

Create or replace package is ending ORA-21700
Database 9.2.0., patch 8 (9.2.0.8.0).
I trying run
create or replace package ....etc.

isset undefined variable
Hi all,

Hope someone can point out the obvious. I've a log in script, if you dont enter a use

function to return url
Hi,

Can you guys help me giving a function that takes all the contents in a particular field

Multiple arrays inside data
Hi,

Simple question. I have a column called "array" in my database, and inserted in

What am I missing here? Help!
Hello all!. I can't seem to get this working right. Well - it renders right, but something is goin

reorder sql query
ok so i have this very simple code:
Code: $query = "SELECT search_keywords, COUNT(search_key

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash