Need help with a simple FORM problem

Tony_Latino

I should be able to figure this out on my own, however I have hit a roadblock.

What we are doing:

Building a FAQ database type of application.

What the problem is:
We need to have a modify application that will allow the user to basically modify an FAQ on their own in one page. I was thinking of having a dynamic form list all of the FAQ's by Category. Next to each FAQ, I wanted it to place several check-boxes.

Each checkbox would be labeled as Modify, Delete and so on..

The problem I have is- how am I going to be able to this? I am just having a problem trying to figure out how to make this work. I know how to get the checkboxes on there and I know the basics, but the problem is really this-

Once the user decides on all of the FAQ's they want to delete, modify, etc., how do I perform the operation on each FAQ?

Any help on this would be greatful, because the next task will be to allow users to place the FAQ's in a particular order, which would use the same logic.

Thank you in advance for any help you can give in this regard.

-Tony

juschillinnow

This is actually is a little more complicated than it seems at first. I sent the user npereira a file that shows you how to do this, and the funny thing is she just posted it to have me do something.

Take a look at the post from her and see modify it.

Tony_Latino

Thanks for the guidance there, but as I was heading home today, I had a brainstorm.

I can just use an array actually and assign the values to it. Then when the form is submitted, it can look at the contents of the array and make the inserts and modifications that way.

I am going to try it tonight and hope it works, I will let you know how everything goes.

Tony_Latino

Well my method was useless 🙁

I tried to look at that file, but unfortunately since it is in another language, it was impossible for me to figure out

Does anyone know where I can get some info on how to do this?

Tony_Latino

Here is the code I was tried when I had my brainstorm, but it is not working as planned:

<?php

INCLUDE("../datavars.php");
INCLUDE("../header2.php");

#########################################

This will MODERATE PENDING COMMENTS

#########################################

#########################

Connect to Database

#########################

$Link1 = mysql_connect($Host, $User, $Password);

mysql_select_db($DBName4, $Link1);

#############################################

Get Variables For the Moderator Display

#############################################

$Query = "SELECT comment_id, username, pro_comment, pro_link, date_submitted from $TableName302 WHERE pro_block = '3'";

$Result = mysql_query($Query, $Link1);

$Count = mysql_num_rows($Result);

##########################

DISPLAY THE COMMENTS

##########################

IF(isset($submit)) {

While ($Counter < $Count) {

$Counter++;

$Query2 = "UPDATE $TableName302 set pro_block = '2' WHERE $comment_id = '$New_Array[$Counter]'";

$Query1 = "UPDATE $TableName302 set pro_block = '1' WHERE $comment_id = '$New_Array[$Counter]'";

$Query3 = "UPDATE $TableName302 set pro_block = '3' WHERE $comment_id = '$New_Array[$Counter]'";

}

}ELSE{

PRINT ("

<p align='center'><font color='#FF0000' size='6'><b><u>MODERATE COMMENTS</u></b></font></p>
<b># of Comments to be Moderated: $Count</b><br>
<form method='post' action=''>

<table width='100%' border='1'>
<tr>
<td width='5%'>YES</td>
<td width='5%'>NO</td>
<td width='5%'>HOLD</td>
<td width='20%'>USER</td>
<td width='55%'>COMMENT</td>
<td width='10%'>See Link?</td>
</tr>");

WHILE ($row = mysql_fetch_array($Result)) {

$Count++;

$New_Array[$Count] = '$row[comment_id]';

PRINT ("

<input type='hidden' name='comment_id' value='$row[comment_id]'>
<tr>
  <td width='5%'>
    <input type='radio' name='status$row[comment_id]' value='2'>
  </td>
  <td width='5%'>
    <input type='radio' name='status$row[comment_id]' value='1'>
  </td>
  <td width='5%'>
    <input type='radio' name='status$row[comment_id]' value='3'>
  </td>
  <td width='20%'>$row[username]</td>
  <td width='55%'>$row[pro_comment]</td>
  <td width='10%'><a href ='$row[pro_link]'>YES</a></td>
</tr>

");

}

PRINT("

</table>
<p align='center'>
<input type='submit' name='Submit' value='SUBMIT THIS MODERATED LIST'>
</p>
</form>
");

}

INCLUDE("../footer2.php");

MrAlaska

Originally posted by Tony_Latino
Thanks for the guidance there, but as I was heading home today, I had a brainstorm.

I can just use an array actually and assign the values to it. Then when the form is submitted, it can look at the contents of the array and make the inserts and modifications that way.

I am going to try it tonight and hope it works, I will let you know how everything goes.

That is the right idea!

I did not get to the point where I was trying to figure out your database and exactly what you are attempting, but I did see a few problems with the code you posted. First of all, you are setting $Count to the number of rows, then when you build the form you are incrementing $Count some more, but that actually will not affect building the form (which is not a form yet) because you are only using $Count to populate an Array which you do nothing with except assign it the literal string '$row[comment_id]'

I would say get rid of extraneous code and just get the form to build properly as confirmed by viewing the source, then build the $submit condition to just collect the variables and echo them back to you. When you get all that working, then start thinking about building the sql statements to update the database. If you have problems with a single step you can always come back and specify them in a question, but I think you will find less problems if you take it one step at a time.

Just my thoughts 🙂