The page loads, BUT it seems that it wants to load the whole time. I cannot click the answers, because it loads it again and again...) .It says on the bar on the bottom left Waiting for http://www.guntmarwolff.com/passiontest.php (Even I can see the page) But
As well: when I click the go on button it does not go on to the page passiontest2.php it just loads this page
Code: Select all
<?php require_once('Connections/Login.php'); ?>
<?php
session_start();
?>
<?php
//You will need to update all the below variables
$mysqlhost = "localhost";
$mysqluser = ""***";";
$mysqlpass = "***";
$mysqldb = ""***";";
$mysqltable = "users";
$username = "username";
// End Variables
mysql_connect($mysqlhost, $mysqluser, $mysqlpass);
mysql_select_db($mysqldb);
$query = "SELECT * FROM " . $mysqltable . " WHERE username='" . $username . "'";
$result = mysql_query($query) or die("There was a mysql error");
while($row = mysql_fetch_array($result)){
$currentpo = $row['resultspo'];
$currentmo = $row['resultsmo'];
}
function showForm () {
echo <<<SHOWFORM
<form id="form1" name="form1" method="post" action="">
<table width="699" border="0" align="center" cellspacing="5" class="style1">
<tr>
<td colspan="3"><div align="center"><span class="style4">Your Passion Test</span></div></td>
</tr>
<tr>
<td width="24"> </td>
<td width="429"> </td>
<td width="220"><div align="right">Saturday, 03/28/09</div></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><div align="right">$_SESSION[MM_firstname]</div></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><div align="right"></div></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>1</td>
<td><strong>I like talking to people. </strong><br />
</b></td>
<td><div align="left">
<input name="po1" type="radio" value="0" />
0
<input name="po1" type="radio" value="1" />
1
<input name="po1" type="radio" value="2" />
2
<input name="po1" type="radio" value="3" />
3
<input name="po1" type="radio" value="4" />
4
<input name="po1" type="radio" value="5" />
5</div></td>
</tr>
<tr>
<td>2</td>
<td>It is important for me what other people think. </td>
<td><p>
<label></label>
<label></label>
<input name="mo2" type="radio" value="0" />
0
<input name="mo2" type="radio" value="1" />
1
<input name="mo2" type="radio" value="2" />
2
<input name="mo2" type="radio" value="3" />
3
<input name="mo2" type="radio" value="4" />
4
<input name="mo2" type="radio" value="5" />
5<br />
<br />
</p></td>
</tr>
<tr>
<td>3</td>
<td class="style1">My level of excitement is high right now. </td>
<td><p>
<label></label>
<input name="mo3" type="radio" value="0" />
0
<input name="mo3" type="radio" value="1" />
1
<input name="mo3" type="radio" value="2" />
2
<input name="mo3" type="radio" value="3" />
3
<input name="mo3" type="radio" value="4" />
4
<input name="mo3" type="radio" value="5" />
5<br />
</p></td>
</tr>
<tr>
<td>4</td>
<td>I like solving mathematical tasks. </td>
<td><input name="po4" type="radio" value="0" />
0
<input name="po4" type="radio" value="1" />
1
<input name="po4" type="radio" value="2" />
2
<input name="po4" type="radio" value="3" />
3
<input name="po4" type="radio" value="4" />
4
<input name="po4" type="radio" value="5" />
5</td>
</tr>
</table>
<p align="center">
<input name="Submit" type="submit" class="style1" value="go on" />
</p>
</form>
SHOWFORM;
}//Close showForm()
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Your Passion Test</title>
<style type="text/css">
<!--
.style1 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
font-weight: bold;
color: #000033;
}
.style3 {font-family: Verdana, Arial, Helvetica, sans-serif}
.style4 {
font-size: 20px;
color: #996600;
}
-->
</style>
</head>
<body>
<?php
if (!isset($_POST['Submit'])) {
showForm();
} else {
$pagepo = ($_POST['po1'] + $_POST['po4']);
$pagemo = ($_POST['mo2'] + $_POST['mo3']);
$newpo = ($currentpo + $pagepo);
$newmo = ($currentmo + $pagemo);
}
$query = "UPDATE ".$mysqltable." SET resultspo = '".$newpo."', resultsmo = '".$newmo."' WHERE username = '".$username."' AND id = '".$_SESSION['id']."'";
mysql_query($query) or die("There was a mysql error<br />Query: {$query}<br />Error Returned: " . mysql_error());
//JavaScript page redirect...
echo '<script>location.href="passiontest.php"</script>'
// Close if/else
?>
</body>
</html>