{"id":1256,"date":"2018-01-19T19:22:37","date_gmt":"2018-01-19T19:22:37","guid":{"rendered":"http:\/\/goofy-trucks.flywheelsites.com\/php-for-pdf-page-3\/"},"modified":"2018-01-19T19:24:39","modified_gmt":"2018-01-19T19:24:39","slug":"php-for-pdf-page-3","status":"publish","type":"post","link":"https:\/\/phpbuilder.com\/php-for-pdf-page-3\/","title":{"rendered":"PHP for PDF Page 3"},"content":{"rendered":"
\n
\n
By Luca Perugini<\/div>\n
on October 26, 2000<\/div>\n<\/p><\/div>\n
\n

Distilling PDF document<\/h2>\n
\nNow we’re ready to generate PDF on the fly!<\/div>\n
\nIn this little example we’ll generate brochure on demand for FlyStore Inc.,
\ntaking data from a catalogue database.<\/div>\n

Prepare Database Test<\/h2>\n
\nI am going to assume a *little* experience in databases. Having said that, I’m
\nreally only hoping that you know how to create a database and insert tables
\ninto that database.<\/div>\n
\nCreating table catalogue<\/i>:<\/div>\n
\n
\ncreate table catalogue(\n  id           smallint(8) unsigned DEFAULT '0' NOT NULL,\n  item         varchar(100)         DEFAULT ''  NOT NULL,\n  description  tinytext,\n  img_data     longblob,\n  imgname      varchar(60),\n  imgsize      varchar(60),\n  imgtype      varchar(60),\n  price        smallint(8) unsigned DEFAULT '0' NOT NULL,\n  PRIMARY      KEY (id),\n  KEY          item (item(20))\n);\n<\/pre>\n<\/div>\n
 Sending MIME Header Information<\/h2>\n
\nIn order to have our document show up correctly, we need to
\nsend correct header information to the user’s browser. <\/div>\n
\nWith PHP we can do that using the header<\/i> function.
\nThe following code sends the correct MIME type to the browser.<\/div>\n
\n
\nheader( \"Content-type: application\/pdf\" );\nheader( \"Content-Disposition: attachment; filename=modulo.pdf\" ); \nheader( \"Content-Description: PHP3 Generated Data\" );\n<\/pre>\n<\/div>\n
 Important Notes<\/h2>\n
\nWhat you need to know is that you must not send anything before header<\/i> output.
\nA common mistake is the presence of spaces at the beginning of the  file. <\/div>\n
 Getting Data From MySQL<\/h2>\n
\nHere we’ve got a snapshot of code for retrieving data from the catalogue database. <\/div>\n
\n<\/p>\n
<?php<\/p>\n
\u00a0\u00a0$link\u00a0<\/span>=\u00a0<\/span>mysql_connect\u00a0<\/span>(<\/span>\"127.0.0.1\"<\/span>,\u00a0<\/span>\"flyadm\"<\/span>,\u00a0<\/span>\"flystore\"<\/span>)
\n
\u00a0\u00a0\u00a0\u00a0\u00a0or\u00a0die\u00a0(<\/span>\"Could\u00a0not\u00a0connect\"<\/span>);<\/p>\n
\u00a0\u00a0<\/span>mysql_select_db\u00a0<\/span>(<\/span>\"flystore\"<\/span>,\u00a0<\/span>$link<\/span>);<\/p>\n
\u00a0\u00a0<\/span>$result\u00a0<\/span>=\u00a0<\/span>mysql_query\u00a0<\/span>(<\/span>\"SELECT\u00a0*\u00a0FROM\u00a0catalogue\"<\/span>,\u00a0<\/span>$link<\/span>)
\n
\u00a0\u00a0\u00a0\u00a0\u00a0or\u00a0die\u00a0(<\/span>\"Invalid\u00a0query\"<\/span>);<\/p>\n
\u00a0\u00a0<\/span>$data\u00a0<\/span>=\u00a0<\/span>mysql_fetch_row\u00a0<\/span>(<\/span>$result<\/span>);
\n
\u00a0....
\n
\u00a0....
\n
\u00a0\u00a0<\/span>mysql_close\u00a0<\/span>(<\/span>$link<\/span>);<\/p>\n
<\/span>?>
\n
<\/span>
\n<\/span>
\n<\/code><\/font><\/div>\n<\/div>\n
<\/p>\n
\n
\u00ab Previous Page<\/a><\/div>\n
1<\/a> <\/div>\n
| <\/div>\n
2<\/a> <\/div>\n
| <\/div>\n
3<\/div>\n
| <\/div>\n
4<\/a> <\/div>\n
Next Page \u00bb<\/a><\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"
By Luca Perugini on October 26, 2000 Distilling PDF document Now we’re ready to generate PDF on the fly! In this little example we’ll generate brochure on demand for FlyStore Inc., taking data from a catalogue database. Prepare Database Test I am going to assume a *little* experience in databases…. <\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1256","post","type-post","status-publish","format-standard","hentry","category-tutorials"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1256","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/comments?post=1256"}],"version-history":[{"count":1,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1256\/revisions"}],"predecessor-version":[{"id":3151,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1256\/revisions\/3151"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=1256"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=1256"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=1256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}