PHP - Downloading Selected Multiple File

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

I wonder if some kind-hearted person can help me?
I am trying to download a video file which has a wmv. The protocol is either mms:// or http://

I can see the video in my browser but I cannot download it using curl or wget in a program and I need to download a few of these.
They are publicly viewable so they are not private stuff.
The URL is http://210.150.12.140/vod11/tepco/other/1111_01.wmv?MSWMExt=.asf
or
mms://wmt.stream.co.jp/vod11/tepco/other/1111_01.wmv

All I get at the moment is a text file of less than 1K and not the movie itself.
How would I download this file please?
Thanks
Paul

Hi,
I want that user can only read my article but can't download it. neither with save page as or with view source, even not with selecting text. and copy and paste. is there any solution in php to do that.
Please help
Thanks

Hello everyone.
I have a problem with some of my php script.

I have some php code that downloads a remote file and directly outputs it to the user. It works and all, it's just that when I do it on my Ubuntu LAMP server, downloading a file takes up a lot of ram. On my Windows WAMP server it works correctly and doesn't use up so much ram. Is this a problem with my code, or is it a server configuration?

Below is the code I use to download the file.
Code: [Select]

public function output_file($file, $name, $mime_type='', $size)
   {
   session_write_close();
    /*
    This function takes a path to a file to output ($file),
    the filename that the browser will see ($name) and
    the MIME type of the file ($mime_type, optional).
   
    If you want to do something on download abort/finish,
    register_shutdown_function('function_name');
    */
    if(is_readable($file)) die('File not found or inaccessible!');
    /*
    $size = $size;
    $name = rawurldecode($name); */
   
    /* Figure out the MIME type (if not specified) */
    $known_mime_types=array(
      "pdf" => "application/pdf",
      "txt" => "text/plain",
      "html" => "text/html",
      "htm" => "text/html",
      "exe" => "application/octet-stream",
      "zip" => "application/zip",
      "doc" => "application/msword",
      "xls" => "application/vnd.ms-excel",
      "ppt" => "application/vnd.ms-powerpoint",
      "gif" => "image/gif",
      "png" => "image/png",
      "jpeg"=> "image/jpg",
      "jpg" =>  "image/jpg",
      "php" => "text/plain"
    );
   
    if($mime_type==''){
       $file_extension = strtolower(substr(strrchr($file,"."),1));
       if(array_key_exists($file_extension, $known_mime_types)){
         $mime_type=$known_mime_types[$file_extension];
       } else {
         $mime_type="application/x-rar-compressed";
       };
    };
   
    @ob_end_clean(); //turn off output buffering to decrease cpu usage
   
    // required for IE, otherwise Content-Disposition may be ignored
    if(ini_get('zlib.output_compression'))
     ini_set('zlib.output_compression', 'Off');
   
    header('Content-Type: ' . $mime_type);
    header('Content-Disposition: attachment; filename="'.$name.'"');
    header("Content-Transfer-Encoding: binary");
    header('Accept-Ranges: bytes');
   
    /* The three lines below basically make the
      download non-cacheable */
    header("Cache-control: no-cache");
    //header('Pragma: private');
   // header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
   
    // multipart-download and download resuming support
    if(isset($_SERVER['HTTP_RANGE']))
    {
      list($a, $range) = explode("=",$_SERVER['HTTP_RANGE'],2);
      list($range) = explode(",",$range,2);
      list($range, $range_end) = explode("-", $range);
      $range=intval($range);
      if(!$range_end) {
         $range_end=$size-1;
      } else {
         $range_end=intval($range_end);
      }
   
      $new_length = $range_end-$range+1;
      header("HTTP/1.1 206 Partial Content");
      header("Content-Length: $new_length");
      header("Content-Range: bytes $range-$range_end/$size");
    } else {
      $new_length=$size;
      header("Content-Length: ".$size);
    }
   
    /* output the file itself */
    $chunksize = 1*(1024)*(1024); //you may want to change this
    $bytes_send = 0;
    if ($file = fopen($file, 'r'))
    {
      if(isset($_SERVER['HTTP_RANGE']))
      fseek($file, $range);
   
      while(!feof($file) &&
         (!connection_aborted()) &&
         ($bytes_send<$new_length)
           )
      {
         $buffer = fread($file, $chunksize);
         print($buffer); //echo($buffer); // is also possible
         flush();
         $bytes_send += strlen($buffer);
      }
    fclose($file);
    } else die('Error - can not open file.');
   
   die();
   }
   // END OUTPUT_FILE function

