[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 256
  • Last Modified:

uploads contents of csv but not excel

hello all
my code for csv works fine but when I try to upload excel, it doesn't work. How do I change it so I can upload excel files

Thanks
<?php 
 
 
require_once('connect_info.php');
// yourfile.csv must be in the same directory as this php file 
$handle = fopen ("upload8\\".$_SESSION['filename'],"r+"); 
 
while ($data = fgetcsv ($handle, 3000, ",")) { 
$atsign = "@no.mail"; 
$gtoken = mysql_real_escape_string ($data[0]);
 
$dedupe = mysql_query("select token from users where token = '".$gtoken."'") or die ("tokens not selected : " .mysql_error());
$derow = mysql_num_rows($dedupe);
if($derow == 0) { 
$query = "insert into users (token) values ('".$gtoken."')";
$result = mysql_query($query) or die("Invalid query: <BR>" . mysql_error().__LINE__ ."<BR>"."Source code ". __FILE__); 
}
 
echo "upload8\update.csv";
 
} 
 
echo "Tokens inserted"; 
//mysql_close($link); 
fclose ($handle); 
header("location: admin.php");
exit;
?>

Open in new window

0
syedasimmeesaq
Asked:
syedasimmeesaq
1 Solution
 
Ivo StoykovCommented:
Hello syedasimmeesaq

excel creates binary files, you probably know, and without creating and Excel object (or equivalent) you cannot treat it as text (csv) file.

if you mean csv created by Excel, it surround cell contents with double quotes (") when there are spaces in. You've to experiment saving one cell with different values and parse them with your script.

HTH

I
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now