#!/usr/bin/perl -T

use CGI::Carp qw(fatalsToBrowser);

use warnings;
use strict;
use feature 'say';
use Scalar::Util qw/tainted/;
use DBI;
use DBI::Const::GetInfoType;

my @argv;
if ($ENV{'GATEWAY_INTERFACE'}) {
    @argv = split /&/, $ENV{'QUERY_STRING'};
} else {
    @argv = @ARGV;
}

my $db_user = 'xxx';
my $db_pass = 'xxx';
my $dbh = DBI->connect(
    "DBI:mysql:database=shoples1_testing;host=127.0.0.1", $db_user,
    $db_pass, { RaiseError=>1, AutoCommit=>1, TaintIn=>0 });

print "Content-type: text/plain\n\n";

say "Perl: $]";
say "Database: ",
    $dbh->get_info( $GetInfoType{SQL_DBMS_NAME} ), " ",
    $dbh->get_info( $GetInfoType{SQL_DBMS_VER} );
say "Driver: ", $dbh->{Driver}->{Name};
say "DBI Ver: ", $DBI::VERSION;
say "DBD::mysql Ver: ", $DBD::mysql::VERSION;

$dbh->do('DROP TABLE IF EXISTS Person');
$dbh->do(<<'ENDSQL');
CREATE TABLE Person (
    idPerson INT,
    email VARCHAR(256),
    altEmail VARCHAR(256)
);
ENDSQL
$dbh->do('INSERT INTO Person (idPerson, email, altEmail) VALUES (5, ?,
+ "foo@bar.com");', undef, $argv[1]);

die "run me with an empty string as the first argument"
    unless @argv && !length $argv[0];
my %data = ( email => $argv[1] );
say "Email is tainted" if tainted($data{'email'});

say "Tainted...";
say "EMAIL: $argv[1]";

if ($argv[1] =~ /^(.+\@.+\..+)$/) {
    $argv[1] = $1;
    
    say "Untainted...";
    say "EMAIL: $argv[1]";
}

my $query = $dbh->prepare("SELECT idPerson FROM Person WHERE email = ?
+ OR altEmail = ?");
$query->execute($data{'email'}, $data{'email'});
my ($crid) = $query->fetchrow_array;
say "CRID:  $crid";

my ($test) = $dbh->selectrow_array("SELECT idPerson FROM Person WHERE 
+email = ? OR altEmail = ?", undef, $data{'email'}, $data{'email'});
say "TEST:  $test";

__END__
[download]