Import Excel File Into MySQL

Bad Bee answered on April 11, 2023 Popularity 9/10 Helpfulness 2/10

answer Import Excel File Into MySQL

related Import Excel File Into MySQL

Import Excel File Into MySQL

Comment

// Database Structure 
CREATE TABLE 'employee' (
 'name' text NOT NULL,
 'age' text NOT NULL,
 'country' text NOT NULL,
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1

<?php
if(isset($_POST["submit_file"]))
{
 $file = $_FILES["file"]["tmp_name"];
 $file_open = fopen($file,"r");
 while(($csv = fgetcsv($file_open, 1000, ",")) !== false)
 {
  $name = $csv[0];
  $age = $csv[1];
  $country = $csv[2];
  mysql_query("INSERT INTO employee VALUES ('$name','$age','country')");
 }
}
?>

Popularity 9/10 Helpfulness 2/10 Language sql

Source: talkerscode.com

Tags: excel file import mysql sql

Link to this answer
Share Copy Link

Contributed on Apr 11 2023

Bad Bee

0 Answers Avg Quality 2/10

Closely Related Answers

Import Excel File Into MySQL

Comment

<html>
<body>
<div id="wrapper">
 <form method="post" action="import_file.php" enctype="multipart/form-data">
  <input type="file" name="file"/>
  <input type="submit" name="submit_file" value="Submit"/>
 </form>
</div>
</body>
</html>

Popularity 9/10 Helpfulness 1/10 Language whatever

Source: talkerscode.com

Tags: excel exce

Link to this answer
Share Copy Link

Contributed on Apr 11 2023

Bad Bee

0 Answers Avg Quality 2/10

Import Excel File Into MySQL

Contents

More Related Answers

Import Excel File Into MySQL

Closely Related Answers

Import Excel File Into MySQL

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.