rseon

I needed to call a routine with Laravel but I encountered the MySQL "Packets out of order" error. I've found an answer on this StackOverflow question : $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);

I have created a trait that can call a stored procedure and log it in Debugbar :

<?php

namespace App\Models\Traits;

Laravel cheatsheet

Original Eloquent attribute

When defining an accessor you can access to original value using this to skip mutator :

$model->getRawOriginal('name');

Get model table name

Deploy a Laravel project on your server

Create bash file

Only once on your server

Create a deploy.sh file at the root of your project :

#!/usr/bin/env bash

AdminPatterns

Pour vous aider dans la conception de vos formulaires ou affichage de configuration de module, il existe un controller caché AdminPatterns qui vous donne tous les champs possibles.

Il est accessible dans l'administration à l'adresse https://website.com/admin_xxxxxx/index.php?controller=AdminPatterns et le controller se trouve dans /controllers/admin/AdminPatternsController.php

Astuce PDF

Gagner du temps lors la personnalisation des fichiers pdf ( factures / livraisons … ) 👉 https://www.h-hennes.fr/blog/2020/07/13/prestashop-gagnez-du-temps-lors-la-personnalisation-des-fichiers-pdf-factures-livraisons/ (ce site est une mine d'or au passage)

	/**
	* Highlights a string in another.
	*
	* This methods wrap the portion of ${search} found in ${str} with a ${tag} with class ${className}.
	* If ${search} was not found, ${str} is returned
	*
	* @example highlightString('Hello World !', 'world') // "Hello <span class="highlight">World</span> !"
	* @example highlightString('Hello World !', 'foo') // "Hello World !"
	* @example highlightString('Hello World !', 'world', 'test', 'div') // "Hello <div class="test">World</div> !"
	*

	<?php
	namespace App\Models;

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

	class Company extends Model
	{
	/**
	* Table schema is :

	<?php

	/**
	* Search value through multi dimensional array by column key and return first found sub array or corresponding key.
	* This method preserves the original array keys.
	*
	* Multiple returns :
	* - The sub-array if value is found
	* - A mixed value corresponding to the key (if $onlyKey is set to true)
	* - false if an error occured or value is not found

	<?php

	/**
	* Wrapper to handle JSON errors and resolve UTF-8 errors
	*
	* @param mixed
	* @param int
	* @param int
	* @param bool
	* @return string\|false

	<?php

	/*
	* Display Laravel queries in PHP files (like the DebugBar but without view)
	*/


	/**
	* 1. Create the helper
	*/

	const object2url = require('./object2url')

	const testData = {
	name: "John",
	age: 13,
	skills: ['games', 'programming', 'reading', 'singing'],
	invests: {
	education: [120.3, 50.5],
	kids: 70,
	optical: {