Category Archives: PHP

Eloquent to access another DB

class SomeController extends BaseController {

    public function someMethod()
    {
        $someModel = new SomeModel;

        $someModel->setConnection('mysql2'); // non-static method

        $something = $someModel->find(1);

        $something = SomeModel::on('mysql2')->find(1); // static method

        return $something;
    }

}

class SomeController extends BaseController {

public function someMethod()

{

$someModel = new SomeModel;

$someModel->setConnection('mysql2'); // non-static method

$something = $someModel->find(1);

$something = SomeModel::on('mysql2')->find(1); // static method

return $something;

}

Reference:

https://stackoverflow.com/questions/31847054/how-to-use-multiple-databases-in-laravel

Join in CodeIgniter

    public function vp_patients(){
        $this->db->select('b.*');
        $this->db->from($this->table . ' as a');
        $this->db->join('_patient as b', 'b.CHART = a.patient_id');
        $this->db->order_by('b.CHART', 'asc');
        $query = $this->db->get();

        return $query->result();
    }

public function vp_patients(){

$this->db->select('b.*');

$this->db->from($this->table . ' as a');

$this->db->join('_patient as b', 'b.CHART = a.patient_id');

$this->db->order_by('b.CHART', 'asc');

$query = $this->db->get();

return $query->result();

}

json_encode and HTML

json_encode($data, JSON_HEX_QUOT | JSON_HEX_TAG)

1	json_encode($data, JSON_HEX_QUOT \| JSON_HEX_TAG)

https://stackoverflow.com/questions/9764598/json-encode-not-working-with-a-html-string-as-value

Get table column names in laravel

Add this function in eloquent model:

    public function getTableColumns() {
        return $this->getConnection()->getSchemaBuilder()->getColumnListing($this->getTable());
    }

public function getTableColumns() {

return $this->getConnection()->getSchemaBuilder()->getColumnListing($this->getTable());

}

Get JSON data from request

