[PHP/MySQL] Update mysql row

[pringle]

Heyy

Ive Just Found A Code , Which Updates php Tables Threw A html Form , i Wont this Code to Edit A Users
username And Password

But I Dont No Where I Should Input The Table Details . Here Is the PHP Code .

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

mysql_query(" UPDATE stuff SET Amount = ('$_POST[amount]')
WHERE Item = ('$_POST[item]') ");
mysql_close($con);
?>

My Database = test
My Section = member

And The Tables For the Username And Password Are

username And Password .

Sorry im a Noob :thumbdown: Lol

Thanks - Pringle

 

[caja]

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

mysql_query(" UPDATE stuff SET Amount = ('$_POST[amount]')
WHERE Item = ('$_POST[item]') ");
mysql_close($con);
?>

 

[LeonStrife]

Try this.

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

mysql_query(" UPDATE member SET Amount = ('$_POST[amount]')
WHERE Item = ('$_POST[item]') ");
mysql_close($con);
?>

 

[caja]

It's the same I wrote but you only change the update table-.-''

 

[s-p-n]

<?php
$db = mysql_connect('localhost','username','Password') or die("Could not connect.");
if(!$db) 
    die('no db');
if(!mysql_select_db('test',$db))
     die("No database selected.");

mysql_query('UPDATE `member` SET `Amount` = "'.$_POST['amount'].'"
WHERE `Item` = "'.$_POST['item'].'" ';
mysql_close($db);
?>

or,
mysql_connect('host','user','pass')

 

[Masius]

above, not..what..he...asked?

<?php
$db = mysql_connect('localhost','username','Password') or die("Could not connect.");
if(!$db) 
    die('no db');
if(!mysql_select_db('test',$db))
     die("No database selected.");

mysql_query('UPDATE `member` SET `username` = "'.$_POST['username'].'"
AND `password` = "'.$_POST['pass'].'" WHERE id = '$id'';
mysql_close($db);
?>

get a way to declare $id.

 

[doraemon2000]

If this is available to the public, make sure you prevent SQL injections by using mysql_real_escape_string()

example:

mysql_real_escape_string($_POST[amount]');