PHP - 帮我从数据库中的序列化值数组中获取值
问题描述:
This is my serialize values in my database when I tried fetching using PHP
$mylink = $wpdb->get_row( "SELECT * FROM wp_hlsq_signups WHERE user_email = 'john.r3@domain.com'" );
$metaData= $mylink->meta;
echo "<pre> $metaData</pre>";
This is the Output:
a:6:{
s:10:"first_name";s:4:"John";s:9:"last_name";s:6:"Ratina";s:9:"user_pass";s:34:"$P$B3EtpszNVkYJseassseaa2$swas";s:10:"user_email";s:14:"john.r3@domain.com";s:10:"user_login";s:6:"john-r";s:4:"role";s:10:"subscriber";
}
I just want to display John Ratina which is first_name
and last_name
in php, how it's possible?
当我尝试使用PHP获取时,这是我数据库中的序列化值 p>
$ mylink = $ wpdb-&gt; get_row(“SELECT * FROM wp_hlsq_signups WHERE user_email ='john.r3@domain.com'”);
$ metaData = $ mylink-&gt; meta;
echo“&lt; ; pre&gt; $ metaData&lt; / pre&gt;“;
code> pre>
这是输出: strong> p>
一个:6:{\ NS:10: “如first_name”; S:4: “约翰”; S:9: “姓氏”; S:6: “Ratina”; S:9: “user_pass”; S:34: “$ P $ $ B3EtpszNVkYJseassseaa2 SWAS”; S:10: “USER_EMAIL”; S:14: “john.r3@domain.com”; S:10: “USER_LOGIN”; S:6:“john- r:; s:4:“role”; s:10:“subscriber”;
}
code> pre>
我只想显示 John Ratina 在php中是 first_name code>和 last_name code>,它是如何实现的? p>
div>
答
$metaData= $mylink->meta;
$valData= unserialize($metaData);
echo $valData['first_name'];