Re: [PHP-DB] authenticating using system user list

2005-02-17 Thread Henry Ortega
I already have the one account in postgres to use the DB. I just need the authentication part. Sure, I can use table based authentication, but if I have 100 users and those 100 users already have an email account on this server, I might as well have them use those system account credentials to aut

RE: [PHP-DB] authenticating using system user list

2005-02-17 Thread Bastien Koert
why not create one account to use the db and use table based authentication? Same for email? bastien From: Henry Ortega <[EMAIL PROTECTED]> Reply-To: Henry Ortega <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] authenticating using system user list Date: Thu, 17 Feb 2005 11:54:17 -

[PHP-DB] authenticating using system user list

2005-02-17 Thread Henry Ortega
I have a database program using postgres and having a PHP front end. It requires people to login to gain access. Everyone who needs to login to that database program has a system user account in that machine. (since it's also the email server) What is the best way to authenticate using the system

Re: [PHP-DB] Intermittent odbc_connect() problem with iodbc/openlink

2005-02-17 Thread Martin Norland
Crone, James wrote: I'm having intermittent problems with odbc_connect(). Here's the situation I'm trying to connect to a Sybase Adaptive Server Anywhere database running on Win2K from my web server using Solaris, Apache, PHP, iODBC, and OpenLink's ODBC universal data access driver for MSSQL/S

Re: [PHP-DB] Re: checkbox into mysql using php

2005-02-17 Thread Martin Norland
Bastien Koert wrote: if its all going into one col, then implode the array into a string $data = implode(",",$_POST['games']); Then insert the data. Still doesn't relieve you of the need to validate the user data. Bastien [snip] No no no - you're confusing the guy further. He's taking an array p

RE: [PHP-DB] Re: checkbox into mysql using php

2005-02-17 Thread Bastien Koert
if its all going into one col, then implode the array into a string $data = implode(",",$_POST['games']); Then insert the data. Still doesn't relieve you of the need to validate the user data. Bastien From: "moses Woldeselassie" <[EMAIL PROTECTED]> To: php-db@lists.php.net, [EMAIL PROTECTED] Subj

Re: [PHP-DB] Intermittent odbc_connect() problem with iodbc/openlink

2005-02-17 Thread Robert Twitty
Assuming you always connect to the server using the exact parameter values for odbc_connect(), this does not look like an easy one to solve. I also connect to a Sybase database on a Win2K server from PHP/Apache/Solaris. However, I don't use the odbc extension. I use the odbtp extension, which work

RE: [PHP-DB] Re: checkbox into mysql using php

2005-02-17 Thread moses Woldeselassie
thank Bastien I did try that, but the input is going into one column or it is take the last array value and put it each chart in the table. in that case, these are the value i got in mysql: f, o, o, t foreach($_POST['games'] AS $game => $value) $valuecount = count($_POST['games']); f