add '0' to 2003,2,14_?

vent

have a calendar but can't get it to change the input of date, so i need to do it in the php script and then put it into a database. Just need to add a '0' to single figure days or months.

ie.
2003,2,14 has to become 2003,02,14
2003,2,4 to 2003,02,04 and so on...

arrays are my weakest point so any help will be great...

dan.

okuto1973

well.....if you have

$string="2";
if (strlen($string)==1)$string.="0".$string;

is it enought?

vent

mmm, no?
$date_s = "2003,1,4";

somehow i have to split at the commas, then
if only one figure add "0"

so i create 3 arrays at first, then check the second 2 and add "0" if required and then put it all back together...
Not a clue how to do it though....

$date_new = "2003,01,04";

bad76

Originally posted by vent

$date_s = "2003,1,4";

somehow i have to split at the commas, then
if only one figure add "0"

Hi,
you can using explode(",",$date_s)

vent

ok so i've managed to split them up:
<?

$date_in1= "2003,4,5";

$array = explode(",", $date_in1);

foreach ($array as $i){
echo "$i<br>";
}

$yyyy ="$array[0]"
$MM="$array[1]"
$dd="$array[2]"

how do i then check and change $MM and $dd???

if($mm<1) {
$mmb = "0$mm"
}else{
$mmb = "$mm"
}

close? or will this just get the value of the character and not count the characters themselves?

okuto1973

$mmb=$mm;
if(strlen($mm)==1) $mmb = "0$mm";

vent

got it, in an ameturish way:
<?

$date_in1= "2003,10,10";

$array = explode(",", $date_in1);
echo "$date_in1<br>
<br>
";
foreach ($array as $i){
echo "$i<br>";
}

$yyyy ="$array[0]";
$MM="$array[1]";
$dd="$array[2]";

if($MM<10){
$MM2="0$MM";
}else{
$MM2="$MM";
}
if($dd<10){
$dd2="0$dd";
}else{
$dd2="$dd";
}

$date_mod_s = "$yyyy,$MM2,$dd2";
print "$date_mod_s";

thanks for the pointers...

bad76

Or look for date() and mktime()

date("d,m,Y",mktime(0,0,0,$MM,$dd,$yyyy));

 
$date_in1= "2003,4,5"; 
$yar = explode(",", $date_in1); 
date("d,m,Y",mktime(0,0,0,$yar[1],$yar[2],$yar[0]));

May be there are many other method to do this, but this is easy...

tbach2

Aw, shucks-- bad76 beat me to the punch while I was talking on the phone... So here's the obfuscated way to do it 😃

print date("Y,m,d",strtotime(ereg_replace(",","-",$date_in1)));

okuto1973

This code takes approximatly 16 sec on my server.......

<?
set_time_limit(100);
$t=time();
for ($i=0;$i<900000;$i++)
{
$date_in1= "2003,4,5";  

$m=substr($date_in1,5,1);
$d=substr($date_in1,7,1);
if (strlen($m)==1)$m="0$m";
if (strlen($d)==1)$d="0$m";
$a=substr($date_in1,0,4);
}
$t2=time();
$diff=$t2-$t;
echo "t=$t,t2=$t2;dif=$diff";
?>

This code takes approximatly 31 sec on my server.......

<?
set_time_limit(100);
$t=time();
for ($i=0;$i<900000;$i++)
{
date("Y,m,d",strtotime(ereg_replace(",","-",$date_in1)));
}
$t2=time();
$diff=$t2-$t;
echo "t=$t,t2=$t2;dif=$diff";
?>

This code takes approximatly 32 sec on my server.......

<?
set_time_limit(100);
$t=time();
for ($i=0;$i<900000;$i++)
{
$date_in1= "2003,4,5";  

$yar = explode(",", $date_in1);  

date("d,m,Y",mktime(0,0,0,$yar[1],$yar[2],$yar[0]));
}
$t2=time();
$diff=$t2-$t;
echo "t=$t,t2=$t2;dif=$diff";
?>

Yes.... my code it's much more long but it take less cpu time.
In some code i usually prefair more code but less cpu usage!

tbach2

Nice tweak 😉

it would be interesting to see how much of a difference preg_replace would make...

to be fair, though, the strtotime and ereg_replace wouldn't be needed if the data were being stored as a timestamp :rolleyes:

If it were stored as a timestamp, then you could do all sorts of conversions and outputs if you needed to with minimal cpu cost

jmcneese

why so complex?

$date = "2003,4,3";

$foo = explode(',',$date);

foreach($foo as $k=>$v) {
    str_pad($v, 2, '0', STR_PAD_LEFT);
}

$date = $foo[0].','.$foo[1].','$foo[2];