Re: RES: [PHP-DB] input field validation

2008-06-03 Thread Ruprecht Helms
YVES SUCAET wrote: > Nope, it's not. The problem was formulated as "Integer" detection. not > numerical detection in general. this must be able via preg_match (http://de3.php.net/manual/en/function.preg-match.php) using the regular expression /[1-9]/ possible [0] in addition. Regards, Ruprech

Re: [PHP-DB] mssql_connect()

2008-06-03 Thread Simge RESMOR
i restart ISS and i checked all the version of php.ini ,i unquoted in all php.ini file php_mssql.dll extension. i put this dll into system32 folder . but still i cant see mssql library in phpinfo() page. i dont understand why? is there anything besides above things i should do? ""YVES SUCAET"" <

Re: [PHP-DB] mssql_connect()

2008-06-03 Thread Yves Sucaet
phpinfo() should also contain a reference to which php.ini file it reads. Does it match the location of your php.ini file? When you say "all versions of php.ini", I would recommend that you only keep one copy of php.ini on your system. About your php.ini: What value do you have for the extens

Re: [PHP-DB] Can't get PHP PGSQL module to load

2008-06-03 Thread Eric
- Original Message - From: "Zimmerli, David" <[EMAIL PROTECTED]> To: Sent: Tuesday, June 03, 2008 10:56 PM Subject: [PHP-DB] Can't get PHP PGSQL module to load : : : Hello all, : : : : I am trying to use PostGreSQL with PHP (using Apache on Windows), but can't : get the php_pgsql

[PHP-DB] Can't get PHP PGSQL module to load

2008-06-03 Thread Zimmerli, David
Hello all, I am trying to use PostGreSQL with PHP (using Apache on Windows), but can't get the php_pgsql.dll module to load. phpinfo() reports that the loaded configuration file is C:\Program Files\PHP\php.ini. (It also reports that the "Configuration File (php.ini) Path" is "C:\WIND

[PHP-DB] Re: [PHP] question, about mysql query

2008-06-03 Thread Daniel Brown
This isn't a PHP question at all. It's a MySQL question. However, answers are below, with forwards to the appropriate lists for archiving purposes. On Mon, Jun 2, 2008 at 9:19 PM, LKSunny <[EMAIL PROTECTED]> wrote: > two table, tablea and tableb > tablea > uid, col1, col2, col3 > 1,xx, xx

RE: [PHP-DB] Can't get PHP PGSQL module to load

2008-06-03 Thread Zimmerli, David
Eric, Thanks for the reply. > Did you have an PHPIniDir in httpd.conf ? > It should point to a dir that specific the php.ini location as > PHPIniDir "e:/winnt" Yes, my httpd.conf includes these lines, added by the PHP installer: #BEGIN PHP INSTALLER EDITS - REMOVE ONLY ON UNINSTALL PHPIniDir "

RE: [PHP-DB] Can't get PHP PGSQL module to load

2008-06-03 Thread Zimmerli, David
Eric, > extension_dir = "c:\Program Files\PHP\ext\" > add c:\Program Files\PHP and c:\Program Files\PHP\ext to system variables. Tried those things, still no luck. > Did other extensions loaded pass ? The "built-in" extensions seem to load fine. I haven't tried any other (non-built-in) extens

RE: [PHP-DB] Can't get PHP PGSQL module to load

2008-06-03 Thread Zimmerli, David
Hmmm, this might be the problem... http://bugs.php.net/bug.php?id=44905 --David Z. -Original Message- From: Zimmerli, David Sent: Tuesday, June 03, 2008 2:59 PM To: 'Eric Lee'; php-db@lists.php.net Subject: RE: [PHP-DB] Can't get PHP PGSQL module to load Eric, > extension_dir = "c:

RE: [PHP-DB] Can't get PHP PGSQL module to load

2008-06-03 Thread Zimmerli, David
Eric, OK, I downgraded to the 5.2.5 extension and now it loads. Thanks for your help. --David Z. -Original Message- From: Zimmerli, David Sent: Tuesday, June 03, 2008 3:15 PM To: 'Eric Lee'; 'php-db@lists.php.net' Subject: RE: [PHP-DB] Can't get PHP PGSQL module to load Hmmm, this

Re: [PHP-DB] Can't get PHP PGSQL module to load

2008-06-03 Thread Eric
Sorry can't help But anything I post it for reference. to support pgsql extension on PHP 5.2.6. user have to download pqsql server 8.3.1 binary file called `postgresql-8.3.1-1-binaries-no-installer.zip` and extract some file and place all these into php folder. I have packed it will mininize

Re: [PHP-DB] explode () and mySQL query

2008-06-03 Thread Thodoris
O/H Ron Piggott ??: I am trying to add a search feature to my shopping cart. I am wanting to use PHP to develop the query for mySQL. I have the following code figured out: foreach(explode(" ", $keyword) as $key) $query .= " $key, "; This produces: WHERE shopping_cart_product.product_desc

Re: [PHP-DB] explode () and mySQL query

2008-06-03 Thread Chris
Thodoris wrote: > O/H Ron Piggott ??: >> I am trying to add a search feature to my shopping cart. >> >> I am wanting to use PHP to develop the query for mySQL. I have the >> following code figured out: >> >> foreach(explode(" ", $keyword) as $key) $query .= " $key, "; >> >> This produces: >> >

Re: [PHP-DB] Wrong results with ORDER BY DESC

2008-06-03 Thread Thodoris
O/H Michael Kelly ??: Hey all. I installed Apache and PHP onto my computer to use for testing about six days ago, and have had MySQL installed for a few weeks before. It all works fine, except for certain queries PHP gets very odd and inconsistent results back. Here's an example. This qu

Re: [PHP-DB] authentication verification

2008-06-03 Thread Thodoris
O/H DeadTOm ??: So the user comes to the site and they're presented with a log in page. They enter they're username and password and php checks a mysql database for a matching username and password. If there is a match, it responds with 1 line found. If no match, it responds with 0 lines fou