"; $gate_conn = pg_connect("dbname=$dbname user=alice") or die ("
ERROR : Couldn't connect to database"); $query = "SELECT * FROM users"; $res = pg_query($query) or die ("
encrypt_psswd.php - ERROR : Couldn't execute user query"); while($row = pg_fetch_array($res)) { // loop over users $who = $row['initials']; $hash = crypt($row['passwd'],trim($who)); $SQL = "UPDATE users SET passwd='".$hash."' WHERE initials='".$who."'"; $res2 = pg_query($SQL) or die ("
ERROR : Couldn't execute encrypt query ".$SQL); } pg_close() or die ("
ERROR : Couldn't disconnect database"); print "User table encryption in $dbname database finished!
"; ?>