listele.php

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

<?
$sunucu="localhost";
$kullanici="root";
$sifre="123456";
$veritabani="site";
 
$baglanti=mysql_connect($sunucu,$kullanici,$sifre);
//Sunucuya Baglan
 
$vt=mysql_select_db($veritabani,$baglanti);
//veritabanina baglan
 
$sql="select * from sayfalar";
$sorgu=mysql_query($sql,$baglanti);
//Tabloyu Seç
 
?>
<!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=iso-8859-1" />
<title>Sayfalari Listele</title>
</head>
 
<body>
<a href="ekleform.php">Ekle</a>
<br />
<br />
<?
while ($sayfa_dizi=mysql_fetch_array($sorgu)){
echo "<a href=duzenleform.php?id=".$sayfa_dizi["id"].">".
$sayfa_dizi["baslik"]."</a> - <a href=#sil>Sil</a><br>";
}
?>
</body>
</html>

duzenleform.php

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44

<?
$sunucu="localhost";
$kullanici="root";
$sifre="123456";
$veritabani="site";
 
$sayfa=$_GET["id"];
 
$baglanti=mysql_connect($sunucu,$kullanici,$sifre);
//Sunucuya Baglan
 
$vt=mysql_select_db($veritabani,$baglanti);
//veritabanina baglan
 
$sql="select * from sayfalar where id=$sayfa";
$sorgu=mysql_query($sql,$baglanti);
//Tabloyu Seç
 
 
$sayfa_dizi=mysql_fetch_array($sorgu);
?>
<!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=iso-8859-1" />
<title>D&uuml;zenl&#351;e</title>
</head>
<body>
<form id="form1" name="form1" method="post" action="duzenlegonder.php">
  <p>
    <input name="baslik" type="text" id="baslik" size="50" value="<?=$sayfa_dizi["baslik"]?>" />
</p>
  <p>
    <textarea name="metin" cols="50" rows="15" ><?=$sayfa_dizi["metin"]?></textarea>
</p>
  <p>
    <input type="submit" name="Submit" value="Düzenle" />
  </p>
  <input type="hidden" name="id" value="<?=$sayfa?>" />
</form>
 
 
</body>
</html>

duzenlegonder.php

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

<?
$sunucu="localhost";
$kullanici="root";
$sifre="123456";
$veritabani="site";
 
$sayfa=$_POST["id"];
$baslik=$_POST["baslik"];
$metin=$_POST["metin"];
 
$baglanti=mysql_connect($sunucu,$kullanici,$sifre);
//Sunucuya Baglan
 
$vt=mysql_select_db($veritabani,$baglanti);
//veritabanina baglan
 
$sql="update sayfalar set baslik='$baslik',metin='$metin' where id=$sayfa";
$sorgu=mysql_query($sql,$baglanti);
//Tabloyu Seç
 
?>
 
Eklendi!<br />
<a href="listele.php">Geridön</a>

ekleform.php

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

<!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=iso-8859-1" />
<title>Ekle</title>
</head>
<body>
<form id="form1" name="form1" method="post" action="eklegonder.php">
  <p>
    <input name="baslik" type="text" id="baslik" size="50" />
</p>
  <p>
    <textarea name="metin" cols="50" rows="15" ></textarea>
</p>
  <p>
    <input type="submit" name="Submit" value="Ekle" />
  </p>
</form>
 
 
</body>
</html>

eklegonder.php

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

<?
$sunucu="localhost";
$kullanici="root";
$sifre="123456";
$veritabani="site";
 
$baslik=$_POST["baslik"];
$metin=$_POST["metin"];
 
$baglanti=mysql_connect($sunucu,$kullanici,$sifre);
//Sunucuya Baglan
 
$vt=mysql_select_db($veritabani,$baglanti);
//veritabanina baglan
 
$sql="insert into sayfalar (baslik,metin) values ('$baslik','$metin')";
$sorgu=mysql_query($sql,$baglanti);
//Tabloyu Seç
 
?>
 
Eklendi!<br />
<a href="listele.php">Geridön</a>