Banco Dados

Boa Noite Pessoal,

Gostaria de Saber como faço para armazenar o valor da variável $totalCorret na coluna nota no Banco de dados no seu respectivo funcionário. Exemplo: Roberto respondeu e acertou 5, isto é, nota recebe 5.

Obs: Cada funcionário tem sua senha de acesso para responder o questionário.
Segue o codigo abaixo.

Att.

<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

<title>PHP Quiz</title>

<link rel="stylesheet" type="text/css" href="css/style.css" />
</head>

<body>

<div id="page-wrap">

<h1>Veja seu desempenho final!!!!</h1>

<?php

$answer1 = $_POST['question-1-answers'];
$answer2 = $_POST['question-2-answers'];
$answer3 = $_POST['question-3-answers'];
$answer4 = $_POST['question-4-answers'];
$answer5 = $_POST['question-5-answers'];
$answer6 = $_POST['question-6-answers'];
$answer7 = $_POST['question-7-answers'];
$answer8 = $_POST['question-8-answers'];
$answer9 = $_POST['question-9-answers'];
$answer10 = $_POST['question-10-answers'];

$totalCorrect = 0;

if ($answer1 == "A") { $totalCorrect++; }
if ($answer2 == "B") { $totalCorrect++; }
if ($answer3 == "D") { $totalCorrect++; }
if ($answer4 == "A") { $totalCorrect++; }
if ($answer5 == "C") { $totalCorrect++; }
if ($answer6 == "A") { $totalCorrect++; }
if ($answer7 == "B") { $totalCorrect++; }
if ($answer8 == "D") { $totalCorrect++; }
if ($answer9 == "C") { $totalCorrect++; }
if ($answer10 == "D") { $totalCorrect++; }

echo "<div id='results'>$totalCorrect / 10 correct</div>";

?>

</div>

<div align="center">
<p>  </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p>
<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<a href="index.html"><img src="btnsair.jpg" width="56" height="40" /></a> </p>
<p><em><strong>SAIR</strong></em></p>
</div>
<script type="text/javascript">
var pageTracker = _gat._getTracker("UA-68528-29");
pageTracker._initData();
pageTracker._trackPageview();
</script>
</body>

</html>

#1 danielffem

#2 André Manoel

#3 danielffem

1 user(s) are reading this topic

Banco Dados

#1 danielffem

#2 André Manoel

#3 danielffem

1 user(s) are reading this topic

Entrar