#! /usr/bin/perl
#
# sqlite3_perl_delete.pl
#
# Oct/21/2010
# ---------------------------------------------------------------------
#
use strict;
use warnings;
use JSON;
use CGI qw (:standard);
#
use DBI;
use lib '/var/www/data_base/common/perl_common';
use cgi_manipulate;
use text_manipulate;
use sql_manipulate;
# ---------------------------------------------------------------------
#
my $db_in_aa = "/var/tmp/sqlite3/cities.db";
my $dbh = DBI->connect ("dbi:SQLite:$db_in_aa")
|| die "Cannot connect: $DBI::errstr";
#
#
print "Content-type: text/html\n\n";
#
#
my @arry_bb = cgi_manipulate::parse_parameter ();
#
print "*** mysql_perl_delete.pl *** start ***
";
#
my $it=0;
foreach (@{$arry_bb[0]})
{
my $id = $arry_bb[0][$it];
print "$id
";
sql_manipulate::dbi_delete_proc ($id,$dbh);
$it++;
}
#
$dbh->disconnect;
#
print "*** sqlite3_perl_delete.pl *** end ***
";
#
# ---------------------------------------------------------------------
#