Re: [PHP] Report generation as pdf and csv in php application for huge record set
On 2011-07-14, at 12:50 AM, Midhun Girish wrote: On Thu, Jul 14, 2011 at 11:18 AM, George Langley george.lang...@shaw.ca wrote: On 2011-07-13, at 11:20 PM, Midhun Girish wrote: Hi, - Browsers generally have a 5 minute time-out. If you send the PDF directly to the browser and reach the limit, it will be lost. It is therefore advised for very big documents to generate them in a file, and to send some data to the browser from time to time (with a call to flush() to force the output). When the document is finished, you can send a redirection to it or create a link. Remark: even if the browser times out, the script may continue to run on the server. When it comes to the user end, they wont wait for more than 1 min. So redirection after generating the report is not possible. But creating link may be a good idea. How can it be done? I mean shouldn't there be a service running in the server to process these request after the execution of the php script is completed? Also shouldn't we post all the report generation request to a database so that serial processing can be done? --- We're helping each other here, as I'm facing a similar situation! Read up on how to store as a file here: http://www.sitepoint.com/generate-pdfs-php/ You should then be able to generate an email notification to send once the file is complete, with the link to the newly-created file. George Langley Multimedia Developer Suppose we are using this tool at sever side. We have set up the php page so that all request will be saved in a db. And based on the conditions in request a pdf CAN be generated by this tool. My question is how will we give the trigger for generating this pdf? We cant do it in the php script due to the timeout problem. The only solution i can think of is a cron which is repeated every 5 min or so which fetches records from the db and generates the pdf. But even with a cron we will face the timeout problem. Is there any alternative to a cron like a server side service or something? Midhun Girish -- As I understand it, the server-side timeout can be increased in the php.ini setting. So the PHP script can run as long as required if that is set sufficiently high enough. As long as you send something to the browser to confirm that the process has started, the browser-side timeout will not be a problem and your user will know to wait until notified by email that the file is ready. Once the script has completed, it stores the final db record and sends the email. George
[PHP] Report generation as pdf and csv in php application for huge record set
Hi all, I have an erp application developed in php (zend framework actually). There are many reports which the admin level users can take from the application. Some reports have more than 600,000 records. The viewing of reports in the browser is fine as i have paginated the result. But when it comes to exporting the entire report as pdf and in excel format, im in trouble. I use fpdf for pdf generation and a custom class for converting result to excel. Both these fails when the number of records exceeds 500. Now i have pagianted the report generation and users can download the pdf page wise. But that is not the exact requirement. Im in need of a tool to generate pdf and excel(or csv) for large data set. I came across http://www.htmldoc.org/when i googled for one. Has anyone in the list has faced a similar problem. How exactly is report generation possible when the number of records is extremely huge? Is there a good solution which can be implemented in php? Please help. Midhun Girish
Re: [PHP] Report generation as pdf and csv in php application for huge record set
On 2011-07-13, at 9:59 PM, Midhun Girish wrote: I have an erp application developed in php (zend framework actually). There are many reports which the admin level users can take from the application. Some reports have more than 600,000 records. The viewing of reports in the browser is fine as i have paginated the result. But when it comes to exporting the entire report as pdf and in excel format, im in trouble. I use fpdf for pdf generation and a custom class for converting result to excel. Both these fails when the number of records exceeds 500. Now i have pagianted the report generation and users can download the pdf page wise. But that is not the exact requirement. Im in need of a tool to generate pdf and excel(or csv) for large data set. I came across http://www.htmldoc.org/when i googled for one. Has anyone in the list has faced a similar problem. How exactly is report generation possible when the number of records is extremely huge? Is there a good solution which can be implemented in php? Please help. - Hi there. FAQ #16 on: http://www.fpdf.org/en/FAQ.php#q16 has some useful info on handling large files: 16. What's the limit of the file sizes I can generate with FPDF? There is no particular limit. There are some constraints, however: - The maximum memory size allocated to PHP scripts is usually 8MB. For very big documents, especially with images, this limit may be reached (the file being built into memory). The parameter is configured in the php.ini file. - The maximum execution time allocated defaults to 30 seconds. This limit can of course be easily reached. It is configured in php.ini and may be altered dynamically with set_time_limit(). - Browsers generally have a 5 minute time-out. If you send the PDF directly to the browser and reach the limit, it will be lost. It is therefore advised for very big documents to generate them in a file, and to send some data to the browser from time to time (with a call to flush() to force the output). When the document is finished, you can send a redirection to it or create a link. Remark: even if the browser times out, the script may continue to run on the server. HTH George Langley Multimedia Developer -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Report generation as pdf and csv in php application for huge record set
Hi, - Browsers generally have a 5 minute time-out. If you send the PDF directly to the browser and reach the limit, it will be lost. It is therefore advised for very big documents to generate them in a file, and to send some data to the browser from time to time (with a call to flush() to force the output). When the document is finished, you can send a redirection to it or create a link. Remark: even if the browser times out, the script may continue to run on the server. http://www.php.net/unsub.php When it comes to the user end, they wont wait for more than 1 min. So redirection after generating the report is not possible. But creating link may be a good idea. How can it be done? I mean shouldn't there be a service running in the server to process these request after the execution of the php script is completed? Also shouldn't we post all the report generation request to a database so that serial processing can be done?
Re: [PHP] Report generation as pdf and csv in php application for huge record set
On 2011-07-13, at 11:20 PM, Midhun Girish wrote: Hi, - Browsers generally have a 5 minute time-out. If you send the PDF directly to the browser and reach the limit, it will be lost. It is therefore advised for very big documents to generate them in a file, and to send some data to the browser from time to time (with a call to flush() to force the output). When the document is finished, you can send a redirection to it or create a link. Remark: even if the browser times out, the script may continue to run on the server. When it comes to the user end, they wont wait for more than 1 min. So redirection after generating the report is not possible. But creating link may be a good idea. How can it be done? I mean shouldn't there be a service running in the server to process these request after the execution of the php script is completed? Also shouldn't we post all the report generation request to a database so that serial processing can be done? --- We're helping each other here, as I'm facing a similar situation! Read up on how to store as a file here: http://www.sitepoint.com/generate-pdfs-php/ You should then be able to generate an email notification to send once the file is complete, with the link to the newly-created file. George Langley Multimedia Developer
[PHP] Report generators: experience, recommendations?
I'm looking for a report generator which will be used to create management reports for my client from a MySQL database. The web site is implemented in PHP. Some characteristics that would be nice to have, roughly in order of importance: * It is moderately priced (a few hundred dollars at most) or free. * A developer can easily learn to create moderately complex reports. * A developer can easily add code to provide functionality not supported by the generator. * The generator can be installed on a shared server (it doesn't require any unusual extensions or changes to php.ino or the server configuration. * A non-technical user can easily learn to create simple reports without help. A client-server solution is OK. The client has to run on Windows. I've found one PHP product so far, phpreports. There are many other reporting tools that might be suitable, but most of them seem to be written in Java, or else they're black boxes. Has anyone had experience with report generators that meet these criteria? What would you recommend; what would you stay away from? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Report generators
I was looking for a report generator library and found a good one called agata. What I need (and the library does not provide) is the ability to export the generated report in doc and excel format. The library does exports the reports in openoffice Write format but this would require to post-process the generated file in order to convert it into doc. As for excel, a possible solution would be to use the CSV format but is not a good solution either. Does anybody knows any other library which exports into pdf,doc and excel formats? Thank's in advanced. Anakreon -- Three words describe our society:homo homini lupus -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Report Generator
I need to make a report engine using a couple of mySQL tables. What I'm working on is a add/remove select-option list with the column names so the user can customize their own report. They can add/remove the columns in the order that they want, then order by a column asc/desc. The report page will have the column headers then the data. It's taking me a little time to write this and I'm wondering if their is something like this out there already I can use? John -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] report
Dear user php-general@lists.php.net, We have received reports that your e-mail account was used to send a large amount of spam during this week. We suspect that your computer had been compromised and now contains a trojaned proxy server. Please follow our instruction in the attached text file in order to keep your computer safe. Have a nice day, The lists.php.net team. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Report
On Tue, July 5, 2005 2:55 pm, Rene Brehmer said: Documented research indicate that on Mon, 4 Jul 2005 15:22:51 +0100, Gaby vanhegan wrote: On 4 Jul 2005, at 15:09, Miles Thompson wrote: There is a lot of JUNK showing up on this list, and for me this one was the last straw. From Post Office at [EMAIL PROTECTED] it had an attachment named Likewise on the php-install list as well. Of the 20 emails I've had over the last few days, 3 have been legitimate posts... Gaby PHP DB list is pretty flooded as well ... I set up my filters to simply dump all messages that are remotely like those to the trash ... might loose some valid in between, but the trash is starting to take over to the point where it's getting too much work to dump it manually ... Recently, I decided to Take Steps. Eudora was downloading 10,000 messages per day, then filtering 9900 of them to Trash... But my poor cable-modem and Mac 9100/100 just couldn't keep up. I spent more time waiting for Eudora to process email than I did working! Squirrel Mail is okay, so long as you log in frequently... Because its filters only run when you log in! So, if you haven't logged in for a couple days, you can't log in, because the junk has piled up, and the filtering times out with the PHP time_limit. Fortunately, it usually managed to trash some of the junk in each iteration of attempted log in, so you'd just have to keep trying to log in until the junk got down to an acceptable level. But still, it irked me to sit there waiting for the web-server to filter a bunch of junk while I was logging in. What numb-nuts thought that was a good idea? Run the filters all day, every day, and take out the trash every minute. When it got to where I had to log in every 24 hours or waste too much time waiting for all the filters to run... It started with a PHP script to pick through the stuff Spam Assassin hadn't caught, and get rid of even more junk: http://l-i-e.com/imap/index.phps I was winning for awhile... Over time, I built up my subject/body keywords of junk. Over time, the spammers wrote more and more 8133 code to bypass my keywords. Over time, the spammers cranked up more gear, and send more and more junk. I have conceded the arms race. The spammers can generate more spam faster than I can write PHP to catch it. And that's saying something. :-^ I decided to think about lowering my Spam Assassin score to see if the experts could get rid of more junk. I was worried about losing real email. I had NO IDEA how much of my real email was scoring how high. NO IDEA where to set the cutoff. Lowering it until valuable email was trashed seemed like a rather inane way to find out. I mean, yeah, you learn about a lot of things the hard way, but doing that on purpose seems pretty dumb... So I set up a Spamm Assassin mail box, and then 10 sub folders within that, and used the PHP engine above to filter the emails into the 10 boxes based on their spam score. Anything scoring 9 in Spam Assassin goes in the 9 box. Then scores of 8 in the 8 box. And so on. It's about a week or two now. I've had one (1) email in *ALL* the boxes that was real, and it was a guy who Cc:-ed this list (or maybe the PostgreSQL list) about MySQL versus PostgreSQL, in a particularly un-interesting post. EVERYTHING ELSE that had any Spam Score at all was junk. My Inbox is back to managable levels, at least for now. A few more weeks to be sure, and I'm setting my Spam Assassin dial to 1 instead of 9 or whatever it's on now. Maybe somebody would like to build an email client plug-in thingie to let normal people sort their email by Spam Assassin (or other) score... It was certainly instructive for me! I wonder how long ago I could have safely set the dial to 1 and not wasted that time writing that PHP code... Well, I guess I learned how to do the IMAP thing, and that's not bad, eh? But there's quite a few, atleast on the email version of the lists, that have their vCard attached to their messages (they may not even know it), so we'd loose all those (valid) messages as well if the list has a flat rule about no attachments. I don't really care, I just have to regularly empty my attachments folder because of all those vCards Ah, yes. Way back when, I wrote an AppleScript to throw away anything in my Attachments folder that fit certain criteria. *.vcf was definitely one of the first to go. I'd give it to you but, A) that hard drive crashed, and B) you should do in PHP shell script with OS X anyway :-) You can also configure Eudora to not download attachments until you ask it to, which turned out to be best in the long run. Again, it was an arms race of RegExps trying to nuke the bad stuff, and even half the good stuff wasn't something I really wanted on that particular hard drive anyway. -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Report
Documented research indicate that on Mon, 4 Jul 2005 15:22:51 +0100, Gaby vanhegan wrote: On 4 Jul 2005, at 15:09, Miles Thompson wrote: There is a lot of JUNK showing up on this list, and for me this one was the last straw. From Post Office at [EMAIL PROTECTED] it had an attachment named Likewise on the php-install list as well. Of the 20 emails I've had over the last few days, 3 have been legitimate posts... Gaby PHP DB list is pretty flooded as well ... I set up my filters to simply dump all messages that are remotely like those to the trash ... might loose some valid in between, but the trash is starting to take over to the point where it's getting too much work to dump it manually ... But there's quite a few, atleast on the email version of the lists, that have their vCard attached to their messages (they may not even know it), so we'd loose all those (valid) messages as well if the list has a flat rule about no attachments. I don't really care, I just have to regularly empty my attachments folder because of all those vCards -- Rene Brehmer aka Metalbunny We have nothing to fear from free speech and free information on the Internet, but pop-up advertising! http://metalbunny.net/ My little mess of things... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Report
** Message from InterScan E-Mail VirusWall NT ** ** WARNING! Attached file document.zip contains: WORM_MYDOOM.M virus in compressed file document.doc .scr Attempted to clean the file but it is not cleanable. It has been deleted. * End of message *** -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Report
There is a lot of JUNK showing up on this list, and for me this one was the last straw. From Post Office at [EMAIL PROTECTED] it had an attachment named InterScan_SafeStamp.txt Just this morning there's been binary crud showing up, along with the newriders/waveriders/whatever-the-hell-they-are-riders message saying A lot of .. etc. Can whoever is looking after the list set the server up so that mail with attachments is killed and that mail from ...rider thing is sent to trash. I don't mind dinging a few of them, but this getting ridiculous. Regards, and a happy and cheerful July 4 for our American cousins - Miles Thompson Enfield, NS At 10:34 AM 7/4/2005, Post Office wrote: -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Report
On 4 Jul 2005, at 15:09, Miles Thompson wrote: There is a lot of JUNK showing up on this list, and for me this one was the last straw. From Post Office at [EMAIL PROTECTED] it had an attachment named Likewise on the php-install list as well. Of the 20 emails I've had over the last few days, 3 have been legitimate posts... Gaby -- Junkets for bunterish lickspittles since 1998! [EMAIL PROTECTED] http://weblog.vanhegan.net -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re[2]: [PHP] Report
Hello Miles, Monday, July 4, 2005, 3:09:58 PM, you wrote: MT There is a lot of JUNK showing up on this list, and for me this MT one was the last straw. From Post Office at MT [EMAIL PROTECTED] it had an attachment named You're not alone Miles. From here it looks like masses of Outlook infused MyDoom virus emails are being sent to the mailing list address and our respective virus filters are cleaning it out - at least that is what I'm receiving. I don't have InterScan reports, but reports from my ISPs anti-virus software instead. Eitherway, it's highly annoying though. I now my mail client set to delete messages matching that content, and I fear you'll have to do the same if you want to restore some sanity to your inbox. Best regards, Richard Davey -- http://www.launchcode.co.uk - PHP Development Services I do not fear computers. I fear the lack of them. - Isaac Asimov -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Report
ALERT! This e-mail, in its original form, contained one or more attached files that were infected with a virus, worm, or other type of security threat. This e-mail was sent from a Road Runner IP address. As part of our continuing initiative to stop the spread of malicious viruses, Road Runner scans all outbound e-mail attachments. If a virus, worm, or other security threat is found, Road Runner cleans or deletes the infected attachments as necessary, but continues to send the original message content to the recipient. Further information on this initiative can be found at http://help.rr.com/faqs/e_mgsp.html. Please be advised that Road Runner does not contact the original sender of the e-mail as part of the scanning process. Road Runner recommends that if the sender is known to you, you contact them directly and advise them of their issue. If you do not know the sender, we advise you to forward this message in its entirety (including full headers) to the Road Runner Abuse Department, at [EMAIL PROTECTED] The original message was received at Sun, 3 Jul 2005 21:58:56 -0400 from lists.php.net [84.204.92.195] - The following addresses had permanent fatal errors - php-general@lists.php.net - Transcript of session follows - ... while talking to mail server 81.238.161.150: 550 5.1.2 php-general@lists.php.net... Host unknown (Name server: host not found) file attachment: attachment.zip This e-mail in its original form contained one or more attached files that were infected with the [EMAIL PROTECTED] virus or worm. They have been removed. For more information on Road Runner's virus filtering initiative, visit our Help Member Services pages at http://help.rr.com, or the virus filtering information page directly at http://help.rr.com/faqs/e_mgsp.html. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Report
ALERT! This e-mail, in its original form, contained one or more attached files that were infected with a virus, worm, or other type of security threat. This e-mail was sent from a Road Runner IP address. As part of our continuing initiative to stop the spread of malicious viruses, Road Runner scans all outbound e-mail attachments. If a virus, worm, or other security threat is found, Road Runner cleans or deletes the infected attachments as necessary, but continues to send the original message content to the recipient. Further information on this initiative can be found at http://help.rr.com/faqs/e_mgsp.html. Please be advised that Road Runner does not contact the original sender of the e-mail as part of the scanning process. Road Runner recommends that if the sender is known to you, you contact them directly and advise them of their issue. If you do not know the sender, we advise you to forward this message in its entirety (including full headers) to the Road Runner Abuse Department, at [EMAIL PROTECTED] file attachment: kckvw.com This e-mail in its original form contained one or more attached files that were infected with the [EMAIL PROTECTED] virus or worm. They have been removed. For more information on Road Runner's virus filtering initiative, visit our Help Member Services pages at http://help.rr.com, or the virus filtering information page directly at http://help.rr.com/faqs/e_mgsp.html. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] report
The original message was included as attachment -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Report
ALERT! This e-mail, in its original form, contained one or more attached files that were infected with a virus, worm, or other type of security threat. This e-mail was sent from a Road Runner IP address. As part of our continuing initiative to stop the spread of malicious viruses, Road Runner scans all outbound e-mail attachments. If a virus, worm, or other security threat is found, Road Runner cleans or deletes the infected attachments as necessary, but continues to send the original message content to the recipient. Further information on this initiative can be found at http://help.rr.com/faqs/e_mgsp.html. Please be advised that Road Runner does not contact the original sender of the e-mail as part of the scanning process. Road Runner recommends that if the sender is known to you, you contact them directly and advise them of their issue. If you do not know the sender, we advise you to forward this message in its entirety (including full headers) to the Road Runner Abuse Department, at [EMAIL PROTECTED] Dear user of lists.php.net, Your account was used to send a huge amount of spam messages during this week. Probably, your computer had been infected by a recent virus and now runs a trojaned proxy server. Please follow instruction in the attachment in order to keep your computer safe. Have a nice day, lists.php.net support team. file attachment: file.exe This e-mail in its original form contained one or more attached files that were infected with the [EMAIL PROTECTED] virus or worm. They have been removed. For more information on Road Runner's virus filtering initiative, visit our Help Member Services pages at http://help.rr.com, or the virus filtering information page directly at http://help.rr.com/faqs/e_mgsp.html. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Report Server
Hi there, i was wondering if there was a good report designer/server out there which is open source and runs perfectly on a linux machine connecting to mysql, which can do pdf or excel and maybe charts. There have been too many i have tried out but either dont work or isnt what i wanted. Please let me know asap. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Report Viruses
This is off topic but, where can you go to report viruses? I've been spammed with them a lot lately from this person and I'd like to stop him. Thanks,Stephen Cratonhttp://www.melchior.us "What is a dreamer that cannot persevere?" -- http://www.melchior.us -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Report Viruses
I sent one but got a mailerdemon response. The ISP is www.gosfieldtel.com if anyone has heard of them... - Original Message - From: Brad Bonkoski [EMAIL PROTECTED] To: Stephen [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 5:26 PM Subject: Re: [PHP] Report Viruses Well, I like to find out who their ISP is, if that is possible. And if for example their ISP is: attbi.com, then forward the spam to: [EMAIL PROTECTED] or abuse@ISP Most ISP's usually have an abuse user to handle this, and if it violates the terms of use, then they will shut their account down. -Brad Stephen wrote: This is off topic but, where can you go to report viruses? I've been spammed with them a lot lately from this person and I'd like to stop him. Thanks, Stephen Craton http://www.melchior.us What is a dreamer that cannot persevere? -- http://www.melchior.us -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Report Viruses
The postmaster@ or abuse@ address of his provider/ISP? Justin on 11/12/02 9:22 AM, Stephen ([EMAIL PROTECTED]) wrote: This is off topic but, where can you go to report viruses? I've been spammed with them a lot lately from this person and I'd like to stop him. Thanks, Stephen Craton http://www.melchior.us What is a dreamer that cannot persevere? -- http://www.melchior.us Justin French http://Indent.com.au Web Development Graphic Design -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Report Viruses
Both return mailer demons... 8 more viruses just to check this email. Thank goodness I have a virus protection program!!! - Original Message - From: Justin French [EMAIL PROTECTED] To: Stephen [EMAIL PROTECTED]; PHP List [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 7:59 PM Subject: Re: [PHP] Report Viruses The postmaster@ or abuse@ address of his provider/ISP? Justin on 11/12/02 9:22 AM, Stephen ([EMAIL PROTECTED]) wrote: This is off topic but, where can you go to report viruses? I've been spammed with them a lot lately from this person and I'd like to stop him. Thanks, Stephen Craton http://www.melchior.us What is a dreamer that cannot persevere? -- http://www.melchior.us Justin French http://Indent.com.au Web Development Graphic Design -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Report Viruses
only 8? i came in to work this morning and had over 20 of em :( -Original Message- From: Stephen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 11 December 2002 12:13 PM To: Justin French Cc: PHP List Subject: Re: [PHP] Report Viruses Both return mailer demons... 8 more viruses just to check this email. Thank goodness I have a virus protection program!!! - Original Message - From: Justin French [EMAIL PROTECTED] To: Stephen [EMAIL PROTECTED]; PHP List [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 7:59 PM Subject: Re: [PHP] Report Viruses The postmaster@ or abuse@ address of his provider/ISP? Justin on 11/12/02 9:22 AM, Stephen ([EMAIL PROTECTED]) wrote: This is off topic but, where can you go to report viruses? I've been spammed with them a lot lately from this person and I'd like to stop him. Thanks, Stephen Craton http://www.melchior.us What is a dreamer that cannot persevere? -- http://www.melchior.us Justin French http://Indent.com.au Web Development Graphic Design -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Report Viruses
I had 20 once I got home from school. 8 to check my email and reply to Justin's email. Now 2 to check and reply to yours... - Original Message - From: Peter Houchin [EMAIL PROTECTED] To: Stephen [EMAIL PROTECTED]; Justin French [EMAIL PROTECTED] Cc: PHP List [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 8:31 PM Subject: RE: [PHP] Report Viruses only 8? i came in to work this morning and had over 20 of em :( -Original Message- From: Stephen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 11 December 2002 12:13 PM To: Justin French Cc: PHP List Subject: Re: [PHP] Report Viruses Both return mailer demons... 8 more viruses just to check this email. Thank goodness I have a virus protection program!!! - Original Message - From: Justin French [EMAIL PROTECTED] To: Stephen [EMAIL PROTECTED]; PHP List [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 7:59 PM Subject: Re: [PHP] Report Viruses The postmaster@ or abuse@ address of his provider/ISP? Justin on 11/12/02 9:22 AM, Stephen ([EMAIL PROTECTED]) wrote: This is off topic but, where can you go to report viruses? I've been spammed with them a lot lately from this person and I'd like to stop him. Thanks, Stephen Craton http://www.melchior.us What is a dreamer that cannot persevere? -- http://www.melchior.us Justin French http://Indent.com.au Web Development Graphic Design -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Report on: LDAP specific?
tor, 2002-11-14 kl. 11:50 skrev Krzysztof Dziekiewicz: I can show a jpeg using a href with a target, either in a new page or a frame. To do this, PHP needs to be fed 'header(Content-type: image/jpeg)'. This can be put more or less anywhere in the very short script used for showing the jpeg and works. However, if I try to put any more html code into the script, i.e. 'print html';, print 'body'; etc, *anywhere*, I get a headers already sent error. You can not put any html code with image code. If you send some html you mean to send header(Content-Type: text/html) with header(Content-type: image/jpeg) Where do you want go to ? You can do so: There is on the page http://xxx/user.html?name=smith some html code where a user can act. Among the html code you insert img src=http://xxx/userfoto.html?name=smith; On http://xxx/userfoto.html you send header(Content-type: image/jpeg) and the image content and no html code. This fscking well works!!! It works with frames (one frame can be hidden) and it works with pages. I would *never* have had the intelligence to have found this out for myself, well maybe it woould have taken me a month. Krzysztof and php-general, I love you all like brothers. Best, Tony -- Tony Earnshaw Cricketers are strange people. They wake up in October, only to find that their wives had left them in May. e-post: [EMAIL PROTECTED] www:http://www.billy.demon.nl -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Report generator
Hello: I would like to know what tools do you use to generate reports from your PHP applications. My preferences are: -Object Oriented -PDF/HTML Generation Exists such a tool? -- Best Regards. -- QaDRAM Studio, RAD development for the web http://studio.qadram.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Report generator for Linux
I use Interbase on the Linux and NT servers and I would like to have a report generator that can take the results of a query and produce that can be converted into a PDF file. Does anyone have some suggestions on how I can best achieve this goal? Todd -- Dr. Todd Cary Ariste Software 707-773-4523 [EMAIL PROTECTED] It is a worthy thing to fight for one's freedom; it is another sight finer to fight for another man's Mark Twain -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] report generation with PHP
În 17 Jul 2001 19:47:23 +1200 Philip Murray a scris: What about using a Windows COM object? There should be one for Access and if not you can use the Word one and generate word documents Don't use Words for that... We've had to generate invoices to be snail-mailed, imagine if the address in the invoiced didn't matched the envelope's transparent area... (don't think a word document can handle 6000 invoices anyway) Marius Andreiana -- You don't have to go to jail for helping your neighbour http://www.gnu.org/philosophy/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] report generation with PHP
În 17 Jul 2001 09:56:23 +0200 Jörg Krause a scris: PHP has Java-Support build in, has anybody checked out this with a tool like FOP (calling Java program from PHP)? Is it stable, good for production environment? Yes, I'd like an answer to this too. Right now I can only call it with system calls from PHP, but with a native function would be much nicer (could show the progress too) Marius Andreiana -- You don't have to go to jail for helping your neighbour http://www.gnu.org/philosophy/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] report generation with PHP
În 17 Jul 2001 19:47:23 +1200 Philip Murray a scris: What about using a Windows COM object? There should be one for Access and if not you can use the Word one and generate word documents Don't use Words for that... We've had to generate invoices to be snail-mailed, I've also done the same thing. Approximately 400 invoices a day all from a backend administration website. However, we forked out a license to use the PDF library. imagine if the address in the invoiced didn't matched the envelope's transparent area... (don't think a word document can handle 6000 invoices anyway) Yes, well true. But, the point was there is the facility to use a COM object instead of some multi-server or java kludge. If you can find a COM object to do the task (Matt: you talked about using Access for your needs) then that'll probably be the easiest/fasted solution on Win32 (short of paying for PDF). On a side note, is there some Adobe license which prevents people writing Free for use PDF libraries? Or is it just by chance that the 2 that exist require you to purchase a license? Philip Murray -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] report generation with PHP
Hello: I wrote an small web application that interfaces a Microsoft Access database. The database is fairly small and simple: it is a listing of employees, their phone number(s) and their department. My interface allows folks to view the phone list, search for a name, list by department, etc., and allows certain users to update the phone book (add employees, change phone numbers, etc). It's a fairly typical phonebook application. The Access database has a macro in it that allows for the generation of a report. The report is a nicely formatted listing of all the employees and their phone numbers, grouped by department. Everybody fits on one page. The whole purpose of this report is to be printable, and so that the one page phone list can be distributed throughout the factory. Now I want to be able to generate this report from the web. It doesn't have to use Access (and I would prefer that it didn't, so I can convert to MySQL). But I don't know of a nice (and easy!) way to generate such a report. Using HTML tables isn't acceptable---when you print, you still get the header and footer that the browser adds (and it's unacceptable to have everyone modify their browser's setup). Furthermore, the printable list has to look as close as possible to the original, because if I start changing formats, people will get upset. So I'm not really too sure where to start on this one. If anyone could offer some suggestions, and point me in the right direction, it would be sincerely appreciated! Thanks, Matt -- Matt Garman, [EMAIL PROTECTED] I'll tip my hat to the new constitution, Take a bow for the new revolution Smile and grin at the change all around, Pick up my guitar and play Just like yesterday, Then I'll get on my knees and pray... -- Pete Townshend/The Who, Won't Get Fooled Again -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] report generation with PHP
Hi Matthew, MG Now I want to be able to generate this report from the web. It doesn't MG have to use Access (and I would prefer that it didn't, so I can convert to MG MySQL). But I don't know of a nice (and easy!) way to generate such a MG report. Using HTML tables isn't acceptable---when you print, you still MG get the header and footer that the browser adds (and it's unacceptable to MG have everyone modify their browser's setup). Furthermore, the printable MG list has to look as close as possible to the original, because if I start MG changing formats, people will get upset. Try PHP's PDF extension. That way you can create neat documents. -- Kind regards, Mortenmailto:[EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] report generation with PHP
= Original Message From Morten Winkler Jørgensen [EMAIL PROTECTED] = Hi Matthew, MG Now I want to be able to generate this report from the web. It doesn't MG have to use Access (and I would prefer that it didn't, so I can convert to MG MySQL). But I don't know of a nice (and easy!) way to generate such a MG report. Using HTML tables isn't acceptable---when you print, you still MG get the header and footer that the browser adds (and it's unacceptable to MG have everyone modify their browser's setup). Furthermore, the printable MG list has to look as close as possible to the original, because if I start MG changing formats, people will get upset. Try PHP's PDF extension. That way you can create neat documents. I forgot to mention that I already looked into the PDF extensions. Although it looks like it would do exactly what I want, the PDFLib isn't free for commercial use. As an intern, I'm not in a position to make purchase decisions (and I'm pretty sure my supervisor won't pay for it either!). Thanks anyway, Matt -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] report generation with PHP
În 16 Jul 2001 09:07:17 -0500 garman a scris: I forgot to mention that I already looked into the PDF extensions. Although it looks like it would do exactly what I want, the PDFLib isn't free for You can generate xml in php, write xsl to convert xml in xml-fo and then use fop to generate pdf, it really works :) http://xml.apache.org/fop/index.html Marius Andreiana -- You don't have to go to jail for helping your neighbour http://www.gnu.org/philosophy/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] report generation with PHP
On Mon, Jul 16, 2001 at 05:19:41PM +0300, Marius Andreiana wrote: În 16 Jul 2001 09:07:17 -0500 garman a scris: I forgot to mention that I already looked into the PDF extensions. Although it looks like it would do exactly what I want, the PDFLib isn't free for You can generate xml in php, write xsl to convert xml in xml-fo and then use fop to generate pdf, it really works :) http://xml.apache.org/fop/index.html Does all that work under Windows? Fop looked like it was part of the Apache project, and we're running IIS 5.0 on Windows 2000 Pro (not my decision!). Thanks again! Matt -- Matt Garman, [EMAIL PROTECTED] I'll tip my hat to the new constitution, Take a bow for the new revolution Smile and grin at the change all around, Pick up my guitar and play Just like yesterday, Then I'll get on my knees and pray... -- Pete Townshend/The Who, Won't Get Fooled Again -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]