Jinsi ya Kutengeneza Mfumo wa Download PDF na Excel kwa PHP

Jifunze kutengeneza system ya kudownload PDF na Excel kwa kutumia PHP. Mwongozo huu una code rahisi, maelezo ya hatua kwa hatua, na mifano ya kutumia libraries kama FPDF na PHPExcel au OpenPyXL.
Kwenye mifumo mingi ya shule, ofisi, fedha, mauzo, na ripoti, mara nyingi tunahitaji kupakua PDF au kupakua Excel.
Kwa kutumia PHP, unaweza kutengeneza mfumo wa kudownload PDF na Excel kwa urahisi sana.

Katika makala hii, tutajifunza:

✅ Kutengeneza PDF file kwa PHP
✅ Kutengeneza Excel file kwa PHP
✅ Code kamili tayari kutumia
✅ Namna ya kuunganisha na database

🧾 1. Kutengeneza PDF Download (PHP + FPDF)
👉 Hatua ya 1: Pakua FPDF

Pakua FPDF hapa:
https://www.fpdf.org/

Weka folder la fpdf/ ndani ya project yako.

👉 Code ya ku-generate PDF
<?php
require("fpdf/fpdf.php");

// Create PDF object
$pdf = new FPDF();
$pdf->AddPage();

// Set font
$pdf->SetFont("Arial", "B", 16);

// Title
$pdf->Cell(0, 10, "Ripoti ya Mauzo - PDF Example", 0, 1, "C");

// Body
$pdf->SetFont("Arial", "", 12);
$pdf->Cell(0, 10, "Hii ni ripoti yako ya mfumo.", 0, 1);

$pdf->Output("D", "report.pdf");
?>

👉 Matokeo

📄 PDF inashushwa moja kwa moja.

📊 2. Kutengeneza Excel Download (PHP + SimpleXLSXGen)
Njia rahisi kabisa (hakihitaji Composer)

Pakua library hapa:
https://github.com/shuchkin/simplexlsxgen

Weka file: SimpleXLSXGen.php kwenye project.

👉 Code ya Excel Download
<?php
require_once("SimpleXLSXGen.php");

// Sample data
$data = [
['Jina', 'Bidhaa', 'Kiasi', 'Bei'],
['Faustine', 'Peni', 12, 2400],
['Anna', 'Daftari', 5, 5000],
];

// Create Excel
$xlsx = SimpleXLSXGen::fromArray($data);

// Download file
$xlsx->downloadAs("report.xlsx");
?>

👉 Matokeo

📘 Excel file inashushwa moja kwa moja.

🔌 3. Kuunganisha na Database (Mfano)
<?php
$conn = mysqli_connect("localhost","root","","mauzo");

// Query data
$result = mysqli_query($conn, "SELECT jina, bidhaa, kiasi, bei FROM sales");

$data = [['Jina','Bidhaa','Kiasi','Bei']];

while ($row = mysqli_fetch_assoc($result)) {
$data[] = [$row['jina'], $row['bidhaa'], $row['kiasi'], $row['bei']];
}

// Generate Excel
require_once("SimpleXLSXGen.php");
$xlsx = SimpleXLSXGen::fromArray($data);
$xlsx->downloadAs("mauzo.xlsx");
?>

🔽 DEMO BUTTONS (kwa HTML)
<a href="download_pdf.php" class="btn">Download PDF</a>
<a href="download_excel.php" class="btn">Download Excel</a>

🔗 Links Za Kujifunza Zaidi

🌐 Faulink Official Website:
https://www.faulink.com/

📘 Jifunze Web Design & Programming:
https://www.faulink.com/excel_mifumo.php

📲 Piga / WhatsApp kwa msaada wa haraka:
https://wa.me/255693118509