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

Form submissing with PHP and JQuery/Ajax
I have searched everywhere, but cannot find a solution for this... I have worked all day trying to g

Functions Not Loading Into Div
I had some help doing some of this but what I'm trying to do is get my functions to retrieve its val

Remote Database Access
Hey guys!!

OK, i'm used to only working with databases from the CPANEL, accessing phpMyAdmin

how to timeout $doc = new DOMDocument()->load($url)
I am currently using this $doc->load($url) to fetch an rss feed.
If a feed takes long than

Just a white page
Okay so, my website, when I click SignUp on it it takes me to /join.php but its a complete white pag

Polymorphism
Was wondering if someone could explain this a little better to me. I had always assumed that it had

utl_file open error
i have file in the unix path

Path /popdev01/pop/popdevb/tfi/

File name

Array to string conversion
Can anyone help me with this?

Notice: Array to string conversion in /home/..../index.php on l

Dynamically set AccordianPane Header
I have an accordian on my master page. I'd like to be able to dynamically change the header on diff

Can't get the unicode character
I'm trying to get some text from various parts of a file. I have converted the file to hex (bin2hex)