1#@!#!123s

file_get_contents 1#@!#!123s
: / home / u247928417 / domains / ranafurnicos.com / public_html / admin / Excel /
Filename : del_2.php
back
<?php
include './config/config.php';
include 'Excel/reader.php';
include 'Excel/function.php';
if (isset($_REQUEST['uploadfile'])) {
// initialize reader object
    $data = new Spreadsheet_Excel_Reader();
    $file = $_FILES['file_excel']['name'];
    move_uploaded_file($_FILES['file_excel']['tmp_name'], "upload/" . $_FILES['file_excel']['name']);
    $data->read('upload/' . $_FILES['file_excel']['name']);
    $mxRows = $data->sheets[0]['numRows'];
    $mxCols = $data->sheets[0]['numCols'];
//echo " mxRows ".$mxRows." mxCols ".$mxCols."<br>";

    /*     * *******************************************READ XLS DATA START HERE************************************************* */
    for ($i = 3; $i <= $mxRows; $i++) {
        //$SERIAL = $data->sheets[0]['cells'][$i][1];
        /* --- PRODUCT INFOMATION */
        //$EAN_CODE = $data->sheets[0]['cells'][$i][2];
        $PRODUCT_NAME = $data->sheets[0]['cells'][$i][3];
        $PRODUCT_TYPE = $data->sheets[0]['cells'][$i][4];
        $PRODUCT_IMG = $data->sheets[0]['cells'][$i][5];
        $PRODUCT_STATUS = $data->sheets[0]['cells'][$i][6];
        $PRODUCT_S_DESC = $data->sheets[0]['cells'][$i][7];

        $PRODUCT_WEIGHT_1 = $data->sheets[0]['cells'][$i][8];
        $PRICE_1 = $data->sheets[0]['cells'][$i][9];
        
        $PRODUCT_WEIGHT_2 = $data->sheets[0]['cells'][$i][10];
        $PRICE_2 = $data->sheets[0]['cells'][$i][11];
        
        $PRODUCT_WEIGHT_3 = $data->sheets[0]['cells'][$i][12];
        $PRICE_3 = $data->sheets[0]['cells'][$i][13];
        
        $PRODUCT_WEIGHT_4 = $data->sheets[0]['cells'][$i][14];
        $PRICE_4 = $data->sheets[0]['cells'][$i][15];
        
        $PRODUCT_WEIGHT_5 = $data->sheets[0]['cells'][$i][16];
        $PRICE_5 = $data->sheets[0]['cells'][$i][17];
        
        $STOCK = $data->sheets[0]['cells'][$i][18];
        $BRAND_NAME = $data->sheets[0]['cells'][$i][19];
        $MANUFACTURE = $data->sheets[0]['cells'][$i][20];
        $CATEGORIE = $data->sheets[0]['cells'][$i][21];

        // function to insert data
        $return_value = insert_excel_data($PRODUCT_NAME, $PRODUCT_TYPE, $PRODUCT_IMG, $PRODUCT_STATUS, $PRODUCT_S_DESC, $PRODUCT_DESC, $PRICE_1, $PRICE_2, $PRICE_3, $PRICE_4, $PRICE_5, $PRODUCT_WEIGHT_1, $PRODUCT_WEIGHT_2, $PRODUCT_WEIGHT_3, $PRODUCT_WEIGHT_4, $PRODUCT_WEIGHT_5, $SPECIAL_PRICE_1, $SPECIAL_PRICE_2, $SPECIAL_PRICE_3, $SPECIAL_PRICE_4, $SPECIAL_PRICE_5, $TAX_CLASS, $META_TITLE, $META_KEYWORD, $META_DESC, $PRODUCT_QUANT, $STOCK, $BRAND_NAME, $MANUFACTURE, $CATEGORIE);
    }
    if ($return_value == TRUE) {
        $message = 'Data is uploaded successfully.';
    } else {
       $error_msg = 'Unable to upload data, Server issue.';
    }
    unlink('upload/' . $_FILES['file_excel']['name']);
    
    header("location: product");
    exit;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
    <script>
        function checkfile() {
            var file = document.getElementById("file_excel").value;
            if (file == '' && file == null) {
                alert('Please upload  xls file format only');
                document.getElementById("file_excel").focus();
                return false;
            }
            if (file != '')
            {
                var valid_extensions = /(.xls)$/i;
                if (!valid_extensions.test(file))
                        /*{ 
                         alert('OK');
                         }
                         else*/
                        {
                            alert('Please upload  xls file format only');
                            document.getElementById("file_excel").value = '';
                            document.getElementById("file_excel").focus();
                            return false;
                        }
            }
        }
    </script>
    <body>
        <table >
            <form method="post" action="" enctype="multipart/form-data" onsubmit="return checkfile();">
                <tr>
                    <td align="center">
                        <input type="file" required name="file_excel" id="file_excel" value="" />
                        <input style="width:100px;" type="submit" name="uploadfile" value="OK" />
                    </td>
                </tr>
            </form>
        </table>
    </body>
</html>