Mkotla has Published 100 Articles

Selects every element whose href attribute value ends with ".htm" with CSS

mkotla

mkotla

Updated on 24-Jun-2020 05:47:59

272 Views

Use the [attribute$=”value”] selector to select elements whose attribute value ends with a specified value i.e. “.htm” here.You can try to run the following code to implement the CSS [attribute$="value"] Selector, ExampleLive Demo                    [href$ = htm] {     ... Read More

Set a delay for the CSS transition effect

mkotla

mkotla

Updated on 24-Jun-2020 05:33:49

178 Views

Use the transition-delay property to set a delay for the transition effect with CSS. You can try to run the following code to set a 1-second delay of transition:ExampleLive Demo                    div {             width: 150px; ... Read More

Usage of CSS [attribute] Selector

mkotla

mkotla

Updated on 23-Jun-2020 15:03:03

188 Views

Use the [attribute] selector to select elements with an attribute, for example, an alt attribute or a target attribute, etc.You can try to run the following code to implement the CSS[attribute] selector,ExampleLive Demo                    img[alt] {             border: 3px solid orange;          }                              

How to write PHP script by using MySQL JOINS inside it to join two MySQL tables?

mkotla

mkotla

Updated on 22-Jun-2020 14:11:18

4K+ Views

We can use the syntax of MySQL JOIN for joining two tables into the PHP function – mysql_query(). This function is used to execute the SQL command and later another PHP function – mysql_fetch_array() can be used to fetch all the selected data.To illustrate it we are having the following ... Read More

Which PHP function is used to establish MySQL database connection using PHP script?

mkotla

mkotla

Updated on 22-Jun-2020 13:23:44

128 Views

PHP provides mysql_connect() function to open a database connection. This function takes five parameters and returns a MySQL link identifier on success or FALSE on failure. Its syntax is as follows −Syntaxconnection mysql_connect(server, user, passwd, new_link, client_flag);Following table give us the parameters used in the syntax above −Sr.NoParameter & Description1ServerOptional ... Read More

Intersect Method in C#

mkotla

mkotla

Updated on 22-Jun-2020 12:58:45

344 Views

Use the Intesect method to get the common elements −Create lists −var list1 = new List{99, 87}; var list2 = new List{56, 87, 45, 99};Now, use the Intersect() method to get the common elements from the above list −list1.Intersect(list2);Here is the complete code −Example Live Demousing System.Collections.Generic; using System.Linq; using System; ... Read More

C# Equivalent to Java Functional Interfaces

mkotla

mkotla

Updated on 22-Jun-2020 12:50:16

1K+ Views

Equivalent of Java’s Functional Interfaces in C# is Delegates.Let us see the implementation of functional interface in Java −Example@FunctionalInterface public interface MyInterface {    void invoke(); } public class Demo {    void method(){       MyInterface x = () -> MyFunc ();       x.invoke();    } ... Read More

How can we simulate the MySQL MINUS query?

mkotla

mkotla

Updated on 22-Jun-2020 12:47:50

491 Views

Since we cannot use the MINUS query in MySQL, we will use JOIN to simulate the MINUS query. It can be understood with the help of the following example −ExampleIn this example, we are two tables namely Student_detail and Student_info having the following data −mysql> Select * from Student_detail; +-----------+---------+------------+------------+ ... Read More

How can we enter characters as Hexadecimal (HEX) number in MySQL statement?

mkotla

mkotla

Updated on 22-Jun-2020 12:25:02

759 Views

Following are the two approaches with the help of which we can enter characters as a Hexadecimal number −By prefix ‘X’In this approach we need to quote hexadecimal numbers within single quotes with a prefix of X. Then HEX number string will be automatically converted into a character string.Examplemysql> Select ... Read More

Sets in C#

mkotla

mkotla

Updated on 22-Jun-2020 11:57:09

6K+ Views

Sets in C# is a HashSet. HashSet in C# eliminates duplicate strings or elements in an array. In C#, it is an optimized set collectionTo declare HashSet −var h = new HashSet(arr1);Above, we have set the already declared array arr1 in the HashSet.Now set it on the array to remove ... Read More

Advertisements