Find this useful? Enter your email to receive occasional updates for securing PHP code.
Signing you up...
Thank you for signing up!
PHP Decode
<?php goto Nt4Xc; jHxLW: $currentDate = date("\x59\x2d\155\55\x64"); goto fudD8; NJSi2: ..
Decoded Output download
<?php
goto Nt4Xc; jHxLW: $currentDate = date("Y-m-d"); goto fudD8; NJSi2: $response = array("selection" => json_decode($selectedRecordsJson, true)); goto t3Bp3; edpT0: $conn->close(); goto AxcN3; t3Bp3: header("Content-Type: application/json"); goto kIERQ; fudD8: $selectedRecordsJson = selectRecords($conn, $currentDate); goto NJSi2; Wr4VY: function updateRecords($conn, $currentDate) { $sql = "\xa UPDATE book\xa SET tStatus = 'rejected', remarks = 'Failed To Attend'
WHERE\xa DATE(dates) = '{$currentDate}'\xa AND tStatus = 'accepted'\xa AND CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(dates, ', ', -1), ' -', -1) AS TIME) < CAST('17:00:00' AS TIME);\xa "; $updated = $conn->query($sql); $updateResponse = array("success" => false, "title" => "Error Updating Records", "message" => "There was an error updating records: " . $conn->error, "icon" => "error", "data" => array()); if ($updated === TRUE) { $updateResponse["success"] = true; $updateResponse["title"] = "Records Updated"; $updateResponse["message"] = "Records have been updated successfully."; $updateResponse["icon"] = "success"; } return json_encode($updateResponse); } goto jHxLW; g2TS8: function selectRecords($conn, $currentDate) { $sql = "
SELECT *
FROM book
WHERE\xa DATE(dates) = '2023-09-13'
AND tStatus = 'accepted'
AND CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(dates, ', ', -1), ' -', -1) AS TIME) < CAST('17:00:00' AS TIME);
"; $result = $conn->query($sql); $response = array("success" => false, "title" => "No Records Found", "message" => "No records matching the criteria were found.", "icon" => "info", "data" => array()); if ($result->num_rows > 0) { $selectedRecords = array(); while ($row = $result->fetch_assoc()) { $selectedRecords[] = $row; } $response["success"] = true; $response["title"] = "Records Selected"; $response["message"] = "Records have been selected successfully."; $response["icon"] = "success"; $response["data"] = $selectedRecords; } return json_encode($response); } goto Wr4VY; kIERQ: echo json_encode($response); goto edpT0; Nt4Xc: session_start(); goto CzThy; CzThy: include "../server/connection.php"; goto g2TS8; AxcN3: ?>
Did this file decode correctly?
Original Code
<?php
goto Nt4Xc; jHxLW: $currentDate = date("\x59\x2d\155\55\x64"); goto fudD8; NJSi2: $response = array("\x73\145\x6c\145\143\x74\x69\x6f\x6e" => json_decode($selectedRecordsJson, true)); goto t3Bp3; edpT0: $conn->close(); goto AxcN3; t3Bp3: header("\x43\x6f\x6e\x74\145\156\x74\x2d\124\x79\x70\x65\x3a\40\141\x70\x70\154\x69\x63\141\x74\151\157\x6e\x2f\152\163\x6f\156"); goto kIERQ; fudD8: $selectedRecordsJson = selectRecords($conn, $currentDate); goto NJSi2; Wr4VY: function updateRecords($conn, $currentDate) { $sql = "\xa\40\x20\x20\x20\x55\x50\x44\101\x54\x45\40\x62\x6f\157\153\xa\x20\40\40\40\x53\x45\x54\x20\164\123\164\141\164\165\163\x20\x3d\40\47\162\x65\x6a\145\143\x74\x65\x64\x27\54\40\162\145\155\x61\x72\x6b\x73\x20\75\40\47\x46\141\x69\154\145\144\40\x54\x6f\x20\x41\164\x74\145\x6e\x64\x27\12\40\x20\x20\x20\x57\x48\x45\122\x45\xa\x20\40\40\x20\x20\40\x20\40\104\x41\124\105\x28\x64\141\x74\145\x73\x29\x20\x3d\40\x27{$currentDate}\47\xa\x20\x20\x20\x20\x20\x20\40\40\x41\116\104\x20\x74\x53\x74\141\x74\x75\x73\40\x3d\40\x27\x61\143\x63\x65\160\x74\145\144\47\xa\40\x20\40\40\x20\40\40\x20\x41\116\104\40\x43\101\x53\124\x28\x53\x55\x42\x53\x54\122\x49\x4e\x47\x5f\111\x4e\104\105\130\50\123\x55\x42\123\x54\x52\111\116\x47\137\111\x4e\104\x45\x58\50\x64\141\x74\145\x73\x2c\40\47\x2c\x20\47\54\40\55\61\x29\54\40\x27\40\55\x27\54\40\55\61\x29\x20\x41\x53\40\x54\111\x4d\x45\51\x20\x3c\x20\x43\101\x53\x54\50\x27\61\x37\72\x30\60\x3a\x30\x30\x27\40\x41\x53\x20\124\111\115\105\x29\73\xa\x20\x20\x20\40"; $updated = $conn->query($sql); $updateResponse = array("\x73\x75\x63\x63\145\163\x73" => false, "\164\x69\x74\154\145" => "\105\x72\162\x6f\x72\40\x55\160\144\141\164\x69\x6e\147\x20\x52\x65\143\x6f\162\x64\x73", "\155\145\163\163\x61\147\145" => "\124\x68\145\x72\x65\x20\167\x61\x73\40\x61\156\x20\x65\162\162\157\x72\40\x75\x70\144\x61\x74\151\x6e\x67\40\x72\145\143\x6f\x72\144\163\72\40" . $conn->error, "\151\143\x6f\x6e" => "\145\162\x72\157\162", "\x64\141\164\141" => array()); if ($updated === TRUE) { $updateResponse["\163\165\143\x63\x65\163\x73"] = true; $updateResponse["\164\x69\x74\154\x65"] = "\122\x65\143\157\x72\x64\163\40\x55\160\144\141\x74\145\x64"; $updateResponse["\155\145\163\163\141\147\x65"] = "\x52\x65\143\x6f\x72\x64\163\x20\150\141\x76\145\x20\x62\x65\145\x6e\40\165\160\144\x61\164\145\x64\40\x73\165\143\x63\145\163\163\146\x75\x6c\154\171\56"; $updateResponse["\x69\x63\157\x6e"] = "\163\165\x63\x63\x65\x73\x73"; } return json_encode($updateResponse); } goto jHxLW; g2TS8: function selectRecords($conn, $currentDate) { $sql = "\12\40\40\x20\40\x53\105\x4c\105\x43\x54\40\x2a\12\x20\40\40\x20\x46\122\117\115\x20\142\x6f\157\x6b\12\40\40\x20\40\x57\x48\105\122\x45\xa\x20\40\x20\40\x20\x20\40\x20\104\x41\x54\105\50\144\x61\164\145\163\x29\40\x3d\40\47\62\x30\x32\x33\55\x30\x39\x2d\x31\x33\x27\12\40\x20\40\x20\40\40\x20\40\101\116\x44\40\164\x53\164\x61\x74\165\x73\x20\75\40\x27\x61\143\143\145\x70\x74\145\x64\x27\12\40\x20\x20\x20\x20\40\x20\40\x41\x4e\104\40\x43\x41\123\x54\x28\123\125\102\123\124\122\111\116\107\x5f\x49\116\x44\105\130\50\123\125\102\x53\x54\x52\x49\x4e\107\137\111\116\x44\x45\130\50\144\x61\x74\x65\163\54\40\x27\54\40\x27\x2c\40\x2d\x31\x29\x2c\40\47\x20\x2d\47\54\x20\x2d\61\51\x20\x41\x53\40\x54\x49\115\x45\x29\40\x3c\40\x43\101\123\x54\x28\x27\61\67\x3a\60\x30\72\x30\x30\x27\x20\x41\123\40\124\111\x4d\x45\51\73\12\40\x20\40\x20"; $result = $conn->query($sql); $response = array("\163\165\143\x63\x65\x73\x73" => false, "\x74\151\164\x6c\145" => "\116\x6f\x20\x52\145\x63\157\162\144\163\x20\x46\157\x75\x6e\x64", "\x6d\x65\163\163\x61\147\x65" => "\116\157\x20\162\x65\x63\x6f\162\144\163\x20\155\141\164\143\150\151\156\147\40\x74\x68\145\40\143\x72\x69\164\145\162\x69\x61\x20\167\145\162\x65\40\x66\x6f\x75\x6e\144\x2e", "\151\143\157\x6e" => "\151\x6e\146\157", "\144\141\164\x61" => array()); if ($result->num_rows > 0) { $selectedRecords = array(); while ($row = $result->fetch_assoc()) { $selectedRecords[] = $row; } $response["\163\x75\143\143\145\x73\x73"] = true; $response["\164\151\164\154\x65"] = "\122\145\x63\x6f\162\x64\163\x20\x53\x65\x6c\x65\x63\x74\145\144"; $response["\155\x65\x73\163\x61\147\x65"] = "\122\145\143\x6f\162\x64\x73\x20\150\x61\166\145\x20\x62\145\145\156\x20\163\145\154\x65\x63\164\145\x64\40\163\165\143\143\x65\x73\x73\146\165\154\154\171\56"; $response["\x69\x63\x6f\x6e"] = "\163\165\143\143\x65\163\163"; $response["\x64\141\x74\141"] = $selectedRecords; } return json_encode($response); } goto Wr4VY; kIERQ: echo json_encode($response); goto edpT0; Nt4Xc: session_start(); goto CzThy; CzThy: include "\x2e\x2e\x2f\163\x65\x72\166\145\x72\57\x63\157\x6e\156\x65\143\x74\151\157\x6e\56\x70\x68\160"; goto g2TS8; AxcN3: ?>
Function Calls
None |
Stats
MD5 | 5f1e946ba9e22915bf82b6af7304ca06 |
Eval Count | 0 |
Decode Time | 71 ms |