Hello, I am new and am having a hard time with PHP. 

Scenario:  There are PDF files on my website that I want users to register before downloading the files.  I do not want them to login but rather provide basic information such as name and email address.  Once the form is submitted, I am not sure if I should be using PHPSESSION to validate the user.  Also, I am not sure where to place the files: either in the webroot (/var/www/) or outside.

I am new to PHP so please forgive me if I use terminology incorrectly.

Thank you for reading my question.

I have a script that will download a file from my server onto the user's computer. The problem is it's adding the pages HTML to the top of the file. When I actually look at the file on my server it does NOT have the HTML there, so it has to be some sort of problem with my headers.

Code: [Select]
<?php

$fname = "keyword_files/".$this->fileID.".csv";

header('Content-type: application/csv');
header("Content-Disposition: inline; filename=".$fname);
readfile($fname);

?>

I would appreciate any help! Thanks.

Hello,   I want the user to get authenticated before file download starts   Here is my code:    <?php
if (!isset($_SERVER['PHP_AUTH_USER'])) {
    header('WWW-Authenticate: Basic realm="My Realm"');
    header('HTTP/1.0 401 Unauthorized');
    echo 'Your request is cancelled';
    exit;
} else {
    //check $_SERVER['PHP_AUTH_USER'] and $_SERVER['PHP_AUTH_PW']
    if (isset ($valid)) {
        //start download

        $path = './data/negative_seq_60.txt';
        $type = "text/plain";

        header("Expires: 0");
        header("Pragma: no-cache");
        header('Cache-Control: no-store, no-cache, must-revalidate');
        header('Cache-Control: pre-check=0, post-check=0, max-age=0');
        header("Content-Description: File Transfer");
        header("Content-Type: " . $type);
        header("Content-Length: " .(string)(filesize($path)) );
        header('Content-Disposition: attachment; filename="'.basename($path).'"');
        header("Content-Transfer-Encoding: binary\n");

        readfile($path); // outputs the content of the file

        exit();
    } else {
        //show error
    }
}
?>   But on clicking download link, I am getting the following error : " Undefined variable: valid at line no 9".   Please help.

Hi,

I'm trying to figure out the best way to determine if a user is currently downloading a file from my website.
The way my site works, is the user waits 30 seconds and views an ad. After the timer is up the download becomes available.
I heard that I could probably use a timestamp or something of the sort. I've read up on it but not sure how I could go about this.

Hello,

I have the following code to force download mp3 file. the code is working fine but its only downloading 799 bytes. I am new in php and not able to figure out the problem. please help me to sort it out. thanks.

Code: [Select]
<?php 
                include "dbconnect.php"; 
                $link=dbconnect(); 
                $cat=$_GET['catagory']; 
                $id=$_GET['id']; 

                $query=("select *from $cat where id='$id'"); 
                $result=mysql_query($query); 
                $row=mysql_fetch_array($result); 
                $file = $row["link"]; 
                header ("Content-type: octet/stream"); 
                header("Content-Disposition: attachment; filename=\"".basename($file)."\";" );  
                header("Content-Length: ".filesize($file)); 
                readfile($file); 
                exit;                 
?>

Ok, I have a download script. The script is called like:

http://www.site.net/index.php?action=downloadfile&filename=file001.zip&directory=directory12&

The download file code is below. My site hosts quite a few files that get linked on other websites. Problem is, when that link is clicked, obviously it just starts the file download, as if it were a direct link to the file.

What I need to do, is still have it download the file when the link is clicked, but I would also like it to redirect the browser to my homepage as well.

I tried placing this after the download headers but it didn't work.

header("Location: http://www.site.net");

Can anyone give me an idea how I can get the code to do that? Keep in mind that I'm not fluent in PHP.



case 'downloadfile';

$filename = getGetVar('filename');
$directory = getGetDir('directory');


$current_dir = $uploads_folder_name;
if ($directory != '')
{ $current_dir.="/$directory"; }


$filename = basename($filename);


if (!$grants[$user_status][DOWNLOAD])
{
place_header($mess[111]);
show_Contents();
break;
}


if (!file_exists("$current_dir/$filename"))
{
place_header($mess[125]);
show_Contents();
break;
}


if (!is_path_safe($directory, $filename))
{
place_header($mess[111]);
show_Contents();
break;
}


