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
  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;

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;
    return false;
  end if;
  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


how to create data dictionary in phpmyadmin

open your data base
login with your credentials
Default phpmyadmin Credentials id User name : root Password :  leave blank
select your data base bottom of a database showing a data dictionary 
click there showing your data dictionary  

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

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.