Form adlı tablona "
durum" diye bi sutun aç. tipini
ENUMyap. Default Değerini
h yap.
SQL'i oluşturuken değer/sayı kısmına
'h','e' diye giriş yap.
Sonrada de bu kodları kullan.
<?php
$kul[0]['username']="admin";
$kul[0]['password']="123456";
// Dogrulama
function authenticate()
{
header( 'WWW-Authenticate: Basic realm="Yonetim Paneli"' );
header( 'HTTP/1.0 401 Unauthorized' );
echo '<br><br><br><body bgcolor=silver><b><font color=red size=2 face="Tahoma"><center>GiRiS YAPILMADI .. <a href="basvur/liste.php"><font color=darkgreen size=2 face="Tahoma">TEKRAR DENE</font></a></b> ';
exit;
}
if (!isset($_SERVER['PHP_AUTH_USER']) || !isset($_SERVER['PHP_AUTH_PW'])) { authenticate(); } else
{
for($i=0;$i<count($kul);$i++) { if($_SERVER['PHP_AUTH_USER']==$kul[$i]['username'] && $_SERVER['PHP_AUTH_PW']==$kul[$i]['password']){$auth=TRUE;}}
if($auth !=TRUE) {authenticate();}
}
include "db.php";
$sql = "SELECT * FROM form";
$sonuc = mysql_query($sql);
?><head><style type="text/css">
<!--
.style1 {
font-size: 11px;
font-family: Arial;
}
-->
</style></head>
<table width="100%" border="1" cellpadding="1" cellspacing="1" bordercolor="#0099FF">
<tr>
<tr>
<td ><div align='center'><strong>TC KIMLIK </strong></div></td>
<td ><div align='center'><strong>ADI</strong></div></td>
<td ><div align='center'><strong>SOYADI</strong></div></td>
<td ><div align='center'><strong>TELEFON</strong></div></td>
<td ><div align='center'><strong>OKULU</strong></div></td>
<td ><div align='center'><strong>DOGUM</strong></div></td>
<td ><div align='center'><strong>E-POSTA</strong></div></td>
<td ><div align='center'><strong>GRUP</strong></div></td>
<td ><div align="center"><strong>SAAT</strong></div></td>
<td ><div align='center'><strong>DURUM</strong></div></td>
</tr>
<?php while($veri = mysql_fetch_array($sonuc)){?>
<font color='#FF0000'><tr>
<td span class='style1'><?php echo $veri[tcno] ?></td>
<td span class='style1'><?php echo $veri[ad] ?></td>
<td span class='style1'><?php echo $veri[soyad] ?></td>
<td span class='style1'><?php echo $veri[telefon]?></td>
<td span class='style1'><?php echo $veri[okul] ?></td>
<td span class='style1'><?php echo $veri[dogum] ?></td>
<td span class='style1'><?php echo $veri[email] ?></td>
<td span class='style1'><?php echo $veri[grup] ?></td>
<td span class='style1'><?php echo $veri[saat] ?></td>
<td span class='style1'><?php if($veri[durum] == "e"){ ?>
<font color="#006600"><strong>OKUNDU</strong></font>
<?php } else { ?>OKUNMADI<?php }
mysql_query("UPDATE form SET durum='e' WHERE tcno = '".$veri['tcno']."'");
?>
</td>
</tr>
</font>
<?php } ?>
</table>
Kolay Gelsin
Semih VURAL