使用存储在插件Wordpress中的选项中的Mysql数据

Question

I have a option page in my plugin and it is stored in table wp-options.

The option value is:

a:1:{s:9:"tablename";s:9:"Personeel";}

Now I just want to select Personeel from the option value, how do I accomplish this?

EDIT:

I have the following code now, but still doesn't work

mysqli_select_db($con,"ajax");
$sql1="SELECT option_value FROM wp_options WHERE option_name like 'fixformdata_options'";
$result1 = mysqli_query($con,$sql1);
$tablename = unserialize($result1);

$sql="SELECT * FROM ".$tablename[1]." WHERE personeelsNummer = '".$q."'";
$result2 = mysqli_query($con,$sql2);

Answer 1

try to use maybe_unserialize() function of wordpress.

$myoption =  get_option( 'fixformdata_options' );
$myoptionValue = maybe_unserialize( $myoption );    

$sql="SELECT * FROM ".$myoptionValue['tablename']." WHERE personeelsNummer = '".$q."'";
$result2 = mysqli_query($con,$sql2);