Reports

[shakayu]

Hello friends :)
I would like to get a help once again..
I need to make reports in php with Codeigniter then be able to print it..
Like list of people who are hasnt yet settle payment
I know..its just a query...but how to turn that a report and give the user the option to print it..
Any guide please..

[LastMitch]

I need to make reports in php with Codeigniter then be able to print it..\

How the reports generated? Is it PDF or other files?

Here a link to generated PDF

http://www.christophermonnat.com/2008/08/generating-pdf-files-using-codeigniter/

You need to used this to print:

window.print();

http://www.congnghiepviet.com.vn/lib/jquery/plugin/jPrintArea.htm

[broj1]

Your responsibility is to format the data read from the database, using PHP and HTML, into something that looks useful and appealing to the user. You can use tables, lists and other HTML elements and CSS. Regarding CSS you can use media rules: @screen for onscreen display in the browser and print for printing. You can also dive into CSS3 media queries for more.

And of course as LastMitch suggested, you can use PDF which will give you much more formating freedom.

[shakayu]

Hye , guys thanks so much :D. .
what about printing some kind of receipt ..where there would be thinng written, i just need to cater for the "name" from the database :S

[broj1]

Can you explain more, please?

[yy886]

If you are looking for printing some stuff out than you can have look of this page.
(php net manual)
http://php.net/manual/en/function.printer-open.php

[LastMitch]

what about printing some kind of receipt ..where there would be thinng written, i just need to cater for the "name" from the database :S

Like what bro1 mention explain a little more what receipt?

I think you might be confused with a Cash Register?

I mean if you are going to print something out from the website (Codeigniter Framework) then I think the CSS would be a best option because you can design and measure the size of the receipt (paper) and it will print it out.

If you were to convert it to PDF then that will be bit too much work on just for a receipt.

[shakayu]

i want like a receipt...hmm aafter payment , we usually get receipt..that wat am talking about :/...in that receipt...the name of customer wud be taken from the db ...

[broj1]

Again, you have to design the receipt using HTML + CSS. Also you have to build the logic to read the correct name from the db.

[LastMitch]

i want like a receipt...hmm aafter payment , we usually get receipt..that wat am talking about :/...in that receipt...the name of customer wud be taken from the db ...

Did you read what broj1 mention used HTML + CSS to do that. He even provide a link for to do that too.

[shakayu]

Theres no link :(

[broj1]

See media rules @screen and @print (my first post).

[shakayu]

oki, thanks

[broj1]

Hopefuly this resolves your issue. If yes, please mark as solved. If no, come back with more questions. Happy coding.