Breaking News: Grepper is joining You.com. Read the official announcement!

excel file upload with other form data

hsn answered on August 31, 2022 Popularity 1/10 Helpfulness 1/10

answer excel file upload with other form data

excel file upload with other form data

Comment

//index.php
function add_words(user_id){
        
            var formdata = new FormData(document.getElementById("word_form"));
            formdata.append("user",user_id); 
            
            $.ajax({
                url: "../admin/metadata_ajax.php?type=102",
                type: "POST",
                data:  formdata,
                cache: false,
                processData: false,
                contentType: false,
                success: function(data){
                console.log(data);
                //alert(data);
                // if(data == 0){
                //     alert("Empty");
                // }else if(data == 1){
                //     alert("Added Successfully");
                //     //location.reload();
                // }else if(data == 2){
                //     alert("Error...!");
                // }
                  
              
                }

              });
            
        }  
        




//ajax.php
function importWordsFile()
{
    date_default_timezone_set("Asia/Karachi");
    $time = date("Y-m-d H:i:s");

    global $con_sen;
    $user = $_POST["user"];
    $w_pool_name = $_POST["pool_name"];
    $w_lang = $_POST["lang"];
    $w_type = $_POST["w_type"];
    $w_theme = $_POST["word_theme"];
    
    $allowedExts = array("xlsx","xls","csv");
    $temp = explode(".", $_FILES["w_excelFile"]["name"]);
    $extension = end($temp);
    $file = $_FILES["w_excelFile"]["name"];
    
    if(!in_array($extension, $allowedExts)) return ['status'=>'error','message'=>'File Type '.$extension.' not allowd'];
    if ($_FILES["w_excelFile"]["error"] > 0) return ['status'=>'error','message'=>"Return Code: " . $_FILES["excelFile"]["error"]];
    $directory = "uploads/";
    $filename = time().".".$extension;
    
    if(!move_uploaded_file($_FILES["w_excelFile"]["tmp_name"],$directory.$filename))
         return ['status'=>'error','message'=>'File Uploading failed in '.$directory.' directory'];

    include('excel_reader2.php');
    include('SpreadsheetReader.php');
    //Import any XLS, XLSX, CSV files by using these libraries.
    if(strtolower($extension) == 'csv') include('SpreadsheetReader_CSV.php');
    if(strtolower($extension) == 'xlsx') include('SpreadsheetReader_XLSX.php');

    $filePath = $directory.$filename;
    $htmlMessage = "Excel Sheets Started Initilized";
    $StartMem = memory_get_usage();

    $errors = [];
    try{
        $Reader = new SpreadsheetReader($filePath);
        $Sheets = $Reader->Sheets();
        $sheetCounts = count($Sheets);
        $htmlMessage .= 'Total Excel Sheets : '.$sheetCounts.'<br>';
        foreach ($Sheets as $Index => $Name)
        {
            $htmlMessage .= '*** Sheet '.$Name.' Started ***<br>';
            $Reader->ChangeSheet($Index);
            $i=0;
            foreach ($Reader as $Row)
            {
                $i++;
                if($i>0)
                {
                    $word = $Row[0];
                    
                    if(!empty($word)){

                    $isAdded = $con_sen->query("INSERT INTO words_list (w_value,w_pool_name,w_language,w_type,w_theme,added_on,added_by) VALUES ('$word','$w_pool_name','$w_lang','$w_type','$w_theme','$time','$user')"); 
                    
                    }
                
                if(!$isAdded) $errors[] = "Error During Insertion at Row No: ".$i." and Error is : " . $mysqli->error;  
                }      
            }
            $htmlMessage .= '*** Sheet '.$Name.' Ended ***<br>';
        }
       // $mysqli -> close();
            $htmlMessage .= '*** Sheet Imported Successfully ***<br>';
            if(!empty($errors)){
                $errorsText = implode(' <br> ',$errors);
                $htmlMessage .=$errorsText;
             return ['status'=>'waring','message'=>$htmlMessage];
            }
            return ['status'=>'success','message'=>$htmlMessage];
    }catch (Exception $e)
    {
        return ['status'=>'error','message'=>$e->getMessage()];
    }
}

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: Grepper

Tags: excel file-upload form-data whatever

Link to this answer
Share Copy Link

Contributed on Aug 31 2022

hsn

0 Answers Avg Quality 2/10

excel file upload with other form data

Contents

More Related Answers

excel file upload with other form data

Grepper

Documentation

Social

Legal

Contact

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