fail insert to mySQL

[rzo]

(excuse my poor english...😃 )

im using a shopping cart code but i have a little problem when i try to insert the itemid id of the products the itemid's that begin with 0 when i see the database the itemid dont have the zeros .

('0001234')----->in the database appear----->('1234')

@("insert into vr_carro(cookieId, itemId,qty) values
('" . GetCartId() . "', $itemId, $qty)");

$itemId the variable contain the value i check that before insert, and the data type of mysql databes for itemid is a varchar(sometimes the id have text).

where are the zeros??

i really dont know what happen please help me

[[deleted]]

"where are the zeros??"

Numbers do not have leading zeros.

The zero's are useless in the database so you can just leave them out.

If you want to print them you can use printf('%06', $number);

[maxsslade]

I am guessing that you are using an integer field in the MYSQL database, am i correct??

If your item number is always going to be 7 numbers, you could change the mysql field to CHAR and have it 7 characters limit.

Whatever you enter into this field will always be the code that you want.

I hope this helps you.

• Max Slade

[jerdo]

If you are using an integer field to store these id's use zero filled and it will put zeroes in front of the number if it's smaller than the maximum show size.

[[deleted]]

", you could change the mysql field to CHAR and have it 7 characters limit. "

You could, but you'd lose th numeric properties, such as the auto_increment feature.

More importantly, the zero's are just for show, they have no purpose inside the database because the database just needs a unique number, and leading zero's don't make a number any more unique, they just take up space.

The only reason to have them is to present a nice number to the user.

And you can get that from printf() or 'zerofill', heck, even lpad() will do.

[the_Igel]

rzo has written that the itemid datatype is varchar, still everybody answer as if he has said "int".

The solution is to put your "000123" in quotes.

mysql_query("insert into vr_carro(cookieId, itemId,qty) values
('" . GetCartId() . "', '$itemId', $qty)");

Should work, AFAIK.