PHP - How To Upload Excel File To Mysqul With A Html/php Form.

Hello,
i am currently getting an Microsoft Excel formatted text file whose save type is .Txt from a URL.I used to open it and will change the save type  as excel file. Please suggest whether we can do this with php code.

currently my code is like this,
<? php
copy("http://www.faa.gov/airports/airport_safety/airportdata_5010/menu/emergencyplanexport.cfm?Region=&District=&State=&County=&City=LAS%20VEGAS&Use=&Certification=","./contactsexport.xls");
?>

where as the contactsexport.xls type is .Txt which i need it in .xls

Thanks in Advance.

This sounds like overkill, but is there any way I can take the results of an html form, and plug them into their respective cells on a excel spreadsheet?

Thanks in advance!

-Brad

I tried to add a second file upload to my previously properly functioning form, but after adding it, now when I submit the form, it submits the data twice. It appears to be submitting the file right on the first insert, but on the second insert, the second image is not inserted, but just blank. Can anyone help me figure out why? I must have done something wrong in my insert statement or second file statement. Here is the page itself which contains the form:


http://midwestcreativeconsulting.com/jhrevell/add/


And below is my insert page:


Code: [Select]

<?php
$dbhost = 'localhost';
$dbuser = 'username';
$dbpass = 'password';


$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');


$dbname = 'jhrevell_jewelry';
mysql_select_db($dbname);


$name = $_POST['name'];
$metal = $_POST['metal'];
$desc = $_POST['desc'];
$item_no = $_POST['item_no'];
$cut = $_POST['cut'];
$color = $_POST['color'];
$carats = $_POST['carats'];
$clarity = $_POST['clarity'];
$size = $_POST['size'];
$type = $_POST['type'];
$other = $_POST['other'];
$total = $_POST['total'];
$certificate = $_POST['certificate'];
$value = $_POST['value'];


//if ((($_FILES["file"]["type"] == "image/gif")
//|| ($_FILES["file"]["type"] == "image/jpeg")
//|| ($_FILES["file"]["type"] == "image/pjpeg"))
//&& ($_FILES["file"]["size"] < 20000))
//  {
  if ($_FILES["file"]["error"] > 0)
    {
    echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
    }
  else
    {
    //echo "Upload: " . $_FILES["file"]["name"] . "<br />";
    //echo "Type: " . $_FILES["file"]["type"] . "<br />";
    //echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
    //echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";


     if (file_exists("upload/" . $_FILES["file"]["name"]))
      {
      echo $_FILES["file"]["name"] . " already exists. ";
      }
    else
      {
      move_uploaded_file($_FILES["file"]["tmp_name"],
      "upload/" . $_FILES["file"]["name"]);
      //echo "Stored in: " . "http://www.webdesignsbyliz.com/wdbl_wordpress/wp-content/themes/twentyten_2/upload/" . $_FILES["file"]["name"];
     
     $image = $_FILES["file"]["name"];
     
      $query = "INSERT INTO gallery VALUES ('', '$cut', '$color', '$carats', '$clarity', '$size', '$metal', '$other', '$total', '$certificate', '$value', '$image', '$name', '$desc', '$item_no', '$type', '$image2')";
$query_res = mysql_query($query) or die(mysql_error());
      }
    }
  //}
  
// IMAGE 2 //


//if ((($_FILES["file"]["type"] == "image/gif")
//|| ($_FILES["file"]["type"] == "image/jpeg")
//|| ($_FILES["file"]["type"] == "image/pjpeg"))
//&& ($_FILES["file"]["size"] < 20000))
//  {
  if ($_FILES["file2"]["error"] > 0)
    {
    echo "Return Code: " . $_FILES["file2"]["error"] . "<br />";
    }
  else
    {
    //echo "Upload: " . $_FILES["file"]["name"] . "<br />";
    //echo "Type: " . $_FILES["file"]["type"] . "<br />";
    //echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
    //echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";


     if (file_exists("upload/" . $_FILES["file2"]["name"]))
      {
      echo $_FILES["file2"]["name"] . " already exists. ";
      }
    else
      {
      move_uploaded_file($_FILES["file2"]["tmp_name"],
      "upload/" . $_FILES["file2"]["name"]);
      //echo "Stored in: " . "http://www.webdesignsbyliz.com/wdbl_wordpress/wp-content/themes/twentyten_2/upload/" . $_FILES["file"]["name"];
     
     $image2 = $_FILES["file2"]["name"];
     
      $query = "INSERT INTO gallery VALUES ('', '$cut', '$color', '$carats', '$clarity', '$size', '$metal', '$other', '$total', '$certificate', '$value', '$image', '$name', '$desc', '$item_no', '$type', '$image2')";
$query_res = mysql_query($query) or die(mysql_error());
      }
    }
  //}
 
     
