Store multiple selection from pagination info into single array

Expand Post »

Hi
I was using a schroll bar to display multiple rows of dynamically created from database records.
The scrolling was not displaying the data properly so I have decided to use pagination.
The problem I am having is,
if I select one item on page #1 and another on page #5
only the last item selected on page #5 is stored in the array.
How can I store selections from multiple pages into one array?
Noite: I am using foreach loop to insert the selected record into a seperate table.

PHP Syntax (Toggle Plain Text)
<?php
session_start();
include("..db_connect_in.php");
?>
<html>
<body>
<form action ="../process.php" method="post">
<php?
  $mysqli = db_connect();
                db_select($mysqli, $db_id);
 
   /**----------------------------paging--------------------------------*/
 //how many rows to show per page
 $BottomRowsPerPage = 17;
 //by default we show first page
 $BottomPageNum = 1;
 //get the current page number
 if(isset($_GET['botpage']))
   {
  $BottomPageNum = $_GET['botpage'];
   }
 //counting the offset
 $BottomOffset = ($BottomPageNum - 1) * $BottomRowsPerPage;
 
  /***************** determine which and how to select data to display ***************/
  $query = "SELECT c.code_id, c.code, c.description
       FROM code c
    WHERE c.fee_code = m.code
    AND c.section_code = 'K'
    ORDER BY c.fee_code";
 
 $BottomPagingQuery = "LIMIT $BottomOffset, $BottomRowsPerPage";
      $result = mysqli_query($mysqli,$query.$BottomPagingQuery); //or die('Error, bot query failed');
 
 
            //search area display area layer and table
     echo "<table width=\"99%\"  border=\"0\">
             <tr align=\"center\" bgcolor=\"#FFFFFF\" height=\"\">
                     <td width=\"100%\" >
               <div id=\"Layer2\" style=\"position:absolute; width:100%; height:550px; z-index:2; left: 12px; top: 305px;\">
                     <div id=\"pat-dash-scroll-box2\" style=\"overflow: off; float: left; width: 100%; height: 540px;  margin: 0px; \">\n";
 
   //table begins
             echo "<table width=\"99%\" height=\"332\" left =\"40\" align = \"\" border=\"0\" font face =\"arial\">\n";
 
         /**----------------------loop record to display----------------------**/
 $num_service = mysqli_num_rows($result);
 for($i=0; $i < $num_service; $i++)
  {
             $row = mysqli_fetch_array($result);
       list($code_id, $fee1_code, $description) = $row;
 
      //diaplay search results in rows
     echo"<tr height=\"10\">
    <td width=\"4%\" bgcolor=\"#fff8dc\" align=\"center\">
        <input type=\"checkbox\" name=\"fee1_choice[$i]\" value=\"$code_id\"></td>
             <td width=\"7%\" bgcolor=\"#fff8dc\" ><span class=\"style20\"><strong>$fee1_code</strong></span></td>
             <td width=\"3%\" bgcolor=\"$bgcolor\" height=\"10\">
         <input type=\"text\" name=\"fee1_unit[$i]\" size=\"1\" maxlength=\"2\" value =\"$fee1_unit\"/></td>
             <td width=\"79%\" bgcolor=\"$bgcolor\" class=\"style20\"> $description </td>
                    echo"</tr>\n";
  }//end of for loop
 
 
    /**----------------Bottom pagination-------------------**/
  echo '<br>';
  //how many rows we have in database
  $result  = mysqli_query($mysqli,$query) or die('Error, 2 query failed');
  $BottomNumRows = mysqli_num_rows($result);
  //how many pages we have when using paging?
  $BottomMaxPage = ceil($BottomNumRows/$BottomRowsPerPage);
  $self = $_SERVER['PHP_SELF'];
  /** creating 'previous' and 'next' link plus 'first page' and 'last page' link
               print 'previous' link only if not on page one **/
  if ($BottomPageNum > 1)
   {
    $BottomPage = $BottomPageNum - 1;
    $BottomPrev = "<a href=\"$self?u_find=$find&u_field=$field&u_search=$searching&u_back=$back&u_special=$special&u_service=$services&u_sch_yr=$schedule_year&toppage=$TopPageNum&botpage=$BottomPage\">[Prev]</a> ";
    $BottomFirst = "<a href=\"$self?u_find=$find&u_field=$field&u_search=$searching&u_back=$back&u_special=$special&u_service=$services&u_sch_yr=$schedule_year&toppage=$TopPageNum&botpage=1\">[First Page]</a> ";
   }
   else
    {
     $BottomPrev  = '[Prev]';       // we're on page one, don't enable 'previous' link  ,
     $BottomFirst = '[First Page]'; // nor 'first page' link
    }
  //print 'next' link only if we're not
  //on the last page
  if ($BottomPageNum < $BottomMaxPage)
   {
    $BottomPage = $BottomPageNum + 1;
    $BottomNext = "<a href=\"$self?u_find=$find&u_field=$field&u_search=$searching&u_back=$back&u_special=$special&u_service=$services&u_sch_yr=$schedule_year&toppage=$TopPageNum&botpage=$BottomPage\">[Next]</a>";
    $BottomLast = "<a href=\"$self?u_find=$find&u_field=$field&u_search=$searching&u_back=$back&u_special=$special&u_service=$services&u_sch_yr=$schedule_year&botpage=$TopPageNum&botpage=$BottomMaxPage\">[Last Page]</a>";
   }
   else
    {
     $BottomNext = '[Next]';      // we're on the last page, don't enable 'next' link
     $BottomLast = '[Last Page]'; // nor 'last page' link
    }
   // print the page navigation link
   echo"<center> ". $BottomFirst . $BottomPrev . " <strong>$BottomPageNum</strong> of <strong>$BottomMaxPage</strong> pages " . $BottomNext . $BottomLast."</center>";
 
  echo"</div>\n";
         echo "</div>\n";
  echo "</table>\n";
        echo "</table>\n";
 
    $mysqli->close();//close connection to db
