PHP从选项中发布十六进制值，并以字符串格式存储到mysql

Question

I need to store a hexadecimal value (values posted from my <options>) to my mysql database without transforming it (stay as is in string form) so that I can compare that value to my select options in string form. I've tried a lot of things, like base_convert(), (string), hex2bin(), but unfortunately. I don't know how to do this.

The image shows the stored value.

This is what I have done so far.

login.php:

$q = mysqli_query($con, "select * from users where email = '$email' and password = '$password'");
if (mysqli_num_rows($q) == 0)
{
$response['message'] = "Account not found.";
}
else
{
$_SESSION['user_currency'] = (string)$f['user_currency'];
}

dasboard.php:

<form id="form_setting_currency">
<select name="select_currency_symbol" class="form-control">
 <option value="&#x24;" <?php echo $_SESSION['user_currency'] == "&#x24;" ? "selected" : ""; ?> >&#x24; Dollar</option>
 <option value="&#xa2;" <?php echo $_SESSION['user_currency'] == "&#xa2;" ? "selected" : ""; ?> >&#xa2; Cent</option>
 <option value="&#xa3;" <?php echo $_SESSION['user_currency'] == "&#xa3;" ? "selected" : ""; ?> >&#xa3; Pound Sterling</option>
<option value="&#xa5;" <?php echo $_SESSION['user_currency'] == "&#xa5;" ? "selected" : ""; ?> >&#xa5; Yen</option>
</select>
</form>

SUBMIT_change_currency.php

<?php
include "includes/connection.php";
require_once("includes/encryption.class.php");

$response['success'] = false;
$response['message'] = "An error has occurred.";

if(isset($_POST['select_currency_symbol']) &&     trim($_POST['select_currency_symbol']) != "")
{

$currencyIcon = mysqli_real_escape_string($con,$_POST['select_currency_symbol']);
// $currencyIcon = mysqli_real_escape_string($con,hex2bin($_POST['select_currency_symbol']));
// $currencyIcon = mysqli_real_escape_string($con,(string)$_POST['select_currency_symbol']);

$query ="UPDATE users SET user_currency = '$currencyIcon' WHERE user_id =   $_SESSION[user_id]";
mysqli_query($con,$query);

if(mysqli_affected_rows($con)>0)
{
    $response['success'] = true;
    $response['message'] = "Successfully changed currency symbol.";
    $_SESSION['user_currency'] = (string)$currencyIcon;
}
else
{
    $response['message'] = "You have not made changes.";
}
}
die(json_encode($response));
?>      `

Answer 1

You need to print it with htmlspecialchars() in the value, so it becomes & amp;#x24