query("SELECT value FROM bills WHERE payer='$you'");
$ar = $q->fetchAll(PDO::FETCH_COLUMN);
$totalowed = array_sum($ar) / 300;
$q = $db->query("SELECT value FROM payments WHERE who='$other' AND receiver='$you'");
$ar = $q->fetchAll(PDO::FETCH_COLUMN);
$totalowed -= (array_sum($ar) / 100);
$q = $db->query("SELECT value FROM bills WHERE payer='$other'");
$ar = $q->fetchAll(PDO::FETCH_COLUMN);
$totalowed -= array_sum($ar) / 300;
$q = $db->query("SELECT value FROM payments WHERE who='$you' AND receiver='$other'");
$ar = $q->fetchAll(PDO::FETCH_COLUMN);
$totalowed += array_sum($ar) / 100;
// not interested in negative values
if ($totalowed <= 0)
{
$totalowed = 0;
}
return "£" . sprintf("%01.2f", $totalowed);
}
?>
Bill Payer system
Bill Payer system
Value must be a number. Please press back and try again.";
die();
}
$s = "INSERT INTO bills(`date`,`payer`,`description`,`value`) VALUES(datetime('now'), " . $db->quote($_POST['who']) . ", " . $db->quote($_POST['description']) . ", " . ($_POST['amount'] * 100) . ")";
if ($db->exec($s) === FALSE)
{
$error = $db->errorInfo();
echo "An error has occured. " . var_dump($error) . "
";
echo "$s
";
die();
}
else
{
echo "Done.
";
}
}
elseif ($_POST['action'] == 'addpayment')
{
if (!filter_input(INPUT_POST, 'amount', FILTER_VALIDATE_FLOAT))
{
echo "Value must be a number. Please press back and try again.
";
die();
}
var_dump($_POST);
$s = "INSERT INTO payments(`date`,`who`,`receiver`,`value`) VALUES(datetime('now'), " . $db->quote($_POST['who']) . ", " . $db->quote($_POST['receiver']) . ", " . ($_POST['amount'] * 100) . ")";
if ($db->exec($s) === FALSE)
{
$error = $db->errorInfo();
echo "An error has occured. " . var_dump($error) . "
";
echo "$s
";
die();
}
else
{
echo "Done.
";
}
}
}
?>
Summary
| |
Rich |
Chris |
Matthew |
| Rich owes |
— |
|
|
| Chris owes |
|
— |
|
| Matthew owes |
|
|
— |
Add Bill
Add Payment
Statement
Bills
| Date |
Paid By |
Description |
Value |
query("SELECT date,payer,description,value FROM bills ORDER BY date DESC");
while ($row = $q->fetch())
{ ?>
|
|
|
£ |
Payments
| Date |
From |
To |
Value |
query("SELECT date,who,receiver,value FROM payments ORDER BY date DESC");
while ($row = $q->fetch())
{ ?>
|
|
|
£ |