Ankith Reddy has Published 996 Articles

How can I search (case-insensitive) in a column using LIKE wildcard?

Ankith Reddy

Ankith Reddy

Updated on 25-Jun-2020 07:44:36

232 Views

We can do this with the help of lower() with column name. Firstly, we will create a table with the help of CREATE command.Creating a table −mysql> CREATE table InCaseSensDemo -> ( -> Name varchar(100) -> ); Query OK, 0 rows affected (0.50 sec)Inserting records into the table with the ... Read More

How to select a column name with spaces in MySQL?

Ankith Reddy

Ankith Reddy

Updated on 25-Jun-2020 07:43:38

20K+ Views

To select a column name with spaces, use the back tick symbol with column name. The symbol is ( ` `). Back tick is displayed in the keyboard below the tilde operator ( ~).Firstly, create a table −mysql> CREATE table SpaceColumn -> ( -> `Student Name` varchar(100) -> ); Query ... Read More

How to take a snapshot of HTML5-JavaScript based video player?

Ankith Reddy

Ankith Reddy

Updated on 25-Jun-2020 07:42:59

798 Views

You can try to run the following code to take a snapshot of HTML5-JavaScript-based video player −Example                                       Snapshot                var video ... Read More

Animate CSS border-top-left-radius property

Ankith Reddy

Ankith Reddy

Updated on 25-Jun-2020 07:38:18

105 Views

To implement animation on the border-top-left-radius property with CSS, you can try to run the following codeExampleLive Demo                    table, th, td {             border: 2px solid black;          }     ... Read More

Geolocation HTML5 enableHighAccuracy True, False or What?

Ankith Reddy

Ankith Reddy

Updated on 25-Jun-2020 07:35:34

311 Views

For Geolocation enableHighAccuracy, you need to set it to true −enableHighAccuracy: trueIf you still fail in getting the result i.e. handling the timeout error, then again try it withenableHighAccuracy: falseThe above would work on Android, Chrome, and Firefox as well.

Show the flex lines with spaces all around with CSS

Ankith Reddy

Ankith Reddy

Updated on 25-Jun-2020 07:30:43

136 Views

Use the align-content property with value space-around to add space around the flex lines.You can try to run the following code to implement the space-around valueExampleLive Demo                    .mycontainer {             display: flex;         ... Read More

Detecting HTML click-to-call support in JavaScript

Ankith Reddy

Ankith Reddy

Updated on 25-Jun-2020 07:19:05

240 Views

The tel: protocol is supported by almost every mobile device nowadays. This includes Safari on iOS, Android Browser, Symbian browser, Opera Mini, etc.Add it like this −if (/(HTC825)/i.test(navigator.userAgent)){    $("a[href^='tel:']").each(function(){       this.href = this.href.replace("tel:", "wtai://wp/mc;");    }); }

Usage of CSS grid-gap property

Ankith Reddy

Ankith Reddy

Updated on 25-Jun-2020 07:14:04

109 Views

Set gap between Grid rows and columns with CSS. You can try to run the following code to implement the grid-gap property.ExampleLive Demo                    .container {             display: grid;             ... Read More

Playing MP4 video in WebView using HTML5 in Android

Ankith Reddy

Ankith Reddy

Updated on 25-Jun-2020 07:12:13

954 Views

To play MP4 video in WebView, you need to first declare Content Provider in Manifest −Implement open file with open() method −URI myURL = URI.create("file:///mypath/new.mp4"); File f = new File(myURL); ParcelFileDescriptor p =    ParcelFileDescriptor.open(f, ParcelFileDescriptor.MODE_READ_ONLY); return p;

Passing mouse clicks through an overlaying HTML element

Ankith Reddy

Ankith Reddy

Updated on 25-Jun-2020 07:05:20

1K+ Views

Retrieve the mouse coordinates in the click event. Now, retrieve the element by hiding your overlay, and use the following. After that, redisplay the overlay −document.elementFromPoint(x, y)You can also use the following CSS −div {    pointer-events:none; }

Advertisements