Bug #3316: problem with select into outfile from php3
| From: | libes at com dot univ-mrs dot fr | 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);
-------------