PHP / MySQL Remote Update Advice

NEX2NUN

I am searching for a method to use php functions to update local php files from a remote server. I also would like to work with a function that can import a CSV file into a MySQL database if it is found in a remote folder. I have done some looking but am not certain on where to start. Any advice on what I can research to create such an file updating system?

Thank you!

big_nerd

NEX2NUN,

A Quick Google search turned up this website: http://www.modwest.com/help/kb6-253.html

Where a user contributed the following code:

<?
   # first get a mysql connection as per the FAQ

  $fcontents = file ('./spreadsheet.xls'); 
  # expects the csv file to be in the same dir as this script

  for($i=0; $i<sizeof($fcontents); $i++) { 
      $line = trim($fcontents[$i]); 
      $arr = explode("\t", $line); 
      #if your data is comma separated
      # instead of tab separated, 
      # change the '\t' above to ',' 

  $sql = "insert into TABLENAME values ('". 
              implode("','", $arr) ."')"; 
  mysql_query($sql);
  echo $sql ."<br>\n";
  if(mysql_error()) {
     echo mysql_error() ."<br>\n";
  } 
}
?>

Check their notes where they mention to change the '\t' to ',' for COMMA delimited (CSV).

Also, if you look at the php manual at fwrite()

You will see many great examples of edit text files.

One thought though: If you are editing PHP files directly, if your application crashes out or there is some error somehow, it can break the application running the file.

I would recommend using as much as you can from a Database, or CSV / XML file.

If your intention is to create a CSV file and import it - these links should certainly get you started.

bradgrafelman

I would say that the above code was written by someone who didn't realize that a better function already exists; [man]fgetcsv/man.

NEX2NUN wrote:
I am searching for a method to use php functions to update local php files from a remote server.

Since I'm assuming you want to update the actual source code of the PHP files, you're best bet might be to use the [man]ftp[/man] functions in PHP to login and download the actual files themselves. Otherwise, you'd have to rig up some PHP script on that remote system where you could authenticate and retrieve the contents of remote files.