DEV Community: asepher

Kinds of Mysql Error fix

asepher — Sun, 26 May 2024 09:51:30 +0000

Warning "unsaved changes" when switching database
https://github.com/phpmyadmin/phpmyadmin/issues/19000

https://www.aurodigo.com/how-to-solve-fatal-error-maximum-execution-time-of-300-seconds-exceeded-phpmyadmin-problem-in-xampp

https://community.apachefriends.org/f/viewtopic.php?t=82396&p=277705

Save File to Public or Storage Folder

asepher — Sat, 29 Jul 2023 22:47:09 +0000

First:
$path = public_path('pdf');
Second:
$path = storage_path('app/public/pdf/');

Command Save :
$pdf->save($path.$nmfile);

Insert Date Format to MySQL

asepher — Thu, 27 Jul 2023 19:15:35 +0000

public function TglSimpan($tglindo)
{
    //27-07-2023
    $tgl     =  substr($tglindo,0,2);
    $bln    =  substr($tglindo,3,2); 
    $thn     =  substr($tglindo,6,4); 
    return  $thn.'/'.$bln.'/'.$tgl;
}

rumus-vlookup-excel

asepher — Thu, 27 Jul 2023 04:25:30 +0000

Berikut adalah rumus VLOOKUP Excel dasar:
=VLOOKUP(lookup value; table array; col_index_num; [range_lookup])

Agar Moms tak bingung, berikut adalah arti dari masing-masing variabel di rumus tersebut:

Lookup value
Sel yang dijadikan patokan.

Table array
Tabel yang ingin diambil datanya.

Col_index_num
Urutan kolom di tabel yang ingin kamu ambil datanya.

Range_lookup
Sifat data yang ingin Moms cari (Akurat atau estimasi).

Pada kasus ini, kita ingin mengisi kolom gaji berdasarkan posisi dari masing-masing karyawan.

Jadi, di sini rumus yang digunakan adalah:

=VLOOKUP(C4;$F$4:$G$6;2;0)

Berikut adalah arti dari masing-masing variabel:

Lookup value (kotak orange)

Di sini, sel yang dijadikan patokan adalah C4. Karena kolom gaji diisi berdasarkan kolom posisi, dan sel teratas di kolom posisi adalah C4.

Table array (kotak biru)
Kita akan mengambil data nominal gaji dari kotak ini (sel F4:G6).

Nah, agar datanya tak berubah, Moms bisa klik tombol F4. Sehingga angkanya akan berubah jadi “$F$4:$G$6”.

Col_index_num
Di sini, kita memasukkan angka 2. Sebab, kolom gaji merupakan kolom kedua di kotak biru.

Range_lookup
Karena ini adalah contoh sederhana dari VLOOKUP Excel, kita bisa masukkan angka 0 saja.

Setelah itu, rumus VLOOKUP Excel akan mengambil data dari kotak biru secara otomatis dan mencocokkannya dengan informasi yang ada di sel C4.

Karena di sel C4 informasinya adalah Manager, jadi data yang ditampilkan adalah 10 juta.

https://www.orami.co.id/magazine/rumus-vlookup-excel

Limit string length in Controller

asepher — Wed, 26 Jul 2023 16:34:53 +0000

Str::limit($your_string, 50)

https://devdojo.com/

Laravel 10 Upload Image To Storage Folder Part 2

asepher — Wed, 26 Jul 2023 07:56:15 +0000

<?php

namespace App\Http\Controllers;

use App\Helper\ImageManager;
use App\Models\Image;
use Illuminate\Http\Request;
class TutorialController extends Controller
{

use ImageManager;
public function index()
{
return view('welcome');
}
public function store(Request $request)
{
$request->validate([
'image' => 'required|image|mimes:jpeg,png,jpg|max:2048',
]);
$path = storage_path('images/');
!is_dir($path) &&
mkdir($path, 0777, true);
if($file = $request->file('image')) {
$fileData = $this->uploads($file,$path);
Image::create([
'name' => $fileData['fileName'],
'type' => $fileData['fileType'],
'path' => $fileData['filePath'],
'size' => $fileData['fileSize']
]);
}
return redirect()
->back()
->with('success', 'Image successfully upload.');
}
}

