alert('$message');
window.location.href = '$redirectUrl';
";
exit();
} else {
setcookie($_COOKIE["username"], '', time() - 3600, '/');
header("Location: https://blackhoundenterprises.com/test/invoices/index.php");
exit();
}
}
} else {
setcookie($_COOKIE["username"], '', time() - 3600, '/');
header("Location: https://blackhoundenterprises.com/test/invoices/index.php");
exit();
}
if(isset($_GET['logout']) && $_GET['logout'] == 1) {
// Delete the cookie by setting its expiration time to a past value
setcookie("username", $_COOKIE["username"], time() - 3600, '/');
// Redirect to the login page or any other page
header("Location: https://blackhoundenterprises.com/test/invoices/index.php");
exit();
}
?>
Client Information
POSSIBLE LEADS
| Name |
Email |
Phone Number |
Company |
exec("ATTACH DATABASE '{$dbFile}' AS encrypted KEY '{$key}'");
$db->exec("CREATE TABLE clients (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT,
email TEXT,
phone TEXT,
company TEXT)");
// Detach the encrypted database
$db->exec("DETACH DATABASE encrypted");
} else {
// Connect to existing encrypted database
$db = new SQLite3($dbFile);
$db->exec("ATTACH DATABASE '{$dbFile}' AS encrypted KEY '{$key}'");
}
// Handle POST requests
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
if ($_POST['action'] === 'add') {
$name = $_POST['name'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$company = $_POST['company'];
$stmt = $db->prepare("INSERT INTO clients (name, email, phone, company) VALUES (:name, :email, :phone, :company)");
$stmt->bindValue(':name', $name, SQLITE3_TEXT);
$stmt->bindValue(':email', $email, SQLITE3_TEXT);
$stmt->bindValue(':phone', $phone, SQLITE3_TEXT);
$stmt->bindValue(':company', $company, SQLITE3_TEXT);
$stmt->execute();
} elseif ($_POST['action'] === 'delete') {
$name = $_POST['name'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$company = $_POST['company'];
$stmt = $db->prepare("DELETE FROM clients WHERE name = :name AND email = :email AND phone = :phone AND company = :company");
$stmt->bindValue(':name', $name, SQLITE3_TEXT);
$stmt->bindValue(':email', $email, SQLITE3_TEXT);
$stmt->bindValue(':phone', $phone, SQLITE3_TEXT);
$stmt->bindValue(':company', $company, SQLITE3_TEXT);
$stmt->execute();
}
}
// Retrieve data from the encrypted database
$result = $db->query("SELECT name, email, phone, company FROM clients");
// Display data in a table
while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
echo "
| {$row['name']} |
{$row['email']} |
{$row['phone']} |
{$row['company']} |
";
}
// Close the database connection
$db->exec("DETACH DATABASE encrypted");
$db->close();
?>