vt.php

<?php
$host="localhost";
$kullaniciadi="";
$sifresi="";
$vtadi="makale";

$baglanti=mysql_connect($host,$kullaniciadi,$sifresi) or die ("Mysql Bagkanadi");
mysql_select_db($vtadi,$baglanti) or die ("Vt Baglanamadi");
?>

index.php

<table width="100%" border="1">
  <tr>
    <td>Makale Baslıgı </td>
    <td>Eklenme Tarihi </td>
    <td>Okunma Sayısı </td>
  <td>Kategori </td>
  </tr>
 <?php
 include ("vt.php");
$sor=mysql_query("select * from yazilar");
while($yaz=mysql_fetch_array($sor)){
$id=$yaz['id'];
$baslik=$yaz['baslik'];
$hit=$yaz['hit'];
$tarih=$yaz['tarih'];
$katid=$yaz['katid'];

$katcek=mysql_fetch_array(mysql_query("select * from kategori where id='$katid'"));
$katadi=$katcek['katadi'];
 echo "<tr>
    <td><a href=makaleoku.php?id=$id>$baslik</a></td>
    <td>$tarih</td>
    <td>$hit</td>
    <td><a href=kategori.php?id=$katid>$katadi</a></td>
    ";
    
    }
    echo '
  </tr>
</table>';
?>


<table width="100%" border="1">
  <tr>
    <td><a href="makaleekle.php">Makale Ekleyin</a></td>
    <td><a href="kategoriekle.php">kategori Ekleyin</a></td>
    <td> </td>
  </tr>
</table>

makaleoku.php

<?php
include("vt.php");
$id=$_GET["id"];
$makalecek=mysql_fetch_array(mysql_query("select * from yazilar where id='$id'"));
$baslik=$makalecek['baslik'];
$makale=$makalecek['yazi_metni'];
$hit=$makalecek['hit'];
$tarih=$makalecek['tarih'];
$katid=$makalecek['katid'];

$hitguncelle=mysql_query("update yazilar SET hit=hit+10 where id='$id'");

$katcek=mysql_fetch_array(mysql_query("select * from kategori where id='$katid'"));
$katadi=$katcek['katadi'];
?>
<table width="100%" border="1">
  <tr>
    <td>Makale Başlığı </td>
    <td>:</td>
    <td><?php echo "$baslik"; ?></td>
  </tr>
  
  <tr>
    <td>Kategori</td>
    <td>:</td>
    <td><?php echo "$katadi"; ?></td>
  </tr>
  
  <tr>
    <td>Tarih</td>
    <td>:</td>
    <td><?php echo "$tarih"; ?></td>
  </tr>
  <tr>
    <td>Hit</td>
    <td>:</td>
    <td><?php echo "$hit"; ?></td>
  </tr>
  <tr>
    <td colspan="3" align="center">Makale</td>
  </tr>
  <tr>
    <td colspan="3" align="center"><?php echo "$makale"; ?></td>
  </tr>
</table>

makaleekle.php

<form id="form1" name="form1" method="post" action="makalekayit.php"><table width="100%" border="1">
  <tr>
    <td>Makale Başlığı</td>
    <td>:</td>
    <td>
      <input type="text" name="textfield" />
   
    </td>
  </tr>
  <tr>
    <td>Kategori Adı </td>
    <td>:</td>
    <td><select name="kategori">
    <?php
    include("vt.php");
    $sor=mysql_query("select * from kategori");
while($yaz=mysql_fetch_array($sor)){
$id=$yaz['id'];
$katadi=$yaz['katadi'];
echo "<option value=$id>$katadi</option>";
}
    ?>
</select>    
    </td>
  </tr>
  <tr>
    <td>Makale Metni</td>
    <td>:</td>
    <td><textarea name="makale" cols="25" rows="5"></textarea></td>
  </tr>
  <tr>
    <td colspan="3"><input type="submit" name="Submit" value="Makale Kaydet" /></td>
  </tr>
