Audi
A1
A3
A4
A5
vs..
BMW
3.16
3.18
3.20
vs..
Aşağıdaki kod index.php
<?php
include "./appy/connectPDO.php";
$title = 'Free';
$sql = $db->prepare("SELECT id, ad FROM bolumListesi");
$sql->execute();
$liste = $sql->fetchAll(PDO::FETCH_ASSOC);
$myFavorites = $db->prepare("SELECT * FROM favorites WHERE ip = :ip");
$myFavorites->execute(["ip" => $_SERVER['REMOTE_ADDR']]);
$myFavorites = $myFavorites->fetchAll(PDO::FETCH_ASSOC);
$ids = [];
foreach($myFavorites as $item){
array_push($ids, $item['lesson_id']);
}
$ba = "(";
$idss = join(',',$ids);
$ba .= $idss. ')';
$sor = 'SELECT * FROM bolumListesi WHERE id IN '.$ba;
$lessons = $db->prepare($sor);
$lessons->execute();
$lessons = $lessons->fetchAll(PDO::FETCH_ASSOC);
?>
<?php include 'header.php'; ?>
<ul style="list-style:none;">
<?php foreach ($liste as $key => $item) {?>
<li style="width:100%;" class="list-group-item list-group-item-action list-group-item-primary rounded"><div><a href="<?php echo 'http://site.com.tr/donem-sec.php?bolumId='.$item['id'] ?>" class="" style="margin-top: -1px; margin-bottom: -1px; color:black; text-decoration:none; width:100%; display:block;"><?php echo $item['ad']; ?> </a>
</div>
</li>
<?php } ?>
</ul>
<?php if(count($liste) < 1) { ?>
<div class="alert alert-warning">
<strong>Hata!</strong> Ders bulunamadı.
</div>
<?php } ?>
<?php include 'footer.php'; ?>Buradaki de altkategori.php<?php
include "./appy/connectPDO.php";
$title = '<a href="site.com" style="color: white; font-size: 20px;"><i class="glyphicon glyphicon-home"></i></a>';
$backUrl = '/';
$bolumId = $_GET['bolumId'];
$sql = $db->prepare("SELECT id, ad FROM bolumListesi WHERE id = :id");
$sql->execute(['id' => $bolumId]);
$title = $sql->fetch(PDO::FETCH_ASSOC)['ad'];
$sql = $db->prepare("SELECT id, ad FROM dersListesi WHERE bolum_id = ?");
$sql->execute(array($bolumId));
$liste = $sql->fetchAll(PDO::FETCH_ASSOC);
?>
<?php include 'header.php'; ?>
<br>
<div class="list-group">
<ul style="list-style:none;">
<?php foreach ($liste as $key => $item) {?>
<li style="width:100%;" class="list-group-item list-group-item-action list-group-item-primary rounded"><div><a href="<?php echo 'http://site.com.tr/test-sec.php?donemId='.$item['id'].'&bolumId='.$bolumId ?>" class="" style="margin-top: -1px; margin-bottom: -1px; color:black; text-decoration:none; width:100%; display:block;"><?php echo $item['ad']; ?> </a>
<?php if(!in_array($item['id'],$ids)){ ?> <a href="ajax.php?addFavorite=1&lesson_id=<?=$item['id']?>&ref_url=<?=$bolumId?>" style="float:right; border:1px solid #ddd; border-radius:5px; padding:3px; color:white; background-color:#00008B; text-decoration:none; margin-top:-20px; z-index:999;">Favoriye Ekle</a>
<?}else{ ?>
<a href="ajax.php?removeFavorite=1&lesson_id=<?=$item['id']?>&ref_url=<?=$bolumId?>" style="float:right; border:1px solid #ddd; border-radius:5px; padding:3px; color:white; background-color:darkred; text-decoration:none; margin-top:-20px; z-index:999;">Favoriden Kaldır</a>
<?php } ?>
</div>
</li>
<?php } ?>
</ul>
</div>
<?php if(count($liste) < 1) { ?>
<div class="alert alert-warning">
<strong>Hata!</strong> Bu derse ait test bulunamadı.
</div>
<?php } ?>
<?php include 'footer.php'; ?>