Ad:

PHP Discussion Thread
Unsolved
Views: 4462

Aug 15th, 2009

How to convert string variable to BIGINT & also to keep leading zeros ??

Expand Post »

Hello,
I need to convert a string variable to BIGINT and store it into the mysql database. I have used settype() but its removing my leading zero in the string.
For example,

PHP Syntax (Toggle Plain Text)
 $new_id1="12";
   $new_id2="345";
   $zero="0";
   $id="{$zero}{$zero}{$new_id1}{$new_id2}";
   settype($id,"float");
   echo $id;
 
output:
12345   // Instead of getting 0012345
 $new_id1="12";
   $new_id2="345";
   $zero="0";
   $id="{$zero}{$zero}{$new_id1}{$new_id2}";
   settype($id,"float");
   echo $id;

output:
12345   // Instead of getting 0012345

The above code removes 00 (leading zeros).Can someone help me how to keep the zeros along with variable type as float??
Help would be appreciated
Thanks.

Last edited by ramsri05; Aug 15th, 2009 at 4:34 am.

Similar Threads

Convert string variable into form object in VB.NET
Convert string variable into form object in VB6 in Visual Basic 4 / 5 / 6
Convert string into string variable in VB.NET
convert string to double, and result is string again in Java

ramsri05

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Jul 2009

Permalink

Aug 15th, 2009

Re: How to convert string variable to BIGINT & also to keep leading zeros ??

Numeric datatypes will never have leading zeros. You could add a dummy number to the front and just remove with substr when outputting it.

php Syntax (Toggle Plain Text)
$new_id1="12";
   $new_id2="345";
   $zero="0";
   $id="1{$zero}{$zero}{$new_id1}{$new_id2}";   
   settype($id,"float");
   echo $id; // outputs 10012345
   echo"<br>";
   $id = substr($id,1);//remove dummy number
   echo $id; // outputs 0012345
$new_id1="12";
   $new_id2="345";
   $zero="0";
   $id="1{$zero}{$zero}{$new_id1}{$new_id2}";   
   settype($id,"float");
   echo $id; // outputs 10012345
   echo"<br>";
   $id = substr($id,1);//remove dummy number
   echo $id; // outputs 0012345

Last edited by buddylee17; Aug 15th, 2009 at 10:46 am.

buddylee17

Reputation Points: 232

Solved Threads: 137

Practically a Master Poster

Offline

665 posts
since Nov 2007

Permalink

Aug 15th, 2009

Re: How to convert string variable to BIGINT & also to keep leading zeros ??

Thanks buddylee17,
Well, I wanted to add leading zero in the numeric datatype only. because I should insert it into MySql database BIGINT data field.
Is there any way to insert the numeric/string value with leading zero into MYSQL BIGINT field ? If I insert a string of "0123456" this BIGINT field removes leading 0 and showing only 123456. how to make it show this 0 without enabling unsigned zerofill option? HELP pls !!

ramsri05

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Jul 2009

Permalink

Aug 16th, 2009

Re: How to convert string variable to BIGINT & also to keep leading zeros ??

Click to Expand / Collapse Quote originally posted by ramsri05 ...

Thanks buddylee17,
Well, I wanted to add leading zero in the numeric datatype only. because I should insert it into MySql database BIGINT data field.
Is there any way to insert the numeric/string value with leading zero into MYSQL BIGINT field ? If I insert a string of "0123456" this BIGINT field removes leading 0 and showing only 123456. how to make it show this 0 without enabling unsigned zerofill option? HELP pls !!

MySQL does not know about PHP datatypes. So an integer or a string in PHP looks the same to MySQL.

It only depends on whether you quote the value in the MySQL query or not.

If you quote a value, it is treated as a string. However, MySQL will automatically convert that to the type of the column.

I don't think you can place 0 in front of a bigint column unless you specify zerofill.

If you have phpmyadmin just play around with the values and storage type of the table to make sure.

digital-ether

Moderator

Reputation Points: 457

Solved Threads: 101

Nearly a Posting Virtuoso

Offline

1,250 posts
since Sep 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: New Social Networking Site

Next Thread in PHP Forum Timeline: php and emailform

DaniWeb Message

Cancel Changes

User Name
Password