#!/usr/bin/perl -w

use CGI;
use strict;
use DBI;

my $query = new CGI->new();



print $query->header("text/html"),


$query->start_html(-title => "Database Test"),

$query->h1("Database Test"),

my $user = $query->param("username"),

my  $db_handle = DBI->connect("dbi:mysql:database=test;host=localhost;user=root;")
  or die "Couldn't connect to database: $DBI::errstr\n";
   
my $sql = "SELECT * FROM users WHERE id = '$user'";

my $statement = $db_handle->prepare($sql)
        or die "Couldn't prepare query '$sql': $DBI::errstr\n";

$statement->execute()
        or die "Couldn't execute query '$sql': $DBI::errstr\n";
    
while (my $row_ref = $statement->fetchrow_hashref())
{
   
	
	print "<b>$row_ref->{email}</b>" ;
	
}

$db_handle->disconnect();

 print "<h1>Database Test</h1>";

	$query->end_html;