theking2

function call_sp( \mysqli|\PDO $db, string $sp_name, ...$params ): string
{
        $placeholders   = array_fill( 0, count( $params ), "?" );
        $placeholders[] = "@__newid;

        $sql = "CALL $sp_name( " . implode( ", ", $placeholders ) . " );";

        try {
                LOG->debug( "calling Stored Procedure", [ "sql" => $sql ] );
                if( $db instanceof \mysqli ) {

theking2

/**
 * class Notifications asks for notification
 */
class NotificationAlert {
  constructor() {
    this.#askNotificationPermission();
  }
  /**
   * ask permissions for Notification, if not granted use alerts
   */

theking2

<?php declare(strict_types=1);

abstract class PluginName
{
  public function __construct()
  {
    $this->bootstrap();

  }
  private function bootstrap()

theking2

what	how
Search	([\s\r\n]*)array[\s\r\n]*\(([\s\r\n]*[^()\s](?:[^()]*[^()\s])?[\s\r\n]*)\)
Replace	$1[$2]

Perhaps repeat for nested arrays

theking2

<?php declare(strict_types=1);
define('NO_SESSION', true);
define('NO_AUTH', true);
require "../inc/config.inc.php";

function show_routine(string $type, string $name) {
  global $db;
  $query = "SHOW CREATE $type `$name`";
  $result = $db->query( $query );
  foreach( $result as $row ) {

theking2

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\Directory\shell\git-clone]
@="Clone here"

[HKEY_CLASSES_ROOT\Directory\shell\git-clone\command]
@="Powershell -NoProfile -Command \"Set-Location -LiteralPath '%V' ; git clone $(Get-Clipboard)\""

theking2

CREATE FUNCTION `BIN_TO_UUID`(b binary(16))
RETURNS char(36) CHARSET ascii
BEGIN
   DECLARE hexStr CHAR(32);
   SET hexStr = HEX(b);
   RETURN LOWER(CONCAT(
     SUBSTR(hexStr, 25, 12), '-',
     SUBSTR(hexStr, 21, 4), '-',
     SUBSTR(hexStr, 13, 4), '-',
     SUBSTR(hexStr, 17, 4), '-',

theking2

CREATE FUNCTION `UUID_TO_BIN`(uuid char(36))
RETURNS binary(16)
BEGIN
  RETURN UNHEX( CONCAT( 
    SUBSTRING(uuid, 25, 12),
    SUBSTRING(uuid, 20, 4),
    SUBSTRING(uuid, 15, 4),
    SUBSTRING(uuid, 10, 4),
    SUBSTRING(uuid,  1, 8)
  ));

theking2

| method | response code | reason  |
| -      | -             | -       |
| *      | 500           | internal error, the request is not processd, the response paylood might include more detail |
| *      | 502           | request validated but upstream service were not available. Request was not fullfilled|
| *      | 405           | request not validated or allowed |
| *      | 403           | the request validated but was not allwowed, reason in payload |

| HEAD   | 200           | success |
| POST   | 201           | rsourcce created,payload contains the id and a identifying url |
| POST   | 303           | resource is availabel unique url|

theking2

<?php
if( !defined( 'ROOT' ) ) {
  define( 'ROOT', $_SERVER[ 'DOCUMENT_ROOT'] . '/' );
}

if(!defined( 'SETTINGS_FILE' ) ) {
  define('SETTINGS_FILE', ROOT . 'settings.ini' );
}

if( !defined( 'SETTINGS') ) {