Batch update record with Pagination

Posted on 16th Feb 2014 07:03 pm by admin

Hoping someone can help me with this issue I'm having, im trying to batch update records from a result set with pagination. The first page results (first 10 records) will update with the batch, but any other pages will not update.... the pagination coding is preventing the rest of the results to update when a date change is made.

Here's the code im using:

<div class="searchTitle">SCHEDULING</div>
<div class="tabber" id="mytab1">
<div class="tabbertab">
<h2>RECORDS</h2><form name="namestoupdate" method="post" action="updateschedule.php">
<div class="searchTitle">RECORDS<input type='submit' class="submitButton" value='SUBMIT' src="images/submit.png" /></div>


<table cellspacing="0" id="box-table-a">
<tr>
<th>TITLE</th>
<th>DATE</th>
</tr>
<?php
$i = 0;
while ($result_row = mysql_fetch_array($resultbypass)) {
if($i< $startbypass || $i>=$stopbypass) { $i++; continue; }
$i++ ; ?>
<tr>
<td><?php print "<input type='hidden' name='ID[$i]' value='{$result_row['ID']}' />" ?> <?php echo $result_row['Provider']; ?></td>
<td><?php echo $result_row['Title']; ?></td>
<td><?php print "<input type='text' size='8' name='Date[$i]' value='{$result_row['Date]}' maxlength='10' />";
?></td>
</tr>
<?php } ?>
</table>
<?php echo getPaginationString($pagebypass,$totalitemsbypass,$itemsPerPage,1,$targetpage,$pagestringbypass); ?>

</form>
</div>


Batch update script: (updateschedule.php)

<?php
session_start();

include("connect.php");

$size = count($_POST['ID']);

$i = 0;
while ($i <= $size) {

$Date= $_POST['Date'][$i];
$id = $_POST['ID'][$i];

$query = "UPDATE Table
SET Date= '$Date'
WHERE ID = '$id' LIMIT 1";

mysql_query($query) or die ("Error in query: $query");

++$i;
}
mysql_close();

?>

Your Answer:

Login to answer

Other forums

PHP Programming error. Please help!
Hi there,

Am making a website for a friend and have encountered a problem that i need fixing

Access website from only 1 computer...?
One of my customers wants his website to only be accessed by people in which they bought the website

Help With editting and deleting form
Hallo !!

So look at this image :

http://img194.imageshack.us/img194/8272/snapshot5f.pn

UL and LI Add Form
The idea I want here is when the user click on a character name from the drop down select bar at the

Loop Through Date Range
Hi guys,
I have date range as parameter like 01/JAN/2009 TO 16/JAN/2009 now i want to loop thro

Curl timeout breaks script
So im having difficulties with skipping timeout error in curl
my script calls different functions

Delete all files in folder except with certain name
I have a script that I want to delete all files in a folder (taken from a database) except for one n

=> and <=
So I was digging through some code when I came across the <= operator. This is the first tim

problems with php variables in mysql query
i can't seem to get the following query to work.

select $q1c from $vote_rate where id = $re

using file_get_contents??
okay how would i create a script using file_get_contents() in php have it grab search pages 1-20 and