şarlı listeleme
(15/02/2010 05:43)
arkadaslar ben combobox dan sectiğim herhangi bi field e göre veri tabanından lsitelemek istiyorum ..kodlar aşagıda
CODE:
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1254">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->
</script>
</head>
<body>
<table width="630" height="391" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="630" bgcolor="BEBEBE"><table width="630" height="391" border="0" cellpadding="1" cellspacing="1">
<tr>
<td width="630" valign="top" bgcolor="#FFFFFF"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="15"></td>
</tr>
<tr>
<td height="22" valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="67%" class="haberyaz1">İNSAN KAYNAKLARI YÖNETİMİ</td>
<td width="33%" class="haberyaz1"><div align="right"> </div></td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="96%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="1"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="D8D8D8"></td>
</tr>
<tr>
<td height="30"><table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="15"></td>
</tr>
<tr>
<td height="15" class="haberyaz1">Öğrenim durumuna görelistele <font color="#CC3300">
<select name="kategori" id="kategori" style="FONT-SIZE: 8pt; WIDTH: 145px";">
<option value="0" selected>Seçiniz</option>
<option value="1">İlk Okul Mezunu</option>
<option value="2">Orta Okul Mezunu</option>
<option value="3">Lise Mezunu</option>
<option value="4">Meslek Yüksek Okulu </option>
<option value="5">Lisans</option>
<option value="6">Yüksek Lisans</option>
<option value="7">Doktora</option>
</select>
</font></td>
</tr>
<tr>
<td height="15"></td>
</tr>
<tr>
<td height="15" class="haberyaz1">Talep edilen işe göre listele <font color="#CC3300">
<select name="select" id="select" style="FONT-SIZE: 8pt; WIDTH: 145px";">
<option value="0" selected>Seçiniz</option>
<option value="1">Hekim</option>
<option value="2">Hemşire</option>
<option value="3">ATT</option>
<option value="4">Sağlık Memuru</option>
<option value="5">Ebe</option>
<option value="6">Röntgen Tek.</option>
<option value="7">Anestezi Tek.</option>
<option value="8">Lab. Tek.</option>
<option value="9">Ortez Protez</option>
<option value="10">Tıbbi Sekreter</option>
<option value="11">Biyolog</option>
<option value="12">Banko-Hekim Asistanı</option>
<option value="13">Teknik Servis</option>
<option value="14">Bilgiişlem</option>
<option value="15">Muhasebe</option>
<option value="16">Şoför</option>
<option value="17">Güvenlik</option>
<option value="18">Temizlik</option>
<option value="19">Aşçı</option>
<option value="20">İnsan Kaynakları</option>
<option value="21">Resmi Yazı İşleri</option>
<option value="22">İstatistik</option>
<option value="23">Stok</option>
<option value="24">Satın Alma</option>
<option value="25">Turizm</option>
</select>
</font></td>
</tr>
<tr>
<td height="15"></td>
</tr>
<tr>
<td height="10"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="25"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="4%" class="haberyaz1"><div align="center"><strong>Sil</strong></div></td>
<td width="24%" height="25" class="haberyaz1"><div align="center"><strong>Tarih</strong></div></td>
<td width="72%" height="25" class="haberyaz1"><strong> İsim
Soyisim </strong></td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="E7E7E7"></td>
</tr>
</table>
<?
$max=1000;
if (!@$sayfa1) { $sayfa1=1;}
$alt=($sayfa1 - 1) * $max;
include("mysql.php");
$q = mysql_query("select * from isbasvuru where egitim1=$kategori ");
$w=mysql_num_rows($q);
$listele=mysql_query("select * from isbasvuru where egitim1=$kategori order by isid desc limit $alt,$max");
while($veri = mysql_fetch_array($listele))
{
$isid=$veri['isid'];
$adisoyadi=$veri['adisoyadi'];
$foto=$veri['foto'];
$cinsiyeti=$veri['cinsiyeti'];
$medenihali=$veri['medenihali'];
$dogumyt=$veri['dogumyt'];
$babaisimmeslek=$veri['babaisimmeslek'];
$kanboykilo=$veri['kanboykilo'];
$saglik=$veri['saglik'];
$evadresi=$veri['evadresi'];
$evcep=$veri['evcep'];
$tckimlik=$veri['tckimlik'];
$sskno=$veri['sskno'];
$vergino=$veri['vergino'];
$emekli=$veri['emekli'];
$egitim1=$veri['egitim1'];
$egitim2=$veri['egitim2'];
$egitim3=$veri['egitim3'];
$egitim4=$veri['egitim4'];
$egitim5=$veri['egitim5'];
$egitim6=$veri['egitim6'];
$egitim7=$veri['egitim7'];
$egitim8=$veri['egitim8'];
$isdurumu1=$veri['isdurumu1'];
$isdurumu2=$veri['isdurumu2'];
$isdurumu3=$veri['isdurumu3'];
$isdurumu4=$veri['isdurumu4'];
$isdurumu5=$veri['isdurumu5'];
$ayrilmasebeb=$veri['ayrilmasebeb'];
$talepgorev=$veri['talepgorev'];
$referans1=$veri['referans1'];
$referans2=$veri['referans2'];
$bil1=$veri['bil1'];
$bil2=$veri['bil2'];
$bil3=$veri['bil3'];
$bil4=$veri['bil4'];
$yabanci1=$veri['yabanci1'];
$yabanci2=$veri['yabanci2'];
$yabanci3=$veri['yabanci3'];
$surucu=$veri['surucu'];
$kurs1=$veri['kurs1'];
$kurs2=$veri['kurs2'];
$askerlik=$veri['askerlik'];
$sigara=$veri['sigara'];
$maas=$veri['maas'];
$dernek=$veri['dernek'];
$cocuk=$veri['cocuk'];
$aciklama=$veri['aciklama'];
$tarihmarih=$veri['tarihmarih'];
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="25"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="4%"><div align="center"><a href="index.php?sayfa=insansil&id=<? echo "$isid"; ?>"><img src="images/delete.gif" width="9" height="9" border="0"></a></div></td>
<td width="24%" height="25"><div align="center"><font class="haberyaz1"><? echo $tarihmarih; ?></font></div></td>
<td width="72%" height="25"><font class="haberyaz1"><? echo $adisoyadi; ?> -
<a href="#" class=haberyaz1 onClick="MM_openBrWindow('insangoster.php?isid=<? echo $isid; ?>','','scrollbars=yes,width=800,height=600')">Oku</a></font></font><font size="1" face="Verdana, Arial, Helvetica, sans-serif" class="yazib">
</font></font></font></td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" bgcolor="E7E7E7"></td>
</tr>
</table>
<?
}
?>
<p></p>
<p>
<?
$goster=$w/$max;
$goster=ceil($goster);
if ($goster>1) {
echo '<font size="1" color ="000000" class=haberyaz1><strong>Sayfalar :</strong></font> ';
for ($i=1;$i<=$goster;$i++) {
if ($sayfa1 == $i) echo "<b><font size='1' color='000000' class=haberyaz1><strong>[ $i ]</strong></font></b>";
else echo "[<a href=index.php?sayfa=insan&kat=$_GET[kat]&sayfa1=$i class='haberyaz1'>$i<a>] ";
}
}
?>
</td>
</tr>
<tr>
<td></td>
</tr>
</table></td>
</tr>
<tr>
<td height="20"></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
OFFLINE
New Coder 
Takip Et
Paylaş