PHP - Download And Save File Remotely

Hello,

I'm editing an XML file using PHP, the XML file contains a playlist of songs for a flash mp3 player.
Now I'm able to edit the XML file, but I'm not able to save it  .

Here's my code:

    $random_speed  = mt_rand(1,15); // Discspeed
    $song_title    = /*mysql_real_escape_string($_GET['song_title'])*/ "My First XML Edit";
    $song_artist   = /*mysql_real_escape_string($_GET['song_artits'])*/ "A great author";
    $song_filename = /*basename(mysql_real_escape_string($_GET['song_filename']))*/ "myfirstxmledit.mp3";
    
    /* Open image directory and get a random image name */
    $dir          = "./img";
    /* Scan the directory and put everything in an array */
    $files        = scandir($dir);
    /* Count the elements in the array */
    $count_array  = count($files);
    /* Pick a random index from the array */
    $rand_array   = array_rand( $files, 1 );
    /* Pick the value of the random index */
    $random_image = $files[$rand_array];
    /* Loop through array and if element is not equal to "." or ".." then set the random_image variable */
    if( ($random_image == "." ) || ($random_image == ".." ) ){
        while( ($random_image == "." ) || ($random_image == ".." ) ){
            $random_image = $files[$rand_array];
        }
    }elseif( ($random_image != "." ) || ($random_image != ".." ) ){
        echo $random_image;
    }
    /* Open the music.xml file */
    $xml = new DOMDocument('1.0', 'utf-8');
    $xml->formatOutput = true;
    $xml->preserveWhiteSpace = false;
    $xml->load('music.xml');
    /* Begin settin new element to music.xml file */
    $newItem = $xml->createElement('song');
    $newItem->appendChild($xml->createElement('title', "'$song_title'"));
    $newItem->appendChild($xml->createElement('artist', "'$song_artist'"));
    $newItem->appendChild($xml->createElement('url', "songs/'$song_filename'"));
    $newItem->appendChild($xml->createElement('image', "img/'$random_image'"));
    $newItem->appendChild($xml->createElement('discspeed', $random_speed));
    /* Add the new elements to the xml tag 'song' */
    $xml->getElementsByTagName('song')->item(0)->appendChild($newItem);
    /* Save the xml file */
    $xml->save();

I've tried to enter the filename in the last $xml->save() function, didn't work, added the location + filename, didn't work ...
Anyone knows what or how do I save the file?

Thanks!

Hi, I am trying to save some content with form which has php code in it.

i.e $submittedphpcode

<?php

echo 'test';

?>


my code to save that $submittedphpcode

$file = "file.php";
$ourFileHandle = fopen($filefile, 'w+') or die("can't open file");
fwrite($ourFileHandle, "$submittedphpcode");
fclose($ourFileHandle);


and i am getting this file created with slashes

<?php\r\n\r\necho \'test\';\r\n\r\n?>

i tried with stripslashes but it just remove \ not r n , i need to keep spaces etc.

any help on how to save it as php file properly?

Thanks

I have this code

header("Content-type: text/xml");
$database = "rprice";
$linkID = mysql_connect($host, $user, $pass) or die("Could not connect to host.");
mysql_select_db($database, $linkID) or die("Could not find database.");

$query = "SELECT * FROM plist ORDER BY date DESC";
$resultID = mysql_query($query, $linkID) or die("Data not found.");

$xml_output = "<?xml version=\"1.0\"?>\n";
$xml_output .= "<graph>\n";

for($x = 0 ; $x < mysql_num_rows($resultID) ; $x++){
    $row = mysql_fetch_assoc($resultID);
    $xml_output .= "\t<set date =\"" . $row['date'] . "\" value =\"" . $row['sprice'] . "\">\n";
    $xml_output .= "\t</set>\n"; 
}
$xml_output .= "</graph>";

echo $xml_output;



I want to save this xml file into the folder name Data what is the code of that please help

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;
?>

Hello,
I want to do, when someone click on button/link will open this:

but not Save As, but Open. I know how to make simple form:
<html>
<body>
<form action="edit.php" method="post" enctype="multipart/form-data">
<label for="file">File:</label>
<input type="file" name="file" id="file" />
<br><br>
<input type="submit" name="submit" value="Open"/>
</form>
</body>
</html> 
But here You must click Browse, but I want to do like in photo: if You click on button, then at once will open form like photo.
Many thanks,
Tadas
P.S. Sorry for my really bad English.

Hi Everyone,

i need some help how can i save this jsonfile to the webserver? 

