₦airaland Forum

How can i create an edit profile like that of nairaland where user data is displayed in form of a input box and is updated when the update button is pressed using MySQL/PHP.

.

?

Whatsapp: 0-8-1-8-6-9-9-2-7-4-5

dhtml18:
?

I want to create a web page with a couple of form textboxes under a table (like the image below) so that when i click on the web page data from the database appears immediately (again just like the image ) but when i change the data(eg from apple to guava) and click update it changes apple to guava in my database.

The answer to this question is a very long one, and I cannot answer it.

ok thank you

The OP has been killed

Basic php/mysql
Then JQuery-Ajax

How can i create an edit profile like that of nairaland where user data is displayed in form of a input box and is updated when the update button is pressed using MySQL/PHP.

The truth is i don't know how you programmed your table but i will just give you a simple illustration as to how that works

This below part is supposed to be before the document type of your user profile.php page

if(isset($_POST['update']))
{

$id = $_POST['id'];

$signature= $_POST['user_signature'];

// checking empty fields
if(empty($signature)) {

if(empty($signature)) {
echo "<font color='red'>The signature is Empty</font><br/>";
}
} else {
//updating the table
$result = mysqli_query($mysqli, "UPDATE u_data SET user_signature='$signature' WHERE id=$id";

//redirectig to the display page. In our case, it is index.php
header("Location:updated.php";
}
}
?>

Then in the body of the same document just add this below form there


<form method="post" action="">
<input type="text" name="signature" value="<?php echo "$signature";?>">
<input type="submit" name="update" value="update">
</form>

I believe i did not confuse you and i believe you already have basic understanding of php. So goodluck

dhtml18:
The answer to this question is a very long one, and I cannot answer it.

Ill try

How can i create an edit profile like that of nairaland where user data is displayed in form of a input box and is updated when the update button is pressed using MySQL/PHP.

As I always say...a programmer should always try to code an answer according to his demand.

If you know how to fetch data ( I'm sure you know)

Then fetch it and display it in a box !!!

Eg

echo '<input type="text" name="fullName" value="'. $row[n] .'" />';

...
Did I answer your question?

Sincerely, badthinds

CryptoCoinr:
S/He has deactivated his/her account.

-

CryptoCoinr:
S/He has deactivated his/her account.

O boy!. I noticed "Nobody" but didn't process till after I posted.