Fix specified key was too long issue in laravel

Go to the config/database.php update

'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',

1 2	'charset' => 'utf8', 'collation' => 'utf8_unicode_ci',

Posted in Laravel No comments November 17, 2022

Install Swagger in Laravel 9

Install and Configure Laravel with Passport

First we install and configure laravel app with passport then next we install the open api l5 swagger for api documentations.

Step 1: Install Laravel App

First create a new Laravel application using the following mentioned command.

composer create-project --prefer-dist laravel/laravel blog

1	composer create-project --prefer-dist laravel/laravel blog

Step your database credentials in your env file.

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=laravel9
DB_USERNAME=root
DB_PASSWORD=

...

1

2

3

4

5

6

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=laravel9

DB_USERNAME=root

DB_PASSWORD=

Posted in Laravel No comments July 15, 2022

Case-sensitive where statement in laravel

You'll need to use DB::raw(), perhaps something like

Invite::where(DB::raw('BINARY `token`'), $token)->first();

or alternatively:

Invite::whereRaw("BINARY `token`= ?",[$token])->first();

1

2

3

4

5

6

7

You'll need to use DB::raw(), perhaps something like

Invite::where(DB::raw('BINARY `token`'), $token)->first();

or alternatively:

Invite::whereRaw("BINARY `token`= ?",[$token])->first();

Posted in Laravel, Postgresql, Sql No comments September 7, 2021

Laravel 5 with Swagger (GET, POST, PUT, DELETE)

Swagger GET Example

/**
     * @SWG\Get(
     *   path="/api/testing/{mytest}",
     *   summary="Get Testing",
     *   operationId="testing",
     *   @SWG\Response(response=200, description="successful operation"),
     *   @SWG\Response(response=406, description="not acceptable"),
     *   @SWG\Response(response=500, description="internal server error"),
	 *		@SWG\Parameter(
     *          name="mytest",
     *          in="path",
     *          required=true, 
     *          type="string" 
     *      ),
     * )
     *
     */
	public function index(Request $request){
		echo $request->mytest;
	}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

/**

* @SWG\Get(

* path="/api/testing/{mytest}",

* summary="G...

Posted in Laravel, Php No comments March 25, 2021

Check Swagger Error

Run this command

php artisan l5-swagger:generate

1	php artisan l5-swagger:generate

Posted in Laravel No comments April 1, 2020

Integration Dropbox in PHP

Use this link https://www.dropbox.com/developers/documentation/http/documentation for documentation

Create a function for Curl call

function CurlCall($url,$method,$header,$fields){
			$curl = curl_init();
			curl_setopt_array($curl, array(
				CURLOPT_URL => $url,
				CURLOPT_RETURNTRANSFER => true,
				CURLOPT_ENCODING => "",
				CURLOPT_MAXREDIRS => 10,
				CURLOPT_TIMEOUT => 30000,
				CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
				CURLOPT_CUSTOMREQUEST => $method,
				CURLOPT_POSTFIELDS => $fields,
				CURLOPT_SSL_VERIFYHOST => 0,
				CURLOPT_SSL_VERIFYPEER => 0,
				CURLOPT_HTTPHEADER => $header,
			)); 
			
			 $response = curl_exec($curl);
			$err = curl_error($curl);
			
			curl_close($curl);
			
			if ($err) {
				return $err;
			...

Posted in Laravel, Php No comments March 17, 2020

Integration One Drive in PHP

Use this link https://docs.microsoft.com/en-us/onedrive/developer/rest-api/getting-started/graph-oauth?view=odsp-graph-online for documentation

creating a function for curl call

function CurlCall($url,$method,$header,$fields){
			$curl = curl_init();
			curl_setopt_array($curl, array(
				CURLOPT_URL => $url,
				CURLOPT_RETURNTRANSFER => true,
				CURLOPT_ENCODING => "",
				CURLOPT_MAXREDIRS => 10,
				CURLOPT_TIMEOUT => 30000,
				CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
				CURLOPT_CUSTOMREQUEST => $method,
				CURLOPT_POSTFIELDS => $fields,
				CURLOPT_SSL_VERIFYHOST => 0,
				CURLOPT_SSL_VERIFYPEER => 0,
				CURLOPT_HTTPHEADER => $header,
			)); 
			
			 $response = curl_exec($curl);
			$err = curl_error($curl);
			
			curl_close($cur...

Posted in Laravel, Php No comments March 11, 2020

Integration Google Drive in PHP

Install Google APIs Client Library for PHP
for more info check https://github.com/googleapis/google-api-php-client

composer require google/apiclient:"^2.0"

1	composer require google/apiclient:"^2.0"

Authentication

for laravel
$client = new \Google_Client();
$client->setClientId('client_id');
$client->setClientSecret('client_secret');
$client->addScope("https://www.googleapis.com/auth/drive.file");
$client->setRedirectUri('redirect_url');
// offline access will give you both an access and refresh token so that
		// your app can refresh the access token without user interaction...

Posted in Laravel, Php No comments March 5, 2020

SSL certificate problem: unable to get local issuer certificate

Download this file: http://curl.haxx.se/ca/cacert.pem
Place this file in the C:\wamp64\bin\php\php7.1.9 folder
Open php.iniand find this line:

;curl.cainfo

Change it to:

curl.cainfo = "C:\wamp64\bin\php\php7.1.9\cacert.pem"

Make sure you remove the semicolon at the beginning of the line.

Save changes to php.ini, restart WampServer, and you’re good to go!

Posted in Laravel, Php One comment March 4, 2020

If laravel url is not working on server

if laravel url is working like index.php/user but not working in /user

// run this command
sudo a2enmod rewrite

1 2	// run this command sudo a2enmod rewrite

Posted in Laravel, Linux No comments February 28, 2020

Recent Posts

Category Laravel