1,105,334 Community Members

Update multiple records with single action

Member Avatar
OsaMasw
Posting Whiz in Training
212 posts since Jan 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 4 [?]
Skill Endorsements: 0 [?]
 
0
 

Hello there
I have question about how to update multi row in MySQL database, I used while function but this do the job with more time and no indecator when to finish the work,
is there any efficient way to update like 1000 row with one button and make indecator to see the progress of work ?

I used this code

if(isset($_POST['update'])) {
   $update=$_POST['update'];
   $sql = "SELECT user FROM users";
$query = mysql_query($sql)or die(mysql_error());
while($found = mysql_fetch_array($query))
    {

$psn = New psn(); 
$psnUser = $psn->get_jid($found['user']); 
$gold = $psnUser [0]['gold'];
$silver = $psnUser [0]['silver'];
$bronze = $psnUser [0]['bronze'];
$score = $psnUser [0]['points'];
$level = $psnUser [0]['level'];
$total = $psnUser [0]['total'];
$progress= $psnUser[0]['progress'];
$games=$psn->get_games($psnUser['jid']);
$totalgames= $games['totalGames'];

$sql="UPDATE `users` SET  `level` =  '$level',
`bronze` =  '$bronze',
`silver` =  '$silver',
`gold` =  '$gold',
`total` =  '$total',
`score` =  '$score',
`progress` =  '$progress',
`totalg` =  '$totalgames' WHERE  `user` = '$found[user]' LIMIT 1 ";

 $result=mysql_query($sql)or die(mysql_error());

echo $found['user'];
echo "  ....... DONE <br>";
}
Member Avatar
pritaeas
mod_pritaeas
11,315 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,835 [?]
Skill Endorsements: 156 [?]
Moderator
Featured
Sponsor
 
0
 

This function may do the trick: http://php.net/ob_implicit_flush

Member Avatar
OsaMasw
Posting Whiz in Training
212 posts since Jan 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 4 [?]
Skill Endorsements: 0 [?]
 
0
 

can you specify more ? with code example

Member Avatar
pritaeas
mod_pritaeas
11,315 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,835 [?]
Skill Endorsements: 156 [?]
Moderator
Featured
Sponsor
 
0
 

See the link.

Member Avatar
OsaMasw
Posting Whiz in Training
212 posts since Jan 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 4 [?]
Skill Endorsements: 0 [?]
 
0
 

I've saw the link and try the examples, all of them update the counter or items then appears once with message complete :(
I need to update one by one and see the result for each result.

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: