Check Printing thru the web

Currently our application does everything thru the web, but check writing.
We currently do checks thru a client server program.

The client server program allows us to run a batch of checks directly to the printer and controlling when a user prints a check twice.
The checks are not preprinted forms, they are completely created on laser printers, with signatures if under a certain amount.

We would like to replace the check program with a web based solution.
A pdf created on the server, and then downloaded is a possible solution, but how would we disallow multiple prints?

We would like to know what solutions are available for this?

Thanks
riskvisionAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

a2techCommented:
When you speak of your current application, do you mean one that you purchased "off the shelf" or one that you had written for you? If so, the main problem you might have is integration between the two systems so that you can pass the data to the check writing program.

A web-based program, such as one written in PHP, can perform the functions you indicate. It can keep track of checks and how many times they are printed. You would have to pay a developer to write the programs. Also, you need aplace to host it, either on an intranet server, or the internet with added security. Remember to add these additional costs in to your business model for the job.

I mentioned PHP because it can be used to generate PDF's. Also, it can pull data from and manipulate database; much like your client server program.

0
riskvisionAuthor Commented:
Thank you for your information, but we are looking for technical examples and information on how we can develop this function, preferably in ASP. But since you seem to have knowledge in PHP, please explain in detail how you would accomplish what you stated above.  Thanks in advance.
0
adanv1Commented:
In PHP to make sure something isn't done twice you should use a simple IF statement and a MySQL database (unless a text file is all you would do).

The PHP Code would look something like this:

<?php

// Connect to your MySQL Database //
// MySQL Available Here: //
// http://www.mysql.com //
$dbusername="your_mysql_username";
$dbpassword="your_mysql_password";
$database="your_database_name";
$connect_to_database = mysql_connect("localhost", "$usernam", "$pass") or die("Invalid server or user."); mysql_select_db("$db", $conn);

$result = mysql_query("select printed_times from print_counts WHERE check_num='$num'"); // you'll have to set the $num var to the check ID
$run_check_printed = mysql_result($result, 0);


if($run_check_printed==1){
echo"Sorry, this check has been printed more than once.";
} else{
// print the check
// more php can be found at:
// http://www.php.net
// or by searching with www.google.com
} // end of the else statement

?>

That's the bases of the code you would want to use. You will need a server that supports PHP ( http://www.php.net ) and a MySQL Database ( http://www.mysql.com ) unless you want to use a text file and store the printed numbers in that. I hope this helps, and happy thanksgiving!

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
riskvisionAuthor Commented:
Thanks a lot, I haven't tried it yet, but I did find more information about writing directly to the printer, from within PHP on www.php.net.

IF PHP does write directly to the printer, then this will work.

Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development Software

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.