From 0a28f9b24a86be118b983b78ae9b105b758c5a43 Mon Sep 17 00:00:00 2001 From: wbudic Date: Sat, 25 Aug 2018 08:16:38 +1000 Subject: [PATCH] Implemented cgi-param('chk') for comfirmation n remove.cgi --- htdocs/cgi-bin/main.cgi | 2 +- htdocs/cgi-bin/remove.cgi | 25 ++++++++++--------------- 2 files changed, 11 insertions(+), 16 deletions(-) diff --git a/htdocs/cgi-bin/main.cgi b/htdocs/cgi-bin/main.cgi index 202138a..54f7f92 100755 --- a/htdocs/cgi-bin/main.cgi +++ b/htdocs/cgi-bin/main.cgi @@ -127,7 +127,7 @@ if($rv < 0) { $tbl = $tbl . "". $dt->ymd . "" . "" . $dt->hms . "" . "" . $row[3] . "". "" . $ct . - " \n"; + " \n"; $tbl_rc +=1; } diff --git a/htdocs/cgi-bin/remove.cgi b/htdocs/cgi-bin/remove.cgi index 2ac56f0..2e074a4 100755 --- a/htdocs/cgi-bin/remove.cgi +++ b/htdocs/cgi-bin/remove.cgi @@ -36,10 +36,11 @@ $today->set_time_zone( 'Australia/Sydney' ); my $stmtCat = "SELECT * FROM CAT;"; -$sth = $dbh->prepare( $stmtCat ); +my $sth = $dbh->prepare( $stmtCat ); my $rv = $sth->execute() or die or die "

Error->"& $DBI::errstri &"

"; my %hshCats; +my $tbl_rc =0; while(my @row = $sth->fetchrow_array()) { $hshCats{$row[0]} = $row[1]; @@ -64,10 +65,16 @@ sub NotConfirmed{ #Get prms and build confirm table and check ### TODO +my $stm = $stmS ." "; +foreach my $prm ($q->param('chk')){ + $stm = $stm . "rowid = '" . $prm . "' OR "; +} +#rid=0 hack! ;) + $stm = $stm . "rowid = '0' " . $stmE; -#Fetch entries! +print $stm; # -$sth = $dbh->prepare( $stmt ); +$sth = $dbh->prepare( $stm ); $rv = $sth->execute() or die or die "

Error->"& $DBI::errstri &"

"; if($rv < 0) { print "

Error->"& $DBI::errstri &"

"; @@ -93,21 +100,9 @@ if($rv < 0) { $tbl = $tbl . ""; $tbl = $tbl . ""; -my $frm = qq( -
- - - - - - -
Datehms . qq(">
Log: ).$cats.qq(
-
- ); -print "
\n" . $frm ."
"; print "
\n" . $tbl ."
"; } -- 2.34.1