list($upl_user, $upl_ip, $filestatus, $contents) = get_file_description("$current_dir/$filename", $comment_max_caracters);
if ($validation_enabled && $filestatus == UNVALIDATED && !$grants[$user_status][VALIDATE])
{
place_header($mess[111]);
show_Contents();
break;
}



$size = filesize("$current_dir/$filename");
$daily_size = get_daydownload();
if (($max_daily_download_mb > 0) && (($size + $daily_size) > ($max_daily_download_mb * 1024 * 1024)))
{
place_header($mess[212]);
show_Contents();
break;
}


$monthly_size = get_monthdownload();
if (($max_monthly_download_mb > 0) && (($size+$monthly_size) > ($max_monthly_download_mb * 1024 * 1024)))
{
place_header($mess[213]);
show_Contents();
break;
}
increasefiledownloadcount("$current_dir/$filename");
increasebytecountdl("$destination/$userfile_name");
if (($user_status != ANONYMOUS) && ($logged_user_name != ''))  // Update user statistics
{
list($files_uploaded, $files_downloaded, $files_emailed) = load_userstat($logged_user_name);
$files_downloaded++;
save_userstat($logged_user_name, $files_uploaded, $files_downloaded, $files_emailed, time());
}


header("Content-Type: application/force-download; name=\"$filename\"");
header("Content-Transfer-Encoding: binary");
header("Content-Length: $size");
header("Content-Disposition: attachment; filename=\"$filename\"");
header("Expires: 0");
header("Cache-Control: no-cache, must-revalidate");
header("Pragma: no-cache");

// Decrypt file if encryption enabled
if ($encrypt_filecontent)
{ decrypt_file("$current_dir/$filename", true); }
else
{ readfile_chunked("$current_dir/$filename"); }


exit;
break;

Hi everyone, I am having trouble passing/displaying the values inside of a selected list.
I created a add/remove list using Jquery and I tried to display the values passed using foreach and for loops but it is still not working. The values I am trying to get are $existing_mID[$j], which is inside of the option value attribute.

Please kindly let me know what should I do in order to get the values and I really appreciate your help.

<?php
$selected = $_POST['selectto'];
if(isset($selected))
{
    echo "something in selected<br />";
    for ($i=0;$i<count($selected);$i++)
    echo "selected #1 : $selected[$i]";
    foreach ($selected as $item)
    echo "selected: item: $item";
}
?>

This is the form

Hi all!

I have a page that is used to manage multiple user requests. The problem that I am having, is that it is supposed to send an email to the reporter any time their request is updated from this page. This works fine as long as I am doing one at a time, but when I try to update multiple records it doesn't send the emails. (All other functionality is working fine though.)
Here is a summary of what I have so far:
The form field to pass the users' emails
Code: [Select]
<input type="hidden" name="user_email<?= $arrValues["mantis_bug_id"] ?>" id="user_email<?= $arrValues["mantis_bug_id"] ?>" value="<?=$arrValues["email"]?>" />

This gets passed, along with the rest, to an update case on the same page, where I use a foreach() to process the multiple records:
Code: [Select]
foreach($_POST['chkResult'] as $intBugID){
.
.
.
.
.
if (isset($_POST["user_email$intBugID"])){
$emailTo = $_POST["user_email$intBugID"];
$emailSubject = "Mantis issue $intBugID has been modified.";
$emailContent = "Mantis issue $intBugID has recently been modified. Please review the changes that have been made
here [link]</a><br
/>If you have any questions or concerns regarding this issue, please contact Mike or Matt.<br />Thank you,<br />The
IT Team.";
include_once("{$_SERVER['DOCUMENT_ROOT']}/includes/Email.class.php");
$email = new Email();
$email->ContentType = "text/html";
$email->From = "me@myemail.org";
$email->FromName = "MOPS Mantis Bugtracker";
$email->to($emailTo);
$email->bcc('me@myemail.org');
$email->subject($emailSubject);
$email->setBody($emailContent);
$email->send;
echo 'User: ' . $emailTo. '<br />';
echo "User Email: " . $emailTo. "<br /><br />";

}
}//end foreach

As I said, this all works fine when I'm processing one issue at a time, but not when doing multiples. All other actions in the foreach() are also working. You'll notice that I'm echoing the username and email at the end for debugging purposes. The interesting thing is, that will output all of the correct usernames and emails for each user, it's just that the $email->send; just isn't working. Needless to say, this has become quite a frustrating bug to fix.
Any help at all is much appreciated!
Thanks,
Mike

