Bağlanma
include("baglan.php");
Düzeltme
if ($duzelt)
mysql_query("update rehber set (ad=$ad,soyad=$soyad,adres=$adres,telefon=$telefon) where telefon='$tel1' ");
Silme
if ($sil)
if (mysql_query(" Delete from rehber WHERE telefon = '$telefon' ")) echo "silindi..."; else echo "silinemedi";
Gönderme
if ($gonder)
{
mysql_query("insert into rehber(ad,soyad,adres,telefon) values('$ad','$soyad','$adres','$telefon')");
}
Arama
<?
if ($ara)
{
$sorgu=mysql_query("select * from rehber where telefon=$aratext");
$satir=mysql_num_rows($sorgu);
$i=0;
$tel1=$aratext;
echo "<table border=1>
<tr>
<td>ad</td>
<td>soyad</td>
<td>adres</td>
<td>telefon</td>
</tr>
";
while ($i<$satir)
{
$ad2=mysql_result($sorgu,$i,"ad");
$soyad2=mysql_result($sorgu,$i,"soyad");
$adres2=mysql_result($sorgu,$i,"adres");
$telefon2=mysql_result($sorgu,$i,"telefon");
echo "
<tr>
<td>$ad2</td>
<td>$soyad2</td>
<td>$adres2</td>
<td>$telefon2</td>
</tr>";
$i++;
}
echo "</table>";
}
?>
Linkback: https://www.buyuknet.com/php-baglanma-duzeltme-silme-gonderme-arama-kodlari-t8203.0.html