my code

       // Load initial values from JSON 'file'
    jsonfile = '[{"lane 1":"1","lane 2":"1","lane 3":"5","lane 4":"2"}]';
    var initialstate = JSON.parse(jsonfile);
    setLaneState("lane1",initialstate[0]['lane 1'])
    setLaneState("lane2",initialstate[0]['lane 2'])
    setLaneState("lane3",initialstate[0]['lane 3'])
    setLaneState("lane4",initialstate[0]['lane 4'])

 

Hi all,

I'm trying to make a PHP script that downloads a file off a remote FTP server and serves the file to the visitor with a limited download speed.

Right now I'm using fopen() like this:

Code: [Select]
$path = "ftp://".$username.":".$password."@".$server."/";
$fullPath = ($path.$fileName);

$speed = 400; // 400 kb/s download rate

    header("Cache-control: private");
    header("Content-Type: application/octet-stream");
    //header("Content-Length: ".filesize($fullPath));
    header("Content-Disposition: filename=\"".$fileName."\"");

    flush();

   $fd = fopen($fullPath, "r");
   while(!feof($fd)) {
         echo fread($fd, round($speed*1024));
       flush();
       sleep(1);
   }
   fclose ($fd);


The file does download but with the wrong speed (8kb/s), does anyone know why?

When I run the same code with a local file instead of a file on FTP it works fine and downloads at the speed I set it to..

Thanks

I've written the following code:

Code: [Select]
<?php
echo '<img src="Sheph.png" />';


function Wad(){
if (file_exists("Sheph.png")) {
    header('Content-Description: File Transfer');
    header('Content-Type: application/octet-stream');
    header('Content-Disposition: attachment; filename='.basename("Sheph.png"));
    header('Content-Transfer-Encoding: binary');
    header('Expires: 0');
    header('Cache-Control: must-revalidate');
    header('Pragma: public');
    header('Content-Length: ' . filesize("Sheph.png"));
    ob_clean();
    flush();
    readfile("Sheph.png");
    exit;
}
}
Wad();
?>
What I want to do is show the image AND show a file download window.
The problem is that it shows the download window but the image doesn't appear. and if I comment the function and keep the echo part only,the image appears normally.

What's wrong ? 

Hello!

I'm making a interface in a website do manage files in a ftp hosted on other server.

I'm using the function ftp_get() to download a file but I've tried different aways but I dosent seem do be able to download the file directly from the FTP server do the user the only way it works is if I download the file to the website server first then to the client.

Is there any way that I can download the file directly to the user without have to hosting it permanently on the website server?

Thank you

How can i handle what the user clicked in the Save File Dialog Box?

if(user clicked "save")
{
  i will send them an email;
}
else if (user clicked "cancel")
{
 i will not send them an email;
}

is this possible? Please help me out guys. Thankyou

Hi,

Very new to PHP and am enjoying learning the ins and outs etc, but while creating my mam a website, ive ran into a problem while uploading, resizing and saving the file to my web host. Initially i used imagecreatefromjpeg, but this was taking too much memory up, so opted to use imagemagick. All of the features work apart from the file getting saved to the uploads directory on my web space. They always get saved to the root. If someone could help i would be very grateful. The code ive got currently is:

<?php

// If the form has been submitted do this
if(isset($_POST['submit'])) { 

// Temporary upload image name
$original_image = $_FILES['photo']['tmp_name']; 

// Get the image dimensions
$size=GetImageSize( $original_image );

// Name to save the image as - in this case the same as the original
$new_image = $_FILES['photo']['name'];

// Maximum image width
$max_width = "600";

// Maximum image height
$max_height = "300";

// Resize the image and save
exec("convert -size {$size[0]}x{$size[1]} $original_image -thumbnail $max_widthx$max_height $new_image");

echo "File uploaded<br>";

echo "<img src=\"".$new_image."\">";
}

?>

Hopefully someone could help

Many thanks,

Matk.

Hi Chaps,

I'm working on a PHP script to mysqldump database to file.

Using this as a base: http://www.edmondscommerce.co.uk/mysql/php-mysql-dump-script/, I've managed to strip it down to this:
Code: [Select]
set_time_limit(0);

$mysql_host='localhost';
$mysql_database='database';
$mysql_username='username';
$mysql_password='pasword';

_mysql_test($mysql_host,$mysql_database, $mysql_username, $mysql_password);
$print_form = 0;

header('Content-type: text/plain');
header('Content-Disposition: attachment; filename="'.$mysql_database."_".date('Y-m-d').'.sql"');

