<?php

	require_once 'dbconfig.php';

	if($_POST)
	{
		$password_change = $_POST['password_change'];
		$password_old = $_POST['password_old'];
		$username_ch = $_POST['username'];

	//	$joining_date =date('Y-m-d H:i:s');

		$username_sha1= sha1($username);
		$password_change_sha1 = sha1($password_change);
		$password_old_sha1 = sha1($password_old);


		try
		{

			$stmt = $db_con->prepare("SELECT * FROM login_user WHERE username=:uname");
			$stmt->execute(array(":uname"=>$username));
			$count = $stmt->rowCount();

			if($count==0){

			$stmt = $db_con->prepare("UPDATE * SET password='$password_change_sha1' WHERE login_user WHERE username=:uname"  );


			$stmt->bindParam(":newpass",$password_change_sha1);
			$stmt->bindParam(":uname",$username_sha1);

			//$stmt->bindParam(":jdate",$joining_date);

				if($stmt->execute())
				{
					echo "registered";
				}
				else
				{
					echo "Query could not execute !";
				}

			}
			else{

				echo "1"; //  not available
			}

		}
		catch(PDOException $e){
			echo $e->getMessage();
		}
	}






?>