[PHP] Updating Tables using forms.

[Livar]

Hey thar, I'm trying to update the users table, this is what it'll really do - update users where username is %name% set motto %motto%;

Does someone mind posting a form and the PHP update please. I can't figure it out.

 

[EliteGM]

You shouldn't ask for complete scripts here (read the rules) but I'll give you a guideline. What you're looking for is like this:

file.php

<?php
//mysql connection here
if($_POST["go"])
{
$motto = $_POST["motto"];
$username = $_POST["username"]; //as I say in the HTML bit, if you have this as a session variable, use that
//you'll have to sanitize these variables of course
$sql = "UPDATE `table_name` SET `motto` = '". $motto ."' WHERE `username` = '". $username ."'";
?>
}

html bit:

<form method="post" action="file.php">
Username: <input type="text" name="username" /> <!-- Or if you have this in a session variable leave this out -->
Motto: <input type="text" name="motto" />
<input type="submit" name="go" value="Change motto" />
</form>

Sorry for the sucky standards, doing this plain text.

 

[s-p-n]

PHP MySQL Introduction

 

[Markshall]

You shouldn't ask for complete scripts here (read the rules) but I'll give you a guideline. What you're looking for is like this:

file.php

<?php
//mysql connection here
if($_POST["go"])
{
$motto = $_POST["motto"];
$username = $_POST["username"]; //as I say in the HTML bit, if you have this as a session variable, use that
//you'll have to sanitize these variables of course
$sql = "UPDATE `table_name` SET `motto` = '". $motto ."' WHERE `username` = '". $username ."'";
?>
}

html bit:

<form method="post" action="file.php">
Username: <input type="text" name="username" /> <!-- Or if you have this in a session variable leave this out -->
Motto: <input type="text" name="motto" />
<input type="submit" name="go" value="Change motto" />
</form>

Sorry for the sucky standards, doing this plain text.

You've not even executed the sql query, that won't work

 

[Livar]

Figured out


/thread