php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #3316 problem with select into outfile from php3
Submitted: 2000-01-26 07:52 UTC Modified: 2002-10-01 14:31 UTC
From: libes at com dot univ-mrs dot fr Assigned:
Status: Wont fix Package: MySQL related
PHP Version: 3.0.14 OS: linux redhat6.0
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: libes at com dot univ-mrs dot fr
New email:
PHP Version: OS:

 

 [2000-01-26 07:52 UTC] libes at com dot univ-mrs dot fr
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);
                                         
-------------

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-10-01 14:31 UTC] hholzgra@php.net
We are sorry, but can not support PHP 3 related problems anymore.
Momentum is gathering for PHP 5, and we think supporting PHP 3 will
lead to a waste of resources which we want to put into getting PHP 5
ready. Ofcourse PHP 4 will will continue to be supported for the
forseeable future.


 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Mar 28 18:01:29 2024 UTC