25
●1.617
<html>
<head><title>Arama Yapma </title>
</head><form action="aramaislem.php" name="ara" method="get">
<input type="text" name="aranacak_kelime">
<select name="sec">
<option value="adi">adi
<option value="soyadi">soyadi
<option value="sinif" selected>sinif
<option value="hepsinde">Hepsinde Ara
</select>
<input type="submit" name="ara" value="ara">
<br>
<br>
<br>
</form>
</html>aramaislem.php<?php // PHP Code Larımıza Başladık
mysql_connect("localhost","xxxxxxx","xxxxxxx");
mysql_select_db("xxxxxxx");
$aranacak_kelime = mysql_real_escape_string($_GET['aranacak_kelime']); /* Aranacak Kelimeyı arama.php den cektik */
$sec =$_GET['sec']; /*Selectte nereyı sectıyse ona gore arama komutunu sectık */
if($sec=="adi"){
$sql= mysql_query("SELECT * FROM deneme WHERE Ad like '%".$aranacak_kelime."%'");
}elseif($sec=="soyadi"){
$sql= mysql_query("SELECT * FROM deneme WHERE Soyad like '%".$aranacak_kelime."%'");
}elseif($sec=="sinif"){
$sql= mysql_query("SELECT * FROM deneme WHERE SinifNo like '%".$aranacak_kelime."%'");
}elseif($sec=="hepsinde"){
$sql= mysql_query("SELECT * FROM deneme WHERE Ad like '%".$aranacak_kelime."%' or Soyad like '%".$aranacak_kelime."%' or SinifNo like '%".$aranacak_kelime."%'");
}aramayı listeletme işini yapamadım :S
<table width="857" border="0">
<tr>
<th width="69" scope="col"> Numarası </th>
<th width="75" scope="col">Sınıf No </th>
<th width="116" scope="col"> Adı </th>
<th width="131" scope="col">Soyadı</th>
<th width="100" scope="col">Telefon No </th>
<th width="114" scope="col">Mobil No </th>
<th width="109" scope="col">Anne Mobil </th>
<th width="109" scope="col">Baba Mobil </th>
</tr>
<tr>
<th scope="row">05545</th>
<td>601</td>
<td>altan</td>
<td>sargın</td>
<td>023545465</td>
<td>065465451</td>
<td>456465065</td>
<td>46545416516</td>
</tr>
<tr>
<th scope="row">05454</th>
<td>501</td>
<td>altan</td>
<td>tolgalı</td>
<td>0545416</td>
<td>016541654165</td>
<td>540654065</td>
<td>046540654</td>
</tr>
</table>
<?php // PHP Code Larımıza Başladık
mysql_connect("localhost","xxxxxxx","xxxxxxx");
mysql_select_db("xxxxxxx");
$aranacak_kelime = mysql_real_escape_string($_GET['aranacak_kelime']); /* Aranacak Kelimeyı arama.php den cektik */
$sec =$_GET['sec']; /*Selectte nereyı sectıyse ona gore arama komutunu sectık */
if($sec=="adi"){
$sql= mysql_query("SELECT * FROM deneme WHERE Ad like '%".$aranacak_kelime."%'");
}elseif($sec=="soyadi"){
$sql= mysql_query("SELECT * FROM deneme WHERE Soyad like '%".$aranacak_kelime."%'");
}elseif($sec=="sinif"){
$sql= mysql_query("SELECT * FROM deneme WHERE SinifNo like '%".$aranacak_kelime."%'");
}elseif($sec=="hepsinde"){
$sql= mysql_query("SELECT * FROM deneme WHERE Ad like '%".$aranacak_kelime."%' or Soyad like '%".$aranacak_kelime."%' or SinifNo like '%".$aranacak_kelime."%'");
}
?>
<table>
<th width="69" scope="col"> Numarası </th>
<th width="75" scope="col">Sınıf No </th>
<th width="116" scope="col"> Adı </th>
<th width="131" scope="col">Soyadı</th>
<th width="100" scope="col">Telefon No </th>
<th width="114" scope="col">Mobil No </th>
<th width="109" scope="col">Anne Mobil </th>
<th width="109" scope="col">Baba Mobil </th>
<?
while($row = mysql_fetch_assoc($sql)) {?>
<tr>
<td><?=$row['numara'];?></td>
<td><?=$row['sinifno'];?></td>
<td><?=$row['ad'];?></td>
<td><?=$row['soyad'];?></td>
<td><?=$row['tel'];?></td>
<td><?=$row['mobil'];?></td>
<td><?=$row['anne'];?></td>
<td><?=$row['baba'];?></td>
</tr>
<? }?>
</table>bu işini görür heralde. tabi alan adlarına göre numara sınıfno vs vs değiştireceksin.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Untitled Document</title>
</head>
<body>
<form id="form2" name="form2" method="post" action="qw.php">
<label>
<input type="text" name="veri" />
<select name="select">
<option value="ogrencino">Öğrenci Numarası</option>
<option value="sinifno">Sınıf No</option>
<option value="adi" selected="selected">Adı</option>
<option value="soyadi">Soyadı</option>
</select>
</label>
<input type="submit" name="Submit" value="Ara" />
</form>
</body>
</html>ara.php<?php
$host = "localhost";
$db_n = "database";
$db_u = "kullanici";
$dn_p = "password";
$con = mysql_connect($host,$db_u,$db_p);
if(!$con) { die("Sql'e Baglanamadik"); }
$db = mysql_select_db($db_n,$con);
if(!$db) { die("Veritabani iliskilendirilemedi"); }
$ara = $_POST['text'];
$secim = $_POST['select'];
if($secim == "ogrencino") {
$anahtar = "OgrNo";
}elseif($secim == "sinifno"){
$anahtar = "SinifNo";
}elseif($secim == "adi"){
$anahtar = "Ad";
}elseif($secim == "soyadi"){
$anahtar = "Soyad";
}else{ die ("si@"); }
$sorgu = mysql_query("select * from tablom WHERE ".$anahtar." LIKE '%".$ara."%'");
?>
<table width="857" border="0">
<tr>
<th width="69" scope="col"> Numarası </th>
<th width="75" scope="col">Sınıf No </th>
<th width="116" scope="col"> Adı </th>
<th width="131" scope="col">Soyadı</th>
<th width="100" scope="col">Telefon No </th>
<th width="114" scope="col">Mobil No </th>
<th width="109" scope="col">Anne Mobil </th>
<th width="109" scope="col">Baba Mobil </th>
</tr>
<?php
while($veri = mysql_fetch_assoc($sorgu)){?>
<tr>
<th scope="row"><?php echo $veri[OgrNo]; ?></th>
<td><?php echo $veri[SinifNo]; ?></td>
<td><?php echo $veri[Ad]; ?></td>
<td><?php echo $veri[Soyad]; ?></td>
<td><?php echo $veri[Tel]; ?></td>
<td><?php echo $veri[Mobil]; ?></td>
<td><?php echo $veri[AnneMobil]; ?></td>
<td><?php echo $veri[BabaMobil]; ?></td>
</tr>
<?php } ?>
</table>denemedim ama sanirim calisir. Bu sadece ornek olarak verilmistir. Guvenlik Tedbirlerinizi aliniz.