PHP - Retaining Checkbox Selections In A Loop

Hi all,

I have a situation where I need to remember what check boxes where checked over pagination, I have managed to do this via the use of this:

http://jamesfunk.com/wordpress/?p=65

The problem is that as the code stood:

Code: [Select]
<input type="checkbox" name="compare" value="<?php echo $list['jobseeker_id'];?>" class="remember_cb"/>
It was treating one ticked checkbox as them all because they all have the same name and are in the a while loop!

I countered this by changing the code to:

Code: [Select]
<input type="checkbox" name="compare<?php echo $list['jobseeker_id']?>" value="<?php echo $list['jobseeker_id'];?>" class="remember_cb"/>
Which effectively now makes the checkbox name unique... i.e. compare{id}.

The problem with this is that I can now no longer process it. This is my processing code:

$jobseekers = $_POST['compare'];
$i = 0;
for($i; $i<count($jobseekers); $i++){
$query = "SELECT * FROM jobseekers WHERE jobseeker_id = '$jobseekers[$i]'";
$result = mysql_query($query) or die (mysql_error());

while ($row = mysql_fetch_array($result)) {
// Spit out the required data
}
}

As you can see I am trying to get the data from $_POST['compare'], which will obviously now be blank as I have had to make the name unique.... the trouble is I'm not sure how to actually process this.

Can anyone help me out here? any help or advice would be greatly appreciated!

many thanks,

Greens85

I'm not sure of the appropriate subject line for this feature, but hopefully I'm close.  I'll try to describe what I'm trying to do.  The most common place you see this is on web based file uploads so I'll use it as my example.

Let's say I want to allow my user to upload files so there is a text box where they enter the file name.  The user is allowed to upload as many files as he wants with 1 push of the submit button.

Upon the loading of the form, there will be 5 textboxes for file upload, but if the user wants to upload more than 5 files, there is a link that is clicked and I think via ajax or javascript another textbox will be added.  The user can do this for as many files he wants to upload.  This is what it looks like to the user, but then when the form is submitted how are these variables referenced?

So how is this setup in the main form and how are the variables referenced after form submission?

If anyone can point me to a good web tutorial on this type of thing I would appreciate it.

Thanks

Carl

Hi Guys,

I have successfully managed to get my select drop down boxes to populate from a DB which i am very proud of as I'm  still learning PHP but I really need some help on the next part please...

I want to display a price based on the drop down selections so in my DB i have this...

id   colours   size   quantity             sides   price    stock               variations

1       1            A6      0-99           SINGLE    200           100g GLOSS            1
2       1            A6      100-199   SINGLE    300           100g GLOSS            1


What would i need to add to my PHP so that it checks the selections made by the user and displays the relevant price in the price filed in my page?????

Hopefully someone can help.

thanks

Craig

This select box below does remember and highlight -one- selection after submitting the form. But when i make it multiple, it doesn't highlight any of the selections after submitting.
Any idea about how to achieve this?

Thanks in advance.

Code: [Select]
<?php
$options_amount = array("0","1","2","3","4","5","6","7","8","9","10+");
$no_way = $_GET['no_way'];
?>

<select class="postform" name="no_way[]" multiple size="5">
<option <?php if ($no_way == 'all') { ?>selected="selected"<?php }?> value="all">Any</option>
<?php
foreach ($options_amount as $option) {
?><option <?php if ($no_way == $option) { ?>selected="selected"<?php }?> value="<?php echo $option; ?>"><?php echo $option; ?></option><?php }?>
</select>

Hey all,

Another question for you. How does one make it so that the selections (choices) a user selects for dynamic selection boxes remain after the form is posted, which does post back to itself?

I've tried JavaScript using the "name" of the selection box as the id but I must be doing something wrong because it's not working..as usual lol. The values in the selection boxes are populated dynamically so I'm not sure how to do this.

Thank you.

Hi,
I am developing a web application using PHP and MySQL. I am filling my combobox with the value fetched from the MySQL database. I want to retain the selected value of the combo box in postback. I am able to do it with the statiic values. But in this case I am binding the combbox   dynamically with the values from the database. Can anybody please help me?
Thanks,
Regards,
Viji

Hi all,

i need some help in retaining the values in an <option> textbox..

I have found a code to loop the date online, and use it for Javascript jump menu, but i have no ideas how to retain the option.. here are my codes(in red),

