Tuesday, 15 March 2011

php - Display message each time SQL update is succesful -



php - Display message each time SQL update is succesful -

i'm using php update item table based on result set.

while (!$rs->eof) { $conn->execute("update [table] set qty='".$quantity."' locn ='".$locn."' , pdln ='".$pdln."'"); echo "item updated...<br/>"; /////////message display here $rs->movenext(); }

because volume of info pretty large, wanted message displayed user after each successful update 1 row @ time. there way accomplish using ajax or jquery?

if (ob_get_level() == 0) ob_start(); while (!$rs->eof) { $conn->execute("update [table] set qty='".$quantity."' locn ='".$locn."' , pdln ='".$pdln."'"); echo "item updated...<br/>"; /////////message display here ob_flush(); flush(); sleep(1); $rs->movenext(); } echo "done."; ob_end_flush();

php jquery sql

No comments:

Post a Comment