*************

SQL code: Upload Copy Format Clear

create table ib_rules_conditions (id int, k varchar(10), v varchar(10), ruleId int); ALTER TABLE ib_rules_conditions ADD `hash` VARCHAR(255) GENERATED ALWAYS AS (MD5(CONCAT(k,IFNULL(v, '')))) STORED, ADD INDEX IDX_GROUP (ruleId, k, hash)

SQL Server: Preserve result

Result: Copy Clear

PHP code: Copy Format Clear

<?php $data = [ "MerchantOrderNo" => "8f086fe19ad6eddc", "Token" => "fb835c91f6f1885d", "WithdrawalAmount" => "7cf252fbbc47b271", "ByReceivableAmount" => "cfbb84bb884479f4", "BeneficiaryName" => "14f38f5514149a925149f2069070ea499eeb456340295fa17bcd4bda3d2092a6", "BeneficiaryAccountNumber" => "69f9b6f59da9a6c7ad7c8759145cb1ec", "BeneficiaryBank" => "a0bf4f014cbec5bd", "BeneficiaryBankCode" => "a0bf4f014cbec5bd", "BeneficiaryBankSwiftCode" => "c386fc6328bf94f576530ee22dea7a11"]; $secret = 'Ote3xsFC3hFA5eoqq64DcBhK'; $iv = substr($secret, 0, 8); $res = []; foreach ($data as $k => $v) { $res[$k] = (openssl_decrypt(hex2bin('8f086fe19ad6eddc'), 'DES-EDE3-CBC', $secret, OPENSSL_RAW_DATA, $iv)); } var_dump($res);

PHP version:

Show: Warnings Notice

Result: Copy Clear

PHPize Online / SQLize Online / SQLtest Online