September, 2021 - My Awesome Moments

Bootstrap version 5 Text On Image When Hover or Static Text

I couldn’t find an easy tutorial how to do text on image for Bootstrap version 5 when you mouse hover an image or a static text on the image.
So I have to try few solutions before get it right.

The solution is using purely CSS without any Javascript

The CSS

.text-on-image {
    position: relative;
}

.text {
    position: absolute;   
    bottom: 0;
    left: 0;
    display: none;
}

.text-active{
    position: absolute;   
    bottom: 0;
    left: 0;
    display: block;
    background: white;
    width: 100%;
    height: 20%;
}

.text-on-image:hover .text {
    display: block;
    background: blue;
    width: 100%;
    height: 20%;
}

.text-on-image {

position: relative;

}

.text {

position: absolute;

bottom: 0;

left: 0;

display: none;

}

.text-active{

position: absolute;

bottom: 0;

left: 0;

display: block;

background: white;

width: 100%;

height: 20%;

}

.text-on-image:hover .text {

display: block;

background: blue;

width: 100%;

height: 20%;

}

How To Use It

Wrap the image in a div with class=”text-on-image”
Under the div wrapper,include a text div with class=”text”
You can add link or button

Demo on JSFiddle

Macbook M1 MacOS Big Sur Error MySQL PhpMyAdmin When Login

I login to MySQL using phpMyAdmin with root account and it produced this error.

The server requested authentication method unknown to the client
mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client

The server requested authentication method unknown to the client

mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]

mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client

Login root via terminal

I was able to login using my root password means something configuration is not correct.

When I googled, I found 2 solutions. I tried the first one but fail. So I documented the one that works with Macbook M1 MacOS Big Sur.

Update root Password via Terminal

mysql -u root -p

mysql&gt; ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YouCanUseBackYourPassword';

mysql -u root -p

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YouCanUseBackYourPassword';

Login Again At Your phpMyAdmin

It should work by now using root and the updated password.

WordPress How To Get Variable from Rewrite Rules

I was scratching my head on how to get the variable from WordPress rewrite rules. In one of Stackoverflow post, it was mentioned we could use $_GET and in some posts proposed to use get_query_var() but when I tried both were emptied.

echo 'my var '.$_GET['myvariablename'];

//return empty value

echo 'my var '.$_GET['myvariablename'];

//return empty value

The Correct Way To get Get Variable from Rewrite Rules

But some conditions must be fulfilled. Please read on.

get_query_var('myvariablename');

1	get_query_var('myvariablename');

If Using get_query_var is still Empty means you use non standard variable name

Here is the list of standard query vars that you can use.

Register Your Variable Name

If you use your custom variable, you must add the variable as below.

add_filter( 'query_vars', function add_query_vars($qvars){
		$qvars[] = "myvariablename";} );

1 2	add_filter( 'query_vars', function add_query_vars($qvars){ $qvars[] = "myvariablename";} );

Ensure Your Regex Has ^ at the beginning and $ at the end

If not, WordPress standard rewrite rules will be executed first and you can ‘t get your variable value.

add_rewrite_rule('^jemputan-kahwin/([-a-z0-9]+)/?$',
 'index.php?pagename=jemputan-kahwin&amp;advertiser_slug=$matches[1]',
  'top');

add_rewrite_rule('^jemputan-kahwin/([-a-z0-9]+)/?$',

'index.php?pagename=jemputan-kahwin&advertiser_slug=$matches[1]',

'top');

The Full Code

Make sure you press save at Settings -> Permalinks.

function add_rewrite_rules(){
   add_rewrite_rule('^jemputan-kahwin/([-a-z0-9]+)/?$',
  'index.php?pagename=jemputan-kahwin&amp;advertiser_slug=$matches[1]',
  'top');
}

add_action( 'init', 'add_rewrite_rules'), 0 );

add_filter( 'query_vars', function add_query_vars($qvars){
		$qvars[] = "myvariablename";} );

function add_rewrite_rules(){

add_rewrite_rule('^jemputan-kahwin/([-a-z0-9]+)/?$',

'index.php?pagename=jemputan-kahwin&advertiser_slug=$matches[1]',

'top');

}

