Cấu hình ckfinder thêm dữ liệu vào mysql

Bảng dữ liệu

CREATE TABLE `php_files` (
  `id` int(11) NOT NULL,
  `file_name` varchar(255) DEFAULT NULL,
  `file_path` text,
  `folder_path` text,
  `file_size` int(11) DEFAULT NULL,
  `file_type` varchar(255) DEFAULT NULL,
  `upload_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

****************************************************************************
****************************************************************************
****************************************************************************
//Lưu file khi tải lên 
//Cấu hình
//config in file ckfinder/config.php

Sau đoạn $config = array();
/*******Start Config insert mysql *******/

require_once dirname(__DIR__,3) . '/config.inc.php';
$config['mysql'] = $cfg;
$dbhost = $config['mysql']['server'];
$dbname = $config['mysql']['name'];
$connck = new PDO("mysql:host=$dbhost;dbname=$dbname",$config['mysql']['usr'], $config['mysql']['psw']);
$connck->exec("set names utf8mb4");
$config['mysql']['connck'] = $connck;

/*******End Config insert mysql *******/

///plugins/ckeditor/ckfinder/core/connector/php/vendor/cksource/ckfinder/src/CKSource/CKFinder/Command
//Thêm, xóa, đổi tên, và chỉnh sửa hình ảnh, quick upload//plugins/ckeditor/ckfinder/core/connector/php/vendor/cksource/ckfinder/src/CKSource/CKFinder/Command
//Start FileUpload.php đặt cuối file gần phần return

$file_name = $responseData['fileName'];
$file_path = $workingFolder->getFileUrl($responseData['fileName']);
$folder_path = $workingFolder->getPath();
$folder_name = $workingFolder->getClientCurrentFolder();
$file_size = $uploadedFile->getSize();
$file_type = $uploadedFile->getMimeType();

try{
    $connck = $config->get('mysql')['connck'];
    $stmt = $connck->prepare("INSERT INTO ".$config->get('mysql')['prefix']."files (file_name,file_path,folder_path,file_size,file_type) VALUES ('".$file_name."', '".$file_path."','".$folder_path."',".$file_size.",'".$file_type."')");
    $stmt->execute();
} catch (Exception $e) {
    echo 'Caught exception: ',  $e->getMessage(), "n";
}

//End FileUpload.php
****************************************************************************
****************************************************************************
****************************************************************************
***************************************************************************

DeleteFiles.php nàm sau  $errors = array_merge($errors, $deletedFile->getErrors());

Thêm thư viên cấu hình

use CKSourceCKFinderConfig; sau use CKSourceCKFinderAclPermission;

public function execute(Request $request, ResourceTypeFactory $resourceTypeFactory, Acl $acl, EventDispatcher $dispatcher)

Thây thế  bằng

public function execute(Request $request, ResourceTypeFactory $resourceTypeFactory, Acl $acl, EventDispatcher $dispatcher, Config $config)

try{
            $connck = $config->get('mysql')['connck'];
            foreach ($deletedFiles as $arr){
                $name = $arr['name'];
                $stmt = $connck->prepare("DELETE FROM ".$config->get('mysql')['prefix']."files WHERE file_name like '".$name."'");
                $stmt->execute();
            }
 } catch (Exception $e) {
             $data['error']['connck'] = 'Caught exception: '.$e->getMessage();
 }

SaveImage.php sau dòng  if (!$saveAsNew && $saved) {

if (!$saveAsNew && $saved) {
                $date = date('Y-m-d H:i:s');
                try{
                    $connck = $config->get('mysql')['connck'];
                    $stmt = $connck->prepare("UPDATE ".$config->get('mysql')['prefix']."files set upload_date='".$date."' WHERE file_name like '".$fileName."'");
                    $stmt->execute();
                } catch (Exception $e) {
                     $responseData['error']['connck'] = 'Caught exception: '.$e->getMessage();
                }
                $resourceType = $workingFolder->getResourceType();
                $thumbnailRepository->deleteThumbnails($resourceType, $workingFolder->getClientCurrentFolder(), $fileName);
                $resizedImageRepository->deleteResizedImages($resourceType, $workingFolder->getClientCurrentFolder(), $fileName);
            }else{
                $file_name = $fileName;
                $file_path = $workingFolder->getFileUrl($fileName);
                $folder_path = $workingFolder->getPath();
                $folder_name = $workingFolder->getClientCurrentFolder();
                $file_size = $imageInfo['size'];
                $file_type = $uploadedImage->getMimeType();
                try{
                    $connck = $config->get('mysql')['connck'];
                    $stmt = $connck->prepare("INSERT INTO ".$config->get('mysql')['prefix']."files (file_name,file_path,folder_path,file_size,file_type) VALUES ('".$file_name."', '".$file_path."','".$folder_path."',".$file_size.",'".$file_type."')");
                    $stmt->execute();
                } catch (Exception $e) {
                     $responseData['error']['connck'] = 'Caught exception: '.$e->getMessage();
                }
            }

Command.zip