Hi,

I am new to php and need help.
I am building a library system for an assignment.
I want to provide a functionality that registers (adds) all transactions to defferent databases.
I am stuck on how to add a selected row (selected by a checkbox) to the database and make sure that 2 users cannot update the same record at the same time.

Thanks for your help.

bellow is my code:

Code: [Select]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
  <meta http-equiv="content-type" content="text/html; charset=windows-1250">
  <meta name="generator" content="PSPad editor, www.pspad.com">
  <title>Web Works DD - Web Development & Software Solutions</title>
         <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3/jquery.min.js"></script>
      <link rel="stylesheet" type="text/css" href="css/style.css" />
 
  </head>
  <body>
  <!--<div class="utilities">
         <!-- UTILITIES MENU --
      <a href="index.php" style=text-decoration:none;><img src="images/home.png" border="0" alt="Home Page"/> Home Page</a>    <a href="sitemap.php" style=text-decoration:none;><img src="images/sitemap.png" border="0" alt="Sitemap"/> Sitemap</a>
        </div><!-- END UTILITIES -->
 
  <div id="right_bar">   <!-- right bar starts here -->
  </div> <!-- end of right bar -->
 
  <div id="top_bar">   <!-- top bar starts here -->
  <a href="index.php" style=text-ecoration:none; title="Web Works DD - Web Development & Software Solutions"><img src="images/mainLib.jpg" border=0 style=height:180;/> </a>
  <img src="images/topText.jpg" border=0 style=height:180;/>
  </div> <!-- end of top bar -->
       
 <div id="container">
 <div id="top-logo">
  <!--<a href="index.php" style=text-ecoration:none; title="Web Works DD - Web Development & Software Solutions"><img src="images/Main_logo.jpg" border=0 /> </a> -->
  </div>   
         
     <ul class="dropdown dav">
     <li><a href="index1.php">HOME</a></li>
     <li><a href="#" class="dir">VIEW RWSOURCES</a>
      <ul>
         <li><a href="books.php">BOOKS</a></li>
         <li><a href="dvds.php">DVDS</a></li>
         <li><a href="journals.php">JOURNALS</a></li>
    </ul>
   </li>
   <li><a href="staffLogin.php">STAFF ZONE</a></li>
    <li><a href="studentsLogin.php">STUDENT ZONE</a></li>
   
</ul>

<table>
<!--This defines a new form -->
<form action="" method="post">
<!--This creates the dropdown in html-->
<select name="fields">
<option value="1">Please select...</option>
<option value="isbnno">isbnno</option>
<option value="title">title</option>
<option value="description">description</option>
<option value="author">author</option>   
</select>
</td>
</tr>
<tr>
<td>
<input type="text" name="value" size="40">
</td>
</tr>
<tr>
<td>
<!-- Create a button -->
<input type="submit" value="Select" name="select">
</td>
</tr>
</form>
</table>
 
<?php
 session_start();
 include("secure/db_open.php");
       /* $myusername=$_SESSION['myusername']; 
        echo $myusername;
        $insert = $checkbox[$i];
        $cops = $_POST['copies'];
        $userid ="SELECT id FROM students WHERE username = '$myusername'";  
        $uido = mysql_query($userid); 
        $row = mysql_fetch_array($uido);
        echo $row['id'];    */
        
        
  
// get variable after selecting something from the dropdown with name 'fields'

