exec($createQuery);
if (!$db->exec($createQuery)) {
die("Failed to create the 'invoices' table.");
}
$db->close();
} else {
$db = new SQLite3($dbFile2);
if (!$db) {
die("Database connection failed: " . $db->lastErrorMsg());
}
}
// Function to fetch and display data
function displayDataForDue($db) {
$query = "SELECT id, expensesName, expensesValue FROM expenses";
$result = $db->query($query);
while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
// if ($row['status'] == "unpaid") {
// $projectId = $row['invoicefull'];
// $formattedTotalValue = preg_replace("/[^0-9.]+/", "", $row['totalvalue']);
// echo "";
//echo "| " . $row['projectname'] . " | ";
// echo "" . $row['invoicefull'] . " | ";
// echo "" . $row['createdby'] . " | ";
// echo "" . $row['createdate'] . " | ";
// echo "R" . $formattedTotalValue ." | ";
// echo ' | ';
// echo ' | ';
// echo "
";
// }
}
}
function displayDataForPaid($db) {
$query = "SELECT id, projectname, invoicefull, createdby, createdate, totalvalue, status FROM figures";
$result = $db->query($query);
while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
if ($row['status'] == "paid") {
$projectId = $row['invoicefull'];
$formattedTotalValue1 = preg_replace("/[^0-9.]+/", "", $row['totalvalue']);
echo "";
echo "| " . $row['projectname'] . " | ";
echo "" . $row['invoicefull'] . " | ";
echo "" . $row['createdby'] . " | ";
echo "" . $row['createdate'] . " | ";
echo "R" . $formattedTotalValue1 ." | ";
echo ' | ';
echo ' | ';
echo "
";
}
}
}
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST["update"])) {
$updatedData = $_POST["updatedData"];
$projectId = $_POST["projectId"];
// $_SESSION['invoiceNumber'] = $invoiceNumber
}
?>