Practical - 11 IWD

 

AIM : Salary Slip Generation in PDF Format

Using TCPDF Library

salary_slip.php

require_once('tcpdf/tcpdf.php');
include "db.php";

$emp_id = 1;
$q = mysqli_query($conn,"SELECT * FROM employees WHERE emp_id=$emp_id");
$row = mysqli_fetch_assoc($q);

$pdf = new TCPDF();
$pdf->AddPage();

$html = "
<h2 align='center'>Salary Slip</h2>
<hr>
Employee Name: {$row['name']}<br>
Department: {$row['department']}<br>
Salary: {$row['salary']}<br>
";

$pdf->writeHTML($html);
$pdf->Output('salary_slip.pdf','I');

Comments

Post a Comment

Popular posts from this blog

Unit I - Introduction to PHP

  1. Introduction to PHP 1.1 Introduction to Static and Dynamic Websites Static Website Content is fixed and does not change automatically. Created using HTML and CSS . Same content is shown to all users. Example: A college notice page written only in HTML. < h1 >Welcome to Our College </ h1 > < p >Admission Open </ p > Dynamic Website Content changes based on user interaction or database. Uses server-side languages like PHP . Can display different data to different users. Example: Login system, online result system, feedback form. 1.2 Introduction to PHP and Its History PHP stands for Hypertext Preprocessor . It is a server-side scripting language . PHP code runs on the server and sends output to the browser as HTML. History of PHP Created by Rasmus Lerdorf in 1994 . Initially called Personal Home Page . Later developed into a powerful web development language. Widely used with MySQL for database-d...
Read more

Practical - 1 IWD

  Aim To install and configure PHP, Web Server, and MySQL database using XAMPP / WAMP / LAMP / MAMP and create a web page to display “Hello World” . Software Required XAMPP / WAMP / LAMP / MAMP Web Browser (Chrome / Firefox) Text Editor (Notepad / VS Code) Theory PHP is a server-side scripting language. Apache is a web server. MySQL is a relational database. XAMPP / WAMP / LAMP / MAMP are software packages that provide: Web Server (Apache) PHP MySQL phpMyAdmin Installation and Configuration Steps Using XAMPP (Windows / Linux / macOS) Step 1: Download XAMPP Download XAMPP installer from official website. Run the installer and select: Apache MySQL PHP phpMyAdmin Step 2: Install XAMPP Follow installation wizard. Default installation path: C:\xampp\ Step 3: Start Services Open XAMPP Control Panel Start: Apache MySQL ✔ Green indicator confirms successful start. Step 4: Verify Ins...
Read more

Practical - 10 IWD

  Aim : Employee Management System using PHP & MySQL Database Creation CREATE DATABASE employee_db; USE employee_db; CREATE TABLE employees ( emp_id INT AUTO_INCREMENT PRIMARY KEY , name VARCHAR ( 100 ), email VARCHAR ( 100 ), password VARCHAR ( 100 ), department VARCHAR ( 50 ), salary FLOAT ); Database Connection (db.php) <?php $conn = mysqli_connect ( "localhost" , "root" , "" , "employee_db" ); if (! $conn ) { die ( "Database Connection Failed" ); } ?> i) Employee Registration Form (register.php) < form method = "post" > Name: < input type = "text" name = "name" > < br > Email: < input type = "email" name = "email" > < br > Password: < input type = "password" name = "password" > < br > Department: < input type = "text" name = "department...
Read more