İNDEX.PHP
<?php
include("function.php");
include("tasarim/head.php");
$sinif= new sinif();
?>
<body id="page-top">
<!-- Page Wrapper -->
<div id="wrapper">
<!-- Sidebar -->
<ul class="navbar-nav bg-gradient-primary sidebar sidebar-dark accordion" id="accordionSidebar">
<!-- Sidebar - Brand -->
<a class="sidebar-brand d-flex align-items-center justify-content-center" href="index.html">
<div class="sidebar-brand-icon rotate-n-15">
<i class="fas fa-laugh-wink"></i>
</div>
<div class="sidebar-brand-text mx-3">SB Admin <sup>2</sup></div>
</a>
<!-- Divider -->
<hr class="sidebar-divider my-0">
<!-- Nav Item - Dashboard -->
<li class="nav-item">
<a class="nav-link" href="index.php">
<i class="fas fa-fw fa-tachometer-alt"></i>
<span>Anasayfa</span></a>
</li>
<!-- Divider -->
<hr class="sidebar-divider">
<!-- Heading -->
<div class="sidebar-heading">
Interface
</div>
<!-- Nav Item - Pages Collapse Menu -->
<li class="nav-item">
<a class="nav-link collapsed" href="#" data-toggle="collapse" data-target="#collapseTwo" aria-expanded="true" aria-controls="collapseTwo">
<i class="fas fa-fw fa-cog"></i>
<span>Açık Lise</span>
</a>
<div id="collapseTwo" class="collapse" aria-labelledby="headingTwo" data-parent="#accordionSidebar">
<div class="bg-white py-2 collapse-inner rounded">
<h6 class="collapse-header">Açık Lise Belgeleri</h6>
<a class="collapse-item" href="index.php?islem=dersler">Dersler</a>
<a class="collapse-item" href="index.php?islem=ogrencilistesi">Öğrenci Listesi</a>
</div>
</div>
</li>
<!-- Nav Item - Utilities Collapse Menu -->
<!-- Sidebar Toggler (Sidebar) -->
<div class="text-center d-none d-md-inline">
<button class="rounded-circle border-0" id="sidebarToggle"></button>
</div>
</ul>
<div class="container-fluid">
<?php
$islem=$_GET["islem"];
switch ($islem) {
case 'dersler':
$sinif->dersler();
break;
case 'ogrencilistesi':
$sinif->ogrencilistesi();
break;
case 'silson':
$sinif->silson();
break;
case 'ogrencilistesi':
$sinif->ogrencilistesi();
break;
default:
# code...
break;
}
?>
<div id="sonuc"></div>
</div>
<!-- /.container-fluid -->
</div>
<!-- End of Main Content -->
<!-- Footer -->
<?php
include("tasarim/footer.php");
?>FUNCTİON.PHP<?php
try {
$db=new PDO("mysql:host=localhost;dbname=eevrak;charset=utf8",'root','12345678');
} catch (PDOException $e) {
echo $e->getMessage();
}
class sinif {
public function dersler()
{
global $db;
$s="select * from dersler";
$ss=$db->prepare($s);
$ss->execute();
echo '<table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
<thead>
<tr>
<th>Ders Adı</th>
<th>Sil</th>
<th>Güncelle</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Ders Adı</th>
<th>Sil</th>
<th>Güncelle</th>
</tr>
</tfoot>
<tbody>
';
while($ok=$ss->fetch(PDO::FETCH_ASSOC)):
echo'<tr>
<td><button type="button" rel="'.$ok["id"].'" class=" aders btn btn-warning">'.$ok["ad"].'</button></td>
<td><button type="button" rel="'.$ok["id"].'" class="asil btn btn-danger">Sil</button></td>
<td><button rel="'.$ok["id"].'" class="aguncelle btn btn-info">Güncelle</button></td>
</tr>
';
endwhile;
echo' </tbody>
</table>';
}
public function ogrencilistesi()
{
global $db;
$dersid=$_POST["dersid"];
$s="select * from ogrencilistesi where dersid=$dersid";
$ss=$db->prepare($s);
$ss->execute();
while($ok=$ss->fetch(PDO::FETCH_ASSOC)):
echo $ok["ad"];
endwhile;
}
public function silson()
{
global $db;
$id=$_POST["silid"];
$s="delete from dersler where id=$id";
$ss=$db->prepare($s);
$ss->execute();
echo "silindi";
}
}
?>OZEL.JS
$(document).ready(function() {
$(".asil").click(function(){
var deger=$(this).attr("rel");
$.ajax({
url:"index.php?islem=silson",
type:"POST",
data:{
"silid":deger
},
success:function(){
window.location.reload();
}
})
})
$(".aders").click(function(){
var deger=$(this).attr("rel");
$.ajax({
url:"index.php?islem=ogrencilistesi",
type:"POST",
data:{
"dersid":deger
},
success:function(a){
$("#sonuc").html(a);
}
})
})
} );
[B][/B]