djidji
Trainee Developer
Joined: 05 Aug 2007
Posts: 11
 337 Cash
|
 How Can Dev PDF using PHP,Mysql in Web Appications
You need the PDFLib, you can find it on the web.
Here is the script page which I use to print PDF from my database, you can try something like it.
<?php
$naslov = $_GET['ns'];
$id = $_GET['id'];
$bas = $_GET['bs'];
require_once('pozivifun.php');
if (@ !db_veza($bas, $vezadb))
{
echo 'Neuspešno povezivanje sa bazom.';
exit;
}
else
{
$pdf = pdf_new();
pdf_open_file($pdf, '');
pdf_set_info($pdf, "Creator", "stampawk.php");
pdf_set_info($pdf, "Author", "Srdjan Vulic");
pdf_set_info($pdf, "Title", "STAMPA");
pdf_begin_page($pdf, 595, 842);
pdf_add_bookmark($pdf, 'Strana 1', 0, 0);
//naslov
$font = pdf_findfont($pdf, 'Helvetica-Bold', 'host', 0);
pdf_setfont($pdf, $font, 14);
pdf_set_text_pos($pdf, 25, 805);
pdf_show($pdf, $naslov);
pdf_continue_text($pdf,'');
//okvir zaglavlja
$linija = 1; //debljina linije
pdf_setlinewidth($pdf, $linija);
pdf_rect($pdf, 20, 775, 555, 25);
pdf_stroke($pdf);
//zaglavlje
$font = pdf_findfont($pdf, 'Helvetica', 'host', 0);
pdf_setfont($pdf, $font, 10);
pdf_set_text_pos($pdf, 25, 788);
pdf_show($pdf, 'RB');
pdf_continue_text($pdf,'');
$font = pdf_findfont($pdf, 'Helvetica', 'host', 0);
pdf_setfont($pdf, $font, 10);
pdf_set_text_pos($pdf, 65, 788);
pdf_show($pdf, 'Naziv');
pdf_continue_text($pdf,'');
$font = pdf_findfont($pdf, 'Helvetica', 'host', 0);
pdf_setfont($pdf, $font, 10);
pdf_set_text_pos($pdf, 265, 788);
pdf_show($pdf, 'JM');
pdf_continue_text($pdf,'');
$font = pdf_findfont($pdf, 'Helvetica', 'host', 0);
pdf_setfont($pdf, $font, 10);
pdf_set_text_pos($pdf, 300, 788);
pdf_show($pdf, 'Cena bez');
pdf_continue_text($pdf,'');
$font = pdf_findfont($pdf, 'Helvetica', 'host', 0);
pdf_setfont($pdf, $font, 10);
pdf_set_text_pos($pdf, 300, 778);
pdf_show($pdf, 'PDV-a');
pdf_continue_text($pdf,'');
$font = pdf_findfont($pdf, 'Helvetica', 'host', 0);
pdf_setfont($pdf, $font, 10);
pdf_set_text_pos($pdf, 385, 788);
pdf_show($pdf, 'PDV %');
pdf_continue_text($pdf,'');
$font = pdf_findfont($pdf, 'Helvetica', 'host', 0);
pdf_setfont($pdf, $font, 10);
pdf_set_text_pos($pdf, 435, 788);
pdf_show($pdf, 'Cena sa');
pdf_continue_text($pdf,'');
$font = pdf_findfont($pdf, 'Helvetica', 'host', 0);
pdf_setfont($pdf, $font, 10);
pdf_set_text_pos($pdf, 435, 778);
pdf_show($pdf, 'PDV-om');
pdf_continue_text($pdf,'');
$font = pdf_findfont($pdf, 'Helvetica', 'host', 0);
pdf_setfont($pdf, $font, 10);
pdf_set_text_pos($pdf, 525, 788);
pdf_show($pdf, 'Uracunat');
pdf_continue_text($pdf,'');
$font = pdf_findfont($pdf, 'Helvetica', 'host', 0);
pdf_setfont($pdf, $font, 10);
pdf_set_text_pos($pdf, 525, 778);
pdf_show($pdf, 'rabat %');
pdf_continue_text($pdf,'');
$upit = "select t.grupaid, t.odelenje, t.tipid, t.kasa_sif, t.brisano, t.tipnaziv,
t.napomena, c.jm, c.cena, c.rabat, o.porez,
c.cena - ((c.cena / 100) * c.rabat) as cenasapdv,
(c.cena-((c.cena/100)*c.rabat))-(((c.cena-((c.cena/100)*c.rabat))/100)*(o.porez/(1+(o.porez/100)))) as cenabezpdv
from tip as t inner join cene as c on t.tipid = c.tipid
inner join odelenje as o on t.odelenje = o.odelenje
where t.grupaid = '$id' and brisano <> 0 order by tipnaziv";
$rezultat = mysql_query($upit);
$brojsl = mysql_num_rows($rezultat);
$y = 770;
for ($i = 0; $i < $brojsl; $i++)
{
$y = $y - 12;
$red = mysql_fetch_assoc($rezultat);
$rb = $i+1;
$naziv_stavke = stripslashes($red['tipnaziv']);
$jm = stripslashes($red['jm']);
$cenabezpdv = number_format(stripslashes($red['cenabezpdv']), 2);
$pdv = number_format(stripslashes($red['porez']), 2);
$cenasapdv = number_format(stripslashes($red['cenasapdv']), 2);
$rabat = number_format(stripslashes($red['rabat']), 2);
$napomena = stripslashes($red['napomena']);
$font = pdf_findfont($pdf, 'Helvetica', 'host', 0);
pdf_setfont($pdf, $font, Cool;
pdf_set_text_pos($pdf, 25, $y);
pdf_show($pdf, $rb);
pdf_continue_text($pdf,'');
$font = pdf_findfont($pdf, 'Helvetica', 'host', 0);
pdf_setfont($pdf, $font, Cool;
pdf_set_text_pos($pdf, 65, $y);
pdf_show($pdf, $naziv_stavke);
pdf_continue_text($pdf,'');
$font = pdf_findfont($pdf, 'Helvetica', 'host', 0);
pdf_setfont($pdf, $font, Cool;
pdf_set_text_pos($pdf, 265, $y);
pdf_show($pdf, $jm);
pdf_continue_text($pdf,'');
$font = pdf_findfont($pdf, 'Helvetica', 'host', 0);
pdf_setfont($pdf, $font, Cool;
pdf_set_text_pos($pdf, 300, $y);
pdf_show($pdf, $cenabezpdv);
pdf_continue_text($pdf,'');
$font = pdf_findfont($pdf, 'Helvetica', 'host', 0);
pdf_setfont($pdf, $font, Cool;
pdf_set_text_pos($pdf, 385, $y);
pdf_show($pdf, $pdv);
pdf_continue_text($pdf,'');
$font = pdf_findfont($pdf, 'Helvetica', 'host', 0);
pdf_setfont($pdf, $font, Cool;
pdf_set_text_pos($pdf, 435, $y);
pdf_show($pdf, $cenasapdv);
pdf_continue_text($pdf,'');
$font = pdf_findfont($pdf, 'Helvetica', 'host', 0);
pdf_setfont($pdf, $font, Cool;
pdf_set_text_pos($pdf, 525, $y);
pdf_show($pdf, $rabat);
pdf_continue_text($pdf,'');
if ($napomena <> null)
{
$y = $y - 12;
$font = pdf_findfont($pdf, 'Helvetica', 'host', 0);
pdf_setfont($pdf, $font, Cool;
pdf_set_text_pos($pdf, 25, $y);
pdf_show($pdf, $napomena);
pdf_continue_text($pdf,'');
}
//linija za razdvajanje redova
$linija = 0.5; //debljina linije
pdf_setlinewidth($pdf, $linija);
pdf_rect($pdf, 25, $y - 2, 545, 0);
pdf_stroke($pdf);
}
pdf_end_page($pdf);
pdf_close($pdf);
$podaci = pdf_get_buffer($pdf);
header('Content-Type: application/pdf');
header('Content-Disposition: inline; filename=stampawk.php');
header('Content-Length: ' . strlen($podaci));
echo $podaci;
mysql_free_result($rezultat);
prekinivezusabazom($vezadb);
}
?>
_________________
"The only problem to drink water from cactus is ... to find a tap."
|
