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

Increase phpmyadmin import file size

Go to wamp64\alias\ edit phpmyadmin.conf file then update size

Alias /phpmyadmin "c:/wamp64/apps/phpmyadmin4.7.9/"

<Directory "c:/wamp64/apps/phpmyadmin4.7.9/">
	Options +Indexes +FollowSymLinks +MultiViews
  AllowOverride all
  <ifDefine APACHE24>
		Require local
	</ifDefine>
	<ifDefine !APACHE24>
		Order Deny,Allow
    Deny from all
    Allow from localhost ::1 127.0.0.1
	</ifDefine>

# To import big file you can increase values
  php_admin_value upload_max_filesize 800M
  php_admin_value post_max_size 800M
  php_admin_value max_execution_time 2800
  php_admin_value max_input_time 2800
</Directory>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

Alias /phpmyadmin "c:/wamp64/apps/phpmyadmin4.7.9/"

<Directory "c:/wamp64/a...

Posted in Php, Sql No comments December 17, 2019

Swagger with GET, POST and Multipart Upload file Example

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

class SwaggerController extends Controller
{
	
	/**
     * @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, 
	 *			description="testing data",
     *          type="string" 
     *      ),
     * )
     *
     */
	public function index(Request $request){
		echo $request->mytest;
	...

Posted in Laravel, Php No comments December 2, 2019

SSL certificate error: unable to get local issuer certificate in curl

Add These Two line

curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);

1 2	curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);

in Laravel open vendor\guzzlehttp\guzzle\src\Handler\CurlFactory.php
and change this

$conf[CURLOPT_SSL_VERIFYHOST] = 2;
$conf[CURLOPT_SSL_VERIFYPEER] = true;

1 2	$conf[CURLOPT_SSL_VERIFYHOST] = 2; $conf[CURLOPT_SSL_VERIFYPEER] = true;

to

$conf[CURLOPT_SSL_VERIFYHOST] = 0;
$conf[CURLOPT_SSL_VERIFYPEER] = FALSE;

1 2	$conf[CURLOPT_SSL_VERIFYHOST] = 0; $conf[CURLOPT_...

Posted in Laravel, Php No comments November 27, 2019

Create Dynamic URLs from Database, like wordpress

if you have a script called index.php that took a parameter called slug…

<?php
if (isset($_GET['slug'])) {
    $sql = "SELECT * FROM `your_table` WHERE slug = ? LIMIT 1";
    $smt = $pdo->prepare($sql);
    $smt->execute(array($_GET['slug']));
    $row = $smt->fetchObject();
    // do something with the matching record here...
}
else {
    // display home page
}

1

2

3

4

5

6

7

8

9

10

11

<?php

if (isset($_GET['slug'])) {

$sql = "SELECT * FROM `your_table` WHERE slug = ? LIMIT 1";

$smt = $pdo->prepare($sql);

$smt->execute(array($_GET['slug']));

$row = $smt->fetchObject();

// do something with the matching record here...

}

else {

// display home page

}

You could then re-write requests using ...

Posted in Php, Sql No comments January 28, 2019

Price Range Slider

Download

Posted in CSS, Jquery, Php, Wordpress No comments October 18, 2018

phpmyadmin not found

Create a link in /var/www like this:

sudo ln -s /usr/share/phpmyadmin /var/www/

Note: since 14.04 you may want to use /var/www/html/ instead of /var/www/

If that’s not working for you, you need to include PHPMyAdmin inside apache configuration.

Posted in Linux, Php No comments July 6, 2018

Modifying the PHP Configuration php.ini

Modifying the PHP Configuration

The php.ini file can be edited to change the settings and configuration of how PHP functions. This section gives a few common examples.

Sometimes a PHP application might need to allow for larger upload files such as uploading themes and plugins on a WordPress site. To allow larger uploads for your PHP application, edit the php.ini file with the following command (Change the path and file to match your Loaded Configuration File. This example shows the path for Apache on Ubuntu 14.04.):

1

sudo nano /etc/php5/apache2/php.ini

1

The default lines that control the file size upload are:

php.ini

...

Posted in Linux, Php No comments July 6, 2018

If Session is not working in VPS

The session support can be turned on automatically at the site level, or manually in each PHP page script: Turning on session support automatically at the site level we have to modify some setting in php.ini file. you can get php.ini file in folder you install PHP. To your sessions you have to set or reset following parameter in your php.ini file

Define path to save sessions
session.save_path = “C:\php\sessiondata\”

Directory related to server session should be under 777 chmod > fully writable

Whether to use cookies.
session.use_cookies = 1

Name of the session (used as cookie name).
session.name = PHPSESSID

Define Lifetime in seconds of cookie or, if 0, until browser is restarted.
session.cookie_lifetime = 0

;The path for which the cookie is valid.
session.cookie_path = /

The domain for w...

Posted in Php No comments January 8, 2018

Recent Posts

Category Php