help me with update records in mysql database

I have a problem .
I 've been trying for a long time to make an update for php mysql to change the data.
but every time I do not manage to make it work with a form.
but it works if I only if I put this ($ sql = "UPDATE users SET username = 'value' WHERE id = 10 " ; )
so it only works when I put the value of the id.

but I want in an html form to indicate what I want to change and what id goes.

but I have tried so long that I do not feel like I so want someone help me.

make the same database and same as my records and make the code and test it if it works show me please



my database name : web test
my table called : users
my records are called :

id int ( 11) AUTO_INNCREMENT
username , varchar ( 255 )
password , varchar ( 255 )
first_name , varchar ( 255 )
last_name , varchar ( 255 )
email, varchar ( 255 )
Age, int ( 11)

please help me out!!!

 

okay
Look, my update.php is like this now

<?php
$servername = "localhost";
$username = "root";
$password = ".....";
$dbname = "webtest";


$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "UPDATE users SET password='cotton candy' WHERE id=10";

if ($conn->query($sql) === TRUE) {
    echo "Record updated successfully";
} else {
    echo "Error updating record: " . $conn->error;
}

$conn->close();
?>

PHP:

but now i have still have to go into the php file to change the valeu or the id
but i looked on site and youtube how to put it in a simple html form
but it still does not work.

i want it in a html from.
I want that when I enter the ID that the data of the user appears and that I can change any valeu separately.

is it more clear?

 

Please explain what exactly you are trying to do. If you want to capture the value of input field and then tranfering it to the database query you should send the value of input filed to the query like this.
update(Convert.ToInt32(rowIdTextbox.Text), nameTextBox.Text);

public void update(int rowId, string name)
{
call update query procedure.
}

 

You'll need to have an input for each of the values you want to change. Let's say you want to change the password for a user, then the form would look something like this:

<form method="post" action="#">
  <input type="text" name="change_password" value="" placeholder="input new password">
  <input type="text" name="user_id" value="" placeholder="input user id"> // however, this should probably be a select-box, gotten from the already existing users
  <input type="submit" name="submit_changepass" value="Change password">
</form>

Code (markup):

and in the PHP-part, you'd have something like this:

$changepass = (isset($_POST['submit_changepass']) && !empty($_POST['change_password'])) ? $_POST['change_password'] : '';
$userid = (isset($_POST['submit_changepass']) && !empty($_POST['user_id'])) ? $_POST['user_id'] : '';

if (!empty($userid) && !empty($changepass)) {
$sql = "UPDATE users SET password = '$changepass' WHERE user_id = '$userid'";
}

PHP:

Be aware that this is VERY simplified, and not proper code AT ALL - the form lacks labels and other stuff, the PHP-part doesn't do ANY kind of cleaning of the input, and this whole thing is just a basic setup to show you how to set up the update - however, this should definitely be secured, and preferably also done via a prepared query (I saw you're using mysqli_ so that should be fairly easy to manage).