Create Mysql Function

Category Laravel

Create Mysql Function

Directly run in sql

CREATE FUNCTION grade (grade_point INT)
            RETURNS VARCHAR(15)
            RETURN 
                CASE
                    WHEN grade_point >= 90 THEN "EXCELLENT"
                    WHEN grade_point >= 80 THEN "GOOD"
                END

CREATE FUNCTION grade (grade_point INT)

RETURNS VARCHAR(15)

RETURN

CASE

WHEN grade_point >= 90 THEN "EXCELLENT"

WHEN grade_point >= 80 THEN "GOOD"

END

Then use like

select grade (79)

1	select grade (79)

using in laravel

DB...

Posted in Laravel, Sql No comments October 3, 2019

There are few step

Step 1

Create FileUpload Model

php artisan make:model FileUpload

1	php artisan make:model FileUpload

Step 2

Create upload function

namespace App;

use File;
use Storage;
class FileUpload
{
	public static function photo($request,$fileName,$default="")
	{
		$name = "";
		$photo=$request->photo;
		if($request->hasFile($fileName))
		{
			$extension=$photo->getClientOriginalExtension();
			$name=rand(11111,99999).".".date('Y-m-d').".".time().".".$extension;
			Storage::disk('photo')->put($name,File::get($photo));
			$name = $name;
		}else{
			$name=$default;
		}
		return $name;
	}
}

2...

Posted in Laravel No comments April 21, 2018

Recent Posts

Category Laravel

Create Mysql Function

Directly run in sql

using in laravel

Upload files in Laravel 5.4

There are few step

Step 1

Step 2