page seems to be in a loop
Posted: Fri Apr 24, 2009 2:27 pm
Hi guys, I need your help.. Thank you so much
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
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>