2. PHPRunner General questions
  3. Not just for printing purposes : How to use selected checkbox in list
This topic is locked

Not just for printing purposes : How to use selected checkbox in list

5/16/2008 6:20:53 AM
PHPRunner General questions
R
 rockrockers23 author

Hey GUYS...

Problem :

Not just for printing purposes : How to use selected checkbox records in LIST in updating my database?.

Elaboration : im going to view and print selected records on the LIST by checking the checkbox.

NOW,:

I have a database table : Bill_Printing_Status .With two table FIELDS : Bill_Number and Printing_Status;

NOw,

How would i track down those selected Billing records to be also updated in my database

changing the Printing_Status to 'Printed'.?
How do phpRunner handle those kind of checkbox selection..? are they stored in sessions ? or just array variables.?
J
 		Jane 5/16/2008

Hi,
to update table and change status to Printed use Print page: Before SQL query event.

Here is a sample code:

global $conn;

$strUpdate = "update Bill_Printing_Status set Printing_Status='Printed' where (".$strWhereClause.")";

db_exec($strUpdate,$conn);
R
 		rockrockers23 author 5/16/2008

hi Jane...
thanks a lot.. it works fine now... thanks ..
R
 		rockrockers23 author 5/19/2008

Hi Jane.. regarding to my problem...

How will i redirect my current LIST PAGE to a new LIST PAGE displaying the records that ive selected...?
R
 		rockrockers23 author 5/19/2008

hi again jane... sorry... i thought it is already ok BUT when i view on the LIST PAGE and check my Database, My Printing Status field is NOT UPDATED. IT IS STILL UNPRINTED.
R
 		rockrockers23 author 5/19/2008

hi again jane... sorry... i thought it is already ok BUT when i view on the LIST PAGE and check my Database, My Printing Status field is NOT UPDATED. IT IS STILL UNPRINTED.

Pls Help me miss jane..
R
 		rockrockers23 author 5/19/2008

hi again and again... sorry for my paranoid problem.... I found already the problem... its the BROWSER

Sorry Jane... YOUR CODE REALLY WORKS WELL..!!! I really appreciate that...thnx..
firefox 3.1 beta confuses me a lot.... but when i use the ie7 and firefox 2.0.14 they really works great....