" . mysqli_error($conn);
//}
?>
How to get and display html input form value on same page using php
';
// echo "Email is = ". $EMAIL .'';
$fl="d:\a"."pdf";
$pdf = new PDF_Code128('P','mm','A4');
$pdf->AddFont('rupee','','rupee.php');
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont('Arial','',9);
$x=0;
$qc1="";
$n=1;
$color="1";
$x=$x+35;
$y=15;
$x=5;
$pdf->SetXY($x,$y);
$pdf->Cell(30,15,'EB NO',0,0,'C');
$x=$x+30;
$pdf->SetXY($x,$y);
$pdf->Cell(30,15,'NAME ',0,0,'L');
$x=$x+40;
$pdf->SetXY($x,$y);
$pdf->Cell(30,15,'DEPARTMENT',0,0,'L');
$x=$x+40;
$pdf->SetXY($x,$y);
$pdf->Cell(30,15,'CATAGORY',0,0,'L');
$x=$x+30;
$pdf->SetXY($x,$y);
$pdf->Cell(30,15,'LAST WORKING ',0,0,'L');
$x=$x+30;
$pdf->SetXY($x,$y);
$pdf->Cell(30,15,'ABSENT FOR',0,0,'L');
$x=150;
$pdf->SetXY($x,$y+4);
$pdf->Cell(30,15,'/LEAVE DATE',0,0,'L');
$x=$x+30;
$pdf->SetXY($x,$y+4);
$pdf->Cell(30,15,' (DAYS) ',0,0,'L');
$pdf->SetLineWidth(.25);
$pdf->line(3,$y+16,203,$y+16);
$y=$y+14;
//$sql="Update itemmaster set op_2018=1 where concat(group_code,item_code)='$NAME'";
//if (mysqli_query($conn, $sql)) {
// echo "New record created successfully";
//} else {
// echo "Error: " . $sql . "
" . mysqli_error($conn);
//}
$sql="select concat(group_code,item_code) itemcode,item_desc,uom_code from itemmaster where group_code='101' ";
$result = $conn->query($sql);
while($row = $result->fetch_assoc()) {
echo $row["itemcode"];
echo $row["item_desc"];
echo $row["uom_code"];
$x=5;
$pdf->SetXY($x,$y);
$pdf->Cell(30,15,$row['EBNO'],0,0,'C');
$x=$x+30;
$pdf->SetXY($x,$y);
$pdf->Cell(30,15,$row['WRK_NAME'],0,0,'L');
$x=$x+40;
$pdf->SetXY($x,$y);
$pdf->Cell(30,15,$row['DEPT_DESC'],0,0,'L');
$x=$x+40;
$pdf->SetXY($x,$y);
$pdf->Cell(30,15,$row['CATA_DESC'],0,0,'L');
$x=$x+30;
$pdf->SetXY($x,$y);
$pdf->Cell(30,15,$row['DATE_FROM'],0,0,'L');
$x=$x+30;
$pdf->SetXY($x,$y);
$pdf->Cell(22,15,$row['ABSENT_DAYS'],0,0,'R');
$pdf->SetLineWidth(.25);
$pdf->line(3,$y+16,203,$y+16);
$y=$y+14;
if ($y>250) {
$y=15;
$pdf->AddPage();
}
}
}
$pdf->Output($fl,'F');
//}
?>