[Solved] base64 encoded column want to decode using a xampp server what [closed]

by


If you’re using MySQL 5.6.1 or higher you can use the FROM_BASE64() function. You can write your query inside file like :

$query = mysqli_query($connection,"SELECT  testid, setno, qnid, FROM_BASE64(question) as question FROM `table_name`");

SQL Query 

SELECT testid, setno, qnid, FROM_BASE64(question) as question FROM `table_name`

Hope it will help you.

0

solved base64 encoded column want to decode using a xampp server what [closed]