PHP - Possible Run File On Event From Server?

Hello all. I have a script that exports data from mysql to a csv file. Everything works great. However, I do not know how to save the csv file to the server. Does anyone have any ideas how I would do that? The script is below. Thanks for all help!

Code: [Select]
<?php
$host = 'localhost';
$user = '';
$pass = '';
$db = '';
$table = '';
$file = 'export';

function escape_csv_value($value) { 
$value = str_replace('"', '""', $value); // First off escape all " and make them "" 
if(preg_match('/,/', $value) or preg_match("/n/", $value) or preg_match('/"/', $value)) { // Check if I have any commas or new lines 
return '"'.$value.'"'; // If I have new lines or commas escape them 
} else { 
return $value; // If no new lines or commas just return the value 
} 
} 


$link = mysql_connect($host, $user, $pass) or die("Can not connect." . mysql_error());
mysql_select_db($db) or die("Can not connect.");

$result = mysql_query("SHOW COLUMNS FROM ".$table."");
$i = 0;
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
$csv_output .= $row['Field'].", ";
$i++;
}
}
$csv_output .= "\n";

$values = mysql_query("SELECT * FROM ".$table."");
while ($rowr = mysql_fetch_row($values)) {
for ($j=0;$j<$i;$j++) {
$csv_output .= escape_csv_value($rowr[$j]).','; 
 //$csv_output .= $rowr[$j].", ";
}
$csv_output .= "\n";
}

$filename = $file."_".date("Y-m-d_H-i",time());
//header( "Content-Type: application/save-as" ); 

header("Content-type: application/vnd.ms-excel");
header("Content-disposition: csv" . date("Y-m-d") . ".csv");
header( "Content-disposition: attachment; filename=".$filename.".csv"); 




//header( "Content-disposition: filename=".$filename.".csv");
print $csv_output;
exit;
?>

I have a script that uploads my file, but this script requires apache. I want to get this file onto my other server that's running nginx. Is there a way for PHP to write a file to nginx?

Alternatively, is there a way for PHP to copy a file from one server to another? Because that will work as well.

How do I do this?

Is it possible to allow a script running on another server to write/read a specific file on my server?  I can set file permissions, but not having any luck with file paths due to php5 blocking http:// urls.

i am making song site
i want to upload songs files on another instread on which m running my script for uploading songs and adding information in data...
mean want to know is there any function or method that i upload files through the panel of www.site1.com
and my files upload on an other server www.site2.com.
which code i have to write for doing this

Hello,

Ive got a script that downloads a file to my server. I want to be able to download a file from a site such as FileServe using my premium details. Ive tried http://username:password@fileserve.com/file.rar but that dosent work, It just downloads a tiny small 30kb file.

Is there a way i can set a cookie or somthing so my script has access to download file using my premium account?

Thanks in advance

Hello There  ,

I want to download a file from the server to the computer  .


How can i do this ??

i found out this code:

header("Content-type: image/jpg");
header("Content-Disposition: attachment; filename=test.jpg");


the problem is , what i get is the file that the code was executed from saved in the .jpg format.

how can i direct to a specified path to select a certain file then download it .

example
let's say i have a folder that contains 2 files:
download.php and image.jpg

how can i download the image.jpg from the server with the Save As window??

Thank You

Hello,

I'm trying to have my index.php to open/run another test.php file.
I'm having my own server that I play with, that I run Ubuntu on.

So the index.php are located at /var/www/ directory, but I want to run a file that are located at /testing/test.php

The final test.php is file for showing pictures, and I don't want to out all the pictures under the /var/www/ location.  It's alot  of photos.
I don't know much about php but I have been trying this:

<?php
header("Location: /var/www/testing/test.php");
    //These below are desperat old tries.
//header("Location: ./testing/test.php");
//header("Location: ../testing/test.php");
//$handle = fopen("/privat/Web_pictures/test.php", "r");
//"/testing/test.php"
// header("Location: ./test.php");   //This one actually works, but I'm still in the wrong folder (/var/www/)
echo "test "; // NN4 requires that we output something...
exit();
?>

Thankful for help!   

A beginner question..

I have tried "isset" but it aint working.. I wonder what PHP function to use to check if a user actually put a file to be uploaded on the server. A validation  just in case a user just click the submit button w/out even choosing a file first.