?>
</form>
</body>
</html>
<?php
session_start();
include("..db_connect_in.php");
?>
<html>
<body>
<form action ="../process.php" method="post">
<php?
  $mysqli = db_connect();
                db_select($mysqli, $db_id);

   /**----------------------------paging--------------------------------*/
 //how many rows to show per page
 $BottomRowsPerPage = 17;
 //by default we show first page
 $BottomPageNum = 1;
 //get the current page number
 if(isset($_GET['botpage']))
   {
  $BottomPageNum = $_GET['botpage'];
   }
 //counting the offset
 $BottomOffset = ($BottomPageNum - 1) * $BottomRowsPerPage;
 
  /***************** determine which and how to select data to display ***************/
  $query = "SELECT c.code_id, c.code, c.description
       FROM code c
    WHERE c.fee_code = m.code
    AND c.section_code = 'K'
    ORDER BY c.fee_code";
 
 $BottomPagingQuery = "LIMIT $BottomOffset, $BottomRowsPerPage";
      $result = mysqli_query($mysqli,$query.$BottomPagingQuery); //or die('Error, bot query failed');
 

            //search area display area layer and table
     echo "<table width=\"99%\"  border=\"0\">
             <tr align=\"center\" bgcolor=\"#FFFFFF\" height=\"\">
                     <td width=\"100%\" >
               <div id=\"Layer2\" style=\"position:absolute; width:100%; height:550px; z-index:2; left: 12px; top: 305px;\">
                     <div id=\"pat-dash-scroll-box2\" style=\"overflow: off; float: left; width: 100%; height: 540px;  margin: 0px; \">\n";

   //table begins
             echo "<table width=\"99%\" height=\"332\" left =\"40\" align = \"\" border=\"0\" font face =\"arial\">\n";
 
         /**----------------------loop record to display----------------------**/
 $num_service = mysqli_num_rows($result);
 for($i=0; $i < $num_service; $i++)
  {
             $row = mysqli_fetch_array($result);
       list($code_id, $fee1_code, $description) = $row;
 
      //diaplay search results in rows
     echo"<tr height=\"10\">
    <td width=\"4%\" bgcolor=\"#fff8dc\" align=\"center\">
        <input type=\"checkbox\" name=\"fee1_choice[$i]\" value=\"$code_id\"></td>
             <td width=\"7%\" bgcolor=\"#fff8dc\" ><span class=\"style20\"><strong>$fee1_code</strong></span></td>
             <td width=\"3%\" bgcolor=\"$bgcolor\" height=\"10\">
         <input type=\"text\" name=\"fee1_unit[$i]\" size=\"1\" maxlength=\"2\" value =\"$fee1_unit\"/></td>
             <td width=\"79%\" bgcolor=\"$bgcolor\" class=\"style20\"> $description </td>
                    echo"</tr>\n";
  }//end of for loop
 

    /**----------------Bottom pagination-------------------**/
  echo '<br>';
  //how many rows we have in database
  $result  = mysqli_query($mysqli,$query) or die('Error, 2 query failed');
  $BottomNumRows = mysqli_num_rows($result);
  //how many pages we have when using paging?
  $BottomMaxPage = ceil($BottomNumRows/$BottomRowsPerPage);
  $self = $_SERVER['PHP_SELF'];
  /** creating 'previous' and 'next' link plus 'first page' and 'last page' link
               print 'previous' link only if not on page one **/
  if ($BottomPageNum > 1)
   {
    $BottomPage = $BottomPageNum - 1;
    $BottomPrev = "<a href=\"$self?u_find=$find&u_field=$field&u_search=$searching&u_back=$back&u_special=$special&u_service=$services&u_sch_yr=$schedule_year&toppage=$TopPageNum&botpage=$BottomPage\">[Prev]</a> ";
    $BottomFirst = "<a href=\"$self?u_find=$find&u_field=$field&u_search=$searching&u_back=$back&u_special=$special&u_service=$services&u_sch_yr=$schedule_year&toppage=$TopPageNum&botpage=1\">[First Page]</a> ";
   }
   else
    {
     $BottomPrev  = '[Prev]';       // we're on page one, don't enable 'previous' link  ,
     $BottomFirst = '[First Page]'; // nor 'first page' link
    }
  //print 'next' link only if we're not
  //on the last page
  if ($BottomPageNum < $BottomMaxPage)
   {
    $BottomPage = $BottomPageNum + 1;
    $BottomNext = "<a href=\"$self?u_find=$find&u_field=$field&u_search=$searching&u_back=$back&u_special=$special&u_service=$services&u_sch_yr=$schedule_year&toppage=$TopPageNum&botpage=$BottomPage\">[Next]</a>";
    $BottomLast = "<a href=\"$self?u_find=$find&u_field=$field&u_search=$searching&u_back=$back&u_special=$special&u_service=$services&u_sch_yr=$schedule_year&botpage=$TopPageNum&botpage=$BottomMaxPage\">[Last Page]</a>";
   }
   else
    {
     $BottomNext = '[Next]';      // we're on the last page, don't enable 'next' link
     $BottomLast = '[Last Page]'; // nor 'last page' link
    }
   // print the page navigation link
   echo"<center> ". $BottomFirst . $BottomPrev . " <strong>$BottomPageNum</strong> of <strong>$BottomMaxPage</strong> pages " . $BottomNext . $BottomLast."</center>";

  echo"</div>\n";
         echo "</div>\n";
  echo "</table>\n";
        echo "</table>\n";
 
    $mysqli->close();//close connection to db
?>
</form>
</body>
</html>

Similar Threads

inserting multiple selection from checkbox in to one column in JSP
How to store multiple selection? in VB.NET
single array objects in Java
Help Reading Info in Text File Into an Array in C++

assgar

Reputation Points: 24

Solved Threads: 0

Junior Poster in Training

Offline

89 posts
since Oct 2006

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Form data & Back button

Next Thread in PHP Forum Timeline: php+javascript

DaniWeb Message

Cancel Changes

User Name
Password