If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

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

Options

02-03-2007 10:40am

#1

ChicoMendez

Registered Users 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

Options
#2 02-03-2007 5:16pm
forbairt

Registered Users 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
Options
#3 02-03-2007 5:17pm
daymobrew

Registered Users Posts: 6,511 ✭✭✭

Join Date: July 2004

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

0
Options
#4 02-03-2007 5:25pm
seamus

Registered Users Posts: 68,317 ✭✭✭✭

Join Date: July 2001

Posts: 67070

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
Options
#5 03-03-2007 9: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