[PHP] Halp please.

[Dzetki]

I'm trying my best to get a settings page in my blogging software (soon to create a development thread for it), but the password won't update no-matter what i do. this is what happens:

You must be registered for see links

And the code's like this:

You must be registered for see links

Halp! ;[

 

[RastaLulz]

The SQL query should be:

UPDATE blog_admin SET password = 'password'

 

[Kryptos]

mysql_connect("This", "code", "is") or die(mysql_error());
mysql_select_db("notgood") or die(mysql_error());

$settings = "UPDATE blog_admin SET password = '" . sha1(md5($_POST['password'])) .  "' WHERE id = '" . $_SESSION['id'] . "'";

mysql_query($settings) or die(mysql_error());

echo "Success!";

The code makes no sense but it should work with what you have.

 

[Dzetki]

mysql_connect("This", "code", "is") or die(mysql_error());
mysql_select_db("notgood") or die(mysql_error());

$settings = "UPDATE blog_admin SET password = '" . sha1(md5($_POST['password'])) .  "' WHERE id = '" . $_SESSION['id'] . "'";

mysql_query($settings) or die(mysql_error());

echo "Success!";

The code makes no sense but it should work with what you have.

That didn't give me errors, but it didn't update the database table. ;[

 

[RastaLulz]

That didn't give me errors, but it didn't update the database table. ;[

Remove the following, and try:

 WHERE id = '" . $_SESSION['id'] . "'

 

[Dzetki]

Remove the following, and try:

 WHERE id = '" . $_SESSION['id'] . "'

tried that aswell, but didn't quite understand what to do with it. I keep getting a T_STRING error now, and the DB table won't still update. ;[

 

[RastaLulz]

tried that aswell, but didn't quite understand what to do with it. I keep getting a T_STRING error now, and the DB table won't still update. ;[

Post the code, and what line?

 

[Dzetki]

<?php
$con = mysql_connect("localhost","root","43kj67");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("blog", $con);
  
$settings="UPDATE blog_admin SET password='" . sha1(md5($_POST['password'])) . "'WHERE id = '" . $_SESSION['id'] . "'

if (!mysql_query($settings,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "Post have been submitted. <a href='admin.php'>Return to the previous page</a>.";
?>

Line 12, ;]

 

[RastaLulz]

Try this:

<?php
$con = mysql_connect("localhost","root","43kj67");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("blog", $con);

$settings = "UPDATE blog_admin SET password = '" . sha1(md5($_POST['password'])) . "'";

if (!mysql_query($settings,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "Post have been submitted. <a href='admin.php'>Return to the previous page</a>.";
?>

 

[Dzetki]

THAT WORKS! Ty Mr.Lulz ;D