Generate quotation using FPDF
-
Currently I'm develop an application same as CRM. To generate report in PDF,i'm using FPDF as my tools. The problem is, to retrieve the data from database,I create temporary file e.g:dldata.php and call that page in my pdf viewer file. U can access the data and easily view the actual data(if you know the address).By using explode(),I retrieve the data and display it on my pdf viewer page. The dldata.php will be delete (using unlink()) after user load the quotation form. Below are the flow to create quotation in pdf: fill form data(createquotation.php)->insert data to database->create session,dldata.php & write data into it from mysql->redirect page to viewquotation.php(here I call dldata.php)->click print quotation or back to createquotation.php & destroy dldata.php. Anyone that have experience using FPDF to advise me about this issue. I'm afraid the conflict arise when 2 or more users doing the same process at the same time. TQ. :)
-
Currently I'm develop an application same as CRM. To generate report in PDF,i'm using FPDF as my tools. The problem is, to retrieve the data from database,I create temporary file e.g:dldata.php and call that page in my pdf viewer file. U can access the data and easily view the actual data(if you know the address).By using explode(),I retrieve the data and display it on my pdf viewer page. The dldata.php will be delete (using unlink()) after user load the quotation form. Below are the flow to create quotation in pdf: fill form data(createquotation.php)->insert data to database->create session,dldata.php & write data into it from mysql->redirect page to viewquotation.php(here I call dldata.php)->click print quotation or back to createquotation.php & destroy dldata.php. Anyone that have experience using FPDF to advise me about this issue. I'm afraid the conflict arise when 2 or more users doing the same process at the same time. TQ. :)
What is your actual problem? Creating the PDF File? or Downloading the PDF File?
-
What is your actual problem? Creating the PDF File? or Downloading the PDF File?
I have no problem with either download or creating the pdf file. The problem is method that i used. I used this code to call dldata.php after i create it.
$pdf = new PDF();
// Column headings
$header = array('Product ID', 'Product No', 'Product Description', 'Subtotal#39;);
// Data load from the file and it will be=>1;#13,21321;Pencil;$1.00
$data = $pdf->LoadData('dldata.php');I followed tutorial based on fpdf official website. Tutorial: http://www.fpdf.org/en/tutorial/tuto5.htm[^] Example for dldata.php shape of data: http://www.fpdf.org/en/tutorial/countries.txt[^] After load back to the createquotation.php,I destroy dldata.php file. I'm afraid, it will be issue if more than 2 user do this process at the same time. It will be last in,first out. Only The last data store will be appear. Can I just use dldata.php without delete it and call the data without any user can access it by type the url.