Parse error problem...in a simple php script

Angad_Singh

PLEASE Help!! Its giving me parse error...

<html>
<head>
<title>Crack the Code</title>
</head>
<body>
<?php
require_once('db.php');
@ $db_server = new mysqli($db_hostname,$db_username,$db_password);
if (mysqli_connect_errno())
{
	echo "Unable to connect to database";
	exit;
}
$db_server->select_db($db_database);
if(isset($_POST['submitted']))
{
	if (isset($_POST['name']) && isset($_POST['checkpoint']))
	{
		if (get_magic_quotes_gpc())
		{
			$name=addslashes($_POST['name']);
			$chk=addslashes($_POST['checkpoint']);
		}

$query="SELECT * FROM ctc WHERE ctc_name='$name' ";
$result=$db_server->query($query);
$rows=$result->num_rows;
if ($rows>0)
{
	$query1="UPDATE ctc SET ctc_checkpoint='$chk' WHERE ctc_name='$name' ";
	$result1 =$db_server->query($query1);
	if ($result1)
		echo "Successfully added name";
	else
		$db_server->error;
}
else
{
	$query2="INSERT INTO ctc VALUE ('NULL','$name','$chk')";
	$result2=$db_server->query($query2);
	if ($result2)
		echo "Successfully added name";
	else
		$db_server->error;

}
}
for ($i=5;$i<=1;$i--)
{
	$query="SELECT * FROM ctc WHERE ctc_checkpoint='$i' ";
	$result3=$db_server->query($query);
	$rows1=$result3->num_rows;
	echo "<div id=\"chk$i\">";
	for($j=0;$j<$rows1;$j++)
	{
		$xxx=$result->fetch_assoc();
		$xxx1=stripslashes($xxx['ctc_name']);
		echo "$xxx1, ";
	}
	echo "</div><br />";
}



?>







<form action="index.php" method="post">
Name : <input type="text" size="10" maxlength="10" name="name" />
 I have Reached : <select name="checkpoint">
<option value="1">Checkpoint 1</option>
<option value="2">Checkpoint 2</option><br>
<option value="3">Checkpoint 3</option>
 <option value="4">Checkpoint 4</option>
 <option value="5">Cracked the finals</option></select>
 <input type="submit" name="sumbit" value="Submit" />
 <input type="hidden" name="submitted" value="1" />
 </form>
 </body>
 </html>

Thank you...

johanafm

For php code you should use php tags, not code tags, so that there is syntax highlighting. And you most definitely should post the parse erros as well.

Apart from that, you definitely want to change this

for ($i=5;$i<=1;$i--)

Angad_Singh

Thanks for pointing that error, i have corrected it but still

Parse error: parse error in D:\wamp\www\ctc\index.php on line 85

johanafm

Then you have not posted the correct code. Either the post is not index.php, or your index.php does not look like this one. Line 85 is

</html>

And it's not inside <?php ... ?>, so the php parser shouldn't care about it.

cahva

Also try to separate logic and presentation. Meaning that do as much as possible in the beginning of the script with PHP. In an ideal situation your html portion should only contain minimal logic(print PHP variables, iterate through arrays etc.) and you should never print html tags with php.

I gave this same advice on other thread. Check it out.

Angad_Singh

Thanks, everyone...I found the problem...A curly brace was missing...