Question

<?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);


?>

Answer 1

Well, I ve looked at it. And you re absolutely right! It s a while loop alright! :)

Answer 2

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)

Answer 3

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.

友情链接