<?php
$con=mysql_connect("localhost","mts","mts");
if(!con)
{
die('unable to connect' . mysql_error());
}
mysql_select_db("mts",$con);
/*
date_default_timezone_set ("Asia/Calcutta");
$date = date('d/m/Y h:i:s a', time());
echo date("d/m/Y h:i:s a", time());
*/
date_default_timezone_set ("Asia/Calcutta");
$cd=date("d/m/Y");
echo $cd;
echo "<br>";
$con=mysql_connect("localhost","mts","mts");
if(!con)
{
die('unable to connect' . mysql_error());
}
$res=mysql_query("select ElpDur,DateTime from doctor_upload");
$i=0;
while($row=mysql_fetch_array($res))
{
$elp[i]=$row['ElpDur'];
$dt=$row['DateTime'];
//$b[i]=$elp;
echo $elp;
echo "<br>";
echo $dt;
$diff[i]=$cd-$dt;
$a[i]=$elp[i]-$diff[i];
echo $diff[i];
echo $a[i];
if($diff[i]<elp[i])
{
echo $a[i]."days";
}
else
{
echo "expire";
}
$i++;
}
mysql_close($con);
?>
views:
91answers:
3
+5
A:
Well, I've looked at it. And you're absolutely right! It's a while loop alright! :)
dufus
2009-11-13 05:59:35
If you happen to be looking for a second opinion, I also checked. It is indeed a while loop.
Simucal
2009-11-13 06:17:20
you forgot if condition
Xinus
2009-11-13 06:46:30
A:
Hi! syntax error here:
if($diff[i]<elp[i])
must be
if($diff[i]<$elp[i])
I dont like this part: $diff[i]=$cd-$dt; maybe beter use timestamp for date operations (my subjective opinion)
wormhit
2009-11-13 06:14:32
A:
I think there is a problem too with
$elp[i]=$row['ElpDur'];
It should look like:
$elp[$i]=$row['ElpDur'];
Or is "i" a constant? By the way, you should try to learn OOP.
If you really want to program code in PHP you´ll have to learn it. Every project is growing, some more some less. The more it grows the more you´ll see that you procedural code is a mess.
MaikL80
2009-11-13 06:42:15