I tried this to save:
use strict;
use warnings;
use Tk;
use Tk::JPEG;
use DBI;
my $datenbank = "bilder";
my $db_host = "localhost";
my $db_port = "3306";
my $db_user = "root";
my $db_pw = "12345";
my $dbh;
my $dsn = "DBI:mysql:database=$datenbank;host=$db_host;port=$db_port"
+;
eval {
$dbh = DBI::->connect( $dsn, $db_user, $db_pw, { Raise
+Error => 1, PrintError => 0, AutoCommit => 1 } );
};
if ($@)
{
print DBI::errstr;
}
my $mw = MainWindow->new();
my $bild = $mw->Photo( -file => "test.jpg" );
$dbh->do("INSERT INTO User (User,Bild) values (?,?)", undef, "2", $bil
+d);
my $label = $mw->Label(-image => $bild, -background => '#ffffff')->pac
+k();
MainLoop;
And this to read:
use strict;
use warnings;
use Tk;
use Tk::JPEG;
use DBI;
my $datenbank = "bilder";
my $db_host = "localhost";
my $db_port = "3306";
my $db_user = "root";
my $db_pw = "12345";
my $dbh;
my $dsn = "DBI:mysql:database=$datenbank;host=$db_host;port=$db_port"
+;
$dbh = DBI::->connect( $dsn, $db_user, $db_pw, { RaiseError => 1, Prin
+tError => 0, AutoCommit => 1 } );
my $mw = MainWindow->new();
my $sql = "SELECT Bild FROM User WHERE User = 2;";
my $sth = $dbh->prepare($sql);
$sth->execute;
my $bildausdb;
($bildausdb) = $sth->fetchrow_array;
my $bild = $mw->Photo( -data => $bildausdb );
my $label = $mw->Label(-image => $bild, -background => '#ffffff')->pac
+k();
MainLoop;