How can i do this in a better way ?

[Nuv]

Hi,

 

I made a code to add 0 infront of any zipcode with 4 digits. I think this can be done in a better way.Maybe using only sql by LEN('string') or DATALENGTH('string'). Can someone please show me how ? Is there any better way ?

 

<?php
  $mysql_hostname = "localhost";
$mysql_user = "root";
$mysql_password = "";
$mysql_database = "flourists";
$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password)
or die("Opps some thing went wrong");
mysql_select_db($mysql_database, $bd) 
or die("Opps some thing went wrong");
$result = mysql_query("SELECT * FROM bakers");
while($row = mysql_fetch_array($result))
{       
    if((strlen($row['pincode'])) == 4 )
    {    
          
          echo  $row['pincode'] ;
          echo "<br />";
          $addzero = "0";
          $newpincode =  $addzero.$row['pincode'];
          echo $newpincode;
          echo "<br />"; 
          echo "<br />"; 
         // will add UPDATE sql query to update $newpincode
    }   
}
?>

 

[spaceman12]

Do it this ways which is alot cleaner.

 

$pincode=$row['pincode'];
If(strlen($pincode)==4)
{
      $pincode='0'.$pincode;
}

[coolcam262]

You could even just do:

 

If(strlen($row['pincode'])==4)
      $pincode='0'.$pincode;

[cyberRobot]

Or you could use sprintf()

http://php.net/manual/en/function.sprintf.php

 

 

$row['pincode'] = sprintf("%05d", $row['pincode']);

[sasa]

you can do it in MYSQL with LPAD() function

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_lpad

[Nuv]

you can do it in MYSQL with LPAD() function

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_lpad

 

Ah thats what i was looking for . Thankyou