add_action( 'init', 'add_rewrite_rules'), 0 );

add_filter( 'query_vars', function add_query_vars($qvars){

$qvars[] = "myvariablename";} );

Ikea Built In PAX Wardrobe – Experience Installing the Wardrobe Ourselves – DIY

I bought IKEA PAX wardrobe at IKEA Damansara on 29th August 2021 and got it delivered on 31st August 2021. We had 50% discount for delivery thanks to Merdeka day. So we just paid RM35 for delivery.

We bought 2 sets of Ikea Pax Wardrobe with 150 cm (width) x 60 (depth) cm x 236 cm (height).

Video of Completed Ikea PAX Wardrobe Assembly

Some Photos of The IKEA Delivery

ikea wardrobe - boxes arrived — ikea wardrobe – boxes arrived

ikea wardrobe - boxes — ikea wardrobe – boxes

ikea wardrobe - doors — ikea wardrobe – doors

Why We Chose Ikea Wardrobe?

Guarantee of 10 years

We had good experience with Ikea kitchen cabinet when we had issue with it, Ikea replaced our whole kitchen cabinet for free as it was still under guarantee.

Ikea PAX Wardrobe - 1o years guarantee — Ikea PAX Wardrobe – 1o years guarantee

Changeable Configuration

You can change the shelves or add new shelf or drawer easily.

Why We decided To Install Ourselves the Wardrobe?

Actually we didn’t at first. But due to MCO Covid-19, Ikea didn’t do any installation until further notice.
When we received our Ikea wardrobe boxes, the delivery guy said they can do installation at 10% of total price.
We agreed to the price but they could only do it the next day.
Because we couldn’t wait and were too excited. We decided to install it ourselves.

What Are Tools Required?

Screwdrivers – 2 sets

Most of the time you just need one. But to join 2 frames together easily you need to use 2 screwdrivers.

Ikea gave one female and one male screw to join those 2 frames. So one screwdriver hold one screw while other turn to tighten the other screw.

ikea pax wardrobe - join 2 frames together — ikea pax wardrobe – join 2 frames together

Cordless screwdriver cum cordless wood drill

Cordless screwdriver uses for closing gap of shelf supports plug and to screw L shape shelf to the frame.

Wood drill bit

You need 2 sizes, the smallest one for the door handle drill and bigger one to make a whole for screw that will be used to join 2 frames.

Water ruler

We used water ruler to ensure door handles were aligned horizontally.

Hammer

Hammer was used to nail the plywood at the back of the wardrobe.

F clamp – 2 sets

F clamp is used to join 2 frames together. IKEA instruction shows that we have to use 2 F clamps but I managed to do it with one F clamp because I only got one.

How Easy it is to do it yourself the Ikea Wardrobe Installation?

Relatively it was easy but it was tiring. It took us nearly 12 hours to complete the whole wardrobe.

The hard part was installing the handle of the door. We made mistakes on it but the mistakes wasn’t that obvious.

What mistakes did we make during the installation?

Wood scar on the door handle

If drill from inside the door create wood scar on the exterior of the door. So the right way was to drill from exterior so the wood scar was only visible from the inside.

ikea pax wardrobe door handle - wood scar on the outside — ikea pax wardrobe door handle – wood scar on the outside

ikea pax wardrobe door handle - no wood scar on the outside — ikea pax wardrobe door handle – no wood scar on the outside

ikea pax wardrobe door handle - drill from outside — ikea pax wardrobe door handle – drill from outside

ikea pax wardrobe door handle - drill from inside — ikea pax wardrobe door handle – drill from inside

The L shape shelf

ikea pax wardrobe - L shape shelf — ikea pax wardrobe – L shape shelf

We wrongly assembled the L shape shelf. We had to disassembled and carefully read the IKEA instructions.

Secondly, we didn’t properly screw the L shape shelf to the frame until there was gap between the shelf and the frame body. When this happened, the drawer was stuck, it couldn’t be opened. We had to unscrew and screw it again.

One person drill the screw at the bottom of L shape shelf while the other push it to the side to avoid it from making a gap with the frame.