unsigned zerofill and clean_array_gpc

[Lionel]

I have a field in database set as INT (7) unsigned zerofill
The value in there is "0096071".

When I browse to ?mid=0096071&do=insert

and in the php do

$vbulletin->input->clean_array_gpc('r', array(
'mid' => TYPE_UINT
));
$myid = & $vbulletin->GPC['mid'];

$myid drops the zeros in front and becomes 96071

How can I make it read the zeros also?

[Guest190829]

Try TYPE_UNUM instead of TYPE_UINT.

[Lionel]

Thanks, but same results: missing zeros upfront. Temporary I removed the zero filled, but that is really no good for me.

[Marco van Herwaarden]

Storing values with zerofill is not really good coding practise.

Zerofill is a display attribute, not something you want to store and use internally in your scripts.

[Lionel]

problem is I am getting that value 0096071 from somewhere else, I am not creating it.

[Marco van Herwaarden]

Just store it without the zerofill.

[Lionel]

That's what I ended up doing and when I do a call back to other site I count the digits and simply place the missing zeros in front of it so the link matches.

[Marco van Herwaarden]

You would not need to count digits, simply format the number with sprintf().