Форум программистов [Powered by Invision Power Board]

Код

$mysqli = new mysqli("localhost", "root", "********", "*******");

if(!empty($_FILES))
{    
    function donwload($params)
    {
        $mysqli = new mysqli("localhost",  "********", "*******");
        
        $path = 'download_file/contractor/2016/21/' . uniqid('file_');

        if(move_uploaded_file($_FILES["filename"]["tmp_name"][$params['key']], $path))
        {
            $fileParams = array(
                'type'      => $_FILES["filename"]["type"][$params['key']],
                'name'      => $_FILES["filename"]["name"][$params['key']],
                'path'      => $path,
                'idBase'    => 2,
                'id_record' => $params['id'],
                'date_load' => date('Y-m-d H:i'),
                'removed'   => 0, 
            );
            
            $result[2] = $mysqli->query("SELECT * FROM  `attach` WHERE `id_record` = '" . $params['id'] . "' AND `name` = '" . $params['name'] . "'");  
           
            if($result[2]->num_rows == 0)
            {
                $result[0] = $mysqli->query("INSERT INTO `attach`(`type`,`name`,`path`,`idBase`,`id_record`,`date_load`,`removed`) VALUES ('" . $fileParams['type'] . "','" . $fileParams['name'] . "','" . $fileParams['path'] . "','" . $fileParams['idBase'] . "','" . $fileParams['id_record'] . "','" . $fileParams['date_load'] . "','" . $fileParams['removed'] . "')");
                
                if($result[0])
                {
                    $_SESSION['result'][] = array($fileParams['id_record'],$fileParams['name'],'<span style="color:#008000; font-weight: bold;">Файл успешно загружен в базу</span>');
                    
                    $mysqli->query("UPDATE `contractor` SET `attach` = '1' WHERE `id` = '".$fileParams['id_record']."'");
                }
            }
            else 
            {
                $_SESSION['result'][] = array($fileParams['id_record'],$fileParams['name'],'<span style="color:#CC6600; font-weight: bold;">Такой файл уже существует в базе</span>');
            }
        }
        else
        {
            $_SESSION['result'][] = array($params['key'],$_FILES["filename"]["name"][$params['key']],'<span style="color:#b70000; font-weight: bold;">Файл не загружен в базу</span>');
        }
        
        $mysqli->close();
    }    
    
    $result[1] = $mysqli->query("SELECT * FROM  `TABLE 10`"); 

    while ($row = $result[1]->fetch_assoc()) {

        if(strripos($row['COL 2'], ';'))
        {
            $array = explode(";", $row['COL 2']);
            
            foreach($_FILES['filename']['name'] as $key => $valfrom)
            {
                if(is_uploaded_file($_FILES["filename"]["tmp_name"][$key]))
                {
                    foreach($array as $valbase)
                    {                
                        if($valbase == $valfrom)
                        {
                            donwload(array('id' => $row['COL 1'], 'name' => $valbase, 'key' => $key));
                        }
                    }
                }              
            }
        }    
        else
        {  
            foreach($_FILES['filename']['name'] as $key => $value)
            {                
                if(is_uploaded_file($_FILES["filename"]["tmp_name"][$key]))
                {                     
                    if($row['COL 2'] == $_FILES['filename']['name'][$key])
                    {                        
                        donwload(array('id' => $row['COL 1'], 'name' => $row['COL 2'], 'key' => $key));
                    }                   
                }
            } 
        }        
    }
    
    echo '<pre>';
    print_r($_SESSION['result']);
    echo '</pre>'; 
}