chirag-shinde · October 23, 2015 13:09
diff --git a/uploadMethodOne.php b/uploadMethodOne.php
 <?php
 //Your Database Connection include file here.
 //This Entire PHP part can be placed in a seperate action file

            //Upload File
            if (isset($_POST['submit'])) {
                //Upload Directory path.
                $uploaddir = 'uploads/';
                //FilePath with File name.
                $uploadfile = $uploaddir . basename($_FILES["filename"]["name"]);
                    //Check if uploaded file is CSV and not any other format.
                    if (($_FILES["filename"]["type"] == "text/csv")){
                        //Move uploaded file to our Uploads folder.
                    if (move_uploaded_file($_FILES["filename"]["tmp_name"], $uploadfile)) {
                    echo "File Uploaded successfully";
                         }
                //Import uploaded file to Database
           
                $handle = fopen($uploadfile, "r"); //here "r" is used to give Read only permission.
                while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
                        $array = array(
                            "key1" => $data[0], //The key is the name of your key in collection.
                            "key2" => $data[1], // Just replace it with the keys in your collection
                            "key3" => $data[2] // And increment the data[i] as per the number of values or coloumns in the csv files.
                        );
                    //Finally insert the data into your collection!
                        $collection->insert($array);
                                    }
                        //close the file
                fclose($handle);
                echo "Import done";
                     
                       
                
                }
                else{
                    //echo incase user uploads a non-csv file.
                    echo "Upload a CSV file Only.";
                }
            }
 ?>
                        <!--Simple Form(no css) to Upload the File-->
 <html>
    <body>
         <form enctype='multipart/form-data' action='#' method='post'>
         File name to import:<br />

         <input size='50' type='file' name='filename'><br />

         <input type='submit' name='submit' value='Upload'></form>
    </body>
 </html>
	<?php
	//Your Database Connection include file here.
	//This Entire PHP part can be placed in a seperate action file

	//Upload File
	if (isset($_POST['submit'])) {
	//Upload Directory path.
	$uploaddir = 'uploads/';
	//FilePath with File name.
	$uploadfile = $uploaddir . basename($_FILES["filename"]["name"]);
	//Check if uploaded file is CSV and not any other format.
	if (($_FILES["filename"]["type"] == "text/csv")){
	//Move uploaded file to our Uploads folder.
	if (move_uploaded_file($_FILES["filename"]["tmp_name"], $uploadfile)) {
	echo "File Uploaded successfully";
	}
	//Import uploaded file to Database

	$handle = fopen($uploadfile, "r"); //here "r" is used to give Read only permission.
	while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
	$array = array(
	"key1" => $data[0], //The key is the name of your key in collection.
	"key2" => $data[1], // Just replace it with the keys in your collection
	"key3" => $data[2] // And increment the data[i] as per the number of values or coloumns in the csv files.
	);
	//Finally insert the data into your collection!
	$collection->insert($array);
	}
	//close the file
	fclose($handle);
	echo "Import done";



	}
	else{
	//echo incase user uploads a non-csv file.
	echo "Upload a CSV file Only.";
	}
	}
	?>
	<!--Simple Form(no css) to Upload the File-->
	<html>
	<body>
	<form enctype='multipart/form-data' action='#' method='post'>
	File name to import:<br />

	<input size='50' type='file' name='filename'><br />

	<input type='submit' name='submit' value='Upload'></form>
	</body>
	</html>