echo '<script language="Javascript">';
echo 'window.location="http://midwestcreativeconsulting.com/jhrevell/collections"';
echo '</script>';
      
    






?>


Can anyone see what could be causing it to insert the record twice?

Having some issues getting this to work properly... I keep getting my own error message

I know where it fails, but I can't seem to figure out why it fails. The test file I'm using is an MP3 file, which is why I'm here asking if anyone other than I can shed some experienced light on this :p

Code: [Select]
File Upload Failed!
No File Exists!The file type or extension you are trying to upload is not allowed! You can only upload MP3 files to the server!

My upload form looks like:

<?php
session_start();
define('PITCHFORK', true);

if(!isset($_SESSION['USERS_AUTHENTICATED'])) { die("You must be logged in to do that"); }

if(isset($_POST['upload']))
{
include("config.php");

include("classes/class.media.upload.php");
$file = $_GET['file'];

$upload = new Upload;
$upload->doAudio($file);
}


?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>PITCHFORK Login</title>
<link rel="stylesheet" href="style/login.css" type="text/css" media="all">
<meta name="robots" content="noindex,nofollow">
</head>

<body>
<div id="login"><h1><a title="A SpaazZ Industries Concept"></a></h1>
<form name="loginform" id="loginform" action="<?php $_SERVER['PHP_SELF']; ?>" method="post">
<p>
<label>File (one at a time for now)<br>
  <input name="file" id="user_login" class="input" size="20" tabindex="10" type="file" />
</label>
</p>
<p>
</p>
<?php 
if(isset($_SESSION['errMessage']))
{
echo("<div id=\"login_error\"><strong>ERROR</strong>:<br />");
echo($_SESSION['errMessage']); unset($_SESSION['errMessage']); 
echo("</div>");
}
?>
<p class="submit">
<input name="upload" id="submit" class="button-primary" value="Upload File" tabindex="100" type="submit">
</p>
</form>
</div>
</body>
</html>


My Upload Class looks liks:

<?php

// TO DO : ERROR HANDLING // AJAX INTERFACING
 
 
 
session_start();
define('PITCHFORK', true);


