Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require "../backends/theDBConn.php";
- $output = '';
- if(isset($_FILES['file']['name'][0]))
- {
- $fileName = $_FILES["file"]["tmp_name"];
- foreach($_FILES['file']['name'] as $key=>$val){
- $output .= $file_name = $_FILES['file']['name'][$key];
- $fileName = $_FILES["file"]["tmp_name"][$key];
- // get file extension
- // $ext = strtolower(pathinfo($file_name, PATHINFO_EXTENSION));
- // // get filename without extension
- // $filenamewithoutextension = pathinfo($file_name, PATHINFO_FILENAME);
- // if (!file_exists(getcwd(). '/uploads')) {
- // mkdir(getcwd(). '/uploads', 0777);
- // }
- // $filename_to_store = $filenamewithoutextension. '_' .uniqid(). '.' .$ext;
- // move_uploaded_file($_FILES['file']['tmp_name'][$key], getcwd(). '/uploads/'.$filename_to_store);
- $file = fopen($fileName, "r");
- while (($column = fgetcsv($file, 10000, ",")) !== FALSE) {
- // NEED
- $lengthArray[] = count($column);
- // $row ++;
- //
- // $sql = "INSERT into userinfo (phonenumber, name, bank_name,branch_name, account_no, date_registered, enabled, status)
- // values ('" . $column[0] . "','" . $column[1] . "','" . $column[2] . "','" . $column[3] . "','" . $column[4] . "','" . $column[5] . "','" . $column[6] . "','" . $column[7] . "')";
- $sql = "INSERT into userinfo (phonenumber,group_id,enabled)
- values ('" . $column[0] . "','1','1' );";
- // run($sql);
- // NEED
- $lengthArray = array_unique($lengthArray);
- if (count($lengthArray) == 1) {
- $response = array(
- "type" => "success",
- "message" => "File Validation Success."
- );
- $msg = "SUCCESS";
- } else {
- $response = array(
- "type" => "error",
- "message" => "Invalid CSV: Count mismatch."
- );
- $msg = "FAILED";
- }
- }
- // $output .= "<div>".$val."</div>";
- }
- }
- echo "File(s) uploaded successfully";
- echo $output;
- die;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement