从URL [已关闭]检索无符号的zerofill int

Question

Scenario: I'm passing an ID of an account through the URL. The account ID must always have 5 digits, that;s why I'm using zerofill int and automatically incrementing it every user account that I add in my database. By passing the ID, I'll use it to query other tables involving the user account

Problem: It seems that if I retrieve the ID from the URL through $_GET, it gives me a normal int instead. Is it possible to get the zerofill version of this number to compare it to my database?

Example: website.php?id=00032

P.S. I am a newbie in PHP so please do go easy on me. Also, I am aware that passing ID's through the URL is a major security issue but I'm not concerned about that right now

Answer 1

You can either cast it to int or check using is_int/ is_integer/filter_var

Also, I personally don't like the idea of using the common id for identifying users. You might want to create a function that generates the user account based on the id plus the current date and maybe some random string as well.