41 lines
1.2 KiB
PHP
41 lines
1.2 KiB
PHP
<?php
|
|
//include autoloader;
|
|
require_once 'dompdf/autoload.inc.php';
|
|
use Dompdf\Dompdf;
|
|
$dompdf = new Dompdf();
|
|
$host_name="localhost";
|
|
|
|
$database_name="new_payroll_db";
|
|
|
|
$database_user="root";
|
|
|
|
$database_password="";
|
|
|
|
|
|
@mysqli_connect($host_name,$database_user,$database_password) or die("Connectionn error");
|
|
|
|
@mysqli_select_db($database_name) or die("No database selected");
|
|
|
|
$query = "select * from generate_salary where employeeId=7";
|
|
$result = mysqli_query($conn,$query);
|
|
$row = mysqli_fetch_array($result);
|
|
$empId = $row['employeeId'];
|
|
$empQuery = "select employeeFirstName,employeeMiddleName,employeeLastName,cardNumber from employee where employeeId='$empId'";
|
|
$resultEmp = mysqli_query($conn,$empQuery);
|
|
$rowEmp = mysqli_fetch_array($resultEmp);
|
|
$empName = $rowEmp['employeeFirstName']." ".$rowEmp['employeeMiddleName']." ".$rowEmp['employeeLastName'];
|
|
|
|
$page = file_get_contents("a.html");
|
|
|
|
$dompdf->loadHtml($page);
|
|
$dompdf->setPaper('A4', 'landscape');
|
|
$dompdf->render();
|
|
$dompdf->stream("salarySlip", array("Attachment" => 0));
|
|
//include ('pdf_header_revee.php');
|
|
//include ('includes/config/config.php');
|
|
//include ('includes/functions.php');
|
|
|
|
// include('pop_up_top.php');
|
|
?>
|
|
|