syazyan
11-07-2006, 09:38 AM
hello...i'm diong a pdf generated from the database. this is my code..
<?php
//error_reporting(E_ALL);
include('class.ezpdf.php');
$register_id = $_REQUEST['register_id'];
$title = $_REQUEST['title'];
$db = @mysql_connect('localhost','root','') or die(mysql_error());
mysql_select_db('register', $db);
$query6 = "SELECT reg.title,reg.register_id,reg.category,reg.publication,reg.date,reg.declaration,reg.brief,
agent.agent_name,agent.firm_name,agent.agent_add,agent.agent_city,agent.agent_state,agent.agent_country,
agent.agent_phone,agent.agent_fax,agent.agent_email
FROM reg
LEFT JOIN agent
ON reg.register_id = agent.register_id
WHERE reg.register_id = '$register_id'";
$result6 = mysql_query($query6,$db)or die(mysql_error());
$query_data6 = mysql_fetch_array($result6);
$title = $query_data6["title"];
$register_id = $query_data6["register_id"];
$category = $query_data6["category"];
$publication = $query_data6["publication"];
$date = $query_data6["date"];
$declaration = $query_data6["declaration"];
$brief = $query_data6["brief"];
$agent_name = $query_data6["agent_name"];
$firm_name = $query_data6["firm_name"];
$agent_add = $query_data6["agent_add"];
$agent_city = $query_data6["agent_city"];
$agent_state = $query_data6["agent_state"];
$agent_country = $query_data6["agent_country"];
$agent_phone = $query_data6["agent_phone"];
$agent_fax = $query_data6["agent_fax"];
$agent_pcode = $query_data6["agent_pcode"];
$agent_email = $query_data6["agent_email"];
//--------------------------------------------------------------------------------------------//
//query for author
$query7 = "SELECT reg.register_id,author.author_name,author.author_ic,author.author_add,
author.author_city,author.author_state,author.author_country,author.author_pcode
FROM reg
LEFT JOIN author
ON reg.register_id = author.register_id
WHERE reg.register_id = '$register_id'";
$queryIC= mysql_query($query7,$db) or die(mysql_error());
$resultRows = mysql_num_rows($queryIC);
//----------------------------------------------------------------------------------------------//
//query for owner
$query8 = "SELECT reg.register_id,owner.owner_name,owner.owner_ic,owner.corp_name,owner.owner_add,
owner.owner_city,owner.owner_state,owner.owner_country,owner.owner_pcode,owner.owner_phone,
owner.owner_fax,owner.owner_email
FROM reg
LEFT JOIN owner
ON reg.register_id = owner.register_id
WHERE reg.register_id = '$register_id'";
$queryID= mysql_query($query8,$db) or die(mysql_error());
$resultRows = mysql_num_rows($queryID);
////////////////////////////////////////////////////////////////////////////////////////////////
$pdf =& new Cezpdf();
$pdf->selectFont('../fonts/Helvetica');
$pdf->setEncryption('','rc',array('print'));
$i=$pdf->ezStartPageNumbers(500,720,9,'','',1);
$uppertext = "REGISTRATION DETAILS";
//$uppertext2 = "betul dan kemaskini Pendaftar Syarikat tidak boleh dipertanggungkan bagi sebarang";
//$uppertext3 = "kerugian kerana maklumat yang tersilap atau tertinggal.";
$pdf->selectFont('./fonts/Helvetica.afm');
$pdf->setColor(0,0,0);
$pdf->addText(80,60,7,'Printing Date : ');
$dateCetak=strtotime($printdate);
$dateCetak=date('d-m-Y',$dateCetak);
$pdf->addText(140,60,7,$dateCetak);
//$pdf->selectFont('./fonts/Helvetica.afm');
$pdf->addText(250,720,10,$uppertext);
//$pdf->addText(100,680,9,$uppertext2);
//$pdf->addText(100,670,9,$uppertext3);
//$pdf->selectFont('./fonts/Helvetica.afm');
$pdf->addText(100,670,9,'Registration Information');
//$pdf->line(250,640,340,638);
//$pdf->selectFont('./fonts/Helvetica.afm');
$pdf->addText(100,640,9,'Registration ID');
$pdf->addText(200,640,9,':');
$pdf->addText(220,640,9,$register_id);
$pdf->addText(100,620,9,'Title');
$pdf->addText(200,620,9,':');
//$pdf->selectFont('./fonts/Helvetica.afm');
$pdf->addText(220,620,9,$title);
//$pdf->selectFont('./fonts/Helvetica.afm');
$pdf->addText(100,600,9,'Category');
$pdf->addText(200,600,9,':');
$pdf->addText(220,600,9,$category);
$pdf->addText(100,580,9,'Publication');
$pdf->addText(200,580,9,':');
$pdf->addText(220,580,9,$publication);
$pdf->addText(100,560,9,'Date of Publication');
$pdf->addText(200,560,9,':');
$pdf->addText(220,560,9,$date);
$pdf->addText(100,540,9,'Declaration');
$pdf->addText(200,540,9,':');
$pdf->addText(220,540,9,$declaration);
$pdf->addText(100,520,9,'Brief of Description');
$pdf->addText(200,520,9,':');
$pdf->addText(220,520,9,$brief);
$pdf->addText(100,490,9,'Author of Work');
while($result7=mysql_fetch_array($queryIC))
{
$pdf->addText(100,470,9,'Name');
$pdf->addText(200,470,9,':');
$pdf->addText(220,470,9,$result7['author_name']);
$pdf->addText(100,450,9,'IC Number');
$pdf->addText(200,450,9,':');
$pdf->addText(220,450,9,$result7['author_ic']);
$pdf->addText(100,430,9,'Address');
$pdf->addText(200,430,9,':');
$pdf->addText(220,430,9,$result7['author_add']);
$pdf->addText(220,420,9,$result7['author_city']);
$pdf->addText(220,410,9,$result7['author_state']);
$pdf->addText(220,400,9,$result7['author_country']);
}
$pdf->addText(100,380,9,'Owner of Work');
while($result8=mysql_fetch_array($queryID))
{
$pdf->addText(100,360,9,'Name');
$pdf->addText(200,360,9,':');
$pdf->addText(220,360,9,$result8['owner_name']);
$pdf->addText(100,340,9,'IC Number');
$pdf->addText(200,340,9,':');
$pdf->addText(220,340,9,$result8['owner_ic']);
$pdf->addText(100,320,9,'Corporation Name');
$pdf->addText(200,320,9,':');
$pdf->addText(220,320,9,$result8['corp_name']);
$pdf->addText(100,300,9,'Address');
$pdf->addText(200,300,9,':');
$pdf->addText(220,300,9,$result8['owner_add']);
$pdf->addText(220,290,9,$result8['owner_city']);
$pdf->addText(220,280,9,$result8['owner_state']);
$pdf->addText(220,270,9,$result8['owner_country']);
$pdf->addText(100,250,9,'Telephone Number');
$pdf->addText(200,250,9,':');
$pdf->addText(220,250,9,$result8['owner_phone']);
$pdf->addText(100,230,9,'Fax Number');
$pdf->addText(200,230,9,':');
$pdf->addText(220,230,9,$result8['owner_fax']);
$pdf->addText(100,210,9,'Email');
$pdf->addText(200,210,9,':');
$pdf->addText(220,210,9,$result8['owner_email']);
}
// For loop ending
/////
//$pdf->addText(220,160,9,$rocincorporation['vchbusinessdescription']);
$pdf->addText(80,50,7,'Maklumat Syarikat ini diperolehi melalui E-info SSM. Maklumat ini adalah sehingga ');
$pdf->setColor(0,0,128);
$pdf->addText(150,36,7,'TINGKAT 2,10-19 PUTRA PLACE, 100, JALAN PUTRA, 50622 KUALA LUMPUR MALAYSIA.');
$pdf->addText(200,29,7,'Tel : 03-4047 6000 Fax : 03-4047 6317');
$pdf->addJpegFromFile('ssm.JPG',199,$pdf->y-60,200,0);
$pdf->ezStream();
mysql_close($db);
?>
i need to make the data for author and owner looping..which is it will list down all author n owner regarding to the same register id...i cannot do it..it being redundant. anyone can help me??:confused: :(
<?php
//error_reporting(E_ALL);
include('class.ezpdf.php');
$register_id = $_REQUEST['register_id'];
$title = $_REQUEST['title'];
$db = @mysql_connect('localhost','root','') or die(mysql_error());
mysql_select_db('register', $db);
$query6 = "SELECT reg.title,reg.register_id,reg.category,reg.publication,reg.date,reg.declaration,reg.brief,
agent.agent_name,agent.firm_name,agent.agent_add,agent.agent_city,agent.agent_state,agent.agent_country,
agent.agent_phone,agent.agent_fax,agent.agent_email
FROM reg
LEFT JOIN agent
ON reg.register_id = agent.register_id
WHERE reg.register_id = '$register_id'";
$result6 = mysql_query($query6,$db)or die(mysql_error());
$query_data6 = mysql_fetch_array($result6);
$title = $query_data6["title"];
$register_id = $query_data6["register_id"];
$category = $query_data6["category"];
$publication = $query_data6["publication"];
$date = $query_data6["date"];
$declaration = $query_data6["declaration"];
$brief = $query_data6["brief"];
$agent_name = $query_data6["agent_name"];
$firm_name = $query_data6["firm_name"];
$agent_add = $query_data6["agent_add"];
$agent_city = $query_data6["agent_city"];
$agent_state = $query_data6["agent_state"];
$agent_country = $query_data6["agent_country"];
$agent_phone = $query_data6["agent_phone"];
$agent_fax = $query_data6["agent_fax"];
$agent_pcode = $query_data6["agent_pcode"];
$agent_email = $query_data6["agent_email"];
//--------------------------------------------------------------------------------------------//
//query for author
$query7 = "SELECT reg.register_id,author.author_name,author.author_ic,author.author_add,
author.author_city,author.author_state,author.author_country,author.author_pcode
FROM reg
LEFT JOIN author
ON reg.register_id = author.register_id
WHERE reg.register_id = '$register_id'";
$queryIC= mysql_query($query7,$db) or die(mysql_error());
$resultRows = mysql_num_rows($queryIC);
//----------------------------------------------------------------------------------------------//
//query for owner
$query8 = "SELECT reg.register_id,owner.owner_name,owner.owner_ic,owner.corp_name,owner.owner_add,
owner.owner_city,owner.owner_state,owner.owner_country,owner.owner_pcode,owner.owner_phone,
owner.owner_fax,owner.owner_email
FROM reg
LEFT JOIN owner
ON reg.register_id = owner.register_id
WHERE reg.register_id = '$register_id'";
$queryID= mysql_query($query8,$db) or die(mysql_error());
$resultRows = mysql_num_rows($queryID);
////////////////////////////////////////////////////////////////////////////////////////////////
$pdf =& new Cezpdf();
$pdf->selectFont('../fonts/Helvetica');
$pdf->setEncryption('','rc',array('print'));
$i=$pdf->ezStartPageNumbers(500,720,9,'','',1);
$uppertext = "REGISTRATION DETAILS";
//$uppertext2 = "betul dan kemaskini Pendaftar Syarikat tidak boleh dipertanggungkan bagi sebarang";
//$uppertext3 = "kerugian kerana maklumat yang tersilap atau tertinggal.";
$pdf->selectFont('./fonts/Helvetica.afm');
$pdf->setColor(0,0,0);
$pdf->addText(80,60,7,'Printing Date : ');
$dateCetak=strtotime($printdate);
$dateCetak=date('d-m-Y',$dateCetak);
$pdf->addText(140,60,7,$dateCetak);
//$pdf->selectFont('./fonts/Helvetica.afm');
$pdf->addText(250,720,10,$uppertext);
//$pdf->addText(100,680,9,$uppertext2);
//$pdf->addText(100,670,9,$uppertext3);
//$pdf->selectFont('./fonts/Helvetica.afm');
$pdf->addText(100,670,9,'Registration Information');
//$pdf->line(250,640,340,638);
//$pdf->selectFont('./fonts/Helvetica.afm');
$pdf->addText(100,640,9,'Registration ID');
$pdf->addText(200,640,9,':');
$pdf->addText(220,640,9,$register_id);
$pdf->addText(100,620,9,'Title');
$pdf->addText(200,620,9,':');
//$pdf->selectFont('./fonts/Helvetica.afm');
$pdf->addText(220,620,9,$title);
//$pdf->selectFont('./fonts/Helvetica.afm');
$pdf->addText(100,600,9,'Category');
$pdf->addText(200,600,9,':');
$pdf->addText(220,600,9,$category);
$pdf->addText(100,580,9,'Publication');
$pdf->addText(200,580,9,':');
$pdf->addText(220,580,9,$publication);
$pdf->addText(100,560,9,'Date of Publication');
$pdf->addText(200,560,9,':');
$pdf->addText(220,560,9,$date);
$pdf->addText(100,540,9,'Declaration');
$pdf->addText(200,540,9,':');
$pdf->addText(220,540,9,$declaration);
$pdf->addText(100,520,9,'Brief of Description');
$pdf->addText(200,520,9,':');
$pdf->addText(220,520,9,$brief);
$pdf->addText(100,490,9,'Author of Work');
while($result7=mysql_fetch_array($queryIC))
{
$pdf->addText(100,470,9,'Name');
$pdf->addText(200,470,9,':');
$pdf->addText(220,470,9,$result7['author_name']);
$pdf->addText(100,450,9,'IC Number');
$pdf->addText(200,450,9,':');
$pdf->addText(220,450,9,$result7['author_ic']);
$pdf->addText(100,430,9,'Address');
$pdf->addText(200,430,9,':');
$pdf->addText(220,430,9,$result7['author_add']);
$pdf->addText(220,420,9,$result7['author_city']);
$pdf->addText(220,410,9,$result7['author_state']);
$pdf->addText(220,400,9,$result7['author_country']);
}
$pdf->addText(100,380,9,'Owner of Work');
while($result8=mysql_fetch_array($queryID))
{
$pdf->addText(100,360,9,'Name');
$pdf->addText(200,360,9,':');
$pdf->addText(220,360,9,$result8['owner_name']);
$pdf->addText(100,340,9,'IC Number');
$pdf->addText(200,340,9,':');
$pdf->addText(220,340,9,$result8['owner_ic']);
$pdf->addText(100,320,9,'Corporation Name');
$pdf->addText(200,320,9,':');
$pdf->addText(220,320,9,$result8['corp_name']);
$pdf->addText(100,300,9,'Address');
$pdf->addText(200,300,9,':');
$pdf->addText(220,300,9,$result8['owner_add']);
$pdf->addText(220,290,9,$result8['owner_city']);
$pdf->addText(220,280,9,$result8['owner_state']);
$pdf->addText(220,270,9,$result8['owner_country']);
$pdf->addText(100,250,9,'Telephone Number');
$pdf->addText(200,250,9,':');
$pdf->addText(220,250,9,$result8['owner_phone']);
$pdf->addText(100,230,9,'Fax Number');
$pdf->addText(200,230,9,':');
$pdf->addText(220,230,9,$result8['owner_fax']);
$pdf->addText(100,210,9,'Email');
$pdf->addText(200,210,9,':');
$pdf->addText(220,210,9,$result8['owner_email']);
}
// For loop ending
/////
//$pdf->addText(220,160,9,$rocincorporation['vchbusinessdescription']);
$pdf->addText(80,50,7,'Maklumat Syarikat ini diperolehi melalui E-info SSM. Maklumat ini adalah sehingga ');
$pdf->setColor(0,0,128);
$pdf->addText(150,36,7,'TINGKAT 2,10-19 PUTRA PLACE, 100, JALAN PUTRA, 50622 KUALA LUMPUR MALAYSIA.');
$pdf->addText(200,29,7,'Tel : 03-4047 6000 Fax : 03-4047 6317');
$pdf->addJpegFromFile('ssm.JPG',199,$pdf->y-60,200,0);
$pdf->ezStream();
mysql_close($db);
?>
i need to make the data for author and owner looping..which is it will list down all author n owner regarding to the same register id...i cannot do it..it being redundant. anyone can help me??:confused: :(