Marcus marcus-at-localhost

[MySQL] Permanently change SQL Mode in MySQL (disable_strict_mode)

Set into [mysqld] of MySQL config, for Ubuntu your could create a file /etc/mysql/conf.d/disable_strict_mode.cnf:

[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION

SQL mode example: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

let handle = function (event) {
  if(event.detail.elt.id !== 'formFilter'){
    return;
  }
  event.detail.path = event.detail.parameters['categories'];
  delete event.detail.parameters['categories'];
};

document.body.addEventListener("htmx:configRequest", handle);

Sans jQuery

Events

// jQuery
$(document).ready(function() {
  // code
})

Cheatsheet

on('click') Event

JSON Path with Alpine.js CSP build in Postman Visualizer

Query JSON Response with JSON Path

To work more easily with Postman JSON results, I implemented JSONPath in a Postman Visualizer, to query the results.

JSONPath is to JSON what XPath is to XML, and it helps to dig into large nested objects and get what you are looking for faster.

First I was using just a jQuery version that can be found in the examples and that worked just fine. (JSONpath Visualizer | Postman Team Collections | Postman API Network)

	<?php

	$csv = fopen('php://memory', 'r+');

	fputcsv($csv, ['a','b','c'], "\t");
	fputcsv($csv, ['a','b','c'], "\t");
	rewind($csv);
	$output = stream_get_contents($csv);

	// tab as string

	<?php

	namespace Kevinrob\GuzzleCache\Storage;

	use Kevinrob\GuzzleCache\CacheEntry;

	class KirbyCacheStorage implements CacheStorageInterface
	{

	/**

	<form>
	<input class="kb-field-2">
	<button class="kb-forms-submit">A</button>
	</form>

	<script>
	const field = document.getElementsByClassName('kb-field-2')[0];
	field.addEventListener("keyup", () => {
	let btn = document.getElementsByClassName('kb-forms-submit')[0];
	if( field.value === "" ) {

	// @see https://stackoverflow.com/a/31536517/814031
	const items = json3.items
	const replacer = (key, value) => value === null ? '' : value // specify how you want to handle null values here
	const header = Object.keys(items[0])
	const csv = [
	header.join(','), // header row first
	...items.map(row => header.map(fieldName => JSON.stringify(row[fieldName], replacer)).join(','))
	].join('\r\n')

	console.log(csv)

	<?php
	$blueprint = new Kirby\Cms\PageBlueprint(array_merge(['model' => $page], Kirby\Cms\Blueprint::load('pages/album')));
	dump($blueprint->section('images'));