connect_error) {
die("Conexiunea a eșuat: " . $conn->connect_error);
}
if (!isset($_SESSION['admin_logged_in'])) {
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$user = $_POST['username'];
$pass = md5($_POST['password']);
$sql = "SELECT * FROM admin WHERE username='$user' AND password='$pass'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
$_SESSION['admin_logged_in'] = true;
} else {
echo "Autentificare eșuată!
";
}
}
if (!isset($_SESSION['admin_logged_in'])) {
echo '';
exit();
}
}
$sql = "SELECT * FROM tranzactii ORDER BY created_at DESC";
$result = $conn->query($sql);
echo "Panou Admin - Tranzacții
";
echo "
| ID |
Nume |
Email |
Data |
Kilometraj |
Mașina |
Bon |
Cantitate |
Valoare |
Combustibil |
Plecare |
Destinații |
KM Totali |
";
while ($row = $result->fetch_assoc()) {
echo "
| {$row['id']} |
{$row['nume']} |
{$row['email']} |
{$row['datetime']} |
{$row['kilometraj']} |
{$row['masina']} |
{$row['bon']} |
{$row['cantitate']} |
{$row['valoare']} |
{$row['combustibil']} |
{$row['plecare']} |
{$row['destinatii']} |
{$row['total_km']} |
";
}
echo "
";
echo 'Exportă CSV | Logout';
$conn->close();
?>
query("SELECT * FROM tranzactii");
while ($row = $result->fetch_assoc()) {
fputcsv($output, $row);
}
fclose($output);
exit();
}
?>