class Upload {

// The path to local (relivent to the user uploading - on their computer) file
var $file;

public function doAudio($file)
{

$target_path = $_SESSION['USERS_Media_Folder']."/"; // Set at login in class.users.php
$flag = 0; // Safety net, if this gets to 1 at any point in the process, we don't upload.

$filename = $_FILES[$file]['name'];
$filesize = $_FILES[$file]['size'];
$mimetype = $_FILES[$file]['type'];

$filename = htmlentities($filename);
$filesize = htmlentities($filesize);
$mimetype = htmlentities($mimetype);

$target_path = $target_path . basename( $filename );

if($filename != ""){

echo "Beginning upload process for file named: ".$filename."<br>";
echo "Filesize: ".$filesize."<br>";
echo "Type: ".$mimetype."<br><br>";

}



//First generate a MD5 hash of what the new file name will be
//Force a MP3 extention on the file we are uploading

$hashedfilename = md5_file($filename);
$hashedfilename = $hashedfilename.".mp3";



//Check for empty file
if($filename == ""){
$_SESSION['errMessage'] .= "No File Exists!";
$flag = $flag + 1;

}



//Now we check that the file doesn't already exist.
$existname = $target_path.$hashedfilename;



if(file_exists($existname))
{

if($flag == 0)
{
$_SESSION['errMessage'] .= "Your file already exists on the server!  
Please choose another file to upload or rename the file on your
computer and try uploading it again!";
}

$flag = $flag + 1;
}




//Whitelisted files - Only allow files with MP3 extention onto server...
$whitelist = array(".mp3");
foreach ($whitelist as $ending) 
{

if(substr($filename, -(strlen($ending))) != $ending) 
{
 $_SESSION['errMessage'] .= "The file type or extention you are trying to upload is not allowed!  
You can only upload MP3 files to the server!";
$flag++;
}
}




//Now we check the filesize.  If it is too big or too small then we reject it
//MP3 files should be at least 1MB and no more than 6.5 MB

if($filesize > 6920600)
{

//File is too large
if($flag == 0)
{
$_SESSION['errMessage'] .= "The file you are trying to upload is too large!  
Your file can be up to 6.5 MB in size only.  
Please upload a smaller MP3 file or encode your file with a lower bitrate.";
}

$flag = $flag + 1;
}


if($filesize < 1048600)
{
//File is too small

if($flag == 0)
{
$_SESSION['errMessage'] .= "The file you are trying to upload is too small!
Your file has been marked as suspicious because our system has
determined that it is too small to be a valid MP3 file.
Valid MP3 files must be bigger than 1 MB and smaller than 6.5 MB.";
}

$flag = $flag + 1;

}




//Check the mimetype of the file
if($mimetype != "audio/x-mp3" and $mimetype != "audio/mpeg")
{

if($flag == 0)
{
$_SESSION['errMessage'] .= "The file you are trying to upload does not contain expected data.
Are you sure that the file is an MP3?";
}

$flag = $flag + 1;
}

//Check that the file really is an MP3 file by reading the first few characters of the file
$f = @fopen($_FILES[$file]['tmp_name'],'r');
$s = @fread($f,3);
@fclose($f);
if($s != "ID3")
{

if($flag == 0){
$_SESSION['errMessage'] .= "The file you are attempting to upload does not appear to be a valid MP3 file.";
}

$flag++;
}



//All checks are done, actually move the file...
if($flag == 0)
{

if(move_uploaded_file($_FILES[$file]['tmp_name'], $target_path)) 
{

//Change the filename to MD5 hash and FORCE a MP3 extention.
if(@file_exists($target_path.$filename))
{

//Rename the file to an MD5 version
rename($target_path.$filename, $target_path.$hashedfilename);

echo "The file ".  basename( $filename ). "
  has been uploaded.  Your file is <a href='$target_path$hashedfilename'>here</a>.";
   
} else{
echo "There was an error uploading the file, please try again!";
}


} else {

echo "There was an error uploading the file, please try again!";
}

} else {
echo "File Upload Failed!<br>";

if($error != "")
{
echo $error;
}
}



} // Close function doAudio

} // Close Class audioUpload

?>

files that upload during insert/submit form was gone , only files upload during the update remain , is the way query for update multiple files is wrong ?

$targetDir1= "folder/pda-semakan/ic/";
if(isset($_FILES['ic'])){
     $fileName1 = $_FILES['ic']['name'];
 $targetFilePath1 = $targetDir1 . $fileName1;
 //$main_tmp2 = $_FILES['ic']['tmp_name'];
$move2 =move_uploaded_file($_FILES["ic"]["tmp_name"], $targetFilePath1);
}

$targetDir2= "folder/pda-semakan/sijil_lahir/";
if(isset($_FILES['sijilkelahiran'])){
     $fileName2 = $_FILES['sijilkelahiran']['name'];
 $targetFilePath2 = $targetDir2 . $fileName2;
$move3 =move_uploaded_file($_FILES["sijilkelahiran"]["tmp_name"], $targetFilePath2);
}

$targetDir3= "folder/pda-semakan/sijil_spm/";
if(isset($_FILES['sijilspm'])){
     $fileName3 = $_FILES['sijilspm']['name'];
 $targetFilePath3 = $targetDir3 . $fileName3;
$move4 =move_uploaded_file($_FILES["sijilspm"]["tmp_name"], $targetFilePath3);
}



$query1=("UPDATE semakan_dokumen set student_id='$noMatrik', email= '$stdEmail', surat_tawaran='$fileName', ic='$fileName1',sijil_lahir='$fileName2',sijil_spm= '$fileName3' where email= '$stdEmail'");