I have this code but it aint working...

Code: [Select]
<?php
if(isset($_POST['submit']))
{

if(isset($_FILES['uploaded_file']))
{
echo "<span class=\"error_validation\">You haven't choose a logo to upload!<br></span>";
echo "<span class=\"error_validation\">Upload Logo Again? <a href=\"edit_logo.php\">Click Here</a><br></span>";
}
else
{

if($_FILES['uploaded_file']["type"] == "image/gif")
{


$target_path = "logo/";

$target_path = $target_path. basename('matzhee_logo.gif');



if(move_uploaded_file($_FILES['uploaded_file']['tmp_name'], $target_path))
{
echo "<span class=\"error_validation\">The Logo has been successfully changed! Refresh the page to see the changed!<br></span>";
echo "<span class=\"error_validation\">Upload Logo Again? <a href=\"edit_logo.php\">Click Here</a><br></span>";
}
else
{
echo "<span class=\"error_validation\">There was an error uploading the logo. Pls. try again.<br></span>";
echo "<span class=\"error_validation\">Upload Logo Again? <a href=\"edit_logo.php\">Click Here</a><br></span>";
}

}
else
{
echo "<span class=\"error_validation\">Invalid file format. We are only accepting image file. Pls. try again.<br></span>";
echo "<span class=\"error_validation\">Upload Logo Again? <a href=\"edit_logo.php\">Click Here</a><br></span>";
}
}

}
else
{
me_redirect_to("edit_logo.php");
}


?>

Anyone? thanks

I designed a web form that takes as input a file and that should upload that file on the server. The file is located on the client machine. The page containing the web form is handled by PHP script.

I found out (reading 9483658954 forum topics so far) that there are 2 methods for getting a file uploaded. The first one is using FTP, and the second one using $_FILES variable. Unfortunately i have complains regarding both of the methods.

Firstly, when attempting to upload the file using FTP it seems that rather the FTP server is calling "upload" a simple copy action (because the only successful thing i could do with FTP was to copy a file from location A to location B, both A and B being on the server) or I don't know to use FTP (which is probably the right answer). Then, when using $_FILES variable, I was forced to include ' enctype="multipart/form-data" ' in the form tag. After a long documentation I finally figured out that by including the enctype blah blah, the $_POST and $_FILES variables were NULL after the form was submitted.Still can't understand why!



Are there any other methods for uploading a file from the client machine to the server? Can I get a competent script for this?

Hi, I have a form where a user selects a file to attach to the email. At the moment when you select a file it uploads from the user device.

How do i change this so that a user can attach a file from a folder on the server. For example the folder name is uploadinvoice

so when the user selects the browse button to attach a file it opens up the uploadinvoice folder on the server so the user can select the file from there ?

 

Thanks 

 

coding i have at moment

function ValidateEmail($email)

{

   $pattern = '/^([0-9a-z]([-.\w]*[0-9a-z])*@(([0-9a-z])+([-\w]*[0-9a-z])*\.)+[a-z]{2,6})$/i';

   return preg_match($pattern, $email);

}

if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['formid']) && $_POST['formid'] == 'form1')

