Trying to complete a script that will make a pdf of the output that it pulls from mysql database.
What happens is when someone puts a model into the form (index.php) it displays data about the model in the "specs" div (getspecs.php). I need a button that'll make a pdf of everything in the "specs" div.
I've looked at verious pdf making methods, the problem is I can't figure out where to put the code in the script or the proper syntax to use.
I just need somene familiar with this to recommend a pdf making solution and where to insert the code and the proper syntax to use to provide a button that will "create a pdf". PM if you need to see a live version. I'm on a linux server.
index.php
getspecs.phpCode:<?php ob_start(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html> <head> <title>Product Specs PDF Maker - v1.0</title> <link rel="stylesheet" href="styles/style.css" type="text/css"> <script type="text/javascript"> function getSpecs(str) { if (str=="") { document.getElementById("txtHint").innerHTML=""; return; } if (window.XMLHttpRequest) { // code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp=new XMLHttpRequest(); } else { // code for IE6, IE5 xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange=function() { if (xmlhttp.readyState==4 && xmlhttp.status==200) { document.getElementById("getSpecs").innerHTML=xmlhttp.responseText; } } xmlhttp.open("GET","getspecs.php?model="+str,true); xmlhttp.send(); } </script> <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script> </head> <body> <div id="header"> <div id="form"> <form onsubmit="return false;"> <b>Model#:</b> <input onkeyup="getSpecs(this.value)" /> <input type="submit" value="Submit"/> </form> </div> </div> <br /> <div id="getSpecs"> <div id="info">Product info listed here.</div> </div> </body> </html> <?php $HtmlCode= ob_get_contents(); ob_end_flush(); ?>
Code:<?php require_once("pdf/dompdf/dompdf_config.inc.php"); ?> <?php // table row is not echoed if value is NULL // table variable is not echoed if it is NULL include ('link.php'); $model = str_replace(" ","",trim($_GET["model"])); $result = mysql_query("select * from test_table where model ='$model'"); if ($row = mysql_fetch_object($result)) { if ($row->model) echo '<div id="menu">'; echo '</div>'; echo '<div class="clear"></div>'; echo '<div id="specs" name="specs">'; echo '<div id="model">'; echo '<span class="model">'. $row->model . '</span><br />'; echo '<span class="description">' . $row->description . '</span><br />'; echo '</div>'; // Product Specifications echo '<div id="tables">'; // Table 1 echo '<h3>Table 1</h3><dl>'; if ($row->table1_var1) echo '<dt>Variable 1</dt><dd>' . $row->table1_var1 . '</dd>'; if ($row->table1_var2) echo '<dt>Variable 2</dt><dd>' . $row->table1_var2 . '</dd>'; if ($row->table1_var3) echo '<dt>Variable 3</dt><dd>' . $row->table1_var3 . '</dd>'; if ($row->table1_var4) echo '<dt>Variable 4</dt><dd>' . $row->table1_var4 . '</dd>'; if ($row->table1_var5) echo '<dt>Variable 5</dt><dd>' . $row->table1_var5 . '</dd>'; echo '</dl>'; // Table 2 echo '<h3>Table 2</h3><dl>'; if ($row->table2_var1) echo '<dt>Variable 1</dt><dd>' . $row->table2_var1 . '</dd>'; if ($row->table2_var2) echo '<dt>Variable 2</dt><dd>' . $row->table2_var2 . '</dd>'; if ($row->table2_var3) echo '<dt>Variable 3</dt><dd>' . $row->table2_var3 . '</dd>'; if ($row->table2_var4) echo '<dt>Variable 4</dt><dd>' . $row->table2_var4 . '</dd>'; if ($row->table2_var5) echo '<dt>Variable 5</dt><dd>' . $row->table2_var5 . '</dd>'; echo '</dl>'; // Table 3 echo '<h3>Table 3</h3><dl>'; if ($row->table3_var1) echo '<dt>Variable 1</dt><dd>' . $row->table3_var1 . '</dd>'; if ($row->table3_var2) echo '<dt>Variable 2</dt><dd>' . $row->table3_var2 . '</dd>'; if ($row->table3_var3) echo '<dt>Variable 3</dt><dd>' . $row->table3_var3 . '</dd>'; if ($row->table3_var4) echo '<dt>Variable 4</dt><dd>' . $row->table3_var4 . '</dd>'; if ($row->table3_var5) echo '<dt>Variable 5</dt><dd>' . $row->table3_var5 . '</dd>'; echo '</dl>'; echo '</dl>'; echo '</div>'; echo '<div id="product_img1">'; if ($row->product_img1) echo '<img src="/images/products/' . $row->product_img1 . '" />'; echo '</div>'; echo '<div class="clear"></div>'; echo '<div id="product_img2">'; if ($row->product_img2) echo '<img src="/images/products/' . $row->product_img2 . '" />'; echo '</div>'; echo '<div class="clear"></div>'; echo '<div id="product_notes">'; if ($row->product_notes) echo $row->product_notes ; echo '</div>'; echo '<input type="submit" name="submit" id=submit" value="Create PDF" class="pdfgen" />'; echo '</form>'; echo '<div class="clear"></div>'; echo '</div>'; } else echo '<div id="info">Product not found. <a href='.$url.'>Create new product?</a></div>'; mysql_free_result($result); ?>


Reply With Quote
Bookmarks