in reply to Re: STRICT question
in thread STRICT question
#!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 $D +BI::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?pr +oduct=viewCart">aici!</a> <br>Pentru check out dati click <a href="$cgi_url/shop.pl?product=chec +kOut">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) = $sta +tement->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 val +ue="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 d +ie "Error $DBI::errstr\n"; $statement->execute or die "Error $DBI::errstr\n"; ($denumire, $pret, $url_demo, $descriere, $url_download, $foto) = $sta +tement->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 val +ue="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;
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Re: Re: STRICT question
by ChrisR (Hermit) on Oct 23, 2003 at 12:52 UTC | |
by webstudioro (Acolyte) on Oct 23, 2003 at 20:13 UTC | |
by ChrisR (Hermit) on Oct 23, 2003 at 20:32 UTC | |
by vek (Prior) on Oct 24, 2003 at 03:03 UTC |