require_once('./files/header.php');
?>
$UserID = $user->GetData('UserID');
$stmt = $pdo->prepare('SELECT * FROM orders WHERE OrderUserID = :OrderUserID');
$stmt->bindParam(':OrderUserID', $UserID);
$stmt->execute();
echo $stmt->rowCount();
?>
Hesap Siparişleri
$stmt = $pdo->prepare('SELECT * FROM products');
$stmt->execute();
echo $stmt->rowCount();
?>
Servisler
$stmt = $pdo->prepare('SELECT * FROM orders');
$stmt->execute();
echo $stmt->rowCount();
?>
Toplam Siparişler
$stmt = $pdo->prepare('SELECT * FROM users');
$stmt->execute();
echo $stmt->rowCount();
?>
Toplam Kullanıcılar
Hesap Geçmiş Siparişleri
$UserID = $user->GetData('UserID');
$stmt = $pdo->prepare('SELECT * FROM orders WHERE OrderUserID = :OrderUserID ORDER BY OrderDate DESC');
$stmt->bindParam(':OrderUserID', $UserID);
$stmt->execute();
if($stmt->rowCount() > 0) {
?>
Siparişin Servisi
Sipariş Miktarı
Sipariş Ücreti
Sipariş Linki
Sipariş Zamanı
Sipariş Durumu
$html = '';
foreach($stmt->fetchAll() as $row) {
$html .= '';
$html .= ''.$product->GetData($row['OrderProductID'], 'ProductName').' ';
$html .= ''.$row['OrderQuantity'].' ';
$html .= 'TL'.round($row['OrderAmount'], 2).' ';
$html .= ''.$row['OrderLink'].' ';
$html .= ''.date('d M, Y h:I:s', $row['OrderDate']).' ';
$html .= ''.$row['OrderStatus'].'. ';
$html .= ' ';
}
echo $html;
?>
} else {
$display->ReturnInfo('Daha önce hiç sipariş vermediniz.');
}
?>
require_once('./files/footer.php');
?>