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

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,631 ✭✭✭

Join Date: July 2004

Posts: 6107
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