$year1 = date('Y');
$month1 = date('m');
$day1 = date('j');

$day1 = $day1 + 1;

$year2 = date('Y') + 2;
$month2 = date('m');
$day2 = date('j');

$start_date = "$year1-$month1-$day1";
$end_date = "$year2-$month2-$day2";


$date = mktime(0,0,0,$month1,$day1,$year1); //Gets Unix timestamp START DATE
$date1 = mktime(0,0,0,$month2,$day2,$year2); //Gets Unix timestamp END DATE
$difference = $date1-$date; //Calcuates Difference
$daysago = floor($difference /60/60/24); //Calculates Days Old



$i = 0;
while ($i <= $daysago +1) {
if ($i != 0) { $date = $date + 86400; }
else { $date = $date - 86400; }



$yy1 = date('Y',$date);
$mm1 = date('m',$date);
$dd1 = date('d',$date);
$date3 = "$yy1-$mm1-$dd1" ;



echo "<option value=\"test1234.php?m=$mm1&amp;y=$yy1&amp;d=$dd1\"  ";
echo ">".$date3 ."</option>";
$i++;
}

i know that i have to something selected, but i dun understand how this set of date code loop which left me helpless.

I'm stuck trying to figure out why when I make a selection in drop down list of a php form, the selection does not stay when form is refreshed or re-displayed due to an pattern error of another field.

My array is
state_province = array(list of the states, and provinces)
field name in the label array is: "state" => "State",
Here is the code that I'm using:

