Updating CSV file in FTP server in PHP

Question

I'm trying to updating a CSV file which in a external FTP server, I tried to follow the basic ftp_fput() but it's not working. File is not updating and also a blank CSV file is downloading when I run this script which is not needed. I've been trying to solve this but can't find the solution

<?php

// connect and login to FTP server
//ftp setup
 $ftp_server = "ftp.test.test.co.uk";
        $ftp_conn = ftp_connect($ftp_server) or die("Could not connect to $ftp_server");
        $ftp_username='ftp_username';
        $ftp_userpass='ftp_userpass';
      $login = ftp_login($ftp_conn, $ftp_username, $ftp_userpass);

//local DB setup
$servername = "localhost";
$username = "root";
$password = "TEST";
$dbname= "TEST";

// Create connection
$conn = new mysqli($servername, $username, $password,$dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
//END database connection//



$sql = "SELECT sku,SUM(quantity) as quantity FROM tbl_old_books GROUP BY isbn";

$result = $conn->query($sql);

         header("Content-Disposition: attachment; filename=AllOpenOrders.csv");
         header("Content-Type: application/csv; ");

         // file creation
       $file = fopen('php://temp', 'W');

        $header = array("SKU","QUANTITY");
        fputcsv($file, $header);


      if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
            fputcsv($file, $row );
        }
    }

 $remote_path = "/export/AllOpenOrders.csv";

ftp_fput($ftp_conn, $remote_path, $file, FTP_BINARY, 0);


  fclose($file);
ftp_close($ftp_conn);
?>

the existing CSV file in not updating, the file permission is 777 but still it's not getting new records. — Sylvester Antu Rozario, Feb 19 '20 at 17:02
@JayBlanchard `fopen` move is not relevant. OP is creating an in-memory buffer. — Martin Prikryl, Feb 19 '20 at 17:09
@Sylvestr We need [mcve]. I'm pretty sure that 90% of your code is not relevant to your current problem. For a start, can you upload a local test file to your FTP server using PHP? + Do you get any PHP errors/warnings from your FTP function calls? What does the `ftp_fput` return? — Martin Prikryl, Feb 19 '20 at 17:09
@MartinPrikryl there is some common code to connect database and make a CSV file. instead of download a file I'm trying to make a file in temp memory and put that temp file to a existing file. — Sylvester Antu Rozario, Feb 19 '20 at 17:12
@MartinPrikryl I'm trying this code from my local environment and it seems to me ftp_fput($ftp_conn, $remote_path, $file, FTP_BINARY, 0); doesn't doing anything that I'm expecting. not getting any error too. — Sylvester Antu Rozario, Feb 19 '20 at 17:17
@MartinPrikryl more exactly ftp_fput() returning true here but my file is not updating — Sylvester Antu Rozario, Feb 19 '20 at 17:23

score 1 · Accepted Answer · answered Feb 19 '20 at 20:01

1

You file handler $file points at the end of the file as you write in it. There is nothing left to write via ftp_fput.

You can reset your file pointer at the beginning of the file with rewind($file); before writing in the FTP : rewind documentation

answered Feb 19 '20 at 20:01

Joffrey Schmitz

2,393
3
19
28

Thank you for your answer but after adding row in my temp file if I rewind() that file it show error message "stream does not support seeking" – Sylvester Antu Rozario Feb 20 '20 at 04:15
1

Try to combine this advice with `$file = fopen('php://temp', 'w');` (lowercase `w`) + What version of PHP are you using? – Martin Prikryl Feb 20 '20 at 06:42

Updating CSV file in FTP server in PHP

1 Answers1