how to create multi user oracle apex application with custome login using database table

how to create multi user oracle apex application

open your oracle application express click on

>app builder
> shred components
>authentication schemes
> create
> choose type custom
> authentication function click help icon
showing this scripts

>

create or replace function authenticate_ft_users
  (p_username in varchar2, p_password in varchar2)
return boolean
is
  l_user_name       ft_users.user_name%type    := upper(p_username);
  l_password        ft_users.password%type;
  l_hashed_password varchar2(1000);
  l_count           number;
begin

select count(*) into l_count from fit_users
  where user_name = l_user_name;

if l_count > 0 then
  l_hashed_password := ft_hash_password(l_user_name, p_password);
  select password into l_password from ft_users where user_name = l_user_name;
    if l_hashed_password = l_password then
    return true;
  else
    return false;
  end if;
  
else
  return false;
end if;
return true;
end authenticate_ft_users;

goto oracle apex sql scripts

> create new
> past (above  sql funcntion code )
> save and run it

>

if you found it error so comment
 

Advertisements

wordpress disable plugin using database

wordpress disable plugin using database
open your database server
open phpmyadmin select your databse
find database se wp-config file
// ** MySQL settings – You can get this info from your web host ** //
/** The name of the database for WordPress */
define(‘DB_NAME’, ‘i2561658_wp9’);

open your db
goto wp_option table
find active_plugin
disable all plugin clear active_plugin
filed

wordpress short code – wordpress developer must be know

how to dynamic write copy write current year and  site title

wordpress short code wordpress developer must be know

print current year in WordPress site  :  [current-year]

print site title in in wordpress site : [site-title]

site url wordpress short code : [site-url]

Copyright &copy; [current-year] <a href=”[site-url]”>[site-title]</a>. All rights reserved.