[PHP-DB] php5 coding class objects best practices

2006-11-16 Thread Chris Barnes
hi people, i havent used thi slist for quite a while. anyway. Im trying to write an application which relies heavily on mysql. so i have made a class object which has all the functions to make using mysql very easy for me. but the problem im faced with now is, i have a bunch of other classes, wh

[PHP-DB] Special Character

2006-11-16 Thread David Skyers
Hi , We have a problem with storing data into our oracle database that is copied from Microsoft word. A typical example would be a hyphen, if entered directly in an input box this is stored fine. However if copied from Microsoft word it is displayed as a question mark. Has anyone else experienced

Re: [PHP-DB] Special Character

2006-11-16 Thread Niel Archer
Hi Is it really a hyphen, or is it an en- or em-dash. The latter two could mess up in in some character sets. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Special Character

2006-11-16 Thread David Skyers
Hi Niel That's the problem I don't know what it is, but I do know that I press the hyphen/minus key on my keyborad. If I type in 'The -' then press enter and copy and paste this from word, it then gets displayed as question mark in Oracle. David -Original Message- From: Niel Archer [m

Re: [PHP-DB] Special Character

2006-11-16 Thread Niel Archer
Hi David What you describe sounds like Word is auto replacing hyphens with either en- or em-dashes. This is a configurable option in Word that often defaults to on. Try using double quotes, If they get switched to 66's and 99's style quotes, then that is likely the problem. I no longer use MS O

Re: [PHP-DB] Special Character

2006-11-16 Thread Dan Shirah
To turn off the auto formatting of hyphens: In Microsoft Word 2003: Open a new document. Go to Tools>Auto Correct Options> Select the "Auto Format As You Type" tab Deselect the "Hyphens (--) with Dash (-)" option. Even though it says it will replace a double hyphen (--) with a Dash (This is an

RE: [PHP-DB] Special Character

2006-11-16 Thread David Skyers
Thanks, The problem is, we will have hundreds of users using Microsoft Word and we cannot switch it off for all of them. Ideally I need some type of string replace function, so no matter what they enter it gets trapped an replaced. It's not the normal hyphens that cause a problem but the long hyp

Re: [PHP-DB] Special Character

2006-11-16 Thread Niel Archer
Hi David off the top of my head, the best I can suggest is using PHP's MB functions (lookup mb_string) to allow recognition and then convert them to hyphens. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Special Character

2006-11-16 Thread Niel Archer
Hi Doh... that's 'mbstring' Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Special Character

2006-11-16 Thread Kevin Murphy
A solution I use is to do apply this function to all POST data collected. The key here for your problem is the chr(150) and chr(151) that are replaced with a normal hyphen. This also takes care of MS Words Smart Quotes. If there are other MS Characters you need to convert, just add them to

Re: [PHP-DB] php5 coding class objects best practices

2006-11-16 Thread Chris
Chris Barnes wrote: hi people, i havent used thi slist for quite a while. anyway. Im trying to write an application which relies heavily on mysql. so i have made a class object which has all the functions to make using mysql very easy for me. but the problem im faced with now is, i have a bunch

Re: [PHP-DB] berkeley db + php + locking

2006-11-16 Thread Christopher Jones
Chris, I've emebedded inline an answer from George Feinberg from the Sleepycat team. Chris Chris Peiffer wrote: I'm having trouble getting php working with db4 so that it does correct write-locking in an apache webserver environment (where there are potentially many applications writing at onc

[PHP-DB] Help on query report...

2006-11-16 Thread Suprie
dear all, i have this table id | contract No | site id | handover date |status| finishing date | contract value|actual value 1 | T0001 | LOS01 | 12-Apr-06| Done | 11-Apr-06 | 12,000 | 12,000 2 | T0002 | LOS02 | 12-Apr-06| Done | 11 Apr-06 | 11

Re: [PHP-DB] Help on query report...

2006-11-16 Thread Chris
Suprie wrote: dear all, i have this table id | contract No | site id | handover date |status| finishing date | contract value|actual value 1 | T0001 | LOS01 | 12-Apr-06| Done | 11-Apr-06 | 12,000 | 12,000 2 | T0002 | LOS02 | 12-Apr-06| Done | 11