$select = $_POST['select']; 
$valu = $_POST['value'];
// if something has been chosen
if (!empty($select)) 
{ 

$fields = $_POST['fields'];  //get the chosen value
$allbooks="SELECT * FROM books WHERE {$fields} = '$valu'";
//select books that are available - driven by the user's input
$copas="SELECT * FROM books WHERE {$fields} = '$valu' AND available_copies > 0";
$copy = mysql_query($copas); 
//count the number of rows resulting from the query
$count=mysql_num_rows($copy);
//$copse = mysql_fetch_array($copy);

//select books that are not available
$notavailable="SELECT * FROM books WHERE {$fields} = '$valu' AND available_copies = 0";
$shownotavailable=mysql_query($notavailable);
$count1=mysql_num_rows($shownotavailable);

//display a form 
echo "<table width='1100' border='0' cellspacing='1' cellpadding='0'>";
echo "<tr>";
echo "<td>" ;
echo "<form name='form1' method='post' action=''>";
echo "<table width='1100' border='0' cellpadding='3' cellspacing='1' bgcolor='#CCCCCC'>";
echo "<tr>";
echo "<td align='center' colspan='9' bgcolor='#FFFFFF'>";
echo "<strong>Available to Loan </strong>" ;
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td align='center' bgcolor='#FFFFFF'>Loan</td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>ISBN No.</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Title</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Description</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Author</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Loan Type</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Location</strong></td>"; 
echo "<td align='center' bgcolor='#FFFFFF'><strong>Available Copies</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Desired Num of Copies</strong></td>";
echo "</tr>"; 
while(($row = mysql_fetch_assoc($copy)))
  {  
  echo "<tr>";
  echo "<td align='center' bgcolor='#FFFFFF'><input name='checkbox[]' type='checkbox' id='checkbox[]' value=".$row['bookid']."></td>";
  echo "<td>" .$row['isbnno']. "</td>";
  echo "<td>" .$row['title']. "</td>";
  echo "<td>" .$row['description']. "</td>";
  echo "<td>" .$row['author']. "</td>";
  echo "<td>" .$row['loan_type']. "</td>";
  echo "<td>" .$row['location']. "</td>";
  echo "<td>" .$row['available_copies']. "</td>"; 
  echo "<td align='center' bgcolor='#FFFFFF'><input name='copies' type='text' id='copies' size='2'></td>";  
  echo "</tr>";
  }        
echo "<tr>";
echo "<td colspan='9' align='center' bgcolor='#FFFFFF'><input name='loan' type='submit' id='loan' value='Loan Book'></td>";
echo "</tr>";
echo "</table>"; 

if (isset($_POST))
{
      session_start();
        $myusername=$_SESSION['myusername'];     
        $cops = $_POST['copies'];
        $userid ="SELECT id FROM students WHERE username = $myusername";  
        $uido = mysql_query($userid); 
        $row1 = mysql_fetch_array($uido);
        $sid = $row1['id']; 
        
    for ($i=0;$i<$count;$i++)
    {   
        $insert = $checkbox[$i];
       //echo "Welcome, ".$row['id'];
        $insertloaned="INSERT INTO studentloanedbooks(studentid, bookid, noofcopies) VALUES ($sid, $insert, $cops)";
        $loaned = mysql_query($insertloaned);
            
    }   
     
}  
    
if($count1>0)
{
    //display the books details
    //display a form 
echo "<br>";
echo "<br>";  
echo "<table width='1100' border='0' cellspacing='1' cellpadding='0'>";
echo "<tr>";
echo "<td>" ;
echo "<form name='form1' method='post' action=''>";
echo "<table width='1100' border='0' cellpadding='3' cellspacing='1' bgcolor='#CCCCCC'>";
echo "<tr>";
echo "<td align='center' colspan='9' bgcolor='#FFFFFF'>";
echo "<strong>Available to Loan </strong>" ;
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td align='center' bgcolor='#FFFFFF'>Loan</td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>ISBN No.</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Title</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Description</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Author</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Loan Type</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Location</strong></td>"; 
echo "<td align='center' bgcolor='#FFFFFF'><strong>Available Copies</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Desired Num of Copies</strong></td>";
echo "</tr>"; 
while(($row = mysql_fetch_assoc($shownotavailable)))
  {  
  echo "<tr>";
  echo "<td align='center' bgcolor='#FFFFFF'><input name='checkbox[]' type='checkbox' id='checkbox[]' value='.$row[bookid]'></td>";
  echo "<td>" .$row['isbnno']. "</td>";
  echo "<td>" .$row['title']. "</td>";
  echo "<td>" .$row['description']. "</td>";
  echo "<td>" .$row['author']. "</td>";
  echo "<td>" .$row['loan_type']. "</td>";
  echo "<td>" .$row['location']. "</td>";
  echo "<td>" .$row['available_copies']. "</td>"; 
  echo "<td align='center' bgcolor='#FFFFFF'><input name='copies' type='text' id='copies' size='2'></td>";  
  echo "</tr>";
  }        
echo "<tr>";
echo "<td colspan='9' align='center' bgcolor='#FFFFFF'><input name='reserve' type='submit' id='reserve' value='Reserve Book'></td>";
echo "</tr>";
echo "</table>"; 

    
}



}
// include("secure/db_close.php");   


 //include("secure/db_close.php");  
?>
   


