first script

[plysiu]

hello
i wrote this script but i cant connect to database
could someone help me with this
i will give rep++

if($action == "")
{
  $main_content .= '<form name="zmianarangi" method="post" action="?subtopic=testowy&action=zmianarangi" enctype="text/plain" id="Form1">
  <input type="text" id="Editbox1" name="nameofcharacter" value="">
  <select name="whatgroup" size="1" id="Combobox1" >
  <option selected value="1">Gracz</option>
  <option value="2">Tutor</option>
  <option value="3">Senior Tutor</option>
  <option value="4">Game Master</option>
  <option value="5">Community Manager</option>
  </select>
  <input type="submit" id="Button1" name="Button1" value="Submit">
  </form>';
} 
       
if($action == "zmianarangi") 
{
  ???????('UPDATE ``players` SET `group_id` = '.$whatgroup.' where `name` = '.$nameofcharacter.' LIMIT 1 ');
  $main_content .= '<center><font size=3><b>Congratulations!</b></font></center>';
}

-----------
sorry for my english

 

[Norix]

this should work:

if($action == "")
{
  $main_content .= '<form name="zmianarangi" method="post" action="?subtopic=testowy&action=zmianarangi" enctype="text/plain" id="Form1">
  <input type="text" id="Editbox1" name="nameofcharacter" value="">
  <select name="whatgroup" size="1" id="Combobox1" >
  <option selected value="1">Gracz</option>
  <option value="2">Tutor</option>
  <option value="3">Senior Tutor</option>
  <option value="4">Game Master</option>
  <option value="5">Community Manager</option>
  </select>
  <input type="submit" id="Button1" name="Button1" value="Submit">
  </form>';
} 
       
if($action == "zmianarangi") 
{
$SQL->query('UPDATE ``players` SET `group_id` = '.$whatgroup.' where `name` = '.$nameofcharacter.' LIMIT 1 ');
  $main_content .= '<center><font size=3><b>Congratulations!</b></font></center>';
}

 

[plysiu]

it give me error
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ''' in F:\z c\xampp\htdocs\dodatki\testowy\testowy.php:19 Stack trace: #0 F:\z c\xampp\htdocs\dodatki\testowy\testowy.php(19): PDO->query('UPDATE ``player...') #1 F:\z c\xampp\htdocs\index.php(308): include('F:\z c\xampp\ht...') #2 {main} thrown in F:\z c\xampp\htdocs\dodatki\testowy\testowy.php on line 19

 

[Norix]

Try this:

if($action == "")
{
  $main_content .= '<form name="zmianarangi" method="post" action="?subtopic=testowy&action=zmianarangi" enctype="text/plain" id="Form1">
  <input type="text" id="Editbox1" name="nameofcharacter" value="">
  <select name="whatgroup" size="1" id="Combobox1" >
  <option selected value="1">Gracz</option>
  <option value="2">Tutor</option>
  <option value="3">Senior Tutor</option>
  <option value="4">Game Master</option>
  <option value="5">Community Manager</option>
  </select>
  <input type="submit" id="Button1" name="Button1" value="Submit">
  </form>';
} 
       
if($action == "zmianarangi") 
{
$SQL->query('UPDATE `players` SET `group_id` = '.$whatgroup.' where `name` = '.$nameofcharacter.' LIMIT 10;');
  $main_content .= '<center><font size=3><b>Congratulations!</b></font></center>';
}

 

[plysiu]

same error i think
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where `name` = LIMIT 10' at line 1' in F:\z c\xampp\htdocs\dodatki\testowy\testowy.php:19 Stack trace: #0 F:\z c\xampp\htdocs\dodatki\testowy\testowy.php(19): PDO->query('UPDATE `players...') #1 F:\z c\xampp\htdocs\index.php(308): include('F:\z c\xampp\ht...') #2 {main} thrown in F:\z c\xampp\htdocs\dodatki\testowy\testowy.php on line 19

 

[Norix]

I changed the code abit. Maybe it works now

$name = stripslashes(ucwords(strtolower(trim($_REQUEST['character']))));
$group = stripslashes(ucwords(strtolower(trim($_REQUEST['group']))));
if($action == "")
{
  $main_content .= '<form name="zmianarangi" method="post" action="?subtopic=testowy&action=zmianarangi" enctype="text/plain" id="Form1">
  <input type="text" id="Editbox1" name="character" value="">
  <select name="group" size="1" id="Combobox1" >
  <option selected value="1">Gracz</option>
  <option value="2">Tutor</option>
  <option value="3">Senior Tutor</option>
  <option value="4">Game Master</option>
  <option value="5">Community Manager</option>
  </select>
  <input type="submit" id="Button1" name="Button1" value="Submit">
  </form>';
} 
       
if($action == "zmianarangi") 
{
$SQL->query('UPDATE `players` SET `group_id` = '.$group.' where `name` = '.$name.' LIMIT 1;');
  $main_content .= '<center><font size=3><b>Congratulations!</b></font></center>';
}

 

[plysiu]

again error
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where `name` = LIMIT 1' at line 1' in F:\z c\xampp\htdocs\dodatki\testowy\testowy.php:21 Stack trace: #0 F:\z c\xampp\htdocs\dodatki\testowy\testowy.php(21): PDO->query('UPDATE `players...') #1 F:\z c\xampp\htdocs\index.php(308): include('F:\z c\xampp\ht...') #2 {main} thrown in F:\z c\xampp\htdocs\dodatki\testowy\testowy.php on line 21

 

[Norix]

Now it have to work, tested it...:

<?PHP
$character = stripslashes(trim($_REQUEST['character']));
$group = stripslashes(ucwords(strtolower(trim($_REQUEST['group']))));
if(empty($name)) {
  $main_content .= '<form action="index.php?subtopic=testowy&action=zmianarangi" METHOD=post>
  <input type="textbox" name="character">
  <select name="group" size="1" id="Combobox1" >
  <option selected value="1">Gracz</option>
  <option value="2">Tutor</option>
  <option value="3">Senior Tutor</option>
  <option value="4">Game Master</option>
  <option value="5">Community Manager</option>
  </select>
  <input type="submit" id="Button1" name="Button1" value="Submit"></form>';
}
if($action == "zmianarangi")
{
$SQL->query('UPDATE players SET group_id = '.$group.' where name = '.$SQL->quote($character).';');
  $main_content .= '<center><font size=3><b>Congratulations!</b></font></center>';
}  

?>

 

[plysiu]

yes its working
good job
like i said rep for you!