Merhabalar,
Aşağıda paylaşmış olduğum php sayfasının kod örneğinde veri tabanında bulunan içerikleri listelemekteyim. ancak bu listelemeyi giriş yapan kullanıcının CariKodu neyse veri tabanında sadece o cari koduna ait verileri listelemek istiyorum başaramadım. Nasıl yapabileceğim konusunda yardımcı olabilecek arkadaşlara şimdiden teşekkür ederim.
<?php
session_start();
require_once 'config/config.php';
require_once BASE_PATH . '/includes/auth_validate.php';
// Costumers class
require_once BASE_PATH . '/lib/Costumers/Costumers.php';
$costumers = new Costumers();
// Get Input data from query string
$search_string = filter_input(INPUT_GET, 'search_string');
$filter_col = filter_input(INPUT_GET, 'filter_col');
$order_by = filter_input(INPUT_GET, 'order_by');
// Per page limit for pagination.
$pagelimit = 15;
// Get current page.
$page = filter_input(INPUT_GET, 'page');
if (!$page) {
$page = 1;
}
// If filter types are not selected we show latest added data first
if (!$filter_col) {
$filter_col = 'id';
}
if (!$order_by) {
$order_by = 'Desc';
}
//Get DB instance. i.e instance of MYSQLiDB Librar
$db = getDbInstance();
$select = array('id', 'CariKodu', 'IrsaliyeNo', 'AliciFirma', 'UrunCinsi' , 'KapCinsi' , 'Adet' , 'IrsaliyeTarihi' , 'SonDurumu' , 'YuklemeTarihi' , 'TeslimTarihi');
//Start building query according to input parameters.
// If search string
if ($search_string) {
$db->orwhere('CariKodu', '%' . $search_string . '%', 'like');
$db->orwhere('IrsaliyeNo', '%' . $search_string . '%', 'like');
$db->orwhere('AliciFirma', '%' . $search_string . '%', 'like');
$db->orwhere('UrunCinsi', '%' . $search_string . '%', 'like');
$db->orwhere('KapCinsi', '%' . $search_string . '%', 'like');
$db->orwhere('Adet', '%' . $search_string . '%', 'like');
$db->orwhere('IrsaliyeTarihi', '%' . $search_string . '%', 'like');
$db->orwhere('SonDurumu', '%' . $search_string . '%', 'like');
$db->orwhere('YuklemeTarihi', '%' . $search_string . '%', 'like');
$db->orwhere('TeslimTarihi', '%' . $search_string . '%', 'like');
}
//If order by option selected
if ($order_by) {
$db->orderBy($filter_col, $order_by);
}
// Set pagination limit
$db->pageLimit = $pagelimit;
// Get result of the query.
$rows = $db->arraybuilder()->paginate('customers', $page, $select);
$total_pages = $db->totalPages;
include BASE_PATH . '/includes/header.php';
?>
<!-- Main container -->
<div id="page-wrapper">
<div class="row">
<div class="col-lg-6">
<h1 class="page-header">Customers</h1>
</div>
<div class="col-lg-6">
<div class="page-action-links text-right">
<a href="add_customer.php?operation=create" class="btn btn-success"><i class="glyphicon glyphicon-plus"></i> Add new</a>
</div>
</div>
</div>
<?php include BASE_PATH . '/includes/flash_messages.php';?>
<!-- Filters -->
<div class="well text-center filter-form">
<form class="form form-inline" action="">
<label for="input_search">Search</label>
<input type="text" class="form-control" id="input_search" name="search_string" value="<?php echo xss_clean($search_string); ?>">
<label for="input_order">Order By</label>
<select name="filter_col" class="form-control">
<?php
foreach ($costumers->setOrderingValues() as $opt_value => $opt_name):
($order_by === $opt_value) ? $selected = 'selected' : $selected = '';
echo ' <option value="' . $opt_value . '" ' . $selected . '>' . $opt_name . '</option>';
endforeach;
?>
</select>
<select name="order_by" class="form-control" id="input_order">
<option value="Asc" <?php
if ($order_by == 'Asc') {
echo 'selected';
}
?> >Asc</option>
<option value="Desc" <?php
if ($order_by == 'Desc') {
echo 'selected';
}
?>>Desc</option>
</select>
<input type="submit" value="Go" class="btn btn-primary">
</form>
</div>
<hr>
<!-- //Filters -->
<div id="export-section">
<a href="export_customers.php"><button class="btn btn-sm btn-primary">Export to CSV <i class="glyphicon glyphicon-export"></i></button></a>
</div>
<!-- Table -->
<table class="table table-striped table-bordered table-condensed">
<thead>
<tr>
<th width="5%">Cari Kodu</th>
<th width="10%">İrsaliye No</th>
<th width="10%">Alıcı Adı</th>
<th width="30%">Ürün Cinsi</th>
<th width="5%">Kap Cinsi</th>
<th width="3%">Adet</th>
<th width="10%">İrs. Tarihi</th>
<th width="10%">Son Durumu</th>
<th width="10%">Yükleme Tarihi</th>
<th width="10%">Teslim Tarihi</th>
</tr>
</thead>
<tbody>
<?php foreach ($rows as $row): ?>
<tr>
<td><?php echo xss_clean($row['CariKodu']); ?></td>
<td><?php echo xss_clean($row['IrsaliyeNo']); ?></td>
<td><?php echo xss_clean($row['AliciFirma']); ?></td>
<td><?php echo xss_clean($row['UrunCinsi']); ?></td>
<td><?php echo xss_clean($row['KapCinsi']); ?></td>
<td><?php echo xss_clean($row['Adet']); ?></td>
<td><?php echo xss_clean($row['IrsaliyeTarihi']); ?></td>
<td><?php echo xss_clean($row['SonDurumu']); ?></td>
<td><?php echo xss_clean($row['YuklemeTarihi']); ?></td>
<td><?php echo xss_clean($row['TeslimTarihi']); ?></td>
<!--<td>
<a href="edit_customer.php?customer_id=<?php echo $row['id']; ?>&operation=edit" class="btn btn-primary"><i class="glyphicon glyphicon-edit"></i></a>
<a href="#" class="btn btn-danger delete_btn" data-toggle="modal" data-target="#confirm-delete-<?php echo $row['id']; ?>"><i class="glyphicon glyphicon-trash"></i></a>
</td>-->
</tr>
<!-- Delete Confirmation Modal -->
<div class="modal fade" id="confirm-delete-<?php echo $row['CariKodu']; ?>" role="dialog">
<div class="modal-dialog">
<form action="delete_customer.php" method="POST">
<!-- Modal content -->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title">Confirm</h4>
</div>
<div class="modal-body">
<input type="hidden" name="del_id" id="del_id" value="<?php echo $row['id']; ?>">
<p>Are you sure you want to delete this row?</p>
</div>
<div class="modal-footer">
<button type="submit" class="btn btn-default pull-left">Yes</button>
<button type="button" class="btn btn-default" data-dismiss="modal">No</button>
</div>
</div>
</form>
</div>
</div>
<!-- //Delete Confirmation Modal -->
<?php endforeach;?>
</tbody>
</table>
<!-- //Table -->
<!-- Pagination -->
<div class="text-center">
<?php echo paginationLinks($page, $total_pages, 'customers.php'); ?>
</div>
<!-- //Pagination -->
</div>
<!-- //Main container -->
<?php include BASE_PATH . '/includes/footer.php';?>
