#!perl -w

use CGI::Carp('fatalsToBrowser');
use CGI qw/:standard/;
use strict;
use DBI;
use vars qw($query $dbase $userdb $passworddb $cgi_url $idProdus);


$query = CGI->new();
$cgi_url = "http://localhost/cgi-bin/script.pl";
$dbase= "test";
$userdb = "admin";
$password = "123456";

my $count=0;
my $driver = "dbi:mysql:" . $dbase;
my $dbh = DBI->connect($driver, $userdb, $passworddb) or die "Error $DBI::errstr\n";
my $statement = $dbh->prepare("SELECT id_produs, denumire FROM produse") or die "Error $DBI::errstr\n";
$statement->execute or die "Error $DBI::errstr\n";
print $query->header(-type=>'text/html');
print <<ENDHTML;
Pentru a vedea ce aveti in cos dati click <a href="$cgi_url/shop.pl?product=viewCart">aici!</a>
<br>Pentru check out dati click <a href="$cgi_url/shop.pl?product=checkOut">aici!</a><br><form action="$cgi_url/shop.pl" method="get">
<input type="hidden" name="product" value="viewProduct"><select name="id"><option value="none">Select product</option>
ENDHTML
while (($idProdus, $denumireProdus) = $statement->fetchrow_array) {
print <<ENDHTML;
<option value="$idProdus">$denumireProdus</option>
ENDHTML
my $count++;
}
print <<ENDHTML;
</select><input type="submit" value="View Product"></form>
ENDHTML
$statement->finish;
$dbh->disconnect;
$dbh = DBI->connect($driver, $userdb, $passworddb) or die "Error $DBI::errstr\n";
$statement = $dbh->prepare("SELECT denumire, pret, url_demo, descriere, url_download, foto  FROM produse WHERE id_produs = $count") or die "Error $DBI::errstr\n";
$statement->execute or die "Error $DBI::errstr\n";
($denumire, $pret, $url_demo, $descriere, $url_download, $foto) = $statement->fetchrow_array();
print <<ENDHTML;
<br><br><table border=0>
<form action="$cgi_url/shop.pl" method="get">
<input type=hidden name="product" value="add">
<input type=hidden name="canditate" value="1">
<input type=hidden name="idp" value="$count">
<input type=hidden name="title" value="$denumireProd">
<input type=hidden name="descriere" value="$descriere">
<input type=hidden name="price" value="$pret">
<input type=hidden name="fotoProdus" value="$foto">
<tr><td rowspan=3>
<img src="$foto">
</td><td>
<b>$denumireProd</b></td></tr>
<tr><td>
$descriere</td></tr>
<tr><td align=right>
<a href="$url_demo">Try demo!</a>  Pret: $pret  <input type=submit value="Buy now!">
</td></tr></form></table><hr>
ENDHTML
$statement->finish;
$dbh->disconnect;
$newCount = $count - 1;
$dbh = DBI->connect($driver, $userdb, $passworddb) or die "Error $DBI::errstr\n";
$statement = $dbh->prepare("SELECT denumire, pret, url_demo, descriere, url_download, foto  FROM produse WHERE id_produs = $newCount") or die "Error $DBI::errstr\n";
$statement->execute or die "Error $DBI::errstr\n";
($denumire, $pret, $url_demo, $descriere, $url_download, $foto) = $statement->fetchrow_array();
print <<ENDHTML;
<br><br><table border=0>
<form action="$cgi_url/shop.pl" method="get">
<input type=hidden name="product" value="add">
<input type=hidden name="canditate" value="1">
<input type=hidden name="idp" value="$newCount">
<input type=hidden name="title" value="$denumire">
<input type=hidden name="descriere" value="$descriere">
<input type=hidden name="price" value="$pret">
<input type=hidden name="fotoProdus" value="$foto">
<tr><td rowspan=3>
<img src="$foto">
</td><td>
<b>$denumire</b></td></tr>
<tr><td>
$descriere</td></tr>
<tr><td align=right>
<a href="$url_demo">Try demo!</a>  Pret: $pret  <input type=submit value="Buy now!">
</td></tr></form></table>
ENDHTML
print <<ENDHTML;
<br><br>Total produse gasite: $count<br>
ENDHTML
exit;
$statement->finish;
$dbh->disconnect;
print <<ENDHTML;
Nu exista in baza de date <b>$dbase</b> nici un produs.
ENDHTML
exit;