php - Print Barcode from ID database -


after last barcode question i'm another. barcode script:http://www.shayanderson.com/php/php-barcode-generator-class-code-39.htm works fine static number, or static variable:

$reparationid = uniqid();  // include barcode39 class  include "barcode39.php";   // set barcode39 object  $barcode = new barcode39("$reparationid");   // display new barcode  $barcode->draw(); 

bu, want $reparationid out of database, last added entry.i tried this, , works without barcode:

$reparationid = "select reparationid reparation order added desc limit 1"; $result = $link->query($reparationid);  if ($result->num_rows > 0) {     while ($row = $result->fetch_assoc()) {         print($row ["reparationid"]);     } } else {     echo "0 results"; } 

as asked, reparationid shown number, works. wanted merge 2 scripts, point goes wrong. doesn't work @ all. tried this:

if ($result->num_rows > 0) {     while ($row = $result->fetch_assoc()) {         print($row ["reparatieid"]);          // include barcode39 class  include "barcode39.php";          // set barcode39 object  $barcode = new barcode39("$reparationid");          // display new barcode  $barcode->draw();      } } else {     echo "0 results"; } 

there blue question mark, nothing more.. ideas?

thanks,

br, daan

tip: don't include whilst in while loop, move above loop.

change line become;

$barcode = new barcode39($row["reparationid"]); 

$reparationid doesn't exist in script you've given, , if does; doesn't have value fetched database. (it have value of database query string though)


Comments

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

delphi - Indy UDP Read Contents of Adata -

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -