Another form problem

blink359 · April 26, 2009

The error is: Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /var/www/nathan/unstuck.php on line 16

from my form:

<?php
include("config.php");
mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbname);
$user = $_POST['user'];
$pass = $_POST['pass'];
$character = $_POST['character'];
{     
     if(!$user || !$pass || !$character)
     {
         $problemMessage = "Please fill in all required fields";
         $success = false;
     }
     if($success);
     {
         $result = mysql_query "SELECT acct FROM accounts WHERE login = '".$account."' AND password = '".$password."'";
         or die(mysql_error());
         $numrows = mysql_num_rows($result);
     }
 else
 {
         die("Account name or password is incorrect");
     }

     $result = mysql_query "update characters SET positionX = 16237, positionY = 16396, positionZ = 60, mapId = 1, zoneId = 0, deathstate = 0 WHERE name = '".$character."'" or die(mysql_error());
     echo "Character '".$character."' has been unstuck!";
     mysql_close();
?>
<html>
<head>
<title>Auto Unstucker</title>
</head>
<body>
<center>
<form name=myform method=post action='unstucker.php'>
<center><h1>Character Unstucker</h1></center>
Account Name:<input type=text name=account value=''><br>
Character Name:<input type=text name=character value=''><br>
Password:<input type=password name=password value=''><br>
<br><input type=submit name=submit value=Unstuck><br>
</form>
</body>
</html>

wildteen88 · April 26, 2009

Remove the ; at the end of line 16

if($success);

blink359 · April 26, 2009

Nothing happens

wildteen88 · April 26, 2009

Sorry, just noticed whats going on with line 8,

7.  $character = $_POST['character'];
8.  {     
9.       if(!$user || !$pass || !$character)

Have you missed something out there? If not then remove that line.

blink359 · April 26, 2009

<?php
include("config.php");
mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbname);
$user = $_POST['user'];
$pass = $_POST['pass'];
$character = $_POST['character'];
    
     if(!$user || !$pass || !$character)
     {
         $problemMessage = "Please fill in all required fields";
         $success = false;
     }
     if($success)
     {
         $result = mysql_query "SELECT acct FROM accounts WHERE login = '".$account."' AND password = '".$password."'"
         or die(mysql_error());
         $numrows = mysql_num_rows($result);
     }
 else
 {
         die("Account name or password is incorrect");
     }

     $result = mysql_query "update characters SET positionX = 16237, positionY = 16396, positionZ = 60, mapId = 1, zoneId = 0, deathstate = 0 WHERE name = '".$character."'" or die(mysql_error());
     echo "Character '".$character."' has been unstuck!";
     mysql_close();
?>
<html>
<head>
<title>Auto Unstucker</title>
</head>
<body>
<center>
<form name=myform method=post action='unstucker.php'>
<center><h1>Character Unstucker</h1></center>
Account Name:<input type=text name=account value=''><br>
Character Name:<input type=text name=character value=''><br>
Password:<input type=password name=password value=''><br>
<br><input type=submit name=submit value=Unstuck><br>
</form>
</body>
</html>

still Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /var/www/nathan/unstuck.php on line 16

wildteen88 · April 26, 2009

Umm, you have forgotten to wrap your query in parenthesis's when you call mysql_query on lines 16 and 25

The correct syntax for using mysql_query is

$result = mysql_query('your query here');

Not

$result = mysql_query 'your query here';

blink359 · April 26, 2009

Thanks for that thats fixed that now ive got a Parse error: syntax error, unexpected T_LOGICAL_OR in /var/www/nathan/unstuck.php on line 17

wildteen88 · April 26, 2009

Post lines 15 - 19 here.

blink359 · April 26, 2009

{

$result = mysql_query("SELECT acct FROM accounts WHERE login = '".$account."' AND password = '".$password."'");

or die(mysql_error());

$numrows = mysql_num_rows($result);

}

premiso · April 26, 2009

{
         $result = mysql_query("SELECT acct FROM accounts WHERE login = '".$account."' AND password = '".$password."'") or die(mysql_error());
         $numrows = mysql_num_rows($result);
     }

blink359 · April 26, 2009

}

$result = mysql_query("update characters SET positionX = 16237, positionY = 16396, positionZ = 60, mapId = 1, zoneId = 0, deathstate = 0 WHERE name = '".$character."'"); or die(mysql_error());

$numrows = mysql_num_rows($result);

}

Parse error: syntax error, unexpected T_LOGICAL_OR in /var/www/nathan/unstuck.php on line 24

wildteen88 · April 26, 2009

Its the same error as last time! Remove the ; before or die

premiso · April 26, 2009

Do you not understand what I did to fix that issue?

I mean come on now...

$result = mysql_query("update characters SET positionX = 16237, positionY = 16396, positionZ = 60, mapId = 1, zoneId = 0, deathstate = 0 WHERE name = '".$character."'") or die(mysql_error());
     $numrows = mysql_num_rows($result);

I would hope that you are able to fix the others yourself, given that all I did was remove the semicolon before the or die statement.

blink359 · April 26, 2009

<?php
$dbhost = "localhost"; 
$dbuser = "nathan"; 
$dbpass = "your_password"; 
$dbname = "logon"; 
mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbname);
$user = $_POST['user'];
$pass = $_POST['pass'];
$character = $_POST['character'];
    
     if(!$user || !$pass || !$character)
     {
         $problemMessage = "Please fill in all required fields";
         $success = false;
     }
     if($success)
     {
         $result = mysql_query("SELECT acct FROM accounts WHERE login = '".$account."' AND password = '".$password."'") or die(mysql_error());
         $numrows = mysql_num_rows($result);
     }
 else
 {
         die("Account name or password is incorrect");
     }

     $result = mysql_query("update characters SET positionX = 16237, positionY = 16396, positionZ = 60, mapId = 1, zoneId = 0, deathstate = 0 WHERE name = '".$character."'") or die(mysql_error());
     $numrows = mysql_num_rows($result);
     
     echo "Character '".$character."' has been unstuck!";
     mysql_close();
?>
<html>
<head>
<title>Auto Unstucker</title>
</head>
<body>
<center>
<form name=myform method=post action='unstucker.php'>
<center><h1>Character Unstucker</h1></center>
Account Name:<input type=text name=account value=''><br>
Character Name:<input type=text name=character value=''><br>
Password:<input type=password name=password value=''><br>
<br><input type=submit name=submit value=Unstuck><br>
</form>
</body>
</html>

its now just die("Account name or password is incorrect");

blink359 · April 26, 2009

Im sorry i made it wrong i got a guy to fix hes made it more messed up than me i dont have a clue what he did

Sign In

Another form problem

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information