Import excel file to php myadmin through file uploading using php


Is it possible to upload excel file to my php myadmin. I know that all the field name of my phpmyadmin database table and my excel sheet table field should be same. But i am not finding the appropriate solution of this topic. The importing of my excel file code i am not finding out. And m confused in this.

Below is the code i tried out:

<form action="upload.php">
        <input type="file" name="txtFile" id="eskal"  /></br>
<input type="submit" name="Import" value="Update Database" /> </b>


$host="localhost"; // Host name.
$db='test'; // Database name.
$conn=mysql_connect($host,$db_user,$db_password) or die (mysql_error());
mysql_select_db($db) or die (mysql_error());

echo $filename=$_FILES["file"]["tmp_name"];
//echo $ext=substr($filename,strrpos($filename,"."),(strlen($filename)-strrpos($filename,".")));

 if($_FILES["file"]["size"] > 0)

  $file = fopen($filename, "r");
         while (($emapData = fgetcsv($file, 10000, ",")) !== FALSE)
            $sql = "INSERT into import(name,address,email,password) values('$emapData[0]','$emapData[1]')";
         echo "CSV File has been successfully Imported";
 echo "Invalid File:Please Upload CSV File";


I had mistaken in my upload.php code. So, if some one could help me with the code here.
Any kind of help is appreciated.
Thanks in advance

1 Like

Hello all,
I have found my solution. Now allz working perfectly fine. I am posting my full code.

<body style="
    background-color: rgb(128, 151, 185);

<form action="import_file.php" method="post"
            <input type="file" name="file" id="file">
        <td colspan="2" align="right">
            <input type="submit" name="submit" value="Submit">



if ($_FILES["file"]["error"] > 0)
    echo "Error: " . $_FILES["file"]["error"] . "<br>";
    echo "Upload: " . $_FILES["file"]["name"] . "<br>";
    echo "Type: " . $_FILES["file"]["type"] . "<br>";
    echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br>";
    //echo "Stored in: " . $_FILES["file"]["tmp_name"];
	//echo $a;
	$connect = mysql_connect('localhost','root','');
if (!$connect) {
die('Could not connect to MySQL: ' . mysql_error());
//your database name
$cid =mysql_select_db('test',$connect);

// path where your CSV file is located
//<!-- C:\\xampp\\htdocs -->
// Name of your CSV file
$csv_file = $a;

if (($getfile = fopen($csv_file, "r")) !== FALSE) {
         $data = fgetcsv($getfile, 1000, ",");
   while (($data = fgetcsv($getfile, 1000, ",")) !== FALSE) {
     //$num = count($data);
	   //echo $num;
        //for ($c=0; $c < $num; $c++) {
            $result = $data;
        	$str = implode(",", $result);
        	$slice = explode(",", $str);

            $col1 = $slice[0];
            $col2 = $slice[1];
            $col3 = $slice[2];
			 $col4 = $slice[3];

$query = "INSERT INTO persons(id, name, email ,contacts) VALUES('".$col1."','".$col2."','".$col3."','".$col4."')";
$s=mysql_query($query, $connect );
echo "<script>alert('Record successfully uploaded.');window.location.href='edit_table.php';</script>";
//echo "File data successfully imported to database!!";

The above is the full working code.
Thanks your rply guys.

1 Like