Category Archives: PHP

Phpspreadsheet memory issue

https://phpspreadsheet.readthedocs.io/en/develop/topics/memory_saving/

Redis is recommended.

Cache Issue (Download excel)

Problem

The excel file on server has changed but client still download the previous version.

Solutoin

php artisan cache:clear
Clear browser cache

urlencode for PHP and Javascript

urlencode() & rawurlencode()

PHP urlencode() use RFC 2396 and rawurlencode() use RFC 3986, the later should be the correct solution. BTW, the result of rawurlencode() and encodeURI() of javascript will be the same.

http_build_query

http_build_query use urlencode() by default, but could be changed by adding some more params:

http_build_query($params, null, '&', PHP_QUERY_RFC3986)

1	http_build_query($params, null, '&', PHP_QUERY_RFC3986)

Reference:

Symfony Setup

Installation

https://symfony.com/doc/2.7/setup.html

By Composer:

composer create-project symfony/framework-standard-edition D:\www\2019\symfony_test 2.4.1

1	composer create-project symfony/framework-standard-edition D:\www\2019\symfony_test 2.4.1

Start PHP server

php app/console server:run

1	php app/console server:run

Overwrite Laravel Helpers

To control http / https related URL generators, some helpers must be overwritten.

Add param in .env:

USE_HTTPS=true

1	USE_HTTPS=true

Find helper file:

\vendor\laravel\framework\src\Illuminate\Foundation\helpers.php

if (! function_exists('asset')) {
    /**
     * Generate an asset path for the application.
     *
     * @param  string  $path
     * @param  bool    $secure
     * @return string
     */
    function asset($path, $secure = null)
    {
        //logg(env('USE_HTTPS'));
        if(env('USE_HTTPS') == true){
            $secure = true;
        }
        return app('url')->asset($path, $secure);
    }
}

if (! function_exists('url')) {
    /**
     * Generate a url for the application.
     *
     * @param  string  $path
     * @param  mixed   $parameters
     * @param  bool    $secure
     * @return \Illuminate\Contracts\Routing\UrlGenerator|string
     */
    function url($path = null, $parameters = [], $secure = null)
    {
        if (is_null($path)) {
            return app(UrlGenerator::class);
        }

        if(env('USE_HTTPS') == true){
            $secure = true;
        }

        return app(UrlGenerator::class)->to($path, $parameters, $secure);
    }
}

if (! function_exists('route')) {
    /**
     * Generate the URL to a named route.
     *
     * @param  string  $name
     * @param  array   $parameters
     * @param  bool    $absolute
     * @return string
     */
    function route($name, $parameters = [], $absolute = true)
    {
        $url = app('url');

        if(env('USE_HTTPS') == true){
            $url->forceScheme('https');
        }
        
        return $url->route($name, $parameters, $absolute);
    }
}

