using mysql load data query as a raw laravel query

Hi im trying to use this query LOAD DATA INFILE 'c:/tmp/discounts.csv' INTO TABLE discounts FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS; in laravel as raw query but that line terminating character actually takes the query on new line and it does not work . $upload = DB::raw("LOAD DATA INFILE '$file' INTO TABLE '$request->tabl

tallaljamshed's avatar
tallaljamshed's avatar tallaljams...Eloquent
6

How do I move my images to s3 in production and in development let it stay locally?

I have read this thread, however I'm still not really sure how to handle this. Of course, I could set FILESYSTEM_DRIVER to s3, but this won't really work. Let me explain: If we upload a simple avatar file: request() ->file('avatar') ->store('avatars', 'public') The file is saved in the DB for example: avatars/R6ZGC9U0c22mKMcAADZbc8kJeU8soTvOuNFvnYgv.jpeg

shadrix's avatar
shadrix's avatar SinnbeckTips
1

Vue component not updating

Hi everyone, I'm currently trying to update my table with an excel sheet that the user will upload via an input file button. Im a using the SheetJS tool. The file is read correctly as the headers results give (the one on my excel file) 20) ["1", "2", "3", "4", "5", "6", "7", "8", "9", &quo

Alexb0903's avatar
Alexb0903's avatar Alexb0903Vue
5

ResumableJS Not user how to link html/js to the request or route

Followed the instructions for this plugin, got the links to the needed libraries. Used an example code for the upload. Have no idea how it links to the Route or Request. May someone please advise - also ignore my last post. HTML + JS <!doctype html> <html lang="{{ str_replace('_', '-', app()->getLocale()) }}"> <head> <meta charset=&

LadyDeathKZN's avatar
LadyDeathKZN's avatar Wandumi Si...Laravel
6

Yajra data table not working

I have got this error in yajra data table ````Class 'DataTables' not found"```. You can see it in attached link. http://prntscr.com/nfwqde http://prntscr.com/nfws84 This package is working fine on my local system but don't works on live server. I have followed following steps to upload it. override composer.json and composer.lock file with local files. upload yajra folder

gurvindersingh's avatar
gurvindersingh's avatar gurvinders...Laravel
2

MethodNotAllowedHttpException with Laravel5.4 when uploading files bigger than 1MB online, but it works perfectly on localhost

I'm using Laravel 5.4 for my website, and I'm getting a problem when the user tries to upload files bigger than 1MB. This problem doesn't appear on localhost. The error I get is nothing related to the file size, but it's a MethodNotAllowedHttpException in RouteCollection.php line 251. The method I'm using to upload the files is 'PUT'. I've tried the " $request->file('po

wbf's avatar
wbf's avatar wbfCode Review
34

stream_socket_sendto(): Broken pipe

I get an error when I upload a 14 MB file. it occurs at the time of request and does not allow me to take any action. I am changing php.ini settings in index.php. Small files are loading, but stream_socket_sendto (): Broken pipe in large files. ini_set('file_uploads', 'On'); ini_set('upload_tmp_dir', '/tmp'); ini_set('upload_max_filesize', 24); ini_set('post_max_size', 32);

tanertombas's avatar
tanertombas's avatar tanertomba...Laravel
2

Changing CSV data into Correct Datatypes

I am currently working on my admin to make my life easier. My current goal is to upload a vendor's csv file, and based on what the vendor id is, I will have different logic to upload different products. My main question however, is how I can manipulate the data that comes from my csv file and convert the fields into the correct datatypes in order to store them in my database. H

Lordbedwetter's avatar
Lordbedwetter's avatar jlrdwGeneral
3

How can I create a folder for each registration on Amazon s3

I am using Amazon S3 to add files to it for my business registration system. Inside the store method I have the following: $input = $request->all(); $files = isset($input['file']) ? $input['file'] : array (); $business_names = json_decode($input['business_names'], true); $business_details = json_decode($input['business_details']); $share_amou

Melodia's avatar
Melodia's avatar MThomasLaravel
5

Pass CSRF Token with Fileinput plugin on delete url

Hi Everyone I am trying to use the Bootstrap File Input Plugin and upload and edit work fine. I am having trouble setting up the deleteUrl option for the plugin. When I click on the file delete icon I get unknown status error. The problem seems to be with CSRFToken so I have tried following solutions but none of them is working. //Attempt 1 $("#file-input").fileinput

bhavuksuthar's avatar
bhavuksuthar's avatar gabGeneral
3

Compiling user-generated assets on demand

Hi, I'm currently working on something which lets a theme be uploaded and then let a user customise aspects of that theme via a form. Right now the theme CSS files are being uploaded to S3 and served from a CDN. Certain variables are stored on a configuration page which then will post to a controller. From that I want to be able to take the user input and pass the values to th

CodeFox's avatar
CodeFox's avatar Laraveleph...Mix
2

form validation

Hi, either i put my code validation in controller or in form request , rules i put does not recognize type of file i'm trying to upload and display this message : --> The filename must be a file of type: image/jpg. here is my rule, simple : return [ 'filename' => 'required|mimetypes:image/jpg', ]; i also try with extension : mimes:jpg,jpeg,png ..... n

nine's avatar
nine's avatar nineLaravel
4

How to use Form Model Binding with related Data and Image on Edit Form

I am still at my Upcoming Event Function. i have now got an issue with the Edit Form. I use Form Model Binding, hope this is how it is called. It works well on my Events Table, pulls in the Data and displays it in my Form, but I do not get my related data. i thought to add the with('eventdates') but the dates are not added. I allow to add multiple Dates with a dynamic created i

Luka's avatar
Luka's avatar LukaLaravel
0

how to grop cuplicate raw data and print only one data row values in laravel 5.6

Hi, I am working on laravel 5.6 and I have multiple images in my uploads table with related to vehicle_id, as foreign key like this, uploads table id fileName vehicle_id 1 1.jpg 1 2 2.jpg 1 3 3.jpg 1 4 4.jpg 1 5 28.png

Msoft's avatar
Msoft's avatar MsoftLaravel
4

MIME detecting as not TXT, but it's TXT - Email Info Inside

I'm using Laravel validation for an uploaded file. The validation string looks something like this: 'file_upload' => 'required|file|max:50000|mimes:zip,csv,doc,docx,gif,jpe,jpeg,jpg,json,log,pdf,png,ppt,pptx,saz,txt,xls,xlsx,xml', When I upload almost any text file, this works great. However, when my text file contains information you might ordinarily find in a text file th

thc1967's avatar
thc1967's avatar thc1967Laravel
2

413 Request Entity too Large (Cloudflare)

I'm allowing large file uploads in my Laravel app, and am using Cloudflare. One of my customers told me today that they were unable to upload a 150 MB file and received a 413 Request Entity too Large error. I looked into this and it's actually coming from Cloudflare; they won't allow uploads greater than 100 MB unless you pay through the nose. Cloudflare suggests that I create

timgavin's avatar
timgavin's avatar timgavinLaravel
3

Queued job silently failing

We’re seeing some unexpected behaviour from queued jobs that take more than a few minutes to process. To explain our set up quickly, we’ve got Horizon running a couple of queues, and the majority of the jobs our system processes, mainly emails etc, are working fine. As far as I can tell there doesn’t seem to be any configuration issues. Some of the jobs are more complex; they u

mpbarlow's avatar
mpbarlow's avatar mpbarlowLaravel
0

Cannot display image from local storage

Hi. I can't for the life of me retrieve and display an image from local storage. It all worked using I've set up the simlink and its set to local in the config/filesystem. The files are saving to the correct place and when i right click the image, it is pointing to the correct place but it still shows 404 error. I've tried a handful of different locations including '/storage/ap

skoobi's avatar
skoobi's avatar biishmarLaravel
5

What changes need in UploadHandler class in blueimp jQuery-File-Upload ?

Dear Friends, I am trying to make use of the UploadHandler.php class as an App/Library file to make ajax upload. But I have not much idea in configuration details in constructor you can see my doubtful lines below public function __construct($options = null, $initialize = true, $error_messages = null) { $this->response = array(); $this->options = array( 'script_url' =>

insight's avatar
insight's avatar insightLaravel
0

Symbolic Link

Hello All, I have created a symbolic link for my storage folder so that I am able to see the images that I upload in a view file. Locally I have done the link and it works a treat, I upload a image and it shows in the storage folder and then in the public folder so that I am able to access the images in the view. I have uploaded my changes to my remote server and the link seem

mattnewark's avatar
mattnewark's avatar mattnewarkLaravel
6

Progress Bar with axios

I have to display the upload status of the file using a Progress Bar. I am using axios to make http requests. I followed the example from their github page https://github.com/mzabriskie/axios/blob/master/examples/upload/index.html My code looks like this: this.store().then(() => { var form = new FormData(); form.append('video', this.file); form.append('ui

pritam1605's avatar
pritam1605's avatar jplhomerVue
1

Forbidden acces (403)

This one is getting on my nerve. Laravel 5.3 project on hosting without ssh access. Host is set to look in ./public folder as web root. Site works fine. I have a part of the site dealing with upload. There is a file preview thing where you can see the image. Uploading is working, i can see the files being saved in the storage folder. Preview doesn't want to work. It wasn't real

Tirke's avatar
Tirke's avatar wmandaiServers
2

Problem of Request time out error

I am trying to upload a big csv file, and use laravel to read it and insert into database. however, if the operation time is longer than 60 s. the request will break, and at client side will receive 504 server time out error. I searched on line for the configuration of this part. it looks like i have to change multiple places, but i can not find exactly one in forge. If any hel

dihuang1986's avatar
dihuang1986's avatar dihuang198...Forge
1

Policy without passing through Model

I've been learning about Policies and implementing them into my application. I understand I do can thing like $user->can('update', $post); But what if I didn't want to pass through a model. Say I'm trying to find out if a user is allowed to upload an WAV audio file. In my app it's based on the users package $user->package so all I would want to do is $user->can('upload

wasimkham's avatar
wasimkham's avatar Matt.HLaravel
1

How to make a video uploaded by the user cross browser?

I am working on a Laravel app. Somewhere in the app users can upload videos and then this video will be hosted on the website. The users will only upload one type of file (mp4 or ogg etc.) How can I play this video in all browsers? Do I NEED to convert this file in the backend. But this really takes some time. Is there a better solution. How was Laracasts made? How are Jeffrey'

iamfaiz's avatar
iamfaiz's avatar ReachedGeneral
1

Using the Storage Feature vs placing images in public/img

I have some thumbnails and I don't know whether to place them public/img or use Laravel's storage API. I'm going to be using the Storage File system anyways to upload the thumbnails, but what should i do about displaying them? Should I write a function in the Model that copies the photo to public/img when it's needed? Should I not worry about having thousands of photos in publi

ElpsySec's avatar
ElpsySec's avatar ElpsySecGeneral
0

How does the .env.php has to look?

Hi, it's my first try with forge and I really are in trouble. I didn't get my database running. Always have errors like root@localhost not found... 1) Do I really have to add APP_ENV (=production) as Enviroment Variable? 2) Do I have to add an .env.php file myself? And then upload it via Bitbucket...? 3) How exactly does the .env.php file has to look like? Thanks Kay

kay899's avatar
kay899's avatar chrisgeary...Forge
4

Have two model events fire

This is how my current boot method looks: /**************** * BOOT *****************/ public static function boot() { parent::boot(); Post::saved(function($post) { // Upload media if( Input::get('gallery_exist') == 1 && ! is_null(Input::file('gallery')[0]) ) { foreach( Input::file('gallery') as $image ) {

peanut's avatar
peanut's avatar peanutRequests
4

How to upload all type of video file in laravel?

I want to upload all type of video file . i dont want like this mimetypes:video/mp4,video/webm,video/ogg i want like this mimetypes:video/all

haris javed 1996's avatar
haris javed 1996's avatar Sergiu17Laravel
1

Excel upload not getting to StudentImport file

I have this code in Laravel-8 using Maatwebsite package for Excel Upload: Import: namespace App\Imports; use App\Models\Student; use Maatwebsite\Excel\Concerns\ToModel; class StudentImport implements ToModel { public function model(array $row) { return new Student([ 'id' => rand(100000, 1000000), 'user_id' => $row[0],

noblemfd's avatar
noblemfd's avatar lorenzo-mi...General
1

Storage::makeDirectory() got "mkdir(): File exists" message after multiple upload files via Dropzone

I am creating a media library by using laravel and dropzone. When drag a folder to browser, it will send multiple requests to server. But the second request always throws "mkdir(): File exists" exception. (No problem for the first request and after the second request) For example: Request 1: fullPath: test folder/1.jpg folder_id: 1 file: (binary) Request 2: fullPath:

Wilsonk's avatar
Wilsonk's avatar WilsonkLaravel
0

Wrong file extension after AWS S3 upload

I am trying to upload APK files to AWS S3 Bucket but they are being saved as ZIP files. Laravel 5.6, PHP 7.1.16 This code worked before, but I wanted to change it because the issue of overwriting existing files: $path = $apkFile->storeAs('update-server', $apkFile->getClientOriginalName(), ['disk' => 's3', 'visibility' => 'public']); I tried this to upload it with a

Glennmen's avatar
Glennmen's avatar GlennmenLaravel
1

Won't upload new theme as zip file

Hi, It's my first time to use WordPress using forge. I already installed wordpress but the thing is when I upload a new theme .zip file, I notice that the upload is running but after that it says: This site can’t be reached The connection was reset. The zip file is from themeforest template. Any help would be much appreciated. Thanks!

claudios's avatar
claudios's avatar claudiosForge
0

Why does my image go in a temp file whenever I update my upload?

Whenever I update my image, it goes to some kind of temp file, and I don't know why. This is the exact output I get after updating my upload: http://test-ridemibo.c9users.io/storage/avatar//tmp/phpSqpSUe.jpg My controller: public function update(Request $request, User $user) { $user->update($request->all()); if($request->input('password')) { $us

Jake2315's avatar
Jake2315's avatar jekinneyCode Review
4

Filament power point upload

Hello all, I need to upload a ppt or pptx file via filament form. When I try I get this error -> the server responded with a status of 422 (Unprocessable Content) from the console and this one -> The data.path.efa77af1-cf26-4edd-8245-a74577b5976f failed to upload. from filament form. I try debugging, but laravel logs are clear and i dont have any restrictions as for the m

lilsOfi's avatar
lilsOfi's avatar lilsOfiFilament
3

Cannot upload to R2 via Laravel & S3 API?

Using Laravel 8 with Inertia and React.Js I am bassicly getting this error: Error executing "PutObject" on "https://hiddenforprivacy.cloudflarestorage.com/hiddenforprivacy/uploads/hiddenforprivacy.png"; AWS HTTP error: cURL error 35: error:14094410:SSL routines:ssl3_read_bytes:sslv3 alert handshake failure (see https://curl.haxx.se/libcurl/c/libcurl-errors.h

Luciano_Canziani's avatar
Luciano_Canziani's avatar Luciano_Ca...Laravel
1

Gracefully handle upload error due to filesize

I've inherited a project with media uploads, performed from a Vue component and axios post to send the form data. The problem is that when the file is below PHP's max upload size, but over the max: validation rule, I get a Laravel error message and a Http status that tells axios that an error occurred. However, when the filesize is above the max_upload, the webserver responds (

Snapey's avatar
Snapey's avatar SnapeyJavaScript
3

Upload multiple files - prevent to upload already uploaded files

Hello guys, hope you are okay, I ma facing some issue with my code <script setup> import {defineProps, onMounted, ref, watch} from 'vue'; import axios from 'axios'; import {ArrowUpOnSquareIcon, TrashIcon} from "@heroicons/vue/24/solid"; const emit = defineEmits(['pendingUploads']); let props = defineProps({ url: { type: String, Required: tr

gidaban79's avatar
gidaban79's avatar Tray2Vue
1

How to upload files from a URL?

I can upload files like this: Storage::putFileAs(config('media.path'), $file, $this->getFilename()); $file can either be a URL or UploadedFile. But when the $file is a URL, I fail to get some information from my $this->getFilename() method: public function getFilename() { return "{$this->getName()}.{$this->getExtension()}"; } pub

panthro's avatar
panthro's avatar s4muelLaravel
3

File Name Change Not Reflected in Downloaded File - Laravel Storage Issue

I have a Laravel application where users can upload files and change the file name. I'm encountering an issue where the changed file name is not reflected when downloading the file. some time when I download it I get failed no file found Here is the code public function saveNewDocumentName(Request $req, $id){ $filename = $req -> input('filename'); $fileID

Danny971's avatar
Danny971's avatar Danny971Laravel
4

Unable to retrieve the file_size for file at location

I'm trying to download a file previously uploaded to storage with: $path=$pdf->store('documents'); The upload step was ok. The file is present in my storage. But if i try to download it by: public function downloadFile() { return Storage::download(storage_path("app/".$this->pdf->{File::PATH})); } I receive this: League\Flysystem\UnableToRetrieve

viappio's avatar
viappio's avatar ZubyLaravel
9

Upload to Digital ocean spaces copies files to public folder

My method for uploading files to digital ocean spaces works perfectly but the files are uploaded both in project's public folder and spaces directory. I want to only upload files to digital ocean spaces and keep none in the project directory how can I go about this?? here is how my upload function looks like if ($file = $request->hasFile('display_image')) { $post

magero's avatar
magero's avatar mageroLaravel
3

Why does my file get the .bin extetion added to it when using s3 storage?

I'm creating a Vue component that uses the Uppy javascript library for uploading files. I'm Using s3 storage. The file time that I'm trying to upload is a 3d model file format .glb When the file gets uploaded and saved to the s3 bucket the file path that comes back has a .bin extension applied to it. How do I force the Storage::disk('s3')->put() to use the file extension fro

m615's avatar
m615's avatar m615Laravel
1

Spatie media library upload to Amazon s3 bucket subfolder

I am using spatie media library in Laravel with the below code to upload images to s3 bucket $file = $this->fileUploadModel ->addMediaFromDisk($file->path(), 's3') ->toMediaCollection(); The image is saved to s3 bucket on the format: my_bucket_name/1/image_name.png my_bucket_name/2/image_name.png etc However I want a way to store the ima

Fiton012's avatar
Fiton012's avatar SilenceBri...Code Review
1

Issue in file uploading with dropzone

Hi i am facing one issue in one of my clients application. We are having a dropzone where students upload their answers. But we have found most of the time dropzone crash itself, i have done my settings for timeout. But it break some time. And some time it works well. i want to know is there any other upload system which support larger file uploadings?

wontonesaju's avatar
wontonesaju's avatar wontonesaj...Laravel
0

How do I upload larger files to s3?

I have created a MediaAsset model and resource in my project for users so they can attach a asset to a particular product or page. I have the FileStorage configured to use my s3 bucket and all is working great. I get an error if the file is too large to upload. My users will need the ability to upload videos and images. Is there a way to configure the File::make field to use s3

m615's avatar
m615's avatar m615Nova
5

Livewire: submit uploaded file to another server

Hello, I have a livewire component that uses WithFileUploads trait. I want when the user submit the upload I resend this uploaded file to API endpoint. <div class="container mt-5"> <div class="row justify-content-center mt-5"> <div class="col-8 mt-4"> <form wire:submit.prevent="upload">

uniqueginun's avatar
uniqueginun's avatar uniqueginu...Livewire
3

Laravel and Vuejs Image Upload System

I have my image Upload Controller like this public function updateProfile(Request $request) { $user = auth('api')->user(); $this->validate($request,[ 'username' => 'required|string|max:255|unique:users,username,'.$user->id, 'name' => 'max:255', 'email' => 'required|string|email|max:255|unique:users,email

monstajamss's avatar
monstajamss's avatar monstajams...Laravel
0

Trying to upload an image using laravel and vuejs

I have my upload html form like this <div class="album_single_data settings_data"> <div class="album_single_img"> <figure class="thumbnail thumbnail-rounded"> <img class="main-profile" :src="getprofilepictu

monstajamss's avatar
monstajamss's avatar m7vm7vVue
3

Upload image from vue ( Please read me :( @bobbybouwmann )

I have a case where I have to upload image with some input file, let's say I want to post an article with the thumbnail required, so when I try to post image, it always fail, tbh, laravel always is the thumbnail should be required. this is my vue code. data() { return { post: { title: '', subject: '', body: '', thumbna

researchers_'s avatar
researchers_'s avatar yjuyjuyVue
2