phpUnserialize ( text )

Unserialize values which were serialized by PHP's serialize() function

Average rating: 4.4 (27 votes) Log in to vote

Sam Barnum - Show more from this author
360Works
http://360works.com

Sample input:

s:19:"http://360works.com";

Sample output:

http://360works.com

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

// s:19:"http://360works.com"; 
// n:42;

Let (  [ 
    trimmed = Left ( text ; Length ( text ) - 1 ) ; // remove semicolon
    p1 = Position ( trimmed ; ":" ; 1 ; 1 ) ; // first colon, should always = 2
    p2 = Position ( trimmed ; ":" ; 1 ; 2) ; // second colon, only for string types
    type = Left ( trimmed ; p1 -1 ) ;
    v2 = Middle ( trimmed ; p1 + 1; p2-p1 );
    v3 = Middle ( trimmed ; p2 + 1 ; Length(trimmed) - p2 )
] ;
    Case ( 
        IsEmpty(text) ; // empty input
            "" ;
        type = "N" ;  // null
            "" ;
        type = "b" ; // boolean
            GetAsBoolean( v2 ) ;
        type = "i" ; // integer
            GetAsNumber( v2 ) ;
        type = "s" ;
            Middle ( v3 ; 2 ; v2 ) ;
        type = "a" ;
            text ; // not yet supported
        type = "O" ;
            text ; // not yet supported
        "Unknown serialize format in " & text
    )
)

If you come across values in a database which start with a type and contain colon-delimited data, that's probably a value written by PHP's serialize() function. This is a quick little function to convert those values to FileMaker types.

Comments

		Daniel Feb 15, 2015
Arrays!

		colin Jan 11, 2019
Fantastic thank you!! Now I can read this wordpress data

		Daniel Oct 8, 2020
Does anyone have a solution to unserialize arrays?

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

phpUnserialize ( text )

Comments

Support this website.

Support this website.