[PHP-DB] Postgres Library problems

2001-07-21 Thread Grant Johnson
Sorry I am not replying to the thread. I deleted the message, not thinking. If you install PostgreSQL from source, and take the defaults, it puts its files in /usr/local/pgsql/... Each of theses subdirectories matches one in /usr/local/... What I do is create symlinks win /usr/local so I

Re: [PHP-DB] NON sql database

2001-08-04 Thread Grant Johnson
Eric Marenyi wrote: I am trying to develop a dynamic website, but I dont have the capability to use SQL, or Access databases, can I use PHP to interface with a different type of database?, maybe a text delimited, or something, please help, thanks -- Eric Marenyi CEO Virtual British

Re: [PHP-DB] Close Postgresql Database Connection Problem !

2001-08-15 Thread Grant Johnson
Perrin wrote: == $connection = pg_connect($constr user='$USER' password='$PW'); Actually It should be closed the connection after access finished, like that pg_close(); == pg_close($connection); But if the user force to close the web page that means have not close the connection. I

Re: [PHP-DB] file upload, again

2001-11-13 Thread Grant Johnson
The web server user needs to have access to that directory. On NT, there are 2 of these users. On *nix, there is one. Giving these users access to write to that directory is not a huge risk. koelwebdesign wrote: hi there, I've searched the lists and forums for a couple of days now but

Re: [PHP-DB] Re: file upload, again

2001-11-14 Thread Grant Johnson
Look in you apache.conf file and find out what user the web server runs as, then give that user the right to write to that directory, probably through a group used for nothing else is most secure. Brian Mauter wrote: To get around this, I made a small shell script which runs as root. The php

Re: [PHP-DB] PHP/MySQL to M$ Access

2001-11-15 Thread Grant Johnson
Access has to be running on a Winders machine. At least the drivers. Another option might be to migrate the data, and use ODBC and linked tables to let Access still work temporarily, but really have the data already transitioned. Otherwise it is a weird linked ODBC bouncing off a Windows

Re: [PHP-DB] Why use MySQL with PHP

2001-11-15 Thread Grant Johnson
I mostly agree, although I prefer PostgreSQL for the transactions, better row locking, and server side cursors. It also does better with lotsa users (if the data isn't just used for the web, this is important). I have used many languages for this stuff, and the one with the best balance of

Re: [PHP-DB] Configure with Postgres/MySQL of different machine

2001-11-27 Thread Grant Johnson
The different machine has nothing to do with the config, and everything to do with the connect. It is in the connect string that you specify which machine for PHP to connect to Postgres. Joe Nelson wrote: I'm trying to configure php so that it will have support for both MySQL and Postgres.