Database not saving all fields

MacCoilin

I was wondering if anybody has experienced this.

I have a message board. You fill out the form. Click submit. The information is saved in a database record. Standard.

Just one thing. In my case with MySQL/PHP it does not work as planned 100% of the time. Most of the time, not all.

In certain cases one of the ten fields is not persisted to the database record. It is usually the first field and sometimes the last. The fields in between are saved.

I have noticed the same effect with two different hosting companies with whom I have used MySQL/PHP. It's not critical to my site, more of a rare inconvenience.

Has anybody else come across this? and if so is there a reason?

g7ibby

Check if punctuation is causing this. A good test is to use Don't in one of your fields. The ' in the string of data causes mysql to think that it is at the end of the data string attempting to enter

don

instead of

don't

Being that the t in don't does not format the sql statement for the next string correctly, mysql pukes on it.

If this is the case add the following for each of your variables before your sql isert code.

$variable = mysql_escape_string($variable);

I did this for each of my variables and it cleared it up. Im not sure if there is a way to make that code work for all of your variables with one line. I had to do this for each of my variables. If anybody else knows how to do that please let me know.

Also I understand that this is a big security hole if you do not escape punctuation in your forms. I dont know if it is this sencitive but imagine somebody putting ');DROP TABLE table as an entry into your message board?

Hope this helps.

sledgeweb

Doesn't the addslashes function remedy this as well? Then just use strip slashes when you display it?

In other words, don't becomes don\'t

Which keeps mysql from reading it as the end of a string?

Sledgweb

MacCoilin

Hello All,

Thanks for taking the time to reply. The fields that are not updating (infrequently) are contolled by me, one is a number and the other is a word without puncutation so by luck puncuation is n't the issue this time round (although thanks for the tip had n't considered that one).

I'll keep the problem under review and if I work it out I'll repost to the board for future reference.

All the best