alert met if else
Gust (laatste wijziging 23/09/2008 10:27)
MySQL interesse
Hallo allemaal,Bekijk aub eventjes deze link index.php http://www.plaatscode.be/28623/ time.php http://www.plaatscode.be/28625/
$i=$id;
$no=$now;
$d_end=$datum_eind;
$i = $id ;
$no = $now ;
$d_end = $datum_eind ;
41 antwoorden
Kr4nKz1n (laatste wijziging 23/09/2008 10:27)
Onbekend Ik zal even voor je kijken Edit
$aTimeReplace = Array('from' => Array(':', '-', ' '), 'to' => Array('', '', ''));
$now = Str_Replace($aTimeReplace['from'], $aTimeReplace['to'], $now);
$datum_eind = Str_Replace($aTimeReplace['from'], $aTimeReplace['to'], $datum_eind);
If($now > $datum_eind)
{
//Etc.
}
$aTimeReplace = Array ( 'from' => Array ( ':' , '-' , ' ' ) , 'to' => Array ( '' , '' , '' ) ) ; $now = Str_Replace ( $aTimeReplace [ 'from' ] , $aTimeReplace [ 'to' ] , $now ) ; $datum_eind = Str_Replace ( $aTimeReplace [ 'from' ] , $aTimeReplace [ 'to' ] , $datum_eind ) ;
If ( $now > $datum_eind )
{
//Etc.
}
Gust
MySQL interesse Moet dit in time.php geplaatst worden?
Kr4nKz1n (laatste wijziging 23/09/2008 12:17)
Onbekend Ik snap niet waarom jij time.php hebt aangemaakt.
<?php
// variabelen initialiseren
$username = "geheim";
$password = "geheim";
$host="localhost";
$dbnaam="geheim";
$fout = "FOUT: openen database mislukt";
setlocale(LC_ALL,'nl_NL.ISO8859-1');
$query="SELECT id, now, datum_eind FROM leveranciers ORDER BY id";
// ---- einde initialisatie
$db=mysql_connect($host, $username, $password);
mysql_select_db($dbnaam, $db) or die($fout);
$result = mysql_query($query) or die (mysql_error());
?>
<html>
<head>
<title>Leveranciers</title>
<body>
<font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<table width="90%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#decb7b">
<tr>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">ID</div></td>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">huidige tijd</div></td>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">deadline</div></td>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center"><b><img src="images/save.gif" alt="bewerken" width="30" height="30"></b></div></td>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif">includen</font></b></div></td>
</tr>
<tr class="tekst">
<?php while (list($id, $now, $datum_eind) =
mysql_fetch_row($result)){
$i=$id;
$aTimeReplace = Array('from' => Array(':', '-', ' '), 'to' => Array('', '', ''));
$no = Str_Replace($aTimeReplace['from'], $aTimeReplace['to'], $now);
$d_end = Str_Replace($aTimeReplace['from'], $aTimeReplace['to'], $datum_eind);
If($no > $d_end)
{
echo "Nog tijd";
}
ElseIf($no < $d_end)
{
echo "Tijd verstreken";
}
Else
{
echo "Niet veel tijd meer";
}
echo("
<td bgcolor=\"#F4ECCC\" class=\"tekst\" align=\"center\" width=\"20%\">$i</td>
<td bgcolor=\"#efe3b5\" class=\"tekst\" width=\"20%\">$no</td>
<td bgcolor=\"#efe3b5\" class=\"tekst\" width=\"20%\">$d_end</td>
<td bgcolor=\"#F4ECCC\"align=\"center\" width=\"20%\"><a href=\"time.php?id=$id\"><img src=\"images/save.gif\" width=\"20\" height=\"20\" border=\"0\"></a></td>
<td bgcolor=\"#F4ECCC\"align=\"center\" width=\"20%\">file_get_contents('time.php?id=$id\');</td>
</tr>
\n");
}
?>
</table>
</body>
</html>
<?php
// variabelen initialiseren
$username = "geheim" ;
$password = "geheim" ;
$host = "localhost" ;
$dbnaam = "geheim" ;
$fout = "FOUT: openen database mislukt" ;
$query = "SELECT id, now, datum_eind FROM leveranciers ORDER BY id" ;
// ---- einde initialisatie
?>
<html>
<head>
<title>Leveranciers</title>
<body>
<font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<table width="90%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#decb7b">
<tr>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">ID</div></td>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">huidige tijd</div></td>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">deadline</div></td>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center"><b><img src="images/save.gif" alt="bewerken" width="30" height="30"></b></div></td>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif">includen</font></b></div></td>
</tr>
<tr class="tekst">
<?php while ( list ( $id , $now , $datum_eind ) =
$i = $id ;
$aTimeReplace = Array ( 'from' => Array ( ':' , '-' , ' ' ) , 'to' => Array ( '' , '' , '' ) ) ; $no = Str_Replace ( $aTimeReplace [ 'from' ] , $aTimeReplace [ 'to' ] , $now ) ; $d_end = Str_Replace ( $aTimeReplace [ 'from' ] , $aTimeReplace [ 'to' ] , $datum_eind ) ;
If ( $no > $d_end )
{
}
ElseIf ( $no < $d_end )
{
}
Else
{
echo "Niet veel tijd meer" ; }
<td bgcolor=\" #F4ECCC\" class=\" tekst\" align=\" center\" width=\" 20%\" >$i </td>
<td bgcolor=\" #efe3b5\" class=\" tekst\" width=\" 20%\" >$no </td>
<td bgcolor=\" #efe3b5\" class=\" tekst\" width=\" 20%\" >$d_end </td>
<td bgcolor=\" #F4ECCC\" align=\" center\" width=\" 20%\" ><a href=\" time.php?id=$id \" ><img src=\" images/save.gif\" width=\" 20\" height=\" 20\" border=\" 0\" ></a></td>
<td bgcolor=\" #F4ECCC\" align=\" center\" width=\" 20%\" >file_get_contents('time.php?id=$id \');</td>
</tr>
\n ") ;
}
?>
</table>
</body>
</html>
Gust
MySQL interesse Kr4nKz1n schreef:
Ik ga de andere fouten niet oplossen.
Kr4nKz1n
Onbekend En werkt het script?
Gust (laatste wijziging 23/09/2008 13:52)
MySQL interesse Ja, zo ongeveer Je kunt hier meekijken als je wilt
<?php
// variabelen initialiseren
$username = "geheim";
$password = "geheim";
$host="localhost";
$dbnaam="geheim";
$fout = "FOUT: openen database mislukt";
setlocale(LC_ALL,'nl_NL.ISO8859-1');
$query="SELECT id, now, datum_eind FROM leveranciers ORDER BY id";
// ---- einde initialisatie
$db=mysql_connect($host, $username, $password);
mysql_select_db($dbnaam, $db) or die($fout);
$result = mysql_query($query) or die (mysql_error());
?>
<html>
<head>
</head>
<body>
<font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<table width="90%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#decb7b">
<tr>
<td width="25%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">ID</div></td>
<td width="25%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">huidige tijd</div></td>
<td width="25%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">deadline</div></td>
<td width="25%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">status</td>
</tr>
<tr class="tekst">
<?php
while (list($id, $now, $datum_eind) = mysql_fetch_row($result)){
$i=$id;
$aTimeReplace = Array('from' => Array(':', '-', ' '), 'to' => Array('', '', ''));
$no = Str_Replace($aTimeReplace['from'], $aTimeReplace['to'], $now);
$d_end = Str_Replace($aTimeReplace['from'], $aTimeReplace['to'], $datum_eind);
echo("
<td bgcolor=\"#F4ECCC\" class=\"tekst\" align=\"center\" width=\"25%\">$i</td>
<td bgcolor=\"#efe3b5\" class=\"tekst\" width=\"25%\">$no</td>
<td bgcolor=\"#efe3b5\" class=\"tekst\" width=\"25%\">$d_end</td>
");
?>
<td width=25%>
<?php
If ($no > $d_end)
{
echo "Nog tijd";
}
ElseIf($no < $d_end)
{
echo "Tijd verstreken";
}
Else
{
echo "Niet veel tijd meer";
}
?>
</td>
</tr>
</table>
</font>
</body>
</html>
<?php
}
?>
<?php
// variabelen initialiseren
$username = "geheim" ;
$password = "geheim" ;
$host = "localhost" ;
$dbnaam = "geheim" ;
$fout = "FOUT: openen database mislukt" ;
$query = "SELECT id, now, datum_eind FROM leveranciers ORDER BY id" ;
// ---- einde initialisatie
?>
<html>
<head>
</head>
<body>
<font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<table width="90%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#decb7b">
<tr>
<td width="25%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">ID</div></td>
<td width="25%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">huidige tijd</div></td>
<td width="25%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">deadline</div></td>
<td width="25%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">status</td>
</tr>
<tr class="tekst">
<?php
$i = $id ;
$aTimeReplace = Array ( 'from' => Array ( ':' , '-' , ' ' ) , 'to' => Array ( '' , '' , '' ) ) ; $no = Str_Replace ( $aTimeReplace [ 'from' ] , $aTimeReplace [ 'to' ] , $now ) ; $d_end = Str_Replace ( $aTimeReplace [ 'from' ] , $aTimeReplace [ 'to' ] , $datum_eind ) ;
<td bgcolor=\" #F4ECCC\" class=\" tekst\" align=\" center\" width=\" 25%\" >$i </td>
<td bgcolor=\" #efe3b5\" class=\" tekst\" width=\" 25%\" >$no </td>
<td bgcolor=\" #efe3b5\" class=\" tekst\" width=\" 25%\" >$d_end </td>
" ) ;
?>
<td width=25%>
<?php
If ( $no > $d_end )
{
}
ElseIf ( $no < $d_end )
{
}
Else
{
echo "Niet veel tijd meer" ; }
?>
</td>
</tr>
</table>
</font>
</body>
</html>
<?php
}
?>
Kr4nKz1n
Onbekend Dat komt omdat de } NA </html> staat.</tr>
Gust
MySQL interesse Bedankt, nu werkt het.
$aTimeReplace = Array('from' => Array(':', '-', ' '), 'to' => Array('', '', ''));
$no = Str_Replace($aTimeReplace['from'], $aTimeReplace['to'], $now);
$d_end = Str_Replace($aTimeReplace['from'], $aTimeReplace['to'], $datum_eind);
$aTimeReplace = Array ( 'from' => Array ( ':' , '-' , ' ' ) , 'to' => Array ( '' , '' , '' ) ) ; $no = Str_Replace ( $aTimeReplace [ 'from' ] , $aTimeReplace [ 'to' ] , $now ) ; $d_end = Str_Replace ( $aTimeReplace [ 'from' ] , $aTimeReplace [ 'to' ] , $datum_eind ) ;
$aTimeReplace = Array('from' => Array(':', '-', ' '), 'to' => Array('/', '/', '/'));
$no = Str_Replace($aTimeReplace['from'], $aTimeReplace['to'], $now);
$d_end = Str_Replace($aTimeReplace['from'], $aTimeReplace['to'], $datum_eind);
$aTimeReplace = Array ( 'from' => Array ( ':' , '-' , ' ' ) , 'to' => Array ( '/' , '/' , '/' ) ) ; $no = Str_Replace ( $aTimeReplace [ 'from' ] , $aTimeReplace [ 'to' ] , $now ) ; $d_end = Str_Replace ( $aTimeReplace [ 'from' ] , $aTimeReplace [ 'to' ] , $datum_eind ) ;
Kr4nKz1n
Onbekend oow wacht, doe dit
$iDateNow = Str_Replace($aTimeReplace['from'], $aTimeReplace['to'], $now);
$iDateDeadline = Str_Replace($aTimeReplace['from'], $aTimeReplace['to'], $datum_eind);
$iDateNow = Str_Replace ( $aTimeReplace [ 'from' ] , $aTimeReplace [ 'to' ] , $now ) ; $iDateDeadline = Str_Replace ( $aTimeReplace [ 'from' ] , $aTimeReplace [ 'to' ] , $datum_eind ) ;
//De eerste
If($iDateNow > $iDateDeadline)
//En de tweede
ElseIf($iDateNow < $iDateDeadline)
//De eerste
If ( $iDateNow > $iDateDeadline )
//En de tweede
ElseIf ( $iDateNow < $iDateDeadline )
Gust (laatste wijziging 23/09/2008 15:11)
MySQL interesse Nee sorry, je was juist denk ik. Ik zag iets over het hoofd
<?php
If ($no < $d_end)
{
echo "Nog tijd";
}
ElseIf($no > $d_end)
{
echo "Tijd verstreken";
}
Else
{
echo "Niet veel tijd meer";}
?>
<?php
If ( $no < $d_end )
{
}
ElseIf ( $no > $d_end )
{
}
Else
{
echo "Niet veel tijd meer" ; }
?>
<?php
If ($no > 31536000)
{
echo "Nog tijd genoeg";
}
ElseIf($no < 31536000)
{
echo "Nog een jaar tijd";
}
ElseIf($no < 3153600)
{
echo "Niet veel tijd meer";
}
Else
{
echo "Tijd verstreken";}
?>
<?php
If ( $no > 31536000 )
{
}
ElseIf ( $no < 31536000 )
{
echo "Nog een jaar tijd" ; }
ElseIf ( $no < 3153600 )
{
echo "Niet veel tijd meer" ; }
Else
{
?>
Kr4nKz1n (laatste wijziging 23/09/2008 15:22)
Onbekend Ja maar dit is geen normale tijd aanduiding.JaarMaandDagUrenMinutenSeconden
// Als $now eruit ziet als: 2008-09-22 15:12:43, kan je dit scriptje toepassen
$aDateTime = Explode(' ', $now);
$aDateTime[0] = Explode('-', $aDateTime[0]);
$aDateTime[1] = Explode(':', $aDateTime[1]);
$no = MkTime($aDateTime[1][2], $aDateTime[1][1], $aDateTime[1][0], $aDateTime[0][1], $aDateTime[0][2], $aDateTime[0][0]);
// Als $now eruit ziet als: 2008-09-22 15:12:43, kan je dit scriptje toepassen
$aDateTime [ 0 ] = Explode ( '-' , $aDateTime [ 0 ] ) ; $aDateTime [ 1 ] = Explode ( ':' , $aDateTime [ 1 ] ) ; $no = MkTime ( $aDateTime [ 1 ] [ 2 ] , $aDateTime [ 1 ] [ 1 ] , $aDateTime [ 1 ] [ 0 ] , $aDateTime [ 0 ] [ 1 ] , $aDateTime [ 0 ] [ 2 ] , $aDateTime [ 0 ] [ 0 ] ) ;
$no in seconden Edit
Gust
MySQL interesse Hij geeft dan wel 4 keer dezelfde foutmelding:Warning: mktime() expects parameter 3 to be long, string given in /usr/www/users/dotserv/gazelle/leveranciers/index_if.php on line 78
Kr4nKz1n (laatste wijziging 23/09/2008 15:51)
Onbekend
$no = MkTime($aDateTime[1][0], $aDateTime[1][1], $aDateTime[1][2], $aDateTime[0][1], $aDateTime[0][2], $aDateTime[0][0]);
$no = MkTime ( $aDateTime [ 1 ] [ 0 ] , $aDateTime [ 1 ] [ 1 ] , $aDateTime [ 1 ] [ 2 ] , $aDateTime [ 0 ] [ 1 ] , $aDateTime [ 0 ] [ 2 ] , $aDateTime [ 0 ] [ 0 ] ) ;
Edit $now nog wel de datum EN tijd of alleen datum?
Gust (laatste wijziging 24/09/2008 10:35)
MySQL interesse Ik heb het bij je huidige regels gehouden, want anders veranderen mijn datums weer. En ook omwille van de volgende reden:datumveld " leeg is en de "huidige tijd " is nog meer dan 6 maanden van de "deadline ": echo tijd genoegdatumveld " leeg is en de "huidige tijd " is minder dan 6 maanden van de "deadline ": echo minder dan 6 maandendatumveld " leeg is en de "huidige tijd " is minder dan 3 maanden van de "deadline ": echo minder dan 3 maandendatumveld " leeg is en de "huidige tijd " is meer de "deadline ": echo te laatdatumveld " niet leeg is: echo ok
<?php
if((!empty($no)) and curdate < ($d_end - 2419200))
{
echo "meer dan 1 maand tijd";
}
elseif((!empty($no)) and curdate > ($d_end - 2419200))
{
echo "minder dan 1 maand tijd";
}
elseif((!empty($no)) and curdate > ($d_end - 24192000))
{
echo "nog 10 maanden tijd";
}
elseif((empty($no)) and curdate < ($d_end - 0))
{
echo "<p><b><font color=\"#FF0000\">te laat</font></b></p>";
}
elseif(empty($no))
{
echo "invullen aub";
}
<?php
if ( ( ! empty ( $no ) ) and curdate
< ( $d_end - 2419200 ) ) {
echo "meer dan 1 maand tijd" ; }
elseif ( ( ! empty ( $no ) ) and curdate
> ( $d_end - 2419200 ) ) {
echo "minder dan 1 maand tijd" ; }
elseif ( ( ! empty ( $no ) ) and curdate
> ( $d_end - 24192000 ) ) {
echo "nog 10 maanden tijd" ; }
elseif ( ( empty ( $no ) ) and curdate
< ( $d_end - 0 ) ) {
echo "<p><b><font color=\" #FF0000\" >te laat</font></b></p>" ; }
{
}
Kr4nKz1n
Onbekend Wat is curdate?
Gust (laatste wijziging 24/09/2008 15:01)
MySQL interesse Ik heb het nu zo gedefinieerd:
$aTimeReplace = Array('from' => Array(':', '-', ' '), 'to' => Array(':', '-', ''));
$no = Str_Replace($aTimeReplace['from'], $aTimeReplace['to'], $now);
$d_end = Str_Replace($aTimeReplace['from'], $aTimeReplace['to'], $datum_eind);
$curdate = time() + (7 * 24 * 60 * 60);
$aTimeReplace = Array ( 'from' => Array ( ':' , '-' , ' ' ) , 'to' => Array ( ':' , '-' , '' ) ) ; $no = Str_Replace ( $aTimeReplace [ 'from' ] , $aTimeReplace [ 'to' ] , $now ) ; $d_end = Str_Replace ( $aTimeReplace [ 'from' ] , $aTimeReplace [ 'to' ] , $datum_eind ) ; $curdate = time ( ) + ( 7 * 24 * 60 * 60 ) ;
Kr4nKz1n (laatste wijziging 24/09/2008 15:32)
Onbekend Ja dan moet je natuurlijk wel
if((!empty($no)) and $curdate < ($d_end - 2419200))
if ( ( ! empty ( $no ) ) and
$curdate < ( $d_end - 2419200 ) )
Edit
<?php
//Hoef je niks aan te veranderen
Function DateToTime($sDate)
{
$aDateTime = Explode(' ', $sDate);
$aDateTime[0] = Explode('-', $aDateTime[0]);
$aDateTime[1] = Explode(':', $aDateTime[1]);
return MkTime($aDateTime[1][0], $aDateTime[1][1], $aDateTime[1][2], $aDateTime[0][1], $aDateTime[0][2], $aDateTime[0][0]);
}
// variabelen initialiseren
$username = "geheim";
$password = "geheim";
$host="localhost";
$dbnaam="geheim";
$fout = "FOUT: openen database mislukt";
setlocale(LC_ALL,'nl_NL.ISO8859-1');
$query="SELECT id, now, datum_eind FROM leveranciers ORDER BY id";
// ---- einde initialisatie
$db=mysql_connect($host, $username, $password);
mysql_select_db($dbnaam, $db) or die($fout);
$result = mysql_query($query) or die (mysql_error());
?>
<html>
<head>
<title>Leveranciers</title>
<body>
<font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<table width="90%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#decb7b">
<tr>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">ID</div></td>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">huidige tijd</div></td>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">deadline</div></td>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center"><b><img src="images/save.gif" alt="bewerken" width="30" height="30"></b></div></td>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif">includen</font></b></div></td>
</tr>
<tr class="tekst">
<?php while (list($id, $now, $datum_eind) =
mysql_fetch_row($result)){
$i=$id;
$no=$now;
$d_end=$datum_eind;
echo("
<td bgcolor=\"#F4ECCC\" class=\"tekst\" align=\"center\" width=\"20%\">$i</td>
<td bgcolor=\"#efe3b5\" class=\"tekst\" width=\"20%\">$no</td>
<td bgcolor=\"#efe3b5\" class=\"tekst\" width=\"20%\">$d_end</td>
<td bgcolor=\"#F4ECCC\"align=\"center\" width=\"20%\"><a href=\"time.php?id=$id\"><img src=\"images/save.gif\" width=\"20\" height=\"20\" border=\"0\"></a></td>
<td bgcolor=\"#F4ECCC\"align=\"center\" width=\"20%\">");
If(DateToTime($no) > DateToTime($d_end))
{
echo "Deadline verstreken";
}
Else
{
echo "Deadline is nog even weg";
}
echo("</td>
</tr>
\n");
}
?>
</table>
</body>
</html>
<?php
//Hoef je niks aan te veranderen
Function DateToTime( $sDate )
{
$aDateTime [ 0 ] = Explode ( '-' , $aDateTime [ 0 ] ) ; $aDateTime [ 1 ] = Explode ( ':' , $aDateTime [ 1 ] ) ; return MkTime ( $aDateTime [ 1 ] [ 0 ] , $aDateTime [ 1 ] [ 1 ] , $aDateTime [ 1 ] [ 2 ] , $aDateTime [ 0 ] [ 1 ] , $aDateTime [ 0 ] [ 2 ] , $aDateTime [ 0 ] [ 0 ] ) ; }
// variabelen initialiseren
$username = "geheim" ;
$password = "geheim" ;
$host = "localhost" ;
$dbnaam = "geheim" ;
$fout = "FOUT: openen database mislukt" ;
$query = "SELECT id, now, datum_eind FROM leveranciers ORDER BY id" ;
// ---- einde initialisatie
?>
<html>
<head>
<title>Leveranciers</title>
<body>
<font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<table width="90%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#decb7b">
<tr>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">ID</div></td>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">huidige tijd</div></td>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">deadline</div></td>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center"><b><img src="images/save.gif" alt="bewerken" width="30" height="30"></b></div></td>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif">includen</font></b></div></td>
</tr>
<tr class="tekst">
<?php while ( list ( $id , $now , $datum_eind ) =
$i = $id ;
$no = $now ;
$d_end = $datum_eind ;
<td bgcolor=\" #F4ECCC\" class=\" tekst\" align=\" center\" width=\" 20%\" >$i </td>
<td bgcolor=\" #efe3b5\" class=\" tekst\" width=\" 20%\" >$no </td>
<td bgcolor=\" #efe3b5\" class=\" tekst\" width=\" 20%\" >$d_end </td>
<td bgcolor=\" #F4ECCC\" align=\" center\" width=\" 20%\" ><a href=\" time.php?id=$id \" ><img src=\" images/save.gif\" width=\" 20\" height=\" 20\" border=\" 0\" ></a></td>
<td bgcolor=\" #F4ECCC\" align=\" center\" width=\" 20%\" >" ) ;
If ( DateToTime( $no ) > DateToTime( $d_end ) )
{
echo "Deadline verstreken" ; }
Else
{
echo "Deadline is nog even weg" ; }
</tr>
\n ") ;
}
?>
</table>
</body>
</html>
If(DateToTime($no) > DateToTime($d_end)) // Wanneer $no LATER is dan $d_end
If(DateToTime($no) < DateToTime($d_end)) // Kun je uitrekenen hoelang je nog hebt
$HoelangNog = DateToTime($d_end) - DateToTime($no); // Zo lang nog in secondes. Dit kun je gebruiken in Date()
If ( DateToTime( $no ) > DateToTime( $d_end ) ) // Wanneer $no LATER is dan $d_end
If ( DateToTime( $no ) < DateToTime( $d_end ) ) // Kun je uitrekenen hoelang je nog hebt
$HoelangNog = DateToTime( $d_end ) - DateToTime( $no ) ; // Zo lang nog in secondes. Dit kun je gebruiken in Date()
Gust
MySQL interesse [quote=Kr4nKz1n]Ja dan moet je natuurlijk weldeze pagina bekijkt dan zie je dat het niet klopt (bv bij een deadline die verstreken is staat er "nog 1 maand).
<?php
// variabelen initialiseren
$username = "geheim";
$password = "geheim";
$host="localhost";
$dbnaam="geheim";
$fout = "FOUT: openen database mislukt";
$query="SELECT id, now, currentdate, datum_eind FROM leveranciers ORDER BY id";
// ---- einde initialisatie
$db=mysql_connect($host, $username, $password);
mysql_select_db($dbnaam, $db) or die($fout);
$result = mysql_query($query) or die (mysql_error());
?>
<html>
<head>
<title>Leveranciers</title>
<style>
body {
background-color: #FFFFCC;
}
.tekst_titel {
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
font-weight: bold;
color:#4E4110;
}
.tekst_titel_klein {
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
font-weight: bold;
color:#4E4110;
}
.tekst {
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color:#000000;
}
.tekstveld {
background-color: #FFEAB3;
font-size: 11px;
color: #2c4c64;
font-family: verdana;
border: 1px solid #2c4c64;
</style>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head>
<body>
<font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<table width="90%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#decb7b">
<tr>
<td width="25%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">ID</div></td>
<td width="25%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">datum van invoering</div></td>
<td width="25%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">deadline</div></td>
<td width="25%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">status</td>
</tr>
<tr>
<?php
while (list($id, $now, $currentdate, $datum_eind) = mysql_fetch_row($result)){
$i=$id;
$aTimeReplace = Array('from' => Array(':', '-', ' '), 'to' => Array(':', '-', ''));
$no = Str_Replace($aTimeReplace['from'], $aTimeReplace['to'], $now);
$d_end = Str_Replace($aTimeReplace['from'], $aTimeReplace['to'], $datum_eind);
$currentdate = time() + (7 * 24 * 60 * 60);
echo("
<td class=\"tekst\" bgcolor=\"#F4ECCC\" class=\"tekst\" align=\"center\" width=\"25%\">$i</td>
<td class=\"tekst\" bgcolor=\"#efe3b5\" class=\"tekst\" width=\"25%\">$no</td>
<td class=\"tekst\" bgcolor=\"#efe3b5\" class=\"tekst\" width=\"25%\">$d_end</td>
");
?>
<td class="tekst" width=25%>
<?php
if((empty($no)) and $currentdate > ($d_end - 2419200))
{
echo "minder dan 1 maand";
}
elseif((empty($no)) and $currentdate > ($d_end - 4838400))
{
echo "minder dan 2 maanden";
}
elseif((empty($no)) and $currentdate > ($d_end - 14515200))
{
echo "minder dan 6 maanden";
}
elseif((empty($no)) and $currentdate > ($d_end - 24192000))
{
echo "Tijd genoeg";
}
elseif(!empty($no))
{
echo "ok";
}
?>
</td>
</tr>
<?php
}
?>
</table>
</font>
</body>
</html>
<?php
// variabelen initialiseren
$username = "geheim" ;
$password = "geheim" ;
$host = "localhost" ;
$dbnaam = "geheim" ;
$fout = "FOUT: openen database mislukt" ;
$query = "SELECT id, now, currentdate, datum_eind FROM leveranciers ORDER BY id" ;
// ---- einde initialisatie
?>
<html>
<head>
<title>Leveranciers</title>
<style>
body {
background-color: #FFFFCC;
}
.tekst_titel {
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
font-weight: bold;
color:#4E4110;
}
.tekst_titel_klein {
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
font-weight: bold;
color:#4E4110;
}
.tekst {
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color:#000000;
}
.tekstveld {
background-color: #FFEAB3;
font-size: 11px;
color: #2c4c64;
font-family: verdana;
border: 1px solid #2c4c64;
</style>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head>
<body>
<font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<table width="90%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#decb7b">
<tr>
<td width="25%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">ID</div></td>
<td width="25%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">datum van invoering</div></td>
<td width="25%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">deadline</div></td>
<td width="25%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">status</td>
</tr>
<tr>
<?php
$i = $id ;
$aTimeReplace = Array ( 'from' => Array ( ':' , '-' , ' ' ) , 'to' => Array ( ':' , '-' , '' ) ) ; $no = Str_Replace ( $aTimeReplace [ 'from' ] , $aTimeReplace [ 'to' ] , $now ) ; $d_end = Str_Replace ( $aTimeReplace [ 'from' ] , $aTimeReplace [ 'to' ] , $datum_eind ) ; $currentdate = time ( ) + ( 7 * 24 * 60 * 60 ) ;
<td class=\" tekst\" bgcolor=\" #F4ECCC\" class=\" tekst\" align=\" center\" width=\" 25%\" >$i </td>
<td class=\" tekst\" bgcolor=\" #efe3b5\" class=\" tekst\" width=\" 25%\" >$no </td>
<td class=\" tekst\" bgcolor=\" #efe3b5\" class=\" tekst\" width=\" 25%\" >$d_end </td>
" ) ;
?>
<td class="tekst" width=25%>
<?php
if ( ( empty ( $no ) ) and
$currentdate > ( $d_end - 2419200 ) ) {
echo "minder dan 1 maand" ; }
elseif ( ( empty ( $no ) ) and
$currentdate > ( $d_end - 4838400 ) ) {
echo "minder dan 2 maanden" ; }
elseif ( ( empty ( $no ) ) and
$currentdate > ( $d_end - 14515200 ) ) {
echo "minder dan 6 maanden" ; }
elseif ( ( empty ( $no ) ) and
$currentdate > ( $d_end - 24192000 ) ) {
}
{
}
?>
</td>
</tr>
<?php
}
?>
</table>
</font>
</body>
</html>
Kr4nKz1n
Onbekend Heb je mijn code gezien van mijn vorige post?
Kr4nKz1n
Onbekend welke dan?
Gust
MySQL interesse Dan krijg ik in de laatste kolim 2 x het volgend bericht:Warning: mktime() expects parameter 1 to be long, string given in /usr/www/users/dotserv/gazelle/leveranciers/index_if1.php on line 8
return MkTime($aDateTime[1][0], $aDateTime[1][1], $aDateTime[1][2], $aDateTime[0][1], $aDateTime[0][2], $aDateTime[0][0]);
}
return MkTime ( $aDateTime [ 1 ] [ 0 ] , $aDateTime [ 1 ] [ 1 ] , $aDateTime [ 1 ] [ 2 ] , $aDateTime [ 0 ] [ 1 ] , $aDateTime [ 0 ] [ 2 ] , $aDateTime [ 0 ] [ 0 ] ) ; }
Je kunt het zien op deze pagina
Kr4nKz1n
Onbekend Je zegt dat $no de waarde van $now moet krijgen.
Gust (laatste wijziging 25/09/2008 10:45)
MySQL interesse Dit is de database:
CREATE TABLE `mijn_tabel` (
`id` int(11) NOT NULL auto_increment,
`now` date default NULL,
`datum_eind` date default '0000-00-00',
`currentdate` time NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
#
# Gegevens worden uitgevoerd voor tabel `mijn_tabel`
#
INSERT INTO `mijn_tabel` VALUES (11, '2008-09-23', '2008-12-25', '00:00:00');
INSERT INTO `mijn_tabel` VALUES (12, '2008-09-23', '2008-10-01', '00:00:00');
INSERT INTO `mijn_tabel` VALUES (13, '2008-09-23', '2009-11-11', '00:00:00');
INSERT INTO `mijn_tabel` VALUES (15, NULL, '2007-09-23', '00:00:00');
INSERT INTO `mijn_tabel` VALUES (16, NULL, '2008-12-31', '00:00:00');
INSERT INTO `mijn_tabel` VALUES (17, '2008-09-24', '1997-12-12', '00:00:00');
INSERT INTO `mijn_tabel` VALUES (18, NULL, '2008-12-12', '00:00:00');
CREATE TABLE `mijn_tabel` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`now` date DEFAULT NULL ,
`datum_eind` date DEFAULT '0000-00-00' ,
`currentdate` time NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE= MyISAM AUTO_INCREMENT = 19 DEFAULT CHARSET= latin1 AUTO_INCREMENT = 19 ;
#
# Gegevens worden uitgevoerd voor tabel `mijn_tabel`
#
INSERT INTO `mijn_tabel` VALUES ( 11 , '2008-09-23' , '2008-12-25' , '00:00:00' ) ;
INSERT INTO `mijn_tabel` VALUES ( 12 , '2008-09-23' , '2008-10-01' , '00:00:00' ) ;
INSERT INTO `mijn_tabel` VALUES ( 13 , '2008-09-23' , '2009-11-11' , '00:00:00' ) ;
INSERT INTO `mijn_tabel` VALUES ( 15 , NULL , '2007-09-23' , '00:00:00' ) ;
INSERT INTO `mijn_tabel` VALUES ( 16 , NULL , '2008-12-31' , '00:00:00' ) ;
INSERT INTO `mijn_tabel` VALUES ( 17 , '2008-09-24' , '1997-12-12' , '00:00:00' ) ;
INSERT INTO `mijn_tabel` VALUES ( 18 , NULL , '2008-12-12' , '00:00:00' ) ;
De code zoals zoals m eerst was (dus wat wij aan het doen zijn): hier te bekijken
<?php //Hoef je niks aan te veranderen
Function DateToTime($sDate)
{
$aDateTime = Explode(' ', $sDate);
$aDateTime[0] = Explode('-', $aDateTime[0]);
$aDateTime[1] = Explode(':', $aDateTime[1]);
return MkTime($aDateTime[1][0], $aDateTime[1][1], $aDateTime[1][2], $aDateTime[0][1], $aDateTime[0][2], $aDateTime[0][0]);
}
$username = "geheim";
$password = "geheim";
$host="localhost";
$dbnaam="geheim";
$fout = "FOUT: openen database mislukt";
setlocale(LC_ALL,'nl_NL.ISO8859-1');
$query="SELECT id, now, currentdate, datum_eind FROM mijn_tabel ORDER BY id";
// ---- einde initialisatie
$db=mysql_connect($host, $username, $password);
mysql_select_db($dbnaam, $db) or die($fout);
$result = mysql_query($query) or die (mysql_error());
?>
<html>
<head>
<title>boeken</title>
<style>
body {
background-color: #FFFFCC;
}
.tekst_titel {
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
font-weight: bold;
color:#4E4110;
}
.tekst_titel_klein {
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
font-weight: bold;
color:#4E4110;
}
.tekst {
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color:#000000;
}
.tekstveld {
background-color: #FFEAB3;
font-size: 11px;
color: #2c4c64;
font-family: verdana;
border: 1px solid #2c4c64;
</style>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head>
<body>
<font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<table width="90%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#decb7b">
<tr>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">ID</div></td>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">huidige tijd</div></td>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">deadline</div></td>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center"><b><img src="images/save.gif" alt="bewerken" width="30" height="30"></b></div></td>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="2">includen</font></b></div></td>
</tr>
<tr class="tekst">
<?php while (list($id, $now, $datum_eind) =
mysql_fetch_row($result)){
$i=$id;
$no=$now;
$d_end=$datum_eind;
echo("
<td bgcolor=\"#F4ECCC\" class=\"tekst\" align=\"center\" width=\"20%\">$i</td>
<td bgcolor=\"#efe3b5\" class=\"tekst\" width=\"20%\">$no</td>
<td bgcolor=\"#efe3b5\" class=\"tekst\" width=\"20%\">$d_end</td>
<td bgcolor=\"#F4ECCC\"align=\"center\" width=\"20%\"><a href=\"time.php?id=$id\"><img src=\"images/save.gif\" width=\"20\" height=\"20\" border=\"0\"></a></td>
<td bgcolor=\"#F4ECCC\"align=\"center\" width=\"20%\">");
If(DateToTime($no) > DateToTime($d_end))
{
echo "Deadline verstreken";
}
Else
{
echo "Deadline is nog even weg";
}
echo("</td>
</tr>
\n");
}
?>
</table>
</body>
</html>
<?php //Hoef je niks aan te veranderen
Function DateToTime( $sDate )
{
$aDateTime [ 0 ] = Explode ( '-' , $aDateTime [ 0 ] ) ; $aDateTime [ 1 ] = Explode ( ':' , $aDateTime [ 1 ] ) ; return MkTime ( $aDateTime [ 1 ] [ 0 ] , $aDateTime [ 1 ] [ 1 ] , $aDateTime [ 1 ] [ 2 ] , $aDateTime [ 0 ] [ 1 ] , $aDateTime [ 0 ] [ 2 ] , $aDateTime [ 0 ] [ 0 ] ) ; }
$username = "geheim" ;
$password = "geheim" ;
$host = "localhost" ;
$dbnaam = "geheim" ;
$fout = "FOUT: openen database mislukt" ;
$query = "SELECT id, now, currentdate, datum_eind FROM mijn_tabel ORDER BY id" ;
// ---- einde initialisatie
?>
<html>
<head>
<title>boeken</title>
<style>
body {
background-color: #FFFFCC;
}
.tekst_titel {
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
font-weight: bold;
color:#4E4110;
}
.tekst_titel_klein {
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
font-weight: bold;
color:#4E4110;
}
.tekst {
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color:#000000;
}
.tekstveld {
background-color: #FFEAB3;
font-size: 11px;
color: #2c4c64;
font-family: verdana;
border: 1px solid #2c4c64;
</style>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head>
<body>
<font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<table width="90%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#decb7b">
<tr>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">ID</div></td>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">huidige tijd</div></td>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">deadline</div></td>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center"><b><img src="images/save.gif" alt="bewerken" width="30" height="30"></b></div></td>
<td width="20%" valign="top" bgcolor="#E9D896"><div align="center"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="2">includen</font></b></div></td>
</tr>
<tr class="tekst">
<?php while ( list ( $id , $now , $datum_eind ) =
$i = $id ;
$no = $now ;
$d_end = $datum_eind ;
<td bgcolor=\" #F4ECCC\" class=\" tekst\" align=\" center\" width=\" 20%\" >$i </td>
<td bgcolor=\" #efe3b5\" class=\" tekst\" width=\" 20%\" >$no </td>
<td bgcolor=\" #efe3b5\" class=\" tekst\" width=\" 20%\" >$d_end </td>
<td bgcolor=\" #F4ECCC\" align=\" center\" width=\" 20%\" ><a href=\" time.php?id=$id \" ><img src=\" images/save.gif\" width=\" 20\" height=\" 20\" border=\" 0\" ></a></td>
<td bgcolor=\" #F4ECCC\" align=\" center\" width=\" 20%\" >" ) ;
If ( DateToTime( $no ) > DateToTime( $d_end ) )
{
echo "Deadline verstreken" ; }
Else
{
echo "Deadline is nog even weg" ; }
</tr>
\n ") ;
}
?>
</table>
</body>
</html>
De code zoals ik hem veranderd heb, en hier te bekijken :
<?php
Function DateToTime($sDate){ $aDateTime = Explode(' ', $sDate); $aDateTime[0] = Explode('-', $aDateTime[0]); $aDateTime[1] = Explode(':', $aDateTime[1]); return MkTime($aDateTime[1][0], $aDateTime[1][1], $aDateTime[1][2], $aDateTime[0][1], $aDateTime[0][2], $aDateTime[0][0]);}
// variabelen initialiseren
$username = "geheim";
$password = "geheim";
$host="localhost";
$dbnaam="geheim";
$fout = "FOUT: openen database mislukt";
$query="SELECT id, now, currentdate, datum_eind FROM mijn_tabel ORDER BY id";
// ---- einde initialisatie
$db=mysql_connect($host, $username, $password);
mysql_select_db($dbnaam, $db) or die($fout);
$result = mysql_query($query) or die (mysql_error());
?>
<html>
<head>
<title>Leveranciers</title>
<style>
body {
background-color: #FFFFCC;
}
.tekst_titel {
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
font-weight: bold;
color:#4E4110;
}
.tekst_titel_klein {
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
font-weight: bold;
color:#4E4110;
}
.tekst {
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color:#000000;
}
.tekstveld {
background-color: #FFEAB3;
font-size: 11px;
color: #2c4c64;
font-family: verdana;
border: 1px solid #2c4c64;
</style>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head>
<body>
<font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<table width="90%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#decb7b">
<tr>
<td width="25%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">ID</div></td>
<td width="25%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">datum van invoering</div></td>
<td width="25%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">deadline</div></td>
<td width="25%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">status</td>
</tr>
<tr>
<?php
while (list($id, $now, $currentdate, $datum_eind) = mysql_fetch_row($result)){
$i=$id;
$aTimeReplace = Array('from' => Array(':', '-', ' '), 'to' => Array(':', '-', ''));
$no = Str_Replace($aTimeReplace['from'], $aTimeReplace['to'], $now);
$d_end = Str_Replace($aTimeReplace['from'], $aTimeReplace['to'], $datum_eind);
$currentdate = time() + (7 * 24 * 60 * 60);
echo("
<td class=\"tekst\" bgcolor=\"#F4ECCC\" class=\"tekst\" align=\"center\" width=\"25%\">$i</td>
<td class=\"tekst\" bgcolor=\"#efe3b5\" class=\"tekst\" width=\"25%\">$no</td>
<td class=\"tekst\" bgcolor=\"#efe3b5\" class=\"tekst\" width=\"25%\">$d_end</td>
");
?>
<td class="tekst" width=25%>
<?php
if((empty($no)) and ($currentdate > ($d_end - 2419200)))
{
echo "minder dan 1 maand";
}
elseif((empty($no)) and ($currentdate > ($d_end - 4838400)))
{
echo "minder dan 2 maanden";
}
elseif((empty($no)) and ($currentdate > ($d_end - 14515200)))
{
echo "minder dan 6 maanden";
}
elseif((empty($no)) and ($currentdate > ($d_end - 24192000)))
{
echo "Tijd genoeg";
}
elseif(!empty($no))
{
echo "ok";
}
?></td>
</tr>
<?php
}
?>
</table>
</font>
</body>
</html>
<?php
Function DateToTime
( $sDate ) { $aDateTime = Explode ( ' ' , $sDate ) ; $aDateTime [ 0 ] = Explode ( '-' , $aDateTime [ 0 ] ) ; $aDateTime [ 1 ] = Explode ( ':' , $aDateTime [ 1 ] ) ; return MkTime ( $aDateTime [ 1 ] [ 0 ] , $aDateTime [ 1 ] [ 1 ] , $aDateTime [ 1 ] [ 2 ] , $aDateTime [ 0 ] [ 1 ] , $aDateTime [ 0 ] [ 2 ] , $aDateTime [ 0 ] [ 0 ] ) ; }
// variabelen initialiseren
$username = "geheim" ;
$password = "geheim" ;
$host = "localhost" ;
$dbnaam = "geheim" ;
$fout = "FOUT: openen database mislukt" ;
$query = "SELECT id, now, currentdate, datum_eind FROM mijn_tabel ORDER BY id" ;
// ---- einde initialisatie
?>
<html>
<head>
<title>Leveranciers</title>
<style>
body {
background-color: #FFFFCC;
}
.tekst_titel {
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
font-weight: bold;
color:#4E4110;
}
.tekst_titel_klein {
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
font-weight: bold;
color:#4E4110;
}
.tekst {
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color:#000000;
}
.tekstveld {
background-color: #FFEAB3;
font-size: 11px;
color: #2c4c64;
font-family: verdana;
border: 1px solid #2c4c64;
</style>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head>
<body>
<font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<table width="90%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#decb7b">
<tr>
<td width="25%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">ID</div></td>
<td width="25%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">datum van invoering</div></td>
<td width="25%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">deadline</div></td>
<td width="25%" valign="top" bgcolor="#E9D896"><div align="center" class="tekst_titel">status</td>
</tr>
<tr>
<?php
$i = $id ;
$aTimeReplace = Array ( 'from' => Array ( ':' , '-' , ' ' ) , 'to' => Array ( ':' , '-' , '' ) ) ; $no = Str_Replace ( $aTimeReplace [ 'from' ] , $aTimeReplace [ 'to' ] , $now ) ; $d_end = Str_Replace ( $aTimeReplace [ 'from' ] , $aTimeReplace [ 'to' ] , $datum_eind ) ; $currentdate = time ( ) + ( 7 * 24 * 60 * 60 ) ;
<td class=\" tekst\" bgcolor=\" #F4ECCC\" class=\" tekst\" align=\" center\" width=\" 25%\" >$i </td>
<td class=\" tekst\" bgcolor=\" #efe3b5\" class=\" tekst\" width=\" 25%\" >$no </td>
<td class=\" tekst\" bgcolor=\" #efe3b5\" class=\" tekst\" width=\" 25%\" >$d_end </td>
" ) ;
?>
<td class="tekst" width=25%>
<?php
if ( ( empty ( $no ) ) and
( $currentdate > ( $d_end - 2419200 ) ) ) {
echo "minder dan 1 maand" ; }
elseif ( ( empty ( $no ) ) and
( $currentdate > ( $d_end - 4838400 ) ) ) {
echo "minder dan 2 maanden" ; }
elseif ( ( empty ( $no ) ) and
( $currentdate > ( $d_end - 14515200 ) ) ) {
echo "minder dan 6 maanden" ; }
elseif ( ( empty ( $no ) ) and
( $currentdate > ( $d_end - 24192000 ) ) ) {
}
{
}
?> </td>
</tr>
<?php
}
?>
</table>
</font>
</body>
</html>
Kr4nKz1n
Onbekend Ja precies in de database heb je al helemaal geen tijd meer in staan.
Gust (laatste wijziging 25/09/2008 13:07)
MySQL interesse Die currentdate was huidige tijd, maar dat kan ook weg zeker?
Kr4nKz1n (laatste wijziging 25/09/2008 13:22)
Onbekend
CREATE TABLE `mijn_tabel` (
`id` int(11) NOT NULL auto_increment,
`now` int(10) default NULL,
`deadline` int(10) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE `mijn_tabel` (
`id` int( 11 ) NOT NULL auto_increment,
`now` int( 10 ) default NULL ,
`deadline` int( 10 ) default NULL ,
) ENGINE= MyISAM AUTO_INCREMENT= 1 DEFAULT CHARSET= latin1 AUTO_INCREMENT= 1 ;
Edit id numeriek auto name naam van het project description beschrijving van het project deadline wanneer het project af moet zijn MkTime functie gooien
$iDeadline = MkTime($_POST['hour'], $_POST['minutes'], $_POST['seconds'], $_POST['month'], $_POST['day'], $_POST['year']);
$iDeadline = MkTime ( $_POST [ 'hour' ] , $_POST [ 'minutes' ] , $_POST [ 'seconds' ] , $_POST [ 'month' ] , $_POST [ 'day' ] , $_POST [ 'year' ] ) ;
Mysql_Query("INSERT INTO projects (name, description, deadline) VALUES ('".$_POST['name']."', '".$_POST['description']."', '".MkTime($_POST['hour'], $_POST['minutes'], $_POST['seconds'], $_POST['month'], $_POST['day'], $_POST['year'])."')");
Mysql_Query ( "INSERT INTO projects (name, description, deadline) VALUES ('" . $_POST [ 'name' ] . "', '" . $_POST [ 'description' ] . "', '" . MkTime ( $_POST [ 'hour' ] , $_POST [ 'minutes' ] , $_POST [ 'seconds' ] , $_POST [ 'month' ] , $_POST [ 'day' ] , $_POST [ 'year' ] ) . "')" ) ;
Gust (laatste wijziging 25/09/2008 13:36)
MySQL interesse Die $now (of $binnengebracht) dient voor het volgende:
Kr4nKz1n
Onbekend Uhmz wat is dan de waarde van $now?
Gust
MySQL interesse Dat is ook een datumveld.
if((empty($now)) and ($curdate < ($deadline - 2419200)))
{
echo "minder dan 1 maand";
}
if ( ( empty ( $now ) ) and
( $curdate < ( $deadline - 2419200 ) ) ) {
echo "minder dan 1 maand" ; }
Dit onderwerp is gesloten .
Wat is jouw favoriete javascript framework? (S: 18, R: 2)
Gesponsorde links
Vind ik zelf veel makkelijker. Vooral voor dit soort toepassingen.
Actiefste leden van de maand