{

   $mailto = $_POST['youremail'];

   $mailfrom = isset($_POST['myemail']) ? $_POST['myemail'] : $mailto;

   $subject = 'Message';

   $message = 'Message';

   $success_url = './test.php';

   $error_url = '';

   $eol = "\n";

   $error = '';

   $internalfields = array ("submit", "reset", "send", "filesize", "formid", "captcha_code", "recaptcha_challenge_field", "recaptcha_response_field", "g-recaptcha-response");

   $boundary = md5(uniqid(time()));

   $header  = 'From: '.$mailfrom.$eol;

   $header .= 'Reply-To: '.$mailfrom.$eol;

   $header .= 'MIME-Version: 1.0'.$eol;

   $header .= 'Content-Type: multipart/mixed; boundary="'.$boundary.'"'.$eol;

   $header .= 'X-Mailer: PHP v'.phpversion().$eol;

   try

   {

      if (!ValidateEmail($mailfrom))

      {

         $error .= "The specified email address (" . $mailfrom . ") is invalid!\n<br>";

         throw new Exception($error);

      }

      $message .= $eol;

      foreach ($_POST as $key => $value)

      {

         if (!in_array(strtolower($key), $internalfields))

         {

            if (!is_array($value))

            {

               $message .= ucwords(str_replace("_", " ", $key)) . " : " . $value . $eol;

            }

            else

            {

               $message .= ucwords(str_replace("_", " ", $key)) . " : " . implode(",", $value) . $eol;

            }

         }

      }

      $body  = 'This is a multi-part message in MIME format.'.$eol.$eol;

      $body .= '--'.$boundary.$eol;

      $body .= 'Content-Type: text/plain; charset=ISO-8859-1'.$eol;

      $body .= 'Content-Transfer-Encoding: 8bit'.$eol;

      $body .= $eol.stripslashes($message).$eol;

      if (!empty($_FILES))

      {

         foreach ($_FILES as $key => $value)

         {

             if ($_FILES[$key]['error'] == 0)

             {

                $body .= '--'.$boundary.$eol;

                $body .= 'Content-Type: '.$_FILES[$key]['type'].'; name='.$_FILES[$key]['name'].$eol;

                $body .= 'Content-Transfer-Encoding: base64'.$eol;

                $body .= 'Content-Disposition: attachment; filename='.$_FILES[$key]['name'].$eol;

                $body .= $eol.chunk_split(base64_encode(file_get_contents($_FILES[$key]['tmp_name']))).$eol;

             }

         }

      }

      $body .= '--'.$boundary.'--'.$eol;

      if ($mailto != '')

      {

         mail($mailto, $subject, $body, $header);

      }

      header('Location: '.$success_url);

   }

   catch (Exception $e)

   {

      $errorcode = file_get_contents($error_url);

      $replace = "##error##";

      $errorcode = str_replace($replace, $e->getMessage(), $errorcode);

      echo $errorcode;

   }

   exit;

}
 

guys i wand to execute a program on my seerver, i use the


$_SESSION['tmp'] = exec("print.exe", $results);

and works but when i change the directory

$_SESSION['tmp'] = exec("d:\\print\\user1\\print.exe", $results);

dont work,

works only in root directory, is any way to set the execution to other directorys??

thanks

I'm trying to work out if in my form my image field, which currently asks the user to upload from their hard drive, can show the contents of a server folder to select an image or upload a new one. Can this be done??

I need to reach Win server, scan shared folder and find out what is last created file name on this folder, and than copy this file to local folder. BUT main problem is smb, never used it before, and this is what i came up  with, but no luck.

require_once('smbclient.php');
$latest = null;

    $smbc = new smbclient ('//10.1.1.10/Share/Address Verification/', 'domain\\username', 'password');
     if ($handle = opendir($smbc)) {
    $latest = null;
    while (($cur = readdir($handle) !== false)) {
        if ($latest == null || filectime($cur) > filectime($latest)) {
            $latest = $cur;
        }
    }
    closedir($handle);
}
return $latest;

please help, returns Warning: opendir() expects parameter 1 to be string

hi,


I want to download the file, where i have the search query in session variable, in my local system its working good, but in server its not working, any guidance please

Code: [Select]
<?php
include("global.php");
// Original PHP code by Chirp Internet: www.chirp.com.au 
// Please acknowledge use of this code by including this header. 

function cleanData(&$str) 
{
 $str = preg_replace("/\t/", "\\t", $str); $str = preg_replace("/\r?\n/", "\\n", $str); 
 if(strstr($str, '"')) $str = '"' . str_replace('"', '""', $str) . '"'; 
} 

$sql = $_SESSION['emp_search_sql'];
// file name for download 
$filename = "employees_" . date('Ymd') . ".xls";
header("Content-Disposition: attachment; filename=\"$filename\"");
header("Content-Type: application/vnd.ms-excel; charset=UTF-8"); 
header("Pragma: no-cache");


$flag = false;
 $result = $DB_site->query($sql) or die('Query failed!');
while(false !== ($row = mysql_fetch_assoc($result)))
{
if(!$flag) 
{
// display field/column names as first row 

echo implode("\t", array_keys($row)) . "\n"; $flag = true; 
} 
array_walk($row, 'cleanData'); 
echo implode("\t", array_values($row)) . "\n";
}

?>

Thanks

Is it possible to connect via php to ftp and download part of file (about 2MB from file)