Jump to content

Posting Edited Form


WendyLady

Recommended Posts

Hello --

I'm working on an admin page that pulls values from MySQL into a pre-filled form, so that the administrator can make changes. Then when submitted, it updates the row in MySQL to be what is on the form.

One of the fields is a category checkbox list that is populated by a request from another table (the admin sets the categories & can change them, and users can select the categories they fit in).

To send this information to the database in a comma-separated string (so that it is in a text-searchable string for another part of the site), I have been using:
$description = implode(',', $_POST['category']);
when I call my variables.

HOWEVER, I can't figure out how to repopulate the checkbox list as checked where the user had checked it, so I am just printing the string of current categories & would like for these to ONLY be changed if new checkboxes are checked. Otherwise, I want it to NOT change that entry. I've been trying this (and similar other things):
if (isset($_POST['category']) && (strlen($_POST['category']) >= 1)) {
$description = implode(',', $_POST['category']);
}
Also tried:
if ($_POST['category'] != ""){
$description = implode(',', $_POST['category']);
}
but it keeps updating the field to empty if nothing is checked. I would appreciate your comments!

Thanks,
Wendy
Link to comment
Share on other sites

hey there, i have done the kind of thing you want, im new to this so im not sure how to ecplain it but if you look at my code you may be able to see what pieces you need.

<HTML>
<BODY>
<body bgcolor="#FFFFCC" text="#006600" link="#0000FF" vlink="#0000FF" alink="#0000FF">

<?php
$db=mysql_connect("localhost","hnd","");
mysql_select_db("hnd",$db);

if($Submit2) {
$sql="UPDATE RB_Customer


SET Title = '$Title',
First_Name = '$First_Name',
Last_Name = '$Last_Name',
Age = '$Age',
Address_Line_1 = '$Address_Line_1',
Address_Line_2 = '$Address_Line_2',
City = '$City',
County = '$County',
Postcode = '$PostCode',
Telephone_Number = '$Telephone_Number',
E_Mail = '$E_Mail'
WHERE Cust_Number = '$Cust_Number'";



$result=mysql_query($sql,$db);
echo "$sql Record updated/edited!<p>";
}

if($Submit) {
$sql="SELECT * FROM RB_Customer WHERE Cust_Number='$ID'";



$result=mysql_query($sql,$db);


$myrow = mysql_fetch_array($result);

echo"
<form method = \"post\" action = \"updatecust2.php\">
Title:<input type = \"Text\" name=\"Title\" value='$myrow[11]'<BR>
First_Name:<input type = \"Text\" name=\"First_Name\" value='$myrow[1]'<BR>
Last_Name:<input type = \"Text\" name=\"Last_Name\" value='$myrow[2]'<BR>
Age:<input type = \"Text\" name=\"Age\" value='$myrow[3]'<BR>
Address_Line_1:<input type = \"Text\" name=\"Address_Line_1\" value='$myrow[4]'<BR>
Address_Line_2:<input type = \"Text\" name=\"Address_Line_2\" value='$myrow[5]'<BR>
City:<input type = \"Text\" name=\"City\" value='$myrow[6]'<BR>
County:<input type = \"Text\" name=\"County\" value='$myrow[7]'<BR>
Postcode:<input type = \"Text\" name=\"PostCode\" value='$myrow[8]'<BR>
Telephone_Number:<input type = \"Text\" name=\"Telephone_Number\" value='$myrow[9]'<BR>
E_Mail:<input type = \"Text\" name=\"E_Mail\" value='$myrow[10]'<BR>
Cust_Number:<input type = \"Text\" name=\"Cust_Number\" value='$myrow[0]'<BR>
<input type = \"Submit\" name=\"Submit2\" value = \"Enter Information\">
";
}


$result=mysql_query("SELECT * FROM RB_Customer",$db);

echo "<table border=1>\n";
echo "<TR>
<TD><h2>Customer Number</h2></TD>
<TD><h2>Title</h2></TD>
<TD><h2>First Name</h2></TD>
<TD><h2>Last Name</h2></TD>
<TD><h2>Age</h2></TD>
<TD><h2>Address Line 1</h2></TD>
<TD><h2>Address Line 2</h2></TD>
<TD><h2>City</h2></TD>
<TD><h2>County</h2></TD>
<TD><h2>PostCode</h2></TD>
<TD><h2>Telephone Number</h2></TD>
<TD><h2>E-Mail Address</h2></TD>
</TR>\n";

while($myrow = mysql_fetch_array($result)){

echo "
<TR>
<TD><h3>$myrow[0]</h3></TD>
<TD><h3>$myrow[11]</h3></TD>
<TD><h3>$myrow[1]</h3></TD>
<TD><h3>$myrow[2]</h3></TD>
<TD><h3>$myrow[3]</h3></TD>
<TD><h3>$myrow[4]</h3></TD>
<TD><h3>$myrow[5]</h3></TD>
<TD><h3>$myrow[6]</h3></TD>
<TD><h3>$myrow[7]</h3></TD>
<TD><h3>$myrow[8]</h3></TD>
<TD><h3>$myrow[9]</h3></TD>
<TD><h3>$myrow[10]</h3></TD>
</TR>";
}
echo "</table>\n";

?>

<form method = "post" action = "<?php echo $PHP_SELF?>">
ID:<input type = "Text" name="ID"><BR>
<input type = "Submit" name="Submit" value = "Choose Record To Be Updated">

</BODY>
</HTML>


Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.