Eccolo...
Codice PHP:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<?php
require_once 'sessione.php';
?><html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="description" content="Gestionale di cassa con sistema di stoccaggio real time" />
<meta name="keywords" content="Store Management" />
<meta name="robots" content="index,follow" />
<meta name="revisit-after" content="90 days" />
<meta http-equiv="content-language" content="it" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="css/style.css" rel="stylesheet" type="text/css" />
<link rel="shortcut icon" href="img/favicon.ico" />
<!--[if lt IE 9]>
<script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
<![endif]-->
<script type="text/javascript">
function setFocus(id) {
document.getElementById(id).focus();
}
</script>
<title>Store Management</title>
</head>
<body>
<div id="main">
<div id="header">
<div id="logo">
[img]images/logo.png[/img]
</div>
<div id="menu">
<span>[url="home.php"][img]images/cassa.png[/img][/url]</span>
<span>[url="inventario.php"][img]images/inventario.png[/img][/url]</span>
<span>[url=""][img]images/logout.png[/img][/url]</span>
</div>
</div>
<div id="center">
<div id="form-s">
<script type="text/javascript">
window.onload = function() {
setFocus('focus');
};
</script>
<form method="post" action="addlist.php">
<input id="focus" type="text" name="code" value="" />
<label>Code</label>
</form>
</div>
<div id="fattura">
<form method="post" action="cleanlist.php">
<table id="fattura-t">
<tbody>
<tr>
<td class="code">Cod. Prodotto</td>
<td class="art">Articoli</td>
<td class="prezzo">Prezzo</td>
</tr>
<tr>
<td class="code"></td>
<td class="art"></td>
<td class="prezzo">
</p></td>
</tr>
<?php
try{
$sql = "SELECT * FROM articolilist";
//Preparo le strutture per contenere la query
$stmt = $dbh->prepare($sql);
//Controllo se la query è andata a buon fine
if (! $stmt->execute() ) echo "[b]Errore nella query.[/b]";
/* Associo un campo ad una variabile */
$stmt->bindColumn('code', $code_bar);
$stmt->bindColumn('articolo', $articolo);
$stmt->bindColumn('prezzo', $prezzo);
while ($row = $stmt->fetch(PDO::FETCH_BOUND)) {
echo '<tr>';
echo '<td class="code">
'.$code_bar.'</p></td>';
echo '<input type="hidden" name="cod" value="'.$code_bar.'" />';
echo '<td class="art">
'.$articolo.'</p></td>';
echo '<input type="hidden" name="articolo" value="'.$articolo.'" />';
echo '<td class="prezzo">
'.$prezzo.' €</p></td>';
echo '<input type="hidden" name="prezzo" value="'.$prezzo.'" />';
echo '</tr>';
//Somma
$prezzoc = array($prezzo);
$count=sizeof($prezzoc);
for($counter=0;$counter<$count;$counter++){
$somma = 0;
$somma += $prezzoc[$counter];
echo sprintf("%01.2f", round($somma,2)).'
';
}
//Somma End
}
}
//Nel caso in cui ci siano errori, li cattura nella variabile $myerror e li stampa
catch (PDOException $myerror)
{
print "Problemi nella connessione al database:
" . $myerror->getMessage() . "
";
}
?>
<tr>
<td class="code"></td>
<td class="art"></td>
<td class="prezzo">
</p></td>
</tr>
<tr>
<td class="code"></td>
<td class="art"></td>
<td class="prezzo">
Totale</p></td>
</tr>
<tr>
<td class="code"></td>
<td class="art"></td>
<td class="prezzo">
€
</p>
</td>
</tr>
<tr>
<td class="code"></td>
<td class="art"></td>
<td class="prezzo">
</p></td>
</tr>
<tr>
<td class="code"></td>
<td class="art"></td>
<td class="prezzo">
<input type="submit" name="submit" value="Concludi" />
</td>
</tr>
</tbody>
</table>
</form>
</div>
</div>
<div id="footer">
</div>
</div>
</body>
</html>
Rispondi quotando