Jump to content

Archived

This topic is now archived and is closed to further replies.

WendyLady

Posting Edited Form

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

Share this post


Link to post
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>


Share this post


Link to post
Share on other sites

×

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.