PHP - Problems With Dompdf Link For Conversion

Hello, 

I have a sample shop that generates a receipt on products purchased. When a user checks out it generates a receipt as a pdf file using dompdf.

If i select a few products and generate a pdf file its ok it shows the products and total price, however if i choose lots of products, too many to fit on one page then when i generate a pdf it only show the first page the rest of the products and the total price are not displayed on page 2 ?

Here is the bit of the code that generates the pdf

sorry i am not very experienced in this stuff i am trying to learn !

$options = new Dompdf\Options();

	$options->set('isRemoteEnabled', true);

	$dompdf = new Dompdf\Dompdf($options);

	$dompdf->loadHtml($html);

	$dompdf->render();

	$output = $dompdf->output();

	$info = file_put_contents("../../files/" . $filepath . $filename, $output);



	

	return array($filename,$filepath);

any advice please.

Hi, for my purposes, I can only use core PHP function (no PEAR for eg) to convert SQL to XML, should I convert SQL to csv first, and then use php's filesystem to read each line to extract and store as xml nodes OR does someone know easier/better method?

Any help much appreciated, thanks.

Hi all,

Hopefully this will be a simple one for all you geniuses...Geniea... clever people out there.  :?

I'm trying to convert the following code from a mysql_ to sqlsrv_ statement. I have to admit i am a bit of a noob, but am learning fast! The code was originally developed by dreamweaver with some webassist extensions.

  $conn4 = sqlsrv_connect($hostname, $connectionInfo);
  if (!session_id()) session_start();
  $insertParamsObj = WA_AB_generateInsertParams($WA_fieldNames, $WA_columns, $WA_fieldValues, -1);
  $WA_Sql = "INSERT INTO `" . $WA_table . "` (" . $insertParamsObj->WA_tableValues . ") VALUES (" . $insertParamsObj->WA_dbValues . ")";
  $MM_editCmd = sqlsrv_query($conn4, $WA_Sql) or die(print_r( sqlsrv_errors(), true));
  $_SESSION[$WA_sessionName] = sqlsrv_insert_id();
  if ($WA_redirectURL != "")  {
    if ($WA_keepQueryString && $WA_redirectURL != "" && isset($_SERVER["QUERY_STRING"]) && $_SERVER["QUERY_STRING"] !== "" && sizeof($_POST) > 0) {
      $WA_redirectURL .= ((strpos($WA_redirectURL, '?') === false)?"?":"&").$_SERVER["QUERY_STRING"];
    }

I appear to have had some luck with other parts of the code renaming mysql_ statements with the appropriate sqlsrv variations and some (slight) code re-hashing, but the above has given me a bit of a headache  :banghead: . I assume that I need to break the   "$WA_Sql = "INSERT INTO `" . $WA_table . "` (" . $insertParamsObj->WA_tableValues . ") VALUES (" . $insertParamsObj->WA_dbValues . ")";" into two parts to give the sqlsrv_query it's `resource`, `array`, `parameter` format (I think that's right!), but i might be wrong.

If it's all completely wrong, I apologise!

Unfortunately due to the nature of the project Microsoft SQL is a necessary evil, and PDO has been considered but my brain is exploding with a (near straight) conversion as is... Unless anyone knows of a mysql to PDO conversion utility....or really easy method???

Would anyone be kind enough to help me with this?

Regards

Paladindc

"In an ideal world, there would be no ideals, therefore would it indeed be ideal?" - Me

I don't really know how to explain this, I saw once on some forum members signature, something like this :
G = "\ x50 \ x72 \ 157 \ 144 \ x75 \ x63 \ 164 \ x20 \ x6c \ x69 \ 143 \ 145 \ 156 \ x73 \ 145 \ 040 \ x68 \ 141 \ x73 \ 040 \ x65 \ x78 \ 160 \. 151 \ 162 \ x65 \ 144 \ x2e \ x20 "+ E.

That somehow translates into words, I know there is a PHP function to convert that, what is that code called and what is the PHP function?

Can someone tell me how to convert a MySQL date such as 2010-08-13 into the the US format, such as 8/13/2010, and also the reverse using PHP?  I can't seem to find the right functions.

Thanks!