public function save(User $user)
{
//select
$sql1 = 'select max(userID) from user';
$statement = $this->dbAdapter->query($sql1);
$result = $statement->execute();
$row = $result->current();
// Debug::dump($row );
$user->setUserID($row['max(userID)'] + 1);
//insert
$defaultfaceimgpath = '/data/face/defaultfaceimg.png';
$sql = 'insert into user(userID,username,upassword,schoolID,faceimgpath) values(' . $user->getUserID() . ',"' . $user->getUsername() . '","' . $user->getUpassword() . '","' . $user->getSchoolID() . '","' . $defaultfaceimgpath . '")';
// echo $sql;
$this->dbAdapter->query($sql, Adapter::QUERY_MODE_EXECUTE);
}
