public function selectAction($where = "")
{
$db = new connection();
$tableName = $this->table_name;
if ($tableName != "") {
$result = array();
$sel = "SELECT * FROM `{$tableName}` WHERE {$where}";
if ($res = mysql_query($sel)) {
if (mysql_num_rows($res) > 0) {
$select_Data = array();
$i = 0;
while ($row = mysql_fetch_array($res)) {
$select_Data[$i]['sys_user_id'] = $row['sys_user_id'];
$select_Data[$i]['sys_name'] = $row['sys_name'];
$select_Data[$i]['sys_role_id'] = $row['sys_role_id'];
$select_Data[$i]['dob'] = $db->showDBDate($row['dob']);
$select_Data[$i]['email'] = $row['email'];
$select_Data[$i]['mobile'] = $row['mobile'];
$select_Data[$i]['address'] = $row['address'];
$select_Data[$i]['user_name'] = $row['user_name'];
$select_Data[$i]['password'] = $db->encodeData($row['password']);
$select_Data[$i]['created_by'] = $row['created_by'];
$select_Data[$i]['created_at'] = $row['created_at'];
$select_Data[$i]['modified_by'] = $row['modified_by'];
$select_Data[$i]['modified_at'] = $row['modified_at'];
$select_Data[$i]['flag'] = 0;
$i++;
}
return $select_Data;
}
} else {
return false;
}
}
}
