Re: [PHP-DB] Configure with Postgres/MySQL of different machine
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. Normally that would not be a problem, however, both MySQL and Postgres will be on a different machine. How can I configure PHP to use the servers on the other machine? Everything I've seen shows how to do it when it's all on one machine. This is what I ran: ./configure \ --enable-track-vars \ --with-gd \ --with-mysql \ --with-pgsql \ --with-apxs=/usr/sbin/apxs --with-config-file-path=/etc Any help or pointers would be appreciated. Thanks. Joe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] PHP/MySQL to M$ Access
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 machine on the way to the data. Chris Andrew wrote: Hi, Until we completely migrate an application from M$ Access to PHP/MySQL, I need to figure out a way to temporarily query an Access DB from PHP/MySQL. I am aware of this article on PHP Builder: http://www.phpbuilder.com/columns/timuckun20001207.php3?page=1 which discusses using ODBC Socket Servers, but the article assumes the M$ Access db is on a winblows machine. In my case, the Access DB is on a Linux machine (served thru' Samba - isn't Linux great... :-) Anyways - could someone offer me some advice - all I need is some some simple SELECT queries on the Access tables. Many Thanks, Chris Email: [EMAIL PROTECTED] Web: www.oxspring.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Why use MySQL with PHP
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 functionality, extensibility, and ease of use is PHP (I have used CF, ASP, Miva/HTMLScript, PERL, C, COBOL, Shell also) BTW, COBOL on the web is weird. ASP is the worst of them all. Sheridan Saint-Michel wrote: I use PHP/MySQL for a few reasons. snip/snip On the other hand, having to write in languages where you have strict types (You want to treat a variable as an int and then as a string?!?!?!?) and very structured design is just as distasteful to me. PHP strikes a very good balance between the two even when working with MySQL (I won't paste any of the kludge needed to interface with CGI and DB in other languages... but if you have some free time look some of these programs up). Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Re: file upload, again
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 page calls the script via the system call. All the shell script does is move a specific file from tmp to a specific location. I'm probably asking for someone to exploit it, but I don't know exactly what they can do. -Brian -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] file upload, again
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 nope... when I upload a file all is well, it get stored in the tmp directory, the filename and path get stored in the mysql database, however, it won't copy to the desired directory unless I give everyone write permissions to that directory. offcourse I don't like this. How do I tell php to use my username and password when copying the file from the tmp dir to the desired dir? Do I really have to make an ftp connection first? or is there a more simple way? How do you upload all those pictures to the webserver? thanks Leo Kuiper www.koelwebdesign.nl -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Close Postgresql Database Connection Problem !
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 want to ask the connection will be closed by Apache Server automatic ? or when user closed the web page the connection will be closed at the same time ? If the connection have not been closed automatic. So the Apache Server will keep the connect port forever ? Actually the connection port handle by Apache Server or PHP ? If you use pg_connect, it will close when the script is finished, like when the page is to the browser. If you use pg_pconnect, it will stay open for other pages to use. I am not sure how pg_close affects a pg_pconnect. As most of the overhead with postgres is in opening the connection, I use pg_pconnect, and never close it. This improves performance, but if I want to shutdown, I have to shutdown apache before I shut down postgres just in case there was some recent activity, and it hasn't timed out yet. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] NON sql database
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 Airways http://www.virtualbritishairways.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] If you are on a Windows machine, you can connect to anything that will work with ODBC. If you are on a Unix or Linux machine, I have 3 or 4 good ones (1 REALLY like) that are full multi-user servers all for $0. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Postgres Library problems
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 don't have to add them to any paths, like: cd /usr/local/lib cp -rs ../pgsql/lib/* . And so on for the other directories (bin, include, etc.) It works great that way. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
