This code is not wroking can anyone help me pls!!!

[Sorrow]

I want to take the info from page 1 send it on page 2 where the only thing that is done in the second page is saving the infos into my database the error is in the query:


<?php
session_start();
$_SESSION['Username'] = $_POST["Username"];


$con = mysql_connect("bla_bla","bla_bla","bla_bla");

if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("jplegris_pirate", $con);

mysql_query("INSERT INTO Usagers (Username) VALUES ($_SESSION['Username'];)");


mysql_close($con);


?>

[marcus]

[code]
<?php
session_start();
$_SESSION['Username'] = $_POST["Username"];


$con = mysql_connect(host,dbuser,dbpass);
$db = mysql_select_db(dbname,$con);

if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_query("INSERT INTO Usagers (Username) VALUES ($_SESSION['Username'])");


mysql_close($con);


?>
[/code]

[Sorrow]

I tryed the code you gave me but it still gives me this error:
parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in

[steelmanronald06]

[code]
<?php
session_start();
$_SESSION['Username'] = $_POST['Username'];


$con = mysql_connect(host,dbuser,dbpass);
$db = mysql_select_db(dbname,$con);

if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_query("INSERT INTO Usagers (Username) VALUES ($_SESSION['Username'])");


mysql_close($con);


?>
[/code]

[marcus]

I had to re-edit my code, which is like the same as his.

[Sorrow]

it still does the same thing the parsing error. do you have another way that i could do it without using session variables

[marcus]

Did you update your fields? host,dbuser,dbpass and dbname?

[Sorrow]

Yes it is done when i am trying to get the info without doing the query I can see the info with :
echo $_SESSION['Username'];

but it keeps giving me te error when im trying to execute the query

[marcus]

Alright
[code]
<?php
session_start();
$un = $_POST[Username];
$_SESSION['Username'] = $un;


$con = mysql_connect(host,dbuser,dbpass);
$db = mysql_select_db(dbname,$con);

if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

$sql = "INSERT INTO Usagers (`Username`) VALUES('$un')";
$result = mysql_query($sql);

mysql_close($con);


?>
[/code]

if session username and post username are the same, why not just insert post username into the database?

[Sorrow]

ty very much it is now working

[marcus]

No problem.

[taith]

i've also found this... mysql cannot directly enter $_SESSION variables... also, for some reason, arrays inside arrays...

[DaviDJ]

you cannot use the apostrophes for the variable name between the [ and ] inside quote marks.

so,

<?php
echo "Hello $_POST['Username']"; // will produce an error
echo "Hello $_POST[Username]"; // will succeed
// or better yet
echo 'Hello ' . $_POST['Username'];
?>

so your original code should look like

[code]
<?php
session_start();
$_SESSION['Username'] = $_POST["Username"];

$con = mysql_connect("bla_bla","bla_bla","bla_bla");

if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("jplegris_pirate", $con);

mysql_query("INSERT INTO Usagers (Username) VALUES (" . $_SESSION['Username'] . ";");

mysql_close($con);
?>
[/code]