Blog

CREATE TABLE expenses (
id INT AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(100),
amount DECIMAL(10,2),
type ENUM(‘Income’, ‘Expense’),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

<?php
$host = ‘localhost’;
$user = ‘root’;
$password = ”;
$db = ‘expense_tracker’;
$conn = new mysqli($host, $user, $password, $db);
if ($conn->connect_error) {
die(“Connection failed: ” . $conn->connect_error);
}
?>

<form method=”post” action=”save.php”>
<input type=”text” name=”title” placeholder=”Title” required><br><br>
<input type=”number” step=”0.01″ name=”amount” placeholder=”Amount” required><br><br>
<select name=”type”>
<option value=”Income”>Income</option>
<option value=”Expense”>Expense</option>
</select><br><br>
<input type=”submit” value=”Add Entry”>
</form>

<?php
include ‘db.php’;
$title = $_POST[‘title’];
$amount = $_POST[‘amount’];
$type = $_POST[‘type’];
$sql = “INSERT INTO expenses (title, amount, type) VALUES (‘$title’, ‘$amount’, ‘$type’)”;
$conn->query($sql);
header(“Location: list.php”);
?>

<?php
include ‘db.php’;
$result = $conn->query(“SELECT * FROM expenses ORDER BY created_at DESC”);
echo “<table style=’width:100%; border-collapse: collapse; border:1px solid #ccc;’>”;
echo “<tr style=’background:#3498db; color:white;’><th>Title</th><th>Amount</th><th>Type</th><th>Date</th></tr>”;
while($row = $result->fetch_assoc()) {
echo “<tr><td style=’padding:10px;’>”.$row[‘title’].”</td><td>”.$row[‘amount’].”</td><td>”.$row[‘type’].”</td><td>”.$row[‘created_at’].”</td></tr>”;
}
echo “</table>”;
?>

<!– Search Form –>
<form method=”get”>
<input type=”text” name=”search” placeholder=”Title দিয়ে খুঁজুন” style=”padding: 8px; width: 250px;”>
<input type=”submit” value=”Search” style=”padding: 8px 12px; background: #3498db; color: white; border: none;”>
</form>

 

<?php
include ‘db.php’;

$search = ”;
if (isset($_GET[‘search’])) {
$search = $conn->real_escape_string($_GET[‘search’]);
$query = “SELECT * FROM expenses WHERE title LIKE ‘%$search%’ ORDER BY created_at DESC”;
} else {
$query = “SELECT * FROM expenses ORDER BY created_at DESC”;
}

$result = $conn->query($query);

echo “<table style=’width:100%; border-collapse: collapse; border:1px solid #ccc;’>”;
echo “<tr style=’background:#3498db; color:white;’><th>Title</th><th>Amount</th><th>Type</th><th>Date</th></tr>”;
while($row = $result->fetch_assoc()) {
echo “<tr><td style=’padding:10px;’>” . $row[‘title’] . “</td><td>” . $row[‘amount’] . “</td><td>” . $row[‘type’] . “</td><td>” . $row[‘created_at’] . “</td></tr>”;
}
echo “</table>”;
?>

<!– Search Form –>
<form method=”get”>
<input type=”text” name=”search” placeholder=”Title দিয়ে খুঁজুন” style=”padding: 8px; width: 250px;”>
<input type=”submit” value=”Search” style=”padding: 8px 12px; background: #3498db; color: white; border: none;”>
</form>

 

<?php
include ‘db.php’;

$search = ”;
if (isset($_GET[‘search’])) {
$search = $conn->real_escape_string($_GET[‘search’]);
$query = “SELECT * FROM expenses WHERE title LIKE ‘%$search%’ ORDER BY created_at DESC”;
} else {
$query = “SELECT * FROM expenses ORDER BY created_at DESC”;
}

$result = $conn->query($query);

$total = 0;
$income = 0;
$expense = 0;

echo “<table style=’width:100%; border-collapse: collapse; border:1px solid #ccc;’>”;
echo “<tr style=’background:#3498db; color:white;’><th>Title</th><th>Amount</th><th>Type</th><th>Date</th></tr>”;
while($row = $result->fetch_assoc()) {
$amount = $row[‘amount’];
$type = strtolower($row[‘type’]);
if ($type == ‘income’) $income += $amount;
else if ($type == ‘expense’) $expense += $amount;
$total += ($type == ‘income’) ? $amount : -$amount;

echo “<tr><td style=’padding:10px;’>” . $row[‘title’] . “</td><td>” . $row[‘amount’] . “</td><td>” . $row[‘type’] . “</td><td>” . $row[‘created_at’] . “</td></tr>”;
}
echo “</table><br>”;

echo “<table style=’width:100%; border:2px solid #27ae60; background:#e8f5e9; padding:10px; margin-top:20px;’>”;
echo “<tr><th style=’text-align:left;’>✅ মোট ইনকাম</th><td>” . $income . ” ৳</td></tr>”;
echo “<tr><th style=’text-align:left;’>❌ মোট খরচ</th><td>” . $expense . ” ৳</td></tr>”;
echo “<tr><th style=’text-align:left;’> ব্যালেন্স</th><td>” . $total . ” ৳</td></tr>”;
echo “</table>”;
?>

<!– Google Charts Load –>
<script type=”text/javascript” src=”https://www.gstatic.com/charts/loader.js”></script>

<?php
include ‘db.php’;

// Pie Chart Data
$income = 0;
$expense = 0;
$res = $conn->query(“SELECT type, SUM(amount) as total FROM expenses GROUP BY type”);
while ($row = $res->fetch_assoc()) {
if (strtolower($row[‘type’]) == ‘income’) $income = $row[‘total’];
else $expense = $row[‘total’];
}

// Bar Chart Data (Month Wise)
$barData = [];
$res2 = $conn->query(“SELECT DATE_FORMAT(created_at, ‘%Y-%m’) as month, type, SUM(amount) as total FROM expenses GROUP BY month, type ORDER BY month ASC”);
while ($row = $res2->fetch_assoc()) {
$month = $row[‘month’];
$type = strtolower($row[‘type’]);
if (!isset($barData[$month])) $barData[$month] = [‘income’ => 0, ‘expense’ => 0];
$barData[$month][$type] = $row[‘total’];
}
?>

<script type=”text/javascript”>
google.charts.load(‘current’, {‘packages’:[‘corechart’]});
google.charts.setOnLoadCallback(drawCharts);

function drawCharts() {
// Pie Chart
var pieData = google.visualization.arrayToDataTable([
[‘Type’, ‘Amount’],
[‘Income’, <?= $income ?>],
[‘Expense’, <?= $expense ?>]
]);
var pieOptions = { title: ‘মোট হিসাব’, is3D: true };
var pieChart = new google.visualization.PieChart(document.getElementById(‘piechart’));
pieChart.draw(pieData, pieOptions);

// Bar Chart
var barData = google.visualization.arrayToDataTable([
[‘Month’, ‘Income’, ‘Expense’],
<?php
foreach ($barData as $month => $amounts) {
echo “[‘$month’, {$amounts[‘income’]}, {$amounts[‘expense’]}],”;
}
?>
]);
var barOptions = {
title: ‘মাসভিত্তিক ইনকাম ও খরচ’,
hAxis: {title: ‘Month’},
vAxis: {title: ‘Amount’},
colors: [‘#4caf50’, ‘#e53935’]
};
var barChart = new google.visualization.ColumnChart(document.getElementById(‘barchart’));
barChart.draw(barData, barOptions);
}
</script>

<!– ️ Chart Divs –>
<div id=”piechart” style=”width: 100%; height: 400px;”></div>
<div id=”barchart” style=”width: 100%; height: 450px;”></div>