Member Avatar for dgcerk369

I have a webmaster that got a problem converting excel to Msql and i want to help him along with a software or other solution that converts excel to msql database.

thanks

  • 2 Contributors
  • 1 Reply
  • 51 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by happytogether
Member Avatar for happytogether

NOTE: This is not my Original script, I just want to help you

<?
include 'connect.php';
$filename='temp.csv';
$handle = fopen("$filename", "r");
while (($data = fgetcsv($handle, 3000, ",")) !== FALSE)
{
$import="INSERT into inventory(tool_id,process,manufacturer,model,description) values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]');";
mysql_query($import) or die("mysql_error()");
print $import."<br>";
}
fclose($handle);
print "Import done";
?>
Edited by happytogether because: /
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.