Merhaba,
Referanslar sayfasında, referans eklediğimde aşağıda listeleme yapması gerekiyor fakat 115. satırda $query = $adminclass->pdoQuery($sql); satırında hata veriyor. Yazım yanlışı mı var ?
<!-- 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>Referanslar</h1>
</div>
</div>
</div><!-- /.container-fluid -->
</section>
<!-- Main content -->
<section class="content">
<div class="container-fluid">
<div class="row">
<!-- left column -->
<div class="col-sm-12">
<?php
if (isset($_POST['save'])) {
if ($_POST['save']==1001){
$title = $_POST['title'];
$description = $_POST['description'];
$image = 'images/'.$_FILES['images']['name'];
$adddate = date('Y-m-d H:i:s');
$user_id = 1;
$statu = $_POST['statu'][0];
$image_tmp = $_FILES['images']['tmp_name'];
if (file_exists ($image)) {
print '<div class="alert alert-danger"> Aynı isimde dosya mevcut.</div>';
} else {
move_uploaded_file($image_tmp, $image);
$sql = "INSERT INTO qp_referanslar(title, description, image, adddate, user_id, statu) VALUES (?,?,?,?,?,?)";
$args = [$title, $description, $image, $adddate, $user_id, $statu];
$args = $adminclass->getSecurity($args);
$query = $adminclass->pdoPrepare($sql, $args);
if ($query) {
print '<div class="alert alert-success">İşlem Başarılı.</div>';
header("refresh:2;url=referanslar");
} else { print '<div class="alert alert-danger">İşlem Başarısız.</div>'; }
}
}
} ?>
<div class="card card-info">
<div class="card-header">
<h3 class="card-title">Referans Ekle</h3>
</div>
<form method="post" enctype="multipart/form-data">
<div class="card-body">
<div class="form-group">
<label>Başlık</label>
<input type="text" class="form-control" name="title">
</div>
<div class="form-group">
<label>Açıklama</label>
<textarea class="form-control rows="3" name="description""></textarea>
</div>
<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 class="form-group">
<label>Resim</label>
<div class="input-group">
<div class="custom-file">
<input type="file" name="images" >
</div>
</div>
</div>
</div>
<!-- /.card-body -->
<input type="hidden" name="save" value="1001">
<div class="card-footer">
<button type="submit" class="btn btn-success">Kaydet</button>
</div>
</form>
</div>
<!-- /.card -->
<div class="card">
<div class="card-header">
<h3 class="card-title">Referans Listesi</h3>
</div>
<!-- /.card-header -->
<div class="card-body">
<table id="example2" class="table table-bordered table-hover">
<thead>
<tr>
<th>id</th>
<th>Başlık</th>
<th>Açıklama</th>
<th>Resim</th>
<th>Durum</th>
<th>İşlem</th>
</tr>
</thead>
<tbody>
<?php
$sql = "SELECT * FROM qp_referanslar";
$query = $adminclass->pdoQuery($sql);
if ($query) {
foreach ($query as $value) {
?>
<tr>
<td><?php print $value['id']; ?></td>
<td><?php print $value['title']; ?></td>
<td><?php print $value['description']; ?></td>
<td><img src="<?php print $value['image']; ?>"</td>
<td><?php print $value['statu']; ?></td>
<td></td>
</tr>
<?php }} ?>
</tbody>
<tfoot>
<tr>
<th>id</th>
<th>Başlık</th>
<th>Açıklama</th>
<th>Resim</th>
<th>Durum</th>
<th>İşlem</th>
</tr>
</tfoot>
</table>
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
</div>
</div>
<!-- /.row -->
</div><!-- /.container-fluid -->
</section>
<!-- /.content -->
</div>
<!-- /.content-wrapper -->
