decode a table in phpmyadmin before taking a backup
$30-250 USD
Completed
Posted almost 3 years ago
$30-250 USD
Paid on delivery
im looking to take backup of my database to use in new website but there is crypted column i want way to decrypt it before back up of mysql so i can use freely in the new website here is my encryption code
function __encode($unencoded,$key = 'i have the key'){
$string=base64_encode($unencoded);
$newstr = '';
$arr=array();
$x=0;
while ($x++< strlen($string)) {
$arr[$x-1] = md5(md5($key.$string[$x-1]).$key);
$newstr = $newstr.$arr[$x-1][3].$arr[$x-1][6].$arr[$x-1][1].$arr[$x-1][2];
}
return $newstr;
and here is my decryption code
function __decode($encoded, $key = 'i have the key'){
$strofsym="qwertyuiopasdfghjklzxcvbnm1234567890QWERTYUIOPASDFGHJKLZXCVBNM=";
$x=0;
while ($x++<= strlen($strofsym)-1) {
$tmp = md5(md5($key.$strofsym[$x-1]).$key);
$encoded = str_replace($tmp[3].$tmp[6].$tmp[1].$tmp[2], $strofsym[$x-1], $encoded);
}
return base64_decode($encoded);
}
i want way to decode the data in phpmyadmin beffor taking backup or software i can use on the backup to decrypt the data to use in the new site
Hello
Hope you are doing well.
I've hand on experience with the web development and designing. I'm supposed to look at the project like this for great work here.
If you think I'm able to do then we can discuss further
Thanks
Regards