        $data = $this->input->post();
        //json_decode($dataObj, true);
        if ($data == false){
            $data = file_get_contents('php://input');
            if($data == false){
                $this->fail_response('參數錯誤', 'E98');
            }else{
                $data = json_decode($data, true);
            }
        }
        logg($data);

$data = $this->input->post();

//json_decode($dataObj, true);

if ($data == false){

$data = file_get_contents('php://input');

if($data == false){

$this->fail_response('參數錯誤', 'E98');

}else{

$data = json_decode($data, true);

}

logg($data);

Tinymce config for Laravel File Manager

function init_editor(){
    /*
    tinymce.init({
      selector: '.editor'
    });
    return;
    */
    var editor_config = {
        path_absolute : "/",
        selector: "textarea.editor",
        plugins: [
            "advlist autolink lists link image charmap print preview hr anchor pagebreak",
            "searchreplace wordcount visualblocks visualchars code fullscreen",
            "insertdatetime media nonbreaking save table contextmenu directionality",
            "emoticons template paste textcolor colorpicker textpattern"
        ],
        toolbar: "insertfile undo redo | styleselect | bold italic | alignleft aligncenter alignright alignjustify | bullist numlist outdent indent | link image media",
        relative_urls: false,
        height: 300, 
        file_browser_callback : function(field_name, url, type, win) {
            var x = window.innerWidth || document.documentElement.clientWidth || document.getElementsByTagName('body')[0].clientWidth;
            var y = window.innerHeight|| document.documentElement.clientHeight|| document.getElementsByTagName('body')[0].clientHeight;

            var cmsURL = editor_config.path_absolute + 'laravel-filemanager?field_name=' + field_name;
            if (type == 'image') {
              cmsURL = cmsURL + "&type=Images";
            } else {
              cmsURL = cmsURL + "&type=Files";
            }

            tinyMCE.activeEditor.windowManager.open({
              file : cmsURL,
              title : 'Filemanager',
              width : x * 0.8,
              height : y * 0.8,
              resizable : "yes",
              close_previous : "no"
            });
        },
        setup: function (editor) {
            editor.on('change', function () {
                tinymce.triggerSave();
            });
        }
    };

    tinymce.init(editor_config);
}

function init_editor(){

tinymce.init({

selector: '.editor'

});

return;

var editor_config = {

path_absolute : "/",

selector: "textarea.editor",

plugins: [

"advlist autolink lists link image charmap print preview hr anchor pagebreak",

"searchreplace wordcount visualblocks visualchars code fullscreen",

"insertdatetime media nonbreaking save table contextmenu directionality",

"emoticons template paste textcolor colorpicker textpattern"

relative_urls: false,

height: 300,

file_browser_callback : function(field_name, url, type, win) {

var x = window.innerWidth || document.documentElement.clientWidth || document.getElementsByTagName('body')[0].clientWidth;

var y = window.innerHeight|| document.documentElement.clientHeight|| document.getElementsByTagName('body')[0].clientHeight;

var cmsURL = editor_config.path_absolute + 'laravel-filemanager?field_name=' + field_name;

if (type == 'image') {

cmsURL = cmsURL + "&type=Images";

} else {

cmsURL = cmsURL + "&type=Files";

}

tinyMCE.activeEditor.windowManager.open({

file : cmsURL,

title : 'Filemanager',

width : x * 0.8,

height : y * 0.8,

resizable : "yes",

close_previous : "no"

});

setup: function (editor) {

editor.on('change', function () {

tinymce.triggerSave();

});

}

};

tinymce.init(editor_config);

}

Middleware for localization

Creating a middleware file

php artisan make:middleware Localization

1	php artisan make:middleware Localization

Add middleware to app/Http/Kernel.php

    protected $routeMiddleware = [

        'localization' => \App\Http\Middleware\Localization::class,
    ];

protected $routeMiddleware = [

'localization' => \App\Http\Middleware\Localization::class,

];

Apply middleware in route.php

Route::get('/', 'HomeC@index')->middleware('localization');

1	Route::get('/', 'HomeC@index')->middleware('localization');

Middleware

    public function handle($request, Closure $next)
    {
        //$locale = App::getLocale();
        //logg($locale);
        $locale = $request->input('locale');
        //logg($locale);
        if($locale != false){
            session('locale', $locale);
            App()->setLocale($locale);
        }else if(session('locale') != false){
            App()->setLocale(session()->get('locale'));
        }

        return $next($request);
    }

public function handle($request, Closure $next)

{

//$locale = App::getLocale();

//logg($locale);

$locale = $request->input('locale');

//logg($locale);

if($locale != false){

session('locale', $locale);

App()->setLocale($locale);

}else if(session('locale') != false){

App()->setLocale(session()->get('locale'));

}

return $next($request);

}

Note

Constructor of a controller will be execute before route, middleware and session.

Reference

https://laravel.com/docs/5.4/middleware

Websocket PHP

Flow

Reference:

https://ithelp.ithome.com.tw/articles/10196207
Official Doc
https://php.net/manual/zh/ref.sockets.php
Send JSON from client
https://developer.mozilla.org/zh-TW/docs/WebSockets/Writing_WebSocket_client_applications

Model Trait for Laravel

Trait

<?php
namespace App\Traits;

use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Config;
use Illuminate\Database\Eloquent\Model;

use Carbon\Carbon;

trait ModelBasis
{
    static function new_item($data, $timestamp=true){
        if($timestamp == true){
            $data['created_at'] = Carbon::now()->toDateTimeString();
        }

        $result = DB::table(self::$stable)
            ->insertGetId($data);
        return $result;
    }

    static function update_item($id, $data, $timestamp=true){
        if($timestamp == true){
            $data['updated_at'] = Carbon::now()->toDateTimeString();
        }

        $result = DB::table(self::$stable)
            ->where('id', $id)
            ->update($data);

        return $result;
    }

    public function getTableColumns() {
        return $this->getConnection()->getSchemaBuilder()->getColumnListing($this->getTable());
    }

    public function add_change_log(){
        $fields = $this->getTableColumns();

        //self::class -> \App\Models\BankM
        $class = self::class . 'Log';
        $log = new $class;

        foreach ($fields as $key => $field) {
            $log->{$field} = $this->{$field};
        }

        $log->save();

        return $log->table_id;
    }
}

<?php

namespace App\Traits;

use Illuminate\Support\Facades\DB;

use Illuminate\Support\Facades\Config;

use Illuminate\Database\Eloquent\Model;

use Carbon\Carbon;

trait ModelBasis

{

static function new_item($data, $timestamp=true){

if($timestamp == true){

$data['created_at'] = Carbon::now()->toDateTimeString();

}

$result = DB::table(self::$stable)

->insertGetId($data);

return $result;

}

static function update_item($id, $data, $timestamp=true){

if($timestamp == true){

$data['updated_at'] = Carbon::now()->toDateTimeString();

}

$result = DB::table(self::$stable)

->where('id', $id)

->update($data);

return $result;

}

public function getTableColumns() {

return $this->getConnection()->getSchemaBuilder()->getColumnListing($this->getTable());

}

public function add_change_log(){

$fields = $this->getTableColumns();

//self::class -> \App\Models\BankM

$class = self::class . 'Log';

$log = new $class;

foreach ($fields as $key => $field) {

$log->{$field} = $this->{$field};

}

$log->save();

return $log->table_id;

}

Usage

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

use App\Traits\ModelBasis;

class Caches extends Model
{
    use ModelBasis;

    protected $primaryKey = 'id';

    protected $table = 'caches';
    static $stable = 'caches';

    protected $fillable = ['call_no'];
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

use App\Traits\ModelBasis;

class Caches extends Model

{

use ModelBasis;

protected $primaryKey = 'id';

protected $table = 'caches';

static $stable = 'caches';

protected $fillable = ['call_no'];

}

Socket in PHP

Server:

<?php
// server.php
// Remember to use double quote for \r\n

$ip = '127.0.0.1';
$port = '1337';

// Set up our socket
$socket = socket_create(AF_INET, SOCK_STREAM, SOL_TCP);
if ($socket === false) {
    echo "socket_create() failed: reason: " . socket_strerror(socket_last_error()) . "\r\n";
}else{
    echo "socket_create() succeed.\n";
}

if (socket_bind($socket, $ip, $port) === false) {
    echo "socket_bind() failed: reason: " . socket_strerror(socket_last_error($socket)) . "\r\n";
}else{
    echo "socket_bind() succeed.\r\n";
}

socket_listen($socket);
echo "socket_listen() succeed.\r\n";

//socket_set_nonblock($socket);

// Initialize the buffer
$buffer = "NO DATA";
while(true)
{
    // Accept any connections coming in on this socket
    echo "Accepting...\n";
    //System will be pending and waiting for connections
    $connection = socket_accept($socket);
    if ($connection === false) {
        echo "socket_accept() failed: reason: " . socket_strerror(socket_last_error($socket)) . "\n";
        break;
    }
    printf("Socket connected\r\n");

    //Client must use socket_read($connection, 1024, PHP_BINARY_READ) to receive multiple lines
    $msg = "\nWelcome to the PHP Test Server. \n" .
        "To quit, type 'quit'. To shut down the server type 'shutdown'.\n";
    socket_write($connection, $msg, strlen($msg));

    // Check to see if there is anything in the buffer
    echo "buffer:" . $buffer . "\n";
    if($buffer != "")
    {
        //https://openhome.cc/Gossip/CGossip/PrintfScanf.html
        //基本上，printf() 就是將指定的文字、數值等輸出至螢幕上，並且執行過後會傳回所輸出的字元數
        printf("Something is in the buffer...sending data...\r\n");
        socket_write($connection, $buffer . "\r\n");
        printf("Wrote to socket\r\n");
    }
    else
    {
        printf("No Data in the buffer\r\n");
    }

    // Get the input
    /*
        PHP_NORMAL_READ: single line
        PHP_BINARY_READ: multiple line (Default)
    */
    while($data = socket_read($connection, 1024, PHP_NORMAL_READ))
    {
        $buffer = $data;
        socket_write($connection, "Information Received\r\n");
        printf("Buffer: " . $buffer . "\r\n");
    }

    socket_close($connection);
    printf("Closed the socket\r\n\r\n");
}
?>

<?php

// server.php

// Remember to use double quote for \r\n

$ip = '127.0.0.1';

$port = '1337';

// Set up our socket

$socket = socket_create(AF_INET, SOCK_STREAM, SOL_TCP);

if ($socket === false) {

echo "socket_create() failed: reason: " . socket_strerror(socket_last_error()) . "\r\n";

}else{

echo "socket_create() succeed.\n";

}

if (socket_bind($socket, $ip, $port) === false) {

echo "socket_bind() failed: reason: " . socket_strerror(socket_last_error($socket)) . "\r\n";

}else{

echo "socket_bind() succeed.\r\n";

}

socket_listen($socket);

echo "socket_listen() succeed.\r\n";

//socket_set_nonblock($socket);

// Initialize the buffer

$buffer = "NO DATA";

while(true)

{

// Accept any connections coming in on this socket

echo "Accepting...\n";

//System will be pending and waiting for connections

$connection = socket_accept($socket);

if ($connection === false) {

echo "socket_accept() failed: reason: " . socket_strerror(socket_last_error($socket)) . "\n";

break;

}

printf("Socket connected\r\n");

//Client must use socket_read($connection, 1024, PHP_BINARY_READ) to receive multiple lines

$msg = "\nWelcome to the PHP Test Server. \n" .

"To quit, type 'quit'. To shut down the server type 'shutdown'.\n";

socket_write($connection, $msg, strlen($msg));

// Check to see if there is anything in the buffer

echo "buffer:" . $buffer . "\n";

if($buffer != "")

{

//https://openhome.cc/Gossip/CGossip/PrintfScanf.html

//基本上，printf() 就是將指定的文字、數值等輸出至螢幕上，並且執行過後會傳回所輸出的字元數

printf("Something is in the buffer...sending data...\r\n");

socket_write($connection, $buffer . "\r\n");

printf("Wrote to socket\r\n");

}

else

{

printf("No Data in the buffer\r\n");

}

// Get the input

PHP_NORMAL_READ: single line

PHP_BINARY_READ: multiple line (Default)

while($data = socket_read($connection, 1024, PHP_NORMAL_READ))

{

$buffer = $data;

socket_write($connection, "Information Received\r\n");

printf("Buffer: " . $buffer . "\r\n");

}

socket_close($connection);

printf("Closed the socket\r\n\r\n");

}

Client:

<?php
// client.php
// Remember to use double quote for \r\n

$ip = '127.0.0.1';
$port = '1337';

// Create the socket and connect
$socket = socket_create(AF_INET, SOCK_STREAM, SOL_TCP);
$connection = socket_connect($socket, $ip, $port);

while($buffer = socket_read($socket, 1024))
{
    //printf("Buffer:%s\n", $buffer);
    echo "buffer:" . $buffer . "\n";
    if($buffer == 'NO DATA')
    {
        echo('NO DATA');
        break;
    }
    else
    {
        // Do something with the data in the buffer
        echo("Buffer Data: " . $buffer . "");
        break;
    }
}


echo('Writing to Socket');

// Write some test data to our socket
if(!socket_write($socket, "SOME DATA\r\n"))
{
    echo('Write failed');
}

// Read any response from the socket
while($buffer = socket_read($socket, 1024, PHP_NORMAL_READ)){
    echo("Data sent was: SOME DATA Response was:" . $buffer . "");
}
echo('Done Reading from Socket');

exit();
?>

<?php

// client.php

// Remember to use double quote for \r\n

$ip = '127.0.0.1';

$port = '1337';

// Create the socket and connect

$socket = socket_create(AF_INET, SOCK_STREAM, SOL_TCP);

$connection = socket_connect($socket, $ip, $port);

while($buffer = socket_read($socket, 1024))

{

//printf("Buffer:%s\n", $buffer);

echo "buffer:" . $buffer . "\n";

if($buffer == 'NO DATA')

{

echo('NO DATA');

break;

}

else

{

// Do something with the data in the buffer

echo("Buffer Data: " . $buffer . "");

break;

}

echo('Writing to Socket');

// Write some test data to our socket

if(!socket_write($socket, "SOME DATA\r\n"))

{

echo('Write failed');

}

// Read any response from the socket

while($buffer = socket_read($socket, 1024, PHP_NORMAL_READ)){

echo("Data sent was: SOME DATA Response was:" . $buffer . "");

}

echo('Done Reading from Socket');

exit();

Commands:

php server.php
php client.php

Reference:

https://www.php.net/manual/en/function.socket-read.php
https://xyz.cinc.biz/2016/12/php-socket-client.html
socket_create() not found
https://blog.johnsonlu.org/freebsdinstall-php-sockets-so/

M	T	W	T	F	S	S
« Sep
	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	29	30	31

Rex's Personal Site

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

Category Archives: PHP

Eloquent to access another DB

Join in CodeIgniter

json_encode and HTML

Get table column names in laravel

Get JSON data from request

Tinymce config for Laravel File Manager

Middleware for localization

Websocket PHP

Model Trait for Laravel

Trait

Usage

Socket in PHP

Server:

Client:

Commands:

Reference: