Aşağıdaki tabloda Yazdığım soruları listeledim. Ben id e göre değilde sql deki sira tablosuna göre listelemek istiyorum. Sort ile yapmak gerekiyormuş ama ben tabloya bir türlü uygulayamadım. Yardımcı olabilecek arkadaş varmı.
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<div class="container-fluid">
<div class="row mb-2">
<div class="col-sm-6">
<h1>SIK SORULAN SORULAR</h1>
</div>
<div class="col-sm-6">
<ol class="breadcrumb float-sm-right">
</ol>
</div>
</div>
</div><!-- /.container-fluid -->
</section>
<?php
if (isset($_POST['save'])) {
if ($_POST['save'] == 1001) {
$title = ($_POST['title']);
$description = ($_POST['description']);
$sira = ($_POST['sira']);
$adddate = date('Y-m-d H:i:s');
$statu = ($_POST['statu'][0]);
$sql = "INSERT INTO qp_sss (title, description, sira, adddate, user_id, statu) VALUES (?,?,?,?,?,?)";
$args = [$title,$description,$sira,$adddate,$user_id,$statu];
$result = ($args);
print $adminclass->pdoInsert($sql,$result);
}
}
if (isset($_POST['update'])) {
if ($_POST['update'] == 1002) {
$id = $_POST['id'];
$title = $_POST['title'];
$description = $_POST['description'];
$statu = $_POST['statu'][0];
$sql = "UPDATE qp_sss SET title = ?,description = ?, sira = ?, statu = ? WHERE id = ?" ;
$args = [$title,$description,$sira,$statu,$id];
$args = $adminclass->getSecurity($args);
$variable = $adminclass->pdoPrepare($sql, $args);
if ($variable == 1) {
print '<div class="alert alert-success"> İşlem başarılı.</div>' ;
} else { print '<div class="alert alert-danger"> İşlem başarısız.</div>' ; }
}
}
if (isset($_POST['dataDelete'])) {
$delete_id = $_POST['dataDelete'];
$sql="DELETE FROM qp_sss WHERE id = ?";
$args = [$delete_id];
$result = $adminclass->pdoDelete($sql,$args);
print $result;
}
?>
<!-- Main content -->
<section class="content">
<div class="container-fluid">
<div class="row">
<div class="col-12">
<div class="card">
<div class="card-header">
<button type="button" class="btn btn-success" data-toggle="modal" data-target="#modal-default-newpost">
YENİ SORU EKLE
</button>
</div>
<!-- /.card-header -->
<div class="card-body">
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<th>id</th>
<th>Soru</th>
<th>Cevap</th>
<th>Sıra</th>
<th>Durum</th>
<th>Tarih</th>
<th>İşlem</th>
</tr>
</thead>
<tbody>
<?php $variable = $adminclass->getSSS(); if ($variable) { foreach ($variable as $value) { ?>
<tr>
<td><?php print html_entity_decode($value['id']); ?></td>
<td><?php print html_entity_decode($value['title']); ?></td>
<td><?php print html_entity_decode($value['description']); ?></td>
<td><?php print html_entity_decode($value['sira']); ?></td>
<td><?php print html_entity_decode($adminclass->getStatu($value['statu'])); ?></td>
<td><?php print html_entity_decode($value['adddate']); ?></td>
<td><button type="button" class="btn btn-danger" data-toggle="modal" data-target="#modal-default<?php print $value['id']; ?>">SİL</button>
<div class="modal fade" id="modal-default<?php print $value['id']; ?>">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title">Soru | SİL</h4>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<!-- general form elements disabled -->
<div class="card card-info">
<div class="card-header">
<h3 class="card-title"></h3>
</div>
<!-- /.card-header -->
<div class="card-body">
<form method="POST">
<input type="hidden" name="dataDelete" value="<?php print $value['id']; ?>">
<p><?php print $value['title']; ?> <b>- Bölümünü Silmek İstiyormusunuz ?</b></p>
<div class="modal-footer justify-content-between">
<button type="button" class="btn btn-success" data-dismiss="modal">VAZGEÇ</button>
<button type="submit" class="btn btn-danger">SİL</button>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
<button type="button" class="btn btn-warning" data-toggle="modal" data-target="#modal-default-update<?php print $value['id']; ?>">GÜNCELLE</button>
<div class="modal fade" id="modal-default-update<?php print $value['id']; ?>">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title">Soru | Güncelle</h4>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<!-- general form elements disabled -->
<div class="card card-info">
<div class="card-header">
<h3 class="card-title"></h3>
</div>
<!-- /.card-header -->
<div class="card-body">
<form method="POST">
<div class="row">
<div class="col-sm-12">
<!-- text input -->
<div class="form-group">
<label>Soru</label>
<input type="text" class="form-control" name="title" value="<?php print $value['title']; ?>">
</div>
</div>
</div>
<div class="row">
<div class="col-sm-12">
<!-- textarea -->
<div class="form-group">
<label>Cevap</label>
<textarea id="ckeditor" class="form-control" rows="5" name="description"><?php print $value['description']; ?></textarea>
</div>
</div>
</div>
<div class="form-group">
<label for="exampleSelectRounded0">Soru Sıra No </label>
<select class="custom-select rounded-0" id="exampleSelectRounded0" name="sira">
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
</select>
</div>
<div class="row">
<div class="col-sm-12">
<!-- select -->
<div class="form-group">
<label>Durum</label>
<select class="form-control" name="statu[]">
<option value="1">Aktif</option>
<option value="2">Pasif</option>
</select>
</div>
</div>
</div>
<div class="modal-footer justify-content-between">
<button type="button" class="btn btn-danger" data-dismiss="modal">VAZGEÇ</button>
<button type="submit" class="btn btn-success">KAYDET</button>
</div>
<input type="hidden" name="id" value="<?php print $value['id']; ?>">
<input type="hidden" name="update" value="1002">
</form>
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
<!-- general form elements disabled -->
</div>
</div>
<!-- /.modal-content -->
</div>
<!-- /.modal-dialog -->
</div>
<!-- /.modal -->
</td>
</tr>
<?php } } ?>
<thead>
<tr>
<th>id</th>
<th>Soru</th>
<th>Cevap</th>
<th>Sıra</th>
<th>Durum</th>
<th>Tarih</th>
<th>İşlem</th>
</tr>
</thead>
</tfoot>
</table>
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
</div>
<!-- /.col -->
</div>
<!-- /.row -->
</div>
<!-- /.container-fluid -->
</section>
<!-- /.content -->
</div>
<!-- /.content-wrapper -->
<div class="modal fade" id="modal-default-newpost">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title">Soru | Yeni Ekle</h4>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<!-- general form elements disabled -->
<div class="card card-info">
<div class="card-header">
<h3 class="card-title"></h3>
</div>
<!-- /.card-header -->
<div class="card-body">
<form method="POST">
<div class="row">
<div class="col-sm-12">
<!-- text input -->
<div class="form-group">
<label>Soru</label>
<input type="text" class="form-control" name="title">
</div>
</div>
</div>
<div class="row">
<div class="col-sm-12">
<!-- textarea -->
<div class="form-group">
<label>Cevap</label>
<textarea id="editor2" class="form-control" rows="5" name="description"></textarea>
</div>
</div>
</div>
<div class="form-group">
<label for="exampleSelectRounded0">Soru Sıra No </label>
<select class="custom-select rounded-0" id="exampleSelectRounded0" name="sira">
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
</select>
</div>
<div class="row">
<div class="col-sm-12">
<!-- select -->
<div class="form-group">
<label>Durum</label>
<select class="form-control" name="statu[]">
<option value="1">Aktif</option>
<option value="2">Pasif</option>
</select>
</div>
</div>
</div>
<div class="modal-footer justify-content-between">
<button type="button" class="btn btn-danger" data-dismiss="modal">VAZGEÇ</button>
<button type="submit" class="btn btn-success">KAYDET</button>
</div>
<input type="hidden" name="save" value="1001">
</form>
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
<!-- general form elements disabled -->
</div>
</div>
<!-- /.modal-content -->
</div>
<!-- /.modal-dialog -->
</div>
<!-- /.modal -->