Open Realty V2+ Brochure generation via FPDF

[halifax]

Hi everyone,

I have been following a few threads regarding generating a brochure in PDF style, and have amended the fantastic code produced by jeffremiller to work for V2+ of OR

For all those who want to produce a PDF brochure from OR, these are the steps I followed: (Note - I am certainly no expert with regards to PHP, so code might be messy, but Ive commented it as far as possible , so you should be able to follow the gist of the code, and amend where necessary)

1) Download the FPDF code from www.fdfp.org and place in your OR folder
2) Wherever you want to call the brochure from (I call it from the listing_detail_slideshow.html file) place the following text to link to the brochure.php file:
<a href="brochure.php?listingID={listingid}">

3) Amend the brochure.php file to suit the style and look of your brochures that you want to create.

The brochure.php file attached is a simple brochure but it displays most of the info clients would most likely require, including the community features, as well as the home features (thanks to pbflash)

Comments are welcome.

This isn't exactly an addon - so the topic can be moved to whichever forum is most appropriate.

Cheers

[sunna]

hi halifax,

the download-link www.fdfp.org isn't correct.

http://www.FPDF.org/

[animas]

Nice job halifax.

[CanariasData]

Hi all,

can anybody give me a hand on how to setup the brochure.php? I cant figure out how to set the settings for the database and table prefix:

$connection = mysql_connect('mydbserver','myusername','mypasswor d')

...this is clear so far!

$db = mysql_select_db('mybatabasename') or die ("Couldn't select database.");

....this too!!

but the script can't connect to the database because of the missing prefix for my DB tables I believe??!!

If I just use this settings I get following error:

Table 'mydatabasename.default_en_listingsDB' doesn't exist

Cant find a place to define my table prefix or do I miss anything else here??

Regards,
Gregor

[sunna]

ich hab das teil noch nicht getestet,

sollte es nicht so sein:

global $conn, $config;

und beispiel

$sql1 = 'SELECT FROM '.$config['table_prefix_no_lang'].'listingsDB WHERE listingsdb_id = \'listingID\'';

[alsmith]

Table 'mydatabasename.default_en_listingsDB' doesn't exist

Take a look at your DB tables. Mine were installed all in lowercase like
default_en_listingsDB is default_en_listingsdb

there are others in the script also, so you will need to replace all the table references with lowercase.

It worked for me.

[crash3903]

Firstly thanks for the script- looks likely to be perfect for my needs

When i click the link it opens a pdf window but does not send the data to the file

So i am left with a page with no details just headings - Any ideas appreciated

Thanks

Mark

[pbflash]

Take a look at your DB tables. Mine were installed all in lowercase like default_en_listingsDB is default_en_listingsdb

OR2 db tables are all lowercase. The queries in this script need to be re-written to work with 2.X.

Also, make sure fpdf.php is in the same folder as brochure.php.

[ucanhindi]

hi halifax,

the download-link www.fdfp.org isn't correct.

http://www.FPDF.org/

here ist correct.http://www.fpdf.org/en/download.php

[dantanner]

I tried this and it doesnt show images could I be doing something wrong with it or is it working with images?

I would like one like they have on the demo for jared. that one has a flash panel to work with but isn't for sale for some strange reason.

any help in this would be appreciated.