Re: [cobalt-users] PHP and single quotes

["Steve Werby" <steve-lists@xxxxxxxxxxxx>]

"Paul" <quinns_inbox@xxxxxxxxxxx> wrote:
> I am using a local linux server, and a win2k server in the office, both
with
> MySQL 3.23.37 and PHP 4.0.4, and if I add a block of text to the database
> with a single quote, ie "paul's nice email message." all works fine.
>
> However the same code on my cobalt RaQ4i fails - the quote messes up the
sql
> syntax.

I'm a PHP-MySQL/PostgreSQL developer and if you post some snippets of
relevant unaltered PHP code I'm sure I can help.  Also, what specific error
message are you getting?  Perhaps you don't have magic quotes turned on in
php.ini or you've overridden it in .htaccess, but I'm not even sure that's
the problem without seeing some code, error messages and more detail.

> I have upgraded mysql on the raq server to 3.23.37, and I still have
> the problem. So I assume it is a parse error in the older version of php,
> but I cannot upgrade php because the rpm installer says that various
> libraries are required, including some from glibc 2.2.
>
> Now, PHP version 4.0.5 has just been released, and I still don't see any
> packages, or upgrades for php 4.0.4. Are Cobalt going to be this slow with
> the upgrades all the time?

I wouldn't hold my breath.  It's actually not reasonable to think Cobalt is
going to create PKG files for all of their products every time one of the
hundreds of programs on the server has a new major (or in this case minor)
release.  Nice, yes.  Reasonable, no.

> and if anyone has installed the new version of php, let me know how it
> went.... and where I can get the packages or rpm's with the other
libraries.

I've installed PHP 4.0.5 from source (not RPM or PKG) on the RaQ2, RaQ3 and
RaQ4, but not yet on a RaQ XTR.

--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/