| 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
Johannes kingma theking2
🎯
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| $request = json_decode( file_get_contents( 'php://input' ) ); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| character_set_server=utf8mb4 | |
| collation_server=utf8mb4_unicode_520_ci |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 ) { |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * class Notifications asks for notification | |
| */ | |
| class NotificationAlert { | |
| constructor() { | |
| this.#askNotificationPermission(); | |
| } | |
| /** | |
| * ask permissions for Notification, if not granted use alerts | |
| */ |
theking2
/ plugin_class.php
Created
May 11, 2024 15:12
WordPress Bootstrap function to load actions and filters
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php declare(strict_types=1); | |
| abstract class PluginName | |
| { | |
| public function __construct() | |
| { | |
| $this->bootstrap(); | |
| } | |
| private function bootstrap() |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?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 ) { |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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)\"" | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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), '-', |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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) | |
| )); |