<?php

require_once 'db.function.php';

$db = getDB();

$rsc = $db->query("select * from researcher");
while($r = $rsc->fetchRow()) {
    $db->query("update researcher set pword_hash = ? where researcher_id = ?", array(hash('sha256', $r['pword']), $r['researcher_id']));
    $db->commit();
}

?>