Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.

https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

php mysql format question

ChicoMendez · 2007-03-02 09:40:29

hi i have a field in my db called orderid if i pull a value from it for example 33 how do i format it with php to show 00000033 ? Tnx

02-03-2007 10:40AM

#1

ChicoMendez

Registered Users, Registered Users 2 Posts: 648 ✭✭✭

Join Date: July 2003

Posts: 364

hi

i have a field in my db called orderid

if i pull a value from it for example 33 how do i format it with php to show
00000033 ?

Tnx

0

Comments

#2 02-03-2007 05:16PM

forbairt

Registered Users, Registered Users 2 Posts: 3,594 ✭✭✭

Join Date: September 2004

Posts: 3389

something like ...

str_pad("33", 10, "0", STR_PAD_LEFT);

make yourself a little function and hey presto ...

function pad0($number,$zeros="0")
{
return str_pad($number, $zeros, "0", STR_PAD_LEFT);
}

pad0("33",10);

0
#3 02-03-2007 05:17PM
daymobrew

Registered Users, Registered Users 2 Posts: 6,651 ✭✭✭

Join Date: July 2004

Posts: 6127
sprintf.
$formatted_str = sprintf( '%08d', $num_from_db );

0
#4 02-03-2007 05:25PM

seamus

Registered Users, Registered Users 2 Posts: 68,173 ✭✭✭✭

Join Date: July 2001

Posts: 66931

You can also tell MySQL to format the data when it selects it

SELECT LPAD(`ID_Column`,8,'0') FROM TABLE....

Will add the '0' character onto ID_Column, up to a maximum of 8 characters.

0
#5 03-03-2007 09:10PM

louie

Closed Accounts Posts: 1,200 ✭✭✭

Join Date: April 2003

Posts: 1176

you can also have this setup in your database start id 0000001

0