Topic awaiting preservation: regex help (Page 1 of 1)

Greets!

I have data in a MySQL table cell that might have data that looks like this:
a:1:{i:2;s:15:"Bill Smith";}
I need to convert echo it out as
<a href="/link/to/user.php?id=2">Bill Smith</a>

where "id" is the value of "i" in the original data.

The problem gets harder, because that same table might hold something like
a:4:{i:2;s:12:"Bill Smith";i:16;s:15:"John Doe";i:77;s:10:"Jack Jones";i:27;s:10:"Ed Johnson";}

And I need to create
<a href="/link/to/user.php?id=2">Bill Smith</a>, <a href="/link/to/user.php?id=16">John Doe</a>, <a href="/link/to/user.php?id=77">Jack Jones</a>, <a href="/link/to/user.php?id=27">Ed Johnson</a>

You'll note that the value of "a" in each shows the total number of users in the array. The value of "s" isn't needed.

This is making my brain hurt. Ideas?



(Edited by Pugzly on 05-30-2004 18:18)

php->unserialize
is probably what you *should* be using.

otherwise, I wouldn't do this with regexps, but with a simple byte-by-byte parser -easy enough to build, and unlike regexps it will descend to any depth (limited by memomry of course)

Ah - never saw that before. That would explain the initial format.

Thanks. I'll dive into that.

$row['touserarray'] = "a:4:{i:2;s:12:"Bill Smith";i:16;s:15:"John Doe";i:77;s:10:"Jack Jones";i:27;s:10:"Ed Johnson";}";

$tousers = unserialize($row['touserarray']);
foreach ($tousers as $value) {
echo $value . ", ";
}

I end up with "Bill Smith, John Doe, Jack Jones, Ed Johnson,"

That's not bad, but I'm unsure how to get the value of i for each. Is that possible?

well... I'm not sure, those might be the keys,
try

foreach($trousers as $aKey => $value)

{

...

}

That did the trick.

Thanks!

you could also have used php->var_dump on it to see everything in that array.