<!--if($cop>0){  -->



<!-- this is my footer div -->
<div id="footer">
Copyright &copy; 2010 | <a href="privacy.php">Privacy Policy</a> | <a href="terms.php">Terms of Service</a>
<img src="images/mini_logo1.png" align="right" style="margin-right:5" />
</div>   <!-- End footer div -->

    </div>
    </div>
  </body>
</html>

MOD EDIT: [code] . . . [/code] BBCode tags added.

Hello all,

i have a table that displays data from mysql, now i want to update multiple rows from that table with checkboxes, the value will basically just switch from 'new' to 'done' so far i have this:

Code: [Select]
<tbody>
                                        <tr class="first">
        </tr>
<?php
$ticketde=0;
while ($ticketde < $numpscde) {

$f1pscde=mysql_result($ticketresultde,$ticketde,"id");
$f2pscde=mysql_result($ticketresultde,$ticketde,"ticket");
$f4pscde=mysql_result($ticketresultde,$ticketde,"date");
$f5pscde=mysql_result($ticketresultde,$ticketde,"ip");
$f6pscde=mysql_result($ticketresultde,$ticketde,"done");

$setdone = ($f6pscde["done"] == 'n') ? "<a href=\"donepsc.php?id=".$f1pscde."\"><img src=\"ico_new.gif\" alt=\"new\" /></a>" : $f6pscde["done"];

if(isset($_POST['setdone'])){$checkbox = $_POST['checkbox'];

$id = "('" . implode( "','", $checkbox ) . "');" ;
$sql = "UPDATE ticket
        SET done='done'
        WHERE id='$f1pscde'";
$result = mysql_query($sql) or die(mysql_error());
}

?>

<tr class="first">
<td class="tc"><font face="Arial, Helvetica, sans-serif"><?php echo $f1pscde; ?></font></td>
<td class="tc"><font face="Arial, Helvetica, sans-serif"><?php echo $f2pscde; ?></font></td>

<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4pscde; ?></font></td>
<td class="tc"><font face="Arial, Helvetica, sans-serif"><?php echo $f5pscde; ?></font></td>
<td class="tc"><font face="Arial, Helvetica, sans-serif"><?php echo $setdone; ?></font></td>
<td class="tc"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $f1pscde['id']; ?>"></td>


</tr>


<?php
$ticketde++;
}
?>
</tbody>
</table>
                                    <center><input type="submit" name="setdone" id="setdone" value="Set selected  to done" class="button"/>   
                                 -     <input type="submit" name="exporttxt" id="exporttxt" value="Export selected to .txt" class="button"/>
                                    </center>
                                   
</fieldset>
</form>
                           
I found that checkbox code sample on some other site and tried to implement it, i don't really know where to go from here, as it's a total mess to me now, any help would be greatly appreciated.

hi, i'm new to php. i've got a problem.
I've 3 tables and table has following content

table 1
id  name  email   address   phone   execution_date   executor_name   web_address


table 2
id  name  email   address   phone   execution_date   executor_name   project_title


table 3
id  name  email   address   phone   execution_date   executor_name   reviewer

I want to export these table to and spreadsheet (.xls) with some criteria

a form will assign which data will published at the spreadsheet with these criteria
#all data can be exported from three tables
#some column can be selected from three tables
#some or all data can be selected from individual table

i've implement a script for this but it didn't meet my requirements. Can anyone help?

here is my script

<?php

$DB_Server = "localhost"; //your MySQL Server 
$DB_Username = "root";  //your MySQL User Name 
$DB_Password = "pass"; //your MySQL Password 
$DB_DBName = "mydb"; //your MySQL Database Name 
$search_from_date = $_POST['start_date'];
$search_to_date = $_POST['end_date'];
$Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password)
or die("Couldn't connect to MySQL:<br>" . mysql_error() . "<br>" . mysql_errno());
$Db = @mysql_select_db($DB_DBName, $Connect)
or die("Couldn't select database:<br>" . mysql_error(). "<br>" . mysql_errno());
$now_date = date('m-d-Y H:i');

if(($_POST['typer_of_report'] == 'rrc_report')  || ($_POST['typer_of_report'] ==  'all_report'))
{
$DB_TBLName = 'rrc_record';
}

if(($_POST['typer_of_report'] == 'erc_report')  || ($_POST['typer_of_report'] ==  'all_report'))
{
$DB_TBLName2 = 'erc_record';
}

