22 lines
543 B
PHP
22 lines
543 B
PHP
<?php
|
|
|
|
include "db.php";
|
|
|
|
$school_num = 19194;
|
|
$school_num = 19192;
|
|
$school_num = 19193;
|
|
|
|
$query = "SELECT * FROM users WHERE school_num = $school_num AND type = 'Parent'";
|
|
$users = db_query($query);
|
|
|
|
while ($row = db_fetch_assoc($users)) {
|
|
extract($row);
|
|
$initials = substr($first_name,0,1).substr($last_name,0,1);
|
|
$newpw = strtolower($initials.$userid);
|
|
printf("%-40s %10s %10s %10s\n","$first_name $last_name",$userid,$password,$newpw);
|
|
db_query("UPDATE users SET password = '$newpw' WHERE record_num = $record_num");
|
|
}
|
|
|
|
|
|
?>
|