if (! function_exists('asset')) {

/**

* Generate an asset path for the application.

* @param string $path

* @param bool $secure

* @return string

function asset($path, $secure = null)

{

//logg(env('USE_HTTPS'));

if(env('USE_HTTPS') == true){

$secure = true;

}

return app('url')->asset($path, $secure);

}

if (! function_exists('url')) {

/**

* Generate a url for the application.

* @param string $path

* @param mixed $parameters

* @param bool $secure

* @return \Illuminate\Contracts\Routing\UrlGenerator|string

function url($path = null, $parameters = [], $secure = null)

{

if (is_null($path)) {

return app(UrlGenerator::class);

}

if(env('USE_HTTPS') == true){

$secure = true;

}

return app(UrlGenerator::class)->to($path, $parameters, $secure);

}

if (! function_exists('route')) {

/**

* Generate the URL to a named route.

* @param string $name

* @param array $parameters

* @param bool $absolute

* @return string

function route($name, $parameters = [], $absolute = true)

{

$url = app('url');

if(env('USE_HTTPS') == true){

$url->forceScheme('https');

}

return $url->route($name, $parameters, $absolute);

}

Get env values using App

use Illuminate\Support\Facades\App;

echo App::environment();

use Illuminate\Support\Facades\App;

echo App::environment();

Output JSON

    protected function json_response($code=200, $message='', $data=null){
        http_response_code($code);
        //Output;
        header('Cache-Control: no-cache, must-revalidate');
        header('Content-type: application/json;charset=utf-8');

        $out = array(
            'code' => $code, 
            'message' => $message, 
            'data' => $data
        );
        echo json_encode($out);
        exit();
    }

protected function json_response($code=200, $message='', $data=null){

http_response_code($code);

//Output;

header('Cache-Control: no-cache, must-revalidate');

header('Content-type: application/json;charset=utf-8');

$out = array(

'code' => $code,

'message' => $message,

'data' => $data

);

echo json_encode($out);

exit();

}

Laravel redirect() issue

Issue:

If ELB pass 443 port to 80 port of the web server inside, and disable 80 port on ELB, redirect() will cause problem. Because redirect() always redirect pages to http and it will not display.

Following traditional way to redirect pages will cause session problem in laravel:

header('location:' . $url);

1	header('location:' . $url);

Solution:

Pass full URL to redirect() function instead of URI only.

//Works
return redirect(BASE_URL . 'admin/products');

//Fail
return redirect('admin/products');

//Works

return redirect(BASE_URL . 'admin/products');

//Fail

return redirect('admin/products');

How to set BASE_URL: (in app\Providers\AppServiceProvider.php)

    public function boot()
    {
        $base_url = secure_url('/');
        define('BASE_URL', $base_url . '/');
        define('ASSETS_FRONT', $base_url . '/assets/front/');
        define('ASSETS_ADMIN', $base_url . '/assets/admin/');
    }

public function boot()

{

$base_url = secure_url('/');

define('BASE_URL', $base_url . '/');

define('ASSETS_FRONT', $base_url . '/assets/front/');

define('ASSETS_ADMIN', $base_url . '/assets/admin/');

}

Suggestion:

Not to close 80 port on ELB.

Reference:

Add middleware to do https redirection: (Tried and not working)
https://stackoverflow.com/questions/28402726/laravel-5-redirect-to-https

cURL with basic authorization

    public static function curl($url){
        $username = self::$username;
        $password = self::$pw;

        $header = array();
        $header[] = "Authorization: Basic ".base64_encode($username.":".$password);
        $header[] = "Content-Type: application/json";
    
        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL,$url);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
        curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);

        $errors = curl_error($ch);
        //logg($errors);

        $data = curl_exec($ch);
        //logg($data);
        //$info = curl_getinfo($ch);
        curl_close ($ch);

        if($data == false){
            return false;
        }else{
            $data = json_decode($data);
            return $data;
        }
    }

public static function curl($url){

$username = self::$username;

$password = self::$pw;

$header = array();

$header[] = "Authorization: Basic ".base64_encode($username.":".$password);

$header[] = "Content-Type: application/json";

$ch = curl_init();

curl_setopt($ch, CURLOPT_URL,$url);

curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);

curl_setopt($ch, CURLOPT_HTTPHEADER, $header);

curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);

$errors = curl_error($ch);

//logg($errors);

$data = curl_exec($ch);

//logg($data);

//$info = curl_getinfo($ch);

curl_close ($ch);

if($data == false){

return false;

}else{

$data = json_decode($data);

return $data;

}

Crontab for Laravel (Scheduled Tasks)

#Example
* * * * * /usr/bin/php /home/ubuntu/hello/artisan schedule:run >> /dev/null 2>&1

1 2	#Example * * * * * /usr/bin/php /home/ubuntu/hello/artisan schedule:run >> /dev/null 2>&1

Reference:

Official Doc:
https://laravel.com/docs/5.4/scheduling

M	T	W	T	F	S	S
« Jan
				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28

Rex's Personal Site

This site is built on WordPress and contains personal notes, photos and videos

Category Archives: PHP

Phpspreadsheet memory issue

Cache Issue (Download excel)

Problem

Solutoin

urlencode for PHP and Javascript

urlencode() & rawurlencode()

http_build_query

Symfony Setup

Installation

Start PHP server

Overwrite Laravel Helpers

Get env values using App

Output JSON

Laravel redirect() issue

cURL with basic authorization

Crontab for Laravel (Scheduled Tasks)