if(($_POST['typer_of_report'] == 'aeec_report')  || ($_POST['typer_of_report'] ==  'all_report'))
{
$DB_TBLName3 = 'aeec_record';
}



$file_type = "vnd.ms-excel";
$file_ending = "xls";
//}
header("Content-Type: application/$file_type");
header("Content-Disposition: attachment; filename=protocol_report.$file_ending");
header("Pragma: no-cache");
header("Expires: 0");

if($DB_TBLName)
{
$sql = "Select * from ".$DB_TBLName." where execution_date >= '".$search_from_date."' and 
execution_date <= '".$search_to_date."' order by execution_date desc";
$Use_Title = 1;


$title = "Report for $DB_TBLName on $now_date";
$result = @mysql_query($sql,$Connect)
or die("Couldn't execute query:<br>" . mysql_error(). "<br>" . mysql_errno());

if ($Use_Title == 1)
{
echo("$title\n");
}
$sep = "\t"; //tabbed character
for ($i = 0; $i < mysql_num_fields($result); $i++)
{
echo mysql_field_name($result,$i) . "\t";
}
print("\n");
while($row = mysql_fetch_row($result))
{
$schema_insert = "";
for($j=0; $j<mysql_num_fields($result);$j++)
{
if(!isset($row[$j]))
$schema_insert .= "NULL".$sep;
elseif ($row[$j] != "")
$schema_insert .= "$row[$j]".$sep;
else
$schema_insert .= "".$sep;
}
$schema_insert = str_replace($sep."$", "", $schema_insert);
$schema_insert = preg_replace("/\r\n|\n\r|\n|\r/", " ", $schema_insert);
$schema_insert .= "\t";
print(trim($schema_insert));
print "\n";
}
//}

echo "\n...\n";
}

if($DB_TBLName2)
{
$sql = "Select * from ".$DB_TBLName2." where execution_date >= '".$search_from_date."' and 
execution_date <= '".$search_to_date."' order by execution_date desc";
$result = @mysql_query($sql,$Connect)
or die("Couldn't execute query:<br>" . mysql_error(). "<br>" . mysql_errno());
$Use_Title = 1;
$title = "Report for $DB_TBLName2 on $now_date";
if ($Use_Title == 1)
{
echo("$title\n");
}
$sep = "\t"; //tabbed character
for ($i = 0; $i < mysql_num_fields($result); $i++)
{
echo mysql_field_name($result,$i) . "\t";
}
print("\n");
while($row = mysql_fetch_row($result))
{
$schema_insert = "";
for($j=0; $j<mysql_num_fields($result);$j++)
{
if(!isset($row[$j]))
$schema_insert .= "NULL".$sep;
elseif ($row[$j] != "")
$schema_insert .= "$row[$j]".$sep;
else
$schema_insert .= "".$sep;
}
$schema_insert = str_replace($sep."$", "", $schema_insert);
$schema_insert = preg_replace("/\r\n|\n\r|\n|\r/", " ", $schema_insert);
$schema_insert .= "\t";
print(trim($schema_insert));
print "\n";
}


echo "\n...\n";
}

if($DB_TBLName3)
{
$sql = "Select * from ".$DB_TBLName3." where execution_date >= '".$search_from_date."' and 
execution_date <= '".$search_to_date."' order by execution_date desc";
$result = @mysql_query($sql,$Connect)
or die("Couldn't execute query:<br>" . mysql_error(). "<br>" . mysql_errno());
$Use_Title = 1;
$title = "Report for $DB_TBLName3 on $now_date";
if ($Use_Title == 1)
{
echo("$title\n");
}
$sep = "\t"; //tabbed character
for ($i = 0; $i < mysql_num_fields($result); $i++)
{
echo mysql_field_name($result,$i) . "\t";
}
print("\n");
while($row = mysql_fetch_row($result))
{
$schema_insert = "";
for($j=0; $j<mysql_num_fields($result);$j++)
{
if(!isset($row[$j]))
$schema_insert .= "NULL".$sep;
elseif ($row[$j] != "")
$schema_insert .= "$row[$j]".$sep;
else
$schema_insert .= "".$sep;
}
$schema_insert = str_replace($sep."$", "", $schema_insert);
$schema_insert = preg_replace("/\r\n|\n\r|\n|\r/", " ", $schema_insert);
$schema_insert .= "\t";
print(trim($schema_insert));
print "\n";
}
}

?>

have anyone any idea?