$filename = $mysql_database."_".date('Y-m-d').'.sql';
_mysqldump($mysql_database);

function _mysqldump($mysql_database)
{
$sql="show tables;";
$result= mysql_query($sql);
if( $result)
{
while( $row= mysql_fetch_row($result))
{
_mysqldump_table_structure($row[0]);
_mysqldump_table_data($row[0]);
}
}
else
{
echo "/* no tables in $mysql_database */\n";
}
mysql_free_result($result);
}
function _mysqldump_table_structure($table)
{
echo "/* Table structure for table `$table` */\n";
echo "DROP TABLE IF EXISTS `$table`;\n\n";
$sql="show create table `$table`; ";
$result=mysql_query($sql);
if( $result)
{
if($row= mysql_fetch_assoc($result))
{
echo $row['Create Table'].";\n\n";
}
}
mysql_free_result($result);
}
function _mysqldump_table_data($table)
{
$sql="select * from `$table`;";
$result=mysql_query($sql);
if( $result)
{
$num_rows= mysql_num_rows($result);
$num_fields= mysql_num_fields($result);
if( $num_rows> 0)
{
echo "/* dumping data for table `$table` */\n";
$field_type=array();
$i=0;
while( $i <$num_fields)
{
$meta= mysql_fetch_field($result, $i);
array_push($field_type, $meta->type);
$i++;
}
echo "insert into `$table` values\n";
$index=0;
while( $row= mysql_fetch_row($result))
{
echo "(";
for( $i=0; $i <$num_fields; $i++)
{
if( is_null( $row[$i]))
echo "null";
else
{
switch( $field_type[$i])
{
case 'int':
echo $row[$i];
break;
case 'string':
case 'blob' :
default:
echo "'".mysql_real_escape_string($row[$i])."'";
}
}
if( $i <$num_fields-1)
echo ",";
}
echo ")";
if( $index <$num_rows-1)
echo ",";
else
echo ";";
echo "\n";
$index++;
}
}
}
mysql_free_result($result);
echo "\n";
}
function _mysql_test($mysql_host,$mysql_database, $mysql_username, $mysql_password)
{
global $output_messages;
$link = mysql_connect($mysql_host, $mysql_username, $mysql_password);
if (!$link)
{
   array_push($output_messages, 'Could not connect: ' . mysql_error());
}
else
{
array_push ($output_messages,"Connected with MySQL server:$mysql_username@$mysql_host successfully");
$db_selected = mysql_select_db($mysql_database, $link);
if (!$db_selected)
{
array_push ($output_messages,'Can\'t use $mysql_database : ' . mysql_error());
}
else
array_push ($output_messages,"Connected with MySQL database:$mysql_database successfully");
}
}
The problem is, I want the file to save to a specific network location, rather than the output being sent to headers.

I've tried to play around with:
Code: [Select]
ob_start();....
$page = ob_get_contents();
ob_end_flush();
$fp = fopen("output.html","w");
fwrite($fp,$page);
fclose($fp);
But this outputs to the browser, then saves the file...I would like to load the page, and have the script create and save the file where I want it (without the output in the browser, or prompt to save/download file).

Note: I need something like this as I'm running PHP/MySQL on IIS, so can use shell/system/etc.

Any help will be hi-5-tastic!

Hello, i need some help/info about searching words in files (txt or xml) and saving them to db or another file.   For example ive got an xml file like below:   <families> <family> <name>brown</name> <city>denver</city> <members>12</members> </family> <family> <name>jackson</name> <city>new york</city> <members>6</members> </family> </families>   i want to search for: <family> then save the lines till it comes to the word </family> and then goes to the next group. did some reading about array, preg_match, strpos functions but dont know where to start. what is the best way to do this?   can you guys give me some advise... or links to good tutorials?   thanks in advance!

I would like to write all files from specific folder into .txt file. The output working just fine, but I'm getting only one file saved into my txt file. Any idea? Thanks!

$fileList = glob('C:\users\John\Documents\*pdf');
foreach($fileList as $filename){
if(is_file($filename)){

echo $filename, '<br>'; 

$save_files = fopen("list.txt", "w");
fwrite($save_files,$filename);
fclose($save_files);

}   
}  

 

I'm wanting to have users able to download a file, but I'm wanting it to be a file that only users who are logged in can download. Basically, I don't want a user to be able to enter the URL and download it while not being logged in. Does anyone know what I would use to do this? Thanks.