</table> </form>

kategori.php

<table width="100%" border="1">
  <tr>
    <td>Makale Baslıgı </td>
    <td>Eklenme Tarihi </td>
    <td>Okunma Sayısı </td>

  </tr>
  <?php
include("vt.php");
$id=$_GET["id"];

$katcek=mysql_query("select * from yazilar where katid='$id'");
while($yaz=mysql_fetch_array($katcek)){
$id=$yaz['id'];
$baslik=$yaz['baslik'];
$hit=$yaz['hit'];
$tarih=$yaz['tarih'];

echo "<tr>
    <td><a href=makaleoku.php?id=$id>$baslik</a></td>
    <td>$tarih</td>
    <td>$hit</td>
    
    ";
    
    }
    echo '
  </tr>
</table>';



?>

kategoriekle.php

<form id="form1" name="form1" method="post" action="kategorikayit.php"><table width="100%" border="1">
  <tr>
    <td>Kategori adı </td>
    <td>:</td>
    <td>
   
        <input type="text" name="kat" />    </td>
  </tr>
  <tr>
    <td colspan="3"><input name="" type="submit" value="Kaydet"/></td>
    </tr>
</table>   
</form>

kategorikayit.php

<?php

include ("vt.php");
$kategoriadi=$_POST["kat"];
$ekle=mysql_query("insert into kategori(katadi)value('$kategoriadi')");
if($ekle){
echo "$kategoriadi Adli Kategori Veritabanina Eklendi";
}else{
echo "$kategoriadi Adli Kategori Veritabanina Eklenemedi";
}

?>

makalekayit.php

<?php
include("vt.php");

$baslik=$_POST["textfield"];
$kategori=$_POST["kategori"];
$makale=$_POST["makale"];
$tarih=date("d/m/y");
$ekle=mysql_query("insert into yazilar(baslik,yazi_metni,tarih,katid)value('$baslik','$makale','$tarih','$kategori')");
if($ekle){
echo "Makale Veritanbanina Eklendi";
}else{
echo "Basarisiz Girisim Veritabani Yazilamadi";
}

?>

sql

-- phpMyAdmin SQL Dump
-- version 2.6.1-rc2
-- http://www.phpmyadmin.net
-- 
-- Sunucu: localhost
-- Çıktı Tarihi: Mart 18, 2008 at 07:50 PM
-- Server sürümü: 4.1.8
-- PHP Sürümü: 4.3.10
-- 
-- Veritabanı: `makale`
-- 

-- --------------------------------------------------------

-- 
-- Tablo yapısı : `kategori`
-- 

CREATE TABLE `kategori` (
  `id` int(11) NOT NULL auto_increment,
  `katadi` varchar(225) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Tablo döküm verisi `kategori`
-- 

INSERT INTO `kategori` VALUES (1, 'Aþk Þiirleri');
INSERT INTO `kategori` VALUES (2, 'Özel Gün Þiirleri');

-- --------------------------------------------------------

-- 
-- Tablo yapısı : `yazilar`
-- 

CREATE TABLE `yazilar` (
  `id` int(11) NOT NULL auto_increment,
  `baslik` varchar(225) NOT NULL default '',
  `yazi_metni` text NOT NULL,
  `tarih` varchar(225) NOT NULL default '',
  `hit` int(11) NOT NULL default '0',
  `katid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Tablo döküm verisi `yazilar`
-- 

INSERT INTO `yazilar` VALUES (1, 'Programlama Dili Net', '', '18/03/08', 6, 1);
INSERT INTO `yazilar` VALUES (2, 'Java Görsel dersler', 'Java Görsel dersleri Cok yaýnda 
programlamadili.net sitesinde',
 '18/03/08', 474, 2);
INSERT INTO `yazilar` VALUES (3, 'Asker Olda Gör', 'Bu Þiiri 
Dun okudum ama bugun unuttum arkadaslar', '18/03/08', 0, 1);