Pulling data out from customfields

[MikaK]

I'm planning to show 1 event by memebrs at their public profile.

This should be the query:

PHP Code:

$query = "SELECT `eventid` , `userid` , `title` , `customfields` , `dateline_from`  
FROM `" . TABLE_PREFIX . "event`
WHERE userid = '$userinfo[userid]' 
ORDER BY `dateline_from` DESC
LIMIT 1"; 


In my case the customfields contains data regarding event type and location
like in the following example: a:2:{i:1;s:4:"Club";i:2;s:8:"Helsinki";}

What would be the best php code snippet for getting "Club" and "Helsinki" in displayed the final output?

Thanks for any insight.
-Mika

[Corsec]

That is the data you want. It is an array (as seen by the "a" at the start I think) with 2 objects (denoted by the 2 at the start I believe, Im not entirely sure the inner workings of serializing data).

You can do this:

$customArray = unserialize($row["customfields"]);

array(2) {
[1]=>
string(4) "Club"
[2]=>
string(8) "Helsinki"
}

[MikaK]

Originally Posted by Corsec

array(2) {
[1]=>
string(4) "Club"
[2]=>
string(8) "Helsinki"
}

Thanks, man! Glad to hear I'm getting there - even if by small steps Now... I still wonder how to formulate string (4) "Club" and string(8) "Helsinki" so it appears dynamically in the final output?

array(2) {
[1]=>
$bbinfo['calendarfield1']
[2]=>
$bbinfo['calendarfield2']
}

perhaps?


This is the code outlining also the problematic, still missing variables

PHP Code:

$limit_page1 = '1';    // Enter the number of maximum events you want to have displayed

$get_events = DB_site->query ("SELECT `eventid` , `userid` , `title` , `customfields` , `dateline_from`  
FROM `" . TABLE_PREFIX . "event`
WHERE userid = '$userinfo[userid]' 
ORDER BY `dateline_from` DESC
LIMIT $limit_page1");  

while($events = $DB_site->fetch_array($get_events))
    {
        exec_switch_bg();
        $events['date'] = vbdate($vboptions['dateformat'],$events['dateline_from']);
        // THE PROBLEM
        // how to formulate the customfields based variables ?
        // Below should be pulling clendar customfield id 1
        $events['type'] = ' ';
        // Below should be pulling clendar customfield id 2
        $events['location'] = ' ';
        eval('$usersevents .= "' . fetch_template('memberinfo_usersevents') . '";');
    } 


Now my problem only seems to be how to implement the above offered snippet into $events['type'] = ' '; and $events['location'] = ' ';

Once again... Thank's for any insight.

-Mika

[MikaK]

case solved and closed.