using a button to perform tasks

[rlm51]

Hey everyone ...

I have a button on my page:

     <input name="button" type="button" class="style3" onclick="window.print()" value="Print Coupon" />
 

that uses window.print() to print a coupon. I would like to add a function to the code that updates a field in a database that tracks how many coupons are printed. Is there a way to add this function:

$CouponNo = $CouponNo + 1;
mysql_query("UPDATE tbl_depts SET CouponNo = $CouponNo WHERE `key` = $spec");
 

to that button?

Thanks for any help

Robert

[Atli]

Hi Robert.

HTML and JavaScript, being server-side monstrosities, can not directly interact with PHP, as that is a server-side language.

You can, however, use tools such as Ajax to make HTTP requests on your server to execute PHP scripts.

For example, if you were to put your PHP code, the one you posted above, in a PHP file, you could use Ajax to request that file from your server, which would effectively increment you coupon count.

[rlm51]

Thanks for your reply. I actually figured it out over the weekend.
In Dreamweaver, you can tag more than one behavior to the "onclick" so I ended up using this code:

      <input name="button" type="button" class="style3" onclick="window.print() ;MM_goToURL('parent','../DeptSpecials.php');<?PHP $CouponNo = $CouponNo + 1 ?>;return document.MM_returnValue" value="Print Coupon" />
 

Works great ...

Again, thanks for your help.

Hope everyone has a great holiday season.

Robert