Mysql -> PHP -> PDF Mailmerge Challange!!
Posted: Sat Jan 08, 2005 9:01 pm
I have finally given up researching and now i am going to put exactly what my scinario is, and i am in need of help despratly.
I have a website working fully in php with mysql as the back end, no problems. Now what my boss wants done is have an accord form (some insurance kind of deal) available in pdf format, to be placed on the webserver (hosting it outside the company/ external so dont have access to the linux or apache configuration or installation) and then be auto filled/ mail merged for the clients only.
here are the steps
1. client comes to a php based form. hits submit (no problem)
2. all the data goes into mysql database (no problem)
3. after writing the data to the database, i can aquire the unique id auto assigned for this client.
big problem starts here
for the forementioned client id
4. open the single pdf form located on the server.
5. pick the corressponding fields from the mysql db and fill in the pdf document.
6. open this pdf document on the clients browser (we dont need to save the respective pdf document as the data is already in mysql).
this has been my challenge for about 7 days now (not to mention with almost no sleep). Is there anyone out there who has my sleeping pill
I have a website working fully in php with mysql as the back end, no problems. Now what my boss wants done is have an accord form (some insurance kind of deal) available in pdf format, to be placed on the webserver (hosting it outside the company/ external so dont have access to the linux or apache configuration or installation) and then be auto filled/ mail merged for the clients only.
here are the steps
1. client comes to a php based form. hits submit (no problem)
2. all the data goes into mysql database (no problem)
3. after writing the data to the database, i can aquire the unique id auto assigned for this client.
big problem starts here
for the forementioned client id
4. open the single pdf form located on the server.
5. pick the corressponding fields from the mysql db and fill in the pdf document.
6. open this pdf document on the clients browser (we dont need to save the respective pdf document as the data is already in mysql).
this has been my challenge for about 7 days now (not to mention with almost no sleep). Is there anyone out there who has my sleeping pill