app/Helper/ImageManager.php

namespace App\Helper;
use Illuminate\Support\Facades\File;
use Illuminate\Support\Facades\Storage;
trait ImageManager {
public function uploads($file, $path)
{
if($file) {
$fileName = time() . $file->getClientOriginalName();
Storage::disk('public')->put($path . $fileName, File::get($file));
$file_name = $file->getClientOriginalName();
$file_type = $file->getClientOriginalExtension();
$filePath = $path . $fileName;
return $file = [
'fileName' => $file_name,
'fileType' => $file_type,
'filePath' => $filePath,
'fileSize' => $this->fileSize($file)
];
}
}
public function fileSize($file, $precision = 2)
{

$size = $file->getSize();
if ( $size > 0 ) {
$size = (int) $size;
$base = log($size) / log(1024);
$suffixes = array(' bytes', ' KB', ' MB', ' GB', ' TB');
return round(pow(1024, $base - floor($base)), $precision) . $suffixes[floor($base)];
}
return $size;
}
}

https://www.laravelia.com/

Laravel File Upload

asepher — Wed, 26 Jul 2023 07:16:03 +0000

Validasi Image

Memeriksa File Upload
if($request->hasFile('foto')){
// ada file yang diupload
}else{
// tidak ada file yang diupload
}
Nama File Unik
$filenameWithExt = $request->file('foto’)->getClientOriginalName();
$filename = pathinfo($filenameWithExt, PATHINFO_FILENAME);
$extension = $request->file('foto’)->getClientOriginalExtension();
$filenameSimpan = $filename.'_'.time().’.'.$extension;

Generate Unique Random Numbers in Laravel

asepher — Wed, 26 Jul 2023 06:58:54 +0000

$data = [
'number' => ticket_number(),
'subject' => 'Sample subject',
'description' => 'This is the description sample'
];

$ticket = Ticket::create($data);

function ticket_number()
{
do {
$number = random_int(1000000, 9999999);
} while (Ticket::where("number", "=", $number)->first());
return $number;
}

https://codeanddeploy.com/

Creating a Storage Link on Shared Hosting

asepher — Tue, 25 Jul 2023 06:07:40 +0000

ln -s /home/u111xxxx/companyprofile/storage/app/public /home/u111xxxx/public_html/storage

thx to
https://codelapan.com/post/easy-ways-to-upload-or-deploy-laravel-project-to-shared-hosting

How to Generate Slug in Laravel

asepher — Tue, 25 Jul 2023 02:01:42 +0000

public function store(Request $request)
{
$post = new Post();
$post->title = $request->title;
$post->slug = \Str::slug($request->title);
$post->save();
}

Thanks to:
https://codelapan.com/post/how-to-generate-unique-slug-in-laravel-8

Get file name without extension in laravel

asepher — Mon, 24 Jul 2023 07:33:43 +0000

if ($request->hasfile('filename')) {
$image = $request->filename;
$namewithextension = $image->getClientOriginalName();
//Name with extension 'filename.jpg'
$name = explode('.', $namewithextension)[0];
// Filename 'filename'
$extension = $image->getClientOriginalExtension();
//Extension 'jpg'
$uploadname = time() . '.' . $extension;
$image->move(public_path() . '/uploads/', $uploadname);
}

Clear Cache at Share Hosting

asepher — Mon, 24 Jul 2023 06:24:24 +0000

//Clear Cache at Route:
Route::get('/route-cache', function() {
$exitCode = Artisan::call('route:cache');
return 'Routes cache cleared';
});

//Clear Cache at Config:
Route::get('/config-cache', function() {
$exitCode = Artisan::call('config:cache');
return 'Config cache cleared';
});

//Clear Cache at Application:
Route::get('/clear-cache', function() {
$exitCode = Artisan::call('cache:clear');
return 'Application cache cleared';
});
//Clear Cache at View:
Route::get('/view-clear', function() {
$exitCode = Artisan::call('view:clear');
return 'View cache cleared';
});

Thanks to https://bangagung.id/