/lenasys/0.1 : revision 4.10.2

To get this branch, use:

bzr branch
http://gegoxaren.bato24.eu/bzr/lenasys/0.1

Code updated partly, File to remember map "duggor" has not been checked.

added added

removed removed

//Passwordchangingcode

if(isset($_POST['changePasswordSubmit'])) {

//////////////////////////

$pdo = new PDO('mysql:dbname=dsystem;host=wwwlab.iki.his.se', 'dbsk', 'Tomten2009'); //ADD NEW USER WITH LESS PRIVILEGES?

$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);

//////////////////////////

$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);

$queryString = "SELECT Student.ssn FROM Student WHERE Student.loginName=:LOGIN AND Student.passw=:PASSW;";

$stmt = $pdo->prepare($queryString);

$stmt->bindParam(':LOGIN', $_POST['loginName']);

$oldPassword=md5($_POST['password']);

$stmt = $pdo->prepare($queryString);

$stmt->bindParam(':LOGIN', $_POST['loginName']);

$oldPassword=md5($_POST['password']);

$stmt->bindParam(':PASSW', $oldPassword);

$stmt->execute();

if ($stmt->rowCount() == 1) { //Old password correct

$stmt->execute();

if ($stmt->rowCount() == 1) { //Old password correct

$student=$stmt->fetch(PDO::FETCH_ASSOC);

//Update password to new password

$updateString = "UPDATE Student