Bug #3316: problem with select into outfile from php3

From: Date: Wed, 26 Jan 2000 12:52:43 +0000
Subject: Bug #3316: problem with select into outfile from php3
Groups: php.dev 
Request: Send a blank email to php-dev+get-14926@lists.php.net to get a copy of this message
From: libes@com.univ-mrs.fr Operating system: linux redhat6.0 PHP version: 3.0.14 PHP Bug Type: MySQL related Bug description: problem with select into outfile from php3 hi to all.. in a previous message you tell me to use "select ... into outfile" query in order to get database result into a file! I try this query from MySQL with success BUT... i do not succeed anything (or get the result file) when launching it from a PHP3 script in the example below we do succeed to write a text file in /home/ftp/pub (so the user rights seems to be good (our http apache demon runs under httpd user and group , and /home/ftp/pub belong to httpd group with 775 permissions) BUT... the same thing from a PHP3 script launching a query select into outfile /home/ftp/pub " no not succeed (the file is not created... and i really don't know why!! what can be wrong??? thanks for your help ---------- <?php $base="PNOC"; $userpnoc="httpd"; $host="localhost"; $passwd="*****"; $connect=mysql_connect($host,$userpnoc,$passwd); $fd=fopen("/home/ftp/pub/titi.txt","w"); /* file is created !!!!*/ $query="select * from mission into outfile \"/home/ftp/pub/bidon\";"; /* file bidon is NOT created !!! */ $result=mysql_db_query($base, $query); -------------

« previous php.dev (#14926) next »