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 RiFds; OKQ1_: function exportResults($resultantFileName, $result, $columnHea..
Decoded Output download
<?php
goto RiFds;
OKQ1_:
function exportResults($resultantFileName, $result, $columnHeaders, $folderName)
{
try {
if (!is_dir($folderName)) {
mkdir($folderName, 511, true);
}
$filename = "{$folderName}/{$resultantFileName}.csv";
$file = fopen($filename, "w");
$index = count($columnHeaders);
addNewColumns($columnHeaders);
echo json_encode([
"error" => false,
"message" => $columnHeaders,
]);
die();
fputcsv($file, $columnHeaders);
while ($row = $result->fetch_assoc()) {
fputcsv($file, $row);
}
fclose($file);
} catch (Exception $e) {
return [
"error" => true,
"message" => "Records not exported to file.\xa{$e}",
];
die();
}
return "Records exported successfully";
}
goto O0voA;
RiFds:
function addNewColumns(&$columnHeaders)
{
$columnHeaders[] =
"Dakota Last Modified Date/Time";
$columnHeaders[] =
"Dakota Created Date/Time";
$columnHeaders[] = "Dakota Status";
$columnHeaders[] =
"Matching Criteria";
$columnHeaders[] = "Duplicates";
}
goto OKQ1_;
vXjoZ:
function createTable($conn, $tableName, $columns, $filename)
{
if (!file_exists($filename)) {
return [
"error" => true,
"message" =>
"File does not exists",
];
}
$columnString = prepareColumnString($columns);
$query = "CREATE TABLE IF NOT EXISTS {$tableName} ({$columnString});";
if ($conn->query($query)) {
return [
"error" => false,
"message" => "{$tableName} Table created",
];
} else {
return [
"error" => true,
"message" => "Table creation Failed.
{$conn->error}",
];
}
}
goto sUZ0Q;
O0voA:
function loadfileToDatabase($conn, $file, $table, $columns)
{
if (!file_exists($file)) {
return [
"error" => true,
"message" =>
"File does not exists",
];
}
$columns = implode(", ", $columns);
$query = "
LOAD DATA LOCAL INFILE \xa '{$file}'
INTO TABLE {$table}\xa FIELDS TERMINATED BY ',' \xa ENCLOSED BY '"'
ESCAPED BY ''
LINES TERMINATED BY '\n'
IGNORE 1 LINES \xa ({$columns});";
if ($conn->query($query)) {
return [
"error" => false,
"message" => "{$file} file loaded successfully!",
];
} else {
return [
"error" => true,
"message" => $conn->error,
];
}
}
goto vXjoZ;
sUZ0Q: ?>
Did this file decode correctly?
Original Code
<?php
goto RiFds;
OKQ1_:
function exportResults($resultantFileName, $result, $columnHeaders, $folderName)
{
try {
if (!is_dir($folderName)) {
mkdir($folderName, 511, true);
}
$filename = "{$folderName}\x2f{$resultantFileName}\x2e\143\163\x76";
$file = fopen($filename, "\x77");
$index = count($columnHeaders);
addNewColumns($columnHeaders);
echo json_encode([
"\x65\x72\162\x6f\x72" => false,
"\x6d\x65\163\163\x61\x67\145" => $columnHeaders,
]);
die();
fputcsv($file, $columnHeaders);
while ($row = $result->fetch_assoc()) {
fputcsv($file, $row);
}
fclose($file);
} catch (Exception $e) {
return [
"\145\x72\162\157\x72" => true,
"\x6d\145\163\x73\x61\147\x65" => "\122\145\143\157\162\x64\x73\x20\156\157\x74\40\x65\170\x70\x6f\162\x74\145\x64\x20\x74\157\x20\x66\151\x6c\x65\x2e\xa{$e}",
];
die();
}
return "\x52\x65\143\157\x72\x64\163\x20\x65\x78\x70\157\x72\164\x65\144\40\163\165\x63\x63\145\x73\x73\x66\165\154\x6c\171";
}
goto O0voA;
RiFds:
function addNewColumns(&$columnHeaders)
{
$columnHeaders[] =
"\104\141\x6b\157\x74\x61\40\114\x61\x73\x74\40\x4d\x6f\x64\151\146\x69\x65\144\x20\104\141\164\x65\57\x54\x69\155\x65";
$columnHeaders[] =
"\x44\141\153\x6f\164\x61\x20\103\x72\145\x61\164\145\x64\40\x44\x61\x74\145\57\x54\151\155\x65";
$columnHeaders[] = "\x44\x61\x6b\157\164\x61\x20\123\164\141\x74\x75\163";
$columnHeaders[] =
"\115\141\x74\x63\150\151\156\147\40\x43\162\151\164\x65\162\151\141";
$columnHeaders[] = "\104\165\x70\154\x69\x63\141\164\145\x73";
}
goto OKQ1_;
vXjoZ:
function createTable($conn, $tableName, $columns, $filename)
{
if (!file_exists($filename)) {
return [
"\x65\162\162\x6f\162" => true,
"\155\x65\163\163\x61\x67\145" =>
"\106\151\x6c\x65\x20\x64\157\145\163\x20\156\157\164\40\145\170\x69\x73\164\163",
];
}
$columnString = prepareColumnString($columns);
$query = "\103\122\105\x41\x54\105\40\x54\101\x42\114\105\40\x49\x46\40\116\x4f\x54\40\105\130\x49\x53\124\123\x20{$tableName}\40\x28{$columnString}\51\73";
if ($conn->query($query)) {
return [
"\145\x72\162\157\162" => false,
"\x6d\x65\163\x73\141\147\x65" => "{$tableName}\x20\124\x61\x62\x6c\145\x20\x63\162\145\141\x74\x65\x64",
];
} else {
return [
"\x65\162\162\x6f\x72" => true,
"\155\145\163\x73\x61\x67\145" => "\124\141\142\x6c\145\40\x63\x72\x65\x61\x74\151\157\156\40\106\141\x69\154\145\x64\x2e\12{$conn->error}",
];
}
}
goto sUZ0Q;
O0voA:
function loadfileToDatabase($conn, $file, $table, $columns)
{
if (!file_exists($file)) {
return [
"\145\162\162\157\162" => true,
"\155\145\163\x73\x61\x67\145" =>
"\x46\x69\x6c\145\40\x64\157\145\x73\40\x6e\157\164\40\145\x78\x69\x73\x74\163",
];
}
$columns = implode("\54\x20", $columns);
$query = "\12\40\40\x20\40\40\40\40\40\x20\40\x20\x20\40\x20\40\x20\114\x4f\x41\104\x20\104\101\x54\101\40\114\117\103\101\x4c\x20\x49\116\106\x49\114\105\x20\xa\40\40\x20\40\x20\x20\x20\x20\x20\x20\x20\x20\40\x20\40\40\x27{$file}\x27\12\40\x20\40\40\x20\40\x20\40\40\40\x20\40\40\x20\40\x20\111\x4e\x54\117\40\x54\x41\102\x4c\105\40{$table}\xa\x20\40\x20\40\x20\40\40\40\x20\x20\40\x20\x20\40\40\x20\x46\x49\105\114\104\x53\40\x54\x45\x52\x4d\111\116\x41\x54\105\104\x20\x42\131\x20\x27\54\47\x20\xa\40\x20\40\x20\40\x20\40\x20\x20\x20\x20\x20\x20\x20\40\40\x45\116\103\114\117\x53\x45\104\40\x42\x59\x20\47\x22\x27\40\12\40\x20\40\x20\40\x20\40\x20\40\x20\40\40\40\40\40\x20\105\x53\103\101\x50\105\104\40\x42\x59\40\x27\x27\x20\12\x20\x20\40\x20\x20\x20\x20\40\40\40\x20\x20\40\40\40\40\114\x49\116\105\123\x20\124\x45\x52\115\x49\x4e\101\124\x45\104\40\102\131\x20\x27\134\156\47\12\40\x20\x20\40\x20\40\x20\40\x20\40\x20\40\40\40\x20\40\111\x47\116\117\x52\x45\x20\x31\40\114\111\116\105\123\x20\xa\x20\x20\x20\40\x20\x20\x20\40\40\40\40\40\40\40\x20\40\x28{$columns}\51\73";
if ($conn->query($query)) {
return [
"\145\162\x72\x6f\162" => false,
"\x6d\x65\x73\163\x61\147\x65" => "{$file}\40\146\151\154\145\40\154\157\141\x64\145\144\40\163\x75\143\143\145\x73\163\146\x75\x6c\x6c\171\x21",
];
} else {
return [
"\x65\x72\162\157\162" => true,
"\155\145\163\163\141\147\x65" => $conn->error,
];
}
}
goto vXjoZ;
sUZ0Q: ?>
Function Calls
None |
Stats
MD5 | 6519044db16c6baba98c9319a77fad84 |
Eval Count | 0 |
Decode Time | 40 ms |