Claro, el campo esta serializado.
Hago un unserialize y recupero la información.
Código PHP:
function getLepra(){
$db = new connexio();
$resultat = $db->query("SELECT * FROM wp_postmeta WHERE meta_key = '_ait-dir-item' and meta_value like '%fechaInicio%' and meta_value like '%fechaFinal%'");
$i = 0;
while ($fila3 = $resultat->fetch_array(MYSQLI_ASSOC)){
$dades = unserialize(utf8_encode($fila3['meta_value']));
$arr[$i][0] = $fila3['post_id'];
$arr[$i][1] = $dades['fechaInicio'];
$arr[$i][2] = $dades['fechaFinal'];
$i++;
}
$db->close();
return $arr;
}
Y me devuelve lo siguiente.
array(13) { [0]=> array(3) { [0]=> string(4) "8700" [1]=> string(0) "" [2]=> string(0) "" } [1]=> array(3) { [0]=> string(4) "8707" [1]=> string(0) "" [2]=> string(0) "" } [2]=> array(3) { [0]=> string(4) "8720" [1]=> string(0) "" [2]=> string(0) "" } [3]=> array(3) { [0]=> string(4) "8727" [1]=> string(0) "" [2]=> string(0) "" } [4]=> array(3) { [0]=> string(4) "8732" [1]=> string(10) "2014-06-06" [2]=> string(10) "2014-06-19" } [5]=> array(3) { [0]=> string(4) "8754" [1]=> NULL [2]=> NULL } [6]=> array(3) { [0]=> string(4) "8784" [1]=> string(0) "" [2]=> string(0) "" } [7]=> array(3) { [0]=> string(4) "8793" [1]=> string(0) "" [2]=> string(0) "" } [8]=> array(3) { [0]=> string(4) "8799" [1]=> string(0) "" [2]=> string(0) "" } [9]=> array(3) { [0]=> string(4) "8803" [1]=> string(10) "2014-06-06" [2]=> string(10) "2014-06-19" } [10]=> array(3) { [0]=> string(4) "8976" [1]=> string(0) "" [2]=> string(0) "" } [11]=> array(3) { [0]=> string(4) "9033" [1]=> string(0) "" [2]=> string(0) "" } [12]=> array(3) { [0]=> string(4) "9046" [1]=> string(0) "" [2]=> string(0) "" } }