function insert()
{
$query = "INSERT INTO `members` (\n`id` ,\n`username` ,\n`password` ,\n`email` ,\n`created_on` ,\n`is_admin` ,\n`firstname` ,\n`lastname` ,\n`gender` ,\n`address`,\n`is_doctor`\n)\nVALUES (\nNULL , '" . $this->getUsername() . "',\n '" . md5($this->getPassword()) . "',\n '" . $this->getEmail() . "', NOW( ) , '0', \n '" . $this->getFirstname() . "', \n '" . $this->getLastname() . "', \n '" . $this->getGender() . "', \n '" . $this->getAddress() . "',\n '" . $this->getIsDoctor() . "'\n)\n";
$result = $this->db->query($query);
// echo $result->err
self::$message = "Registered SuccessFully";
if ($this->getIsDoctor() == 1) {
$query = "INSERT INTO `doctor_info` VALUES(NULL,'" . $this->getFirstname() . " " . $this->getLastname() . "','0','0')";
$this->db->query($query);
}
return $this->db->affected_rows;
}