echo "<form action='$_SERVER[PHP_SELF]' method='POST'>";
foreach($labels as $field => $label)
{
 if($field == "state")
   {
      echo "<div class='province_state'><label for='state' size='15'>* Province/State</label><select>";
            
      foreach($state_province as $state)
      
         {
         echo "<option value=$state";
         if(@$_POST['state'] == $state)
           {
            echo "selected='selected'";
           }   
       echo ">";
       echo $state;
       echo "</option>\n";
      }
     echo "</select></div>\n";      

   }

Hi guys, I had a problem before which is similar to the problem im about to describe, however Pikachu helped me solve the last problem so a big thanks to him! However this problem is slightly different and im struggling to find a solution. I will first describe the problem I had which pikachu helped me solve as it would be easier for me to describe this past problem.

I have an update form, so a user can edit existing records which are pulled from a database. When the user changes the values in a text field then submits the form, the values in the text fields updates fine. However if they change the values in the text box and then tries to submit the form but there was an error, the values in the text fields go back to the values from the database and the user has to change the text fields again.

Well this problem was solved with the help of pikachu and the this is what I did...

<?php if(isset($_POST['title'])){echo htmlspecialchars($_POST['title']);} else if (isset($title)) {echo htmlspecialchars($title);}?>

Again, the above works fine however the problem I have now is the same problem as described above however it relates to drop down menus and not text fields. I can't seem to figure out how to retain the values in a drop down menu the same way I have for text fields. Below is the code that im using that I thought would work however it isnt working, the values of the drop down menu (if there was an error) are going back to the values from the database. Heres the code...

<option value="Psychopathic" <?php if ((isset($_POST['category']))&&($_POST['category'] == 'Psychopathic')) { echo ' selected=selected'; }  else if ((isset($category))&&($category == 'Psychopathic')) { echo ' selected=selected'; } ?>>Psychopathic</option>

Does anybody know what i am doing wrong and how i can fix this problem? I understand what i need to do but i cant seem to get the code to do what i want to do and thats to retain values of a drop down menu when the page is returned with an error.

Any help would be much appreciated.

AJay

Hi I have tried the mysql forum but have had no joy with an answer to my problem so wondered if php would be better.

I want my users to be able to select from 5 different drop down lists where they can chose any combination from 1 up to all 5,  I have attached the front end.  These lists are being populated from mysql tables.

Code for the drop down lists is as follows
Code: [Select]
  <form action="horse-events-devon.php?url_countyid=<?php echo  urlencode ($url_countyid ['url_countyid'])  ; ?>&go" method="POST">
    <table id="searchtable">
      <tr>
        <th>Find By Discipline</th>
        <th>Find By Venue</th>
        <th>Find By Championship</th>
        <th>Find By Organiser</th>
        <th>Equine Association</th>
        <th>Submit Your Selections</th>
        </tr>
      <tr>
        <td><select name="dis_id">
                                    <?php 
                                        $upcomingdis = upcomingdis($url_countyid);
                                        $upcoming_dis_bycounty = mysql_fetch_assoc ($upcomingdis);
                                    ?>
                                    <?php 
                                    do { 
       ?>   <option value="<?php echo $upcoming_dis_bycounty ['dis_id']; ?>" >
<?php echo $upcoming_dis_bycounty ['dis_description']; ?></option>
<?php 
                                    } while ($upcoming_dis_bycounty = mysql_fetch_assoc ($upcomingdis)); 
                                    ?></select></td>
        <td><select name="ven_id">
                                    <?php 
                                        $upvenbycounty_set = upcoming_venevents_bycounty($url_countyid);
                                        $upcoming_ven_bycounty = mysql_fetch_assoc ($upvenbycounty_set);
                                    ?>
                                    <?php 
                                    do { 
       ?>   <option value="<?php echo $upcoming_ven_bycounty ['ven_id']; ?>" >
<?php echo $upcoming_ven_bycounty ['ven_name']; ?></option>
<?php 
                                    } while ($upcoming_ven_bycounty = mysql_fetch_assoc ($upvenbycounty_set)); 
                                    ?></select></td>
        <td><select name="champ_id">
                                    <?php 
                                        $championship_set = findchampionships();
                                        $champlist = mysql_fetch_assoc ($championship_set);
                                    ?>
                                    <?php 
do { 
?>   <option value="<?php echo $champlist ['champ_id']; ?>" >
<?php echo $champlist ['champ_description']; ?></option>
<?php 
} while ($champlist = mysql_fetch_assoc ($championship_set)); 
?></select></td>
        <td>
        <select name="org_id">
                        <?php 
                            $uporgbycounty_set = upcoming_organevents_bycounty($url_countyid);
                            $upcoming_org_bycounty = mysql_fetch_assoc ($uporgbycounty_set);
                        ?>
                        <?php 
                        do { 
                        ?>   <option value="<?php echo $upcoming_org_bycounty ['org_id']; ?>" ><?php echo $upcoming_org_bycounty ['org_name']; ?></option>
                        <?php 
                        } while ($upcoming_org_bycounty = mysql_fetch_assoc ($uporgbycounty_set)); 
                        ?></select>
       
        </td>
        <td><select name="ass_id">
                                    <?php
                                        $upassbycounty_set = upcoming_assevents_bycounty($url_countyid);
                                        $upcoming_assbycounty = mysql_fetch_assoc ($upassbycounty_set);
                                    ?>
                                    <?php 
                                    do { 
                                    ?>   <option value="<?php echo $upcoming_assbycounty ['ass_id']; ?>" >
<?php echo $upcoming_assbycounty ['ass_description']; ?></option>
                                    <?php 
                                    } while ($upcoming_assbycounty = mysql_fetch_assoc ($upassbycounty_set)); 
                                    ?></select></td>
      <td><input name="submit" type="submit" /><input name="countyid" type="hidden" value="<?php echo $url_countyid ['url_countyid']; ?>" /></td>
        </tr>
      </table>
  </form>
My search processing is as follows

Code: [Select]
  <?php
if (isset($_POST['submit'])){
if (isset($_GET['go'])){
$countyid = $_POST['countyid'];
$ven_id = $_POST['ven_id'];
$dis_id = $_POST['dis_id'];
$champ_id = $_POST['champ_id'];
$org_id = $_POST['org_id'];
$event_id = $row['event_id'];

$sql = "SELECT DATE_FORMAT (events.startdate, '%a, %d, %b') 
   AS stdate, events.event_id, events.title, events.ven_id, events.org_id,
   venue.county_id, venue.ven_id, eventdisciplines.event_id, eventdisciplines.dis_id, county.county_id, discipline.dis_id \n"
. "FROM events \n"
. "LEFT OUTER JOIN eventdisciplines \n"
. "ON events.event_id = eventdisciplines.event_id \n"
. "LEFT OUTER JOIN discipline \n"
. "ON eventdisciplines.dis_id = discipline.dis_id \n"
. "LEFT OUTER JOIN venue \n"
. "ON events.ven_id = venue.ven_id \n"
. "LEFT OUTER JOIN county \n"
. "ON venue.county_id = county.county_id \n"
. "WHERE events.ven_id = ({$ven_id} OR events.org_id = {$org_id})\n"
. "AND events.startdate > NOW()\n"
. "AND venue.county_id = {$countyid}  \n"
. "ORDER BY startdate ASC";

$result = mysql_query ($sql, $connection);
?>
How am I best to do this please?  my OR within the mysql does not work, should I not be doing this with php in the search processing?  someones help would really be appreciated, just to point me in the right direction.

[attachment deleted by admin]

I cannot figure out how to retain the inputted information once submit is pressed. I want the user to enter their first name, last name, hours of work, and hourly pay rate. Then, I want them to press submit. Their pay will be calculated and displayed, but I still want their inputted information to be visible. How can I do that??

Here is my code:
Code: [Select]
<html>
<head>

<?php

$pay = $_POST['pay'];
$hours = $_POST['hours'];
$extra = $_POST['extra'];
$rate = $_POST['rate'];

if ($hours > 40){
        $extra=$hours-40;
        $hours=40;
        $pay=($extra*1.5*$rate)+($hours*$rate);
} else {
        $pay=$hours*$rate;
}
echo "Your pay is:  <br /> $ $pay <br />"
;

?>
</head>
<body>

<form method='post' action='pay2.php'>
First Name: <input type='text' name='first'><br/>
Last Name: <input type='text' name='last'><br/>
Hours of Work: <input type='text' name='hours'><br/>
Hourly Pay Rate: <input type='text' name='rate'><br/>
<input type='submit' value='submit'>

</form>
</body>
</html>

Ok from one brick wall to the next. After lots of help with my last query I moved onto the next task an I'm completely stuck again.

I have a form thats created with a loop.  Here is that form


 <form action="" method="post" id="">
        <?php 
 for ($i = 1; $i <= $totalRows_rs_cacheNum; $i++) {
    echo "<label>Cache ".$i."</label>
          <span id='sprytextfield".$i."'>
         <input name='cache[$i]' type='text' value='".$_POST['cache[$i]']."'/>
         <span class='textfieldRequiredMsg'>Required!</span></span>
         <div class='clear'></div>";
}
?>
 <input name="nextbtn" type="submit" value="Next" />


When a user enters data in all the fields, If one piece of information is incorrect an error pops up saying one of the fields you entered does not match the fields in the database. At the same time however i wish to keep the data they have entered in each of the fields.

Normally you'd just write

value="<?php echo $_POST['fieldName'];?>"

but for some reason in this case it does not work. can someone point me in the right direction.  I've tried Google many different terms but I can not find the correct term to find my answer.  Hence me asking you guys again.

Thanks

Am new to php... I have been battling on my dynamic checkboxes in such a way that if none is checked the form is return, also I need to retain what was checked when the form postback due to other invalid inputs.

Code: [Select]
$result = mysql_query("SELECT * FROM course") or die(mysql_error()); if ($result) { while ($row = mysql_fetch_array($result)){ if (isset($_POST['courses']) and $_POST['courses'] == $row['cid']) {echo $row['cid'];} print "<input type=\"checkbox\" name=\"courses[]\" value=\"$row[cid]\">$row[cname]\n"; } }
Help needed purely on php codes. Thanks in advance

Hi there,   I am getting this in a PHP generated email:   ACWA Member/Subscriber: Melody’s Children’s Service   The line of code in the php is:     $subject = "ACWA Member/Subscriber: $membername";   I have tried htmlentitiies, html_entity_decode, htmlspecialchars but nothing seems to work.   I haven't used htmlentities anywhere else in the code for this variable.   Any suggestions?   All advice gratefully received.

Hi I have a list of states using the array method in a form. The drop down menu works fine.  I want to save the user choice,if the form is re-displayed due to a blank field or pattern mismatch.  I know I can use the selected=selected, but don't know wher to put the statement:
My array is:
state_province = array ("list of states", "provinces")
Var in my labels array is "state"=>"state"
Here is my code for the select/option statement:

{
 if($field == "state")
   {
      echo "<div class='province_state'><label for='state' size='10'>* Province/State</label><select>";
            
      foreach($state_province as $state)
         {
         echo "\n<option value='$state_province' /> ";   
          echo $state ;
          echo "</option>";
         }
      echo "</select></div>\n";   

   }
?Is this the correct code to add and where would I add  it?
          if(@$_POST['state'] == $value)
     {
         echo "selected='selected'  ";
     }