RE: [PHP-DB] MySQL/PHP dropping characters

[Ford, Mike [LSS]]

 -Original Message-
 From: Micah Stevens [mailto:[EMAIL PROTECTED]]
 Sent: 23 September 2002 18:09
 
 I've been running into a strange problem on my server with 
 scripts that 
 take form input and reformat it into SQL. It only happens 
 with statements 
 that insert or update data, the first four characters of the 
 POST variables 
 starting at the fourth variable passed are dropped.

There are several bug reports at http://bugs.php.net for this -- basically, it seems 
to be related to transparent multi-byte string encoding (or something like that).  If 
you don't need that support, you should turn it off -- search the bug database for the 
appropriate bugs, which will give you more information than my brain can!

Cheers!

Mike

-
Mike Ford,  Electronic Information Services Adviser,
Learning Support Services, Learning  Information Services,
JG125, James Graham Building, Leeds Metropolitan University,
Beckett Park, LEEDS,  LS6 3QS,  United Kingdom
Email: [EMAIL PROTECTED]
Tel: +44 113 283 2600 extn 4730  Fax:  +44 113 283 3211 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] MySQL/PHP dropping characters

[Micah Stevens]

Hi,

I've been running into a strange problem on my server with scripts that 
take form input and reformat it into SQL. It only happens with statements 
that insert or update data, the first four characters of the POST variables 
starting at the fourth variable passed are dropped.

So lately if I try and insert data into a table using a form:

Form1 holds data: 'onevalue', 'twovalue', 'threevalue', 'fourvalue', 
'fivevalue'

and posts to a php script that makes an insert statement out of the data, 
the insert statement will read:

insert into tbl_foo values ('onevalue, 'twovalue', 'threevalue', 'value', 
'value');

See what I'm saying? It's always four characters and it doesn't seem to 
matter what the data is. Normally I would assume it's my faulty 
programming, but it's also happening with scripts like PHPMyAdmin, and 
OSCommerce. So I'm thinking it's a problem with the server configuration.

It started soon after I upgraded to PHP 4.2.3

I'm running PHP as a module under Apache on a Redhat 7.2 system.

Does anyone have any ideas? I'd sure appreciate it, I've been playing with 
php.ini for two days now, and that doesn't seem to have any effect.

Thank you,
-Micah Stevens

Raincross Technologies
Maintenance, Development and Consulting Services
www.raincross-tech.com