Editing mySQL fields with forms

[ZackStorm]

I would like to use HTML forms to edit some fields that are in the mySQL database.

For example, the forms are suposed to call the data that is connected with the id# given in the URL (i.e.: pagename.php?id=25) so that I can edit the information it called to the forms, click the submit button and it would update it.

Any help would be appreciated.

[bodzan]

Try something like:

function update(){
global $id;
GLOBAL $db;

	$sql = "UPDATE $db SET";
	$sql .= " item1 = '$value1'";
	$sql .= " item2 = '$value2'";
	$sql .= " item3 = '$value3'";
	$sql .= " item4 = '$value4'";
	$sql .= " WHERE id = '$id'";

	my_query($sql);

}

function print_form($action,$id){
GLOBAL $db;

$sql = "SELECT id,item1,item2,item3,item4 FROM $db";
$sql .= " WHERE id = '$id'";

$result = my_query($sql);

$data = mysql_fetch_array($result);

<FORM ACTION="<?php echo $action; ?>" METHOD="POST">
<INPUT TYPE="TEXT" NAME="item1" VALUE="<?php echo $data[item1]; ?>">
<TEXTAREA COLS="25" ROWS="5" NAME="item2"><?php echo $data[item2]; ?></TEXTAREA>
<TEXTAREA COLS="25" ROWS="5" NAME="item3"><?php echo $data[item3]; ?></TEXTAREA>
<TEXTAREA COLS="25" ROWS="5" NAME="item4"><?php echo $data[item4]; ?></TEXTAREA>

<INPUT TYPE="submit" NAME="dugme" VALUE="Save changes">

</FORM>

}

switch($param){
default:
print_form("pageName.php?param=enter&&i=$id",$id);
break;
case "enter":
update();
break;
}

it should work...

[ZackStorm]

I tried fixing it a bit, but got nowhere. I am going to continue to expiriment. Any further help is welcomed

[bodzan]

I believe this was a correct update() function syntax:

function update(){
global $id;
GLOBAL $db;

$sql = "UPDATE $db SET";
$sql .= " item1 = '$data[item1]'";
$sql .= " item2 = '$data[item2]'";
$sql .= " item3 = '$data[item3]'";
$sql .= " item4 = '$data[item4]'";
$sql .= " WHERE id = '$id'";

my_query($sql);

}

Let me know if it helped...

[ZackStorm]

Well, in my previoud post, I had posted some errors, but since the thread died, I just edited it and earased it.

However, I found